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 101–110 of 150

Q101

A company needs to optimize data storage costs in Azure. Which strategy should they prioritize?

  • A Use Azure Data Lake Store
  • B Implement data lifecycle management
  • C Maximize redundant storage options
  • D Increase storage throughput
Explanation Implementing data lifecycle management helps reduce costs through automated tiering or deletion, while others can increase expenses.
Q102

You are configuring data movement with Azure Data Factory. What happens when you set a fault tolerance option for data copies?

  • A Stops on the first failure
  • B Retries until successful or timeout
  • C Logs errors only
  • D Skips invalid records silently
Explanation Setting fault tolerance allows for retries to ensure data reliability, whereas other options either ignore or lack persistence in error handling.
Q103

Which service helps manage and analyze data in real time?

  • A Azure Stream Analytics
  • B Azure SQL Database
  • C Azure Blob Storage
  • D Azure Data Factory
Explanation Azure Stream Analytics is designed for real-time data consumption; others focus on different data management aspects.
Q104

A company wants to ingest large data sets efficiently into Azure Data Lake. What is the best option to achieve this?

  • A Azure Functions
  • B Azure Data Lake Storage Gen2
  • C Azure Blob Storage
  • D Azure SQL Database
Explanation Azure Data Lake Storage Gen2 specializes in managing large datasets; other options are not optimized for such ingestion.
Q105

You are configuring Azure Synapse Analytics. What happens when you define a table with CLUSTERED columnstore?

  • A It boosts write performance.
  • B It helps in data compression.
  • C It uses row-based storage.
  • D It disables data partitioning.
Explanation CLUSTERED columnstore enhances data compression; other options reflect misconceptions about performance or storage type.
Q106

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

  • A Azure Stream Analytics
  • B Azure Data Factory
  • C Azure Blob Storage
  • D Azure SQL Database
Explanation Azure Stream Analytics specializes in real-time processing, while the others focus on storage or batch processing.
Q107

A company needs to efficiently manage large volumes of diverse data. Which design principle should they consider?

  • A Data Redundancy
  • B Database Sharding
  • C Data Monolith
  • D Data Silos
Explanation Database sharding helps scale and manage large datasets, whereas the other options lead to inefficiencies or increased complexity.
Q108

What happens when an Azure Data Lake is configured without access controls?

  • A Only admins can access data
  • B All users can access data
  • C Data is automatically encrypted
  • D Connections are terminated immediately
Explanation Without access controls, the default behavior is open access to all, while the others do not reflect real access conditions.
Q109

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

  • A Azure Stream Analytics
  • B Azure Blob Storage
  • C Azure Synapse Analytics
  • D Azure Data Factory
Explanation Azure Stream Analytics is designed for real-time analytics on streaming data, while the others serve different purposes.
Q110

A company needs to transform and move data into a data lake nightly. Which service do you recommend?

  • A Azure Logic Apps
  • B Azure Data Factory
  • C Azure Data Lake Storage
  • D Azure Functions
Explanation Azure Data Factory is best suited for orchestration of data movement and transformation workflows, unlike the other options.