Microsoft Azure

Microsoft Certified: Fabric Data Engineer Associate

DP-700

Achieve the Fabric Data Engineer Associate certification with the DP-700 exam.

150 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 71–80 of 150

Q71

A company needs to securely share datasets with external partners. Which feature should they use?

  • A Azure Data Share
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure Virtual Network
Explanation Azure Data Share is specifically built for secure data sharing.
Q72

You are configuring a dataset to automatically refresh. What happens if the refresh fails?

  • A The dataset becomes inaccessible.
  • B The dataset retains last updates.
  • C It triggers an alert.
  • D The dataset is deleted.
Explanation If a dataset refresh fails, it keeps the last successful data.
Q73

Which Azure service is used for real-time analytics on streaming data?

  • A Azure Stream Analytics
  • B Azure Functions
  • C Azure SQL Database
  • D Azure Data Lake
Explanation Azure Stream Analytics specializes in real-time analysis, whereas the others serve different cloud computing purposes.
Q74

A company needs to migrate its on-premises SQL Server to Azure. What should they choose for minimal downtime?

  • A Azure Migrate
  • B Azure Site Recovery
  • C Data Migration Assistant
  • D Azure SQL Managed Instance
Explanation Azure SQL Managed Instance supports near-zero downtime migrations, while others do not focus solely on SQL Server migrations.
Q75

You are configuring Azure Data Factory for data integration. What will happen if you set incorrect Linked Service authentication parameters?

  • A Data integration will succeed
  • B Pipeline execution fails
  • C Linked Service becomes disabled
  • D Authentication parameters auto-correct
Explanation Incorrect authentication parameters will cause the pipeline to fail, while the other options are not accurate outcomes of this situation.
Q76

Which service is used for real-time analytics in Azure?

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Data Lake Storage
Explanation Azure Stream Analytics is specifically designed for real-time analytics, unlike the other storage or database solutions.
Q77

A company needs to run complex analyses on data from multiple sources. Which Azure service should they use?

  • A Azure Synapse Analytics
  • B Azure Virtual Machines
  • C Azure Logic Apps
  • D Azure App Service
Explanation Azure Synapse Analytics combines big data and data warehousing for complex analysis on diverse data sources.
Q78

You are configuring data import/export settings in Azure Data Factory. What happens when you set 'Protected' mode during cloning?

  • A Sensitive data is ignored
  • B All data is cloned as-is
  • C Only metadata is cloned
  • D Sensitive data is encrypted
Explanation 'Protected' mode prevents sensitive information from being cloned directly, unlike the other options which do not specifically address protection.
Q79

Which service is primarily used for data integration in Azure?

  • A Azure Data Factory
  • B Azure Blob Storage
  • C Azure SQL Database
  • D Azure Virtual Network
Explanation Azure Data Factory is designed for data integration, while others serve different purposes.
Q80

A company needs to process streaming data from IoT devices. Which Azure service should they use?

  • A Azure Functions
  • B Azure Databricks
  • C Azure Stream Analytics
  • D Azure Logic Apps
Explanation Azure Stream Analytics is specifically built for real-time data streaming processing, unlike the others.