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

Questions 36–40

1. 36expert · hard

   A data platform team has an Azure Data Factory pipeline that runs every hour. The pipeline has a 'ForEach' loop that processes multiple files. The team has noticed that the pipeline sometimes takes longer than the expected 30 minutes, and they want to set up an alert that only triggers when the pipeline runs longer than 45 minutes, but not for every run that is slightly over. What should they do?

   • ASet up an alert on the 'Activity run duration' metric for the ForEach loop activity.
   • BUse a webhook in the pipeline to send a notification if the run duration exceeds 45 minutes.
   • CCreate a metric alert on the 'Pipeline run duration' metric with a threshold of 45 minutes and a condition that evaluates the last 3 runs.
   • DCreate a log alert that queries the ADFPipelineRun table for runs with a duration greater than 45 minutes and triggers on every occurrence.
   Reveal Solution Discussion Select an answer first
2. 37expert · hard

   A data engineer is troubleshooting a slow Azure Data Factory copy activity that moves data from an Azure SQL Database to Azure Data Lake Storage Gen2. The source has 10 million rows. The copy activity uses the default settings. The engineer observes that the 'Data read' metric is high, but the 'Data written' metric is low, and the 'Throughput' is below expected. What is the most likely cause and what should they do?

   • AThe sink is throttling writes due to storage account limits; increase the storage account's ingress/egress limits.
   • BThe source query is performing a full table scan; use a query with a WHERE clause to reduce the data volume.
   • CThe source is returning more data than expected due to a query that joins tables, and the sink is receiving only the projected columns; optimize the source query to select only needed columns.
   • DThe copy activity is using the staging option, which writes to an intermediate blob before moving to the final sink.
   Reveal Solution Discussion Select an answer first
4. 38application · medium

   A team runs ad-hoc queries on Azure Synapse Analytics. Users report that some queries are slow. The team needs to identify which queries are consuming the most resources and set up an alert when a query runs longer than 10 minutes. What should they do?

   • AQuery the sys.dm_pdw_exec_requests DMV to find long-running queries, then create an alert rule in Azure Monitor based on the DMV data.
   • BReview the Azure Monitor 'CPU' metric for the SQL pool and set an alert when it exceeds 80%.
   • CUse Azure SQL Analytics to view query performance insights and set a threshold on the 'Query Duration' metric.
   • DEnable SQL Server Profiler on the Synapse workspace and trace all queries.
   Reveal Solution Discussion Select an answer first
5. 39foundation · easy

   What does the 'Integration Runtime' metric 'Queue Length' indicate in Azure Data Factory?

   • AThe number of pipeline runs that failed
   • BThe number of pending activities waiting to be executed
   • CThe amount of data transferred in bytes
   • DThe number of linked services in the pipeline
   Reveal Solution Discussion Select an answer first
6. 40application · medium

   A data platform team needs to track all data processing activities in Azure Databricks for auditing and security analysis. They want to store the logs in a central location that supports querying and alerting. What should they configure?

   • AUse Azure Monitor's activity log to capture Databricks workspace operations.
   • BEnable diagnostic settings for the Azure Databricks workspace to stream logs to a Log Analytics workspace.
   • CConfigure Azure Databricks to write logs to a storage account and use Azure Storage analytics to query them.
   • DSet up a webhook in Databricks to send all cluster events to an external SIEM.
   Reveal Solution Discussion Select an answer first