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 111–120 of 150

Q111

You are configuring a pipeline in Azure Synapse. What happens if a task fails during execution?

  • A Pipeline execution stops immediately
  • B The entire pipeline is retried
  • C Only subsequent tasks are skipped
  • D Error is logged, pipeline continues
Explanation If a task fails in Azure Synapse, the pipeline execution stops immediately unless configured to handle failures differently.
Q112

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

  • A Azure Stream Analytics
  • B Azure Data Factory
  • C Azure Blob Storage
  • D Azure SQL Database
Explanation Azure Stream Analytics is designed specifically for real-time data analytics, while the others serve different purposes.
Q113

A company needs to analyze large datasets stored in Azure Data Lake. Which tool should they use for efficient querying?

  • A Azure Synapse Analytics
  • B Azure Functions
  • C Azure Logic Apps
  • D Power BI
Explanation Azure Synapse Analytics provides a robust environment for querying large datasets in Azure Data Lake.
Q114

What happens when you set the retention policy of a table to zero in Azure Cosmos DB?

  • A Data is permanently deleted
  • B Data retention is disabled
  • C Data is retained indefinitely
  • D Data retention needs configuration
Explanation A retention policy of zero means data will be deleted immediately, whereas other options imply different retention behaviors.
Q115

Which service is used for dataflow orchestration in Azure Data Factory?

  • A Data Pipeline
  • B Dataflow
  • C Integration Runtime
  • D Activity Scheduler
Explanation Data Pipeline is used for orchestration, while other options serve different purposes.
Q116

A company needs real-time analytics on IoT data. Which Azure service should they implement?

  • A Azure Blob Storage
  • B Azure Stream Analytics
  • C Azure Data Lake
  • D Azure Functions
Explanation Azure Stream Analytics is designed for real-time analysis, unlike the other options.
Q117

You are configuring a data warehouse in Azure Synapse Analytics. What would happen if you choose a clustering key?

  • A Improved performance for joins
  • B Increased storage costs
  • C Faster data ingestion
  • D Optimized query performance
Explanation Clustering keys optimize query performance by organizing data to facilitate efficient access.
Q118

Which service is optimal for building analytics solutions in Azure?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Active Directory
  • D Azure Firewall
Explanation Azure Synapse Analytics combines big data and data warehousing, while others serve different purposes.
Q119

A company needs to implement real-time data processing for streaming data. Which service should they use?

  • A Azure Data Factory
  • B Azure Stream Analytics
  • C Azure Data Lake Storage
  • D Azure Logic Apps
Explanation Azure Stream Analytics is specifically designed for real-time data processing, unlike the others.
Q120

You are configuring a data integration pipeline using Azure Data Factory. What will happen if you set a specific activity to have a retry count of zero?

  • A No retries will be attempted
  • B One retry will be attempted
  • C It will completely fail the pipeline
  • D Retries will happen indefinitely
Explanation Setting a retry count of zero means the activity will fail if it does not succeed on the first attempt, while others imply incorrect behavior.