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 61–70 of 150

Q61

Which service helps monitor data quality in Azure?

  • A Azure Data Factory
  • B Azure Monitor
  • C Azure Data Share
  • D Azure Purview
Explanation Azure Purview specializes in data governance and quality, while the others do not focus exclusively on data quality.
Q62

A company needs to process real-time event data for analysis. Which Azure service should they choose?

  • A Azure SQL Database
  • B Azure Event Hubs
  • C Azure Data Lake
  • D Azure Blob Storage
Explanation Azure Event Hubs is designed for real-time event ingestion, unlike the other options.
Q63

What happens when you delete a dataset in Azure Databricks?

  • A Data is permanently lost
  • B Only references are removed
  • C All associated notebooks are deleted
  • D Nothing happens to the workspace
Explanation When a dataset is deleted, its data is permanently lost unless backed up elsewhere or retained in the Delta Lake.
Q64

What happens when you assign a dedicated SQL pool to a workspace in Azure Synapse Analytics?

  • A Increases data processing capabilities.
  • B Reduces overall data costs.
  • C Automatically scales with user traffic.
  • D Creates a low-latency storage solution.
Explanation Assigning a dedicated SQL pool increases data processing capabilities, while others do not accurately describe its function.
Q65

A company needs to analyze large volumes of streaming data in real-time. Which service should they use?

  • A Azure Data Warehouse
  • B Azure Stream Analytics
  • C Azure Functions
  • D Azure Logic Apps
Explanation Azure Stream Analytics is specifically designed for real-time data analysis, while others do not cater to this need effectively.
Q66

You are configuring dataflows in Azure Data Factory. What is the purpose of a dataflow?

  • A To visualize data transformations.
  • B To manage pipeline schedules.
  • C To define data transformation logic.
  • D To monitor data lineage.
Explanation Dataflows are for defining data transformation logic, unlike the other options that serve different purposes.
Q67

Which service allows you to orchestrate data workflows in Azure?

  • A Azure Data Factory
  • B Azure Blob Storage
  • C Azure Synapse Analytics
  • D Azure Databricks
Explanation Azure Data Factory is designed specifically for data orchestration, while the others serve different primary purposes.
Q68

A company needs real-time analytics on streaming data from IoT devices. Which Azure service should they use?

  • A Azure SQL Database
  • B Azure Stream Analytics
  • C Azure Data Lake Storage
  • D Azure Cosmos DB
Explanation Azure Stream Analytics is built for real-time stream processing, unlike the other options.
Q69

You are configuring a data pipeline in Azure Data Factory that sources data from multiple formats. What happens if one of the source data types is not supported?

  • A The pipeline fails silently.
  • B The pipeline continues with warnings.
  • C The pipeline aborts immediately.
  • D The unsupported data is skipped.
Explanation Azure Data Factory will abort the pipeline immediately if it encounters unsupported data types, rather than allowing it to continue or skip.
Q70

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

  • A Azure Stream Analytics
  • B Azure Data Factory
  • C Azure Synapse Analytics
  • D Azure Blob Storage
Explanation Azure Stream Analytics is designed for real-time event processing, unlike the others.