A data engineer uses Azure Data Factory to copy large Parquet files from Azure Blob Storage to Azure Data Lake Storage Gen2 every hour. The copy activity takes longer than expected, and the engineer wants to measure the actual data movement throughput to identify if the source or sink is the bottleneck. What should they do?

Run a test copy of a single file and use a stopwatch to measure the elapsed time.

Use Azure Storage analytics logs to measure the time taken for each blob read and write operation.

Review the copy activity's 'Data read' and 'Data written' metrics along with the 'Throughput' metric in the ADF monitoring view.

Enable Azure Monitor diagnostics and query the ADFActivityRun logs for the 'CopyDuration' field.

A data pipeline in Azure Data Factory copies data from an on-premises SQL Server to Azure Synapse Analytics. The pipeline runs hourly and takes 45 minutes to complete. The team wants to reduce the duration to under 30 minutes. They have already enabled staging and increased the integration runtime's number of concurrent connections. What should they do next?

Partition the source query by a high-cardinality column and enable parallel copy in the copy activity.

Use a self-hosted integration runtime with more nodes to distribute the load.

Increase the size of the Azure-SSIS integration runtime if the pipeline uses SSIS packages.

Change the sink to use PolyBase instead of the copy activity.

Microsoft Certified:Azure Data Engineer Associate

Domain 3Objective 2

Monitor Data Storage and Data Processing DP-203 Practice Questions (Page 5)

Part of the Secure, monitor, and optimize data storage and data processing domain, which accounts for 30–35% of the DP-203 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 4–8 from this objective — we provide 46 practice questions to prepare you well beyond it. (estimate)

46questions here

10free pages

10concepts

30–35%of the exam

Questions 21–25

21foundation · easy
Which Azure service can be used to schedule and run automated tests for data pipelines?
Select an answer first
22foundation · easy
Which tool in Azure Synapse Analytics can be used to measure the performance of a SQL query?
Select an answer first
23foundation · easy
Which Azure Data Factory monitoring view shows the status and duration of each activity within a pipeline run?
Select an answer first
24application · medium
A data engineer uses Azure Data Factory to copy large Parquet files from Azure Blob Storage to Azure Data Lake Storage Gen2 every hour. The copy activity takes longer than expected, and the engineer wants to measure the actual data movement throughput to identify if the source or sink is the bottleneck. What should they do?
Select an answer first
25expert · hard
A data pipeline in Azure Data Factory copies data from an on-premises SQL Server to Azure Synapse Analytics. The pipeline runs hourly and takes 45 minutes to complete. The team wants to reduce the duration to under 30 minutes. They have already enabled staging and increased the integration runtime's number of concurrent connections. What should they do next?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-203

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-203” is a trademark of its owner, used for identification only.

Monitor Data Storage and Data Processing DP-203 Practice Questions (Page 5)

Questions 21–25

Which Azure service can be used to schedule and run automated tests for data pipelines?

Which tool in Azure Synapse Analytics can be used to measure the performance of a SQL query?

Which Azure Data Factory monitoring view shows the status and duration of each activity within a pipeline run?

Keep studying — Secure, monitor, and optimize data storage and data processing