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 11–20 of 150

Q11

A company needs a secure way to manage data access in Azure. What should they implement?

  • A Azure RBAC
  • B Virtual Network
  • C Network Security Group
  • D Azure Blob Storage
Explanation Azure RBAC allows granular access control for resources, while the other options provide different security or data storage functionalities.
Q12

What happens when you enable soft delete on an Azure Blob Storage container?

  • A Tiles data indefinitely
  • B Data cannot be recovered
  • C Deleted blobs can be restored
  • D Increases storage costs immediately
Explanation Soft delete allows deleted blobs to be restored within a retention period, while the other options misrepresent functionality.
Q13

Which service is best for managing big data workloads?

  • A Azure Databricks
  • B Azure Functions
  • C Azure CDN
  • D Azure Logic Apps
Explanation Azure Databricks is optimized for big data analytics, while the others serve different purposes.
Q14

A company requires real-time data processing with low latency. Which option should they choose?

  • A Azure Data Lake
  • B Azure Stream Analytics
  • C Azure Blob Storage
  • D Azure Data Factory
Explanation Azure Stream Analytics is specifically designed for real-time data processing, unlike the other storage or batch tools.
Q15

What happens when you integrate Azure Data Factory with Power BI?

  • A Enables mobile access to datasets
  • B Schedules data refreshes automatically
  • C Increases storage limits significantly
  • D Enhances data visualizations directly
Explanation Azure Data Factory can schedule and orchestrate data refreshes that Power BI can consume, unlike the other options which aren't applicable.
Q16

Which service is used for monitoring data pipelines in Azure Synapse Analytics?

  • A Azure Monitor
  • B Azure DevOps
  • C Azure Security Center
  • D Azure Sentinel
Explanation Azure Monitor provides comprehensive monitoring capabilities for data pipelines, while others focus on different aspects.
Q17

A company needs to automate data movement between Azure Blob Storage and Azure SQL Database. Which Azure service should it use?

  • A Azure Data Factory
  • B Azure Logic Apps
  • C Azure Stream Analytics
  • D Azure Functions
Explanation Azure Data Factory is designed specifically for data movement and transformation tasks.
Q18

What happens when data ingestion in Azure Data Lake Storage goes over quota?

  • A Data is automatically deleted
  • B Ingestion fails but storage remains intact
  • C Data is queued until space is available
  • D Ingestion is throttled to prevent overload
Explanation When over quota, ingestion fails but existing data remains; no automatic deletion or queuing occurs.
Q19

Which service allows real-time data streaming in Azure Fabric?

  • A Azure Data Factory
  • B Azure Stream Analytics
  • C Azure Data Lake
  • D Azure SQL Database
Explanation Azure Stream Analytics enables real-time data processing, while the others are more oriented towards batch processing or storage.
Q20

A company needs to implement data lineage tracking in their Azure environment. Which Azure service should they use?

  • A Azure Data Factory
  • B Azure Monitor
  • C Azure Purview
  • D Azure Logic Apps
Explanation Azure Purview specializes in data governance and lineage tracking, unlike the other services listed.