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 121–130 of 150

Q121

Which service allows large-scale data processing in Azure?

  • A Azure Data Lake Analytics
  • B Azure SQL Database
  • C Azure Blob Storage
  • D Azure Cosmos DB
Explanation Azure Data Lake Analytics is built for large-scale data processing, while others serve different functions.
Q122

A company needs to analyze real-time streaming data. Which Azure service should they use?

  • A Azure Analysis Services
  • B Azure Stream Analytics
  • C Azure Data Factory
  • D Azure Batch
Explanation Azure Stream Analytics is specifically designed for real-time data analysis, unlike the other options which handle batch or static data.
Q123

What happens when you enable Soft Delete on an Azure Blob Storage container?

  • A Blobs are permanently deleted immediately
  • B Deleted blobs are recoverable
  • C Storage costs are halved
  • D Soft delete is irreversible
Explanation Soft delete allows recovery of blobs within the retention period, contrary to permanent deletion or incorrect storage cost assumptions.
Q124

Which Azure service is best for data visualization?

  • A Power BI
  • B Azure Functions
  • C Azure VM
  • D Azure Blob Storage
Explanation Power BI specializes in data visualization, unlike the other services.
Q125

A company needs to process large datasets in real-time. Which Azure service should they use?

  • A Azure Data Lake
  • B Azure Stream Analytics
  • C Azure SQL Database
  • D Azure Cosmos DB
Explanation Azure Stream Analytics is designed for real-time data processing.
Q126

What happens when you set the retention policy on Azure Data Lake Storage?

  • A Files are permanently deleted immediately
  • B Files are archived to a different service
  • C Files are retained as per policy
  • D Files are encrypted by default
Explanation Retention policies manage the lifecycle, not immediate deletions.
Q127

Which Azure service provides real-time analytics on streaming data?

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Azure SQL Database
Explanation Azure Stream Analytics is designed for real-time analysis, whereas others are for storage or batch processing.
Q128

A company needs to analyze large volumes of data stored in Azure Data Lake. Which service should they use?

  • A Azure Data Warehouse
  • B Azure Databricks
  • C Azure Functions
  • D Azure Virtual Machines
Explanation Azure Databricks integrates seamlessly with Azure Data Lake for analytics, while others focus on different functionalities.
Q129

What happens when data is ingested into Azure Synapse Analytics from multiple sources?

  • A Data automatically cleansed
  • B Data combined in one table
  • C Data stored in different areas
  • D Data indexed for faster queries
Explanation Data ingested from multiple sources retains source context and is stored separately unless otherwise configured.
Q130

Which service allows real-time analytics on data streams?

  • A Azure Stream Analytics
  • B Azure Data Lake
  • C Azure Blob Storage
  • D Azure SQL Database
Explanation Azure Stream Analytics is designed for real-time analytics, while the others serve different data storage or management functions.