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

Questions 1–5

1. 1foundation · easy

   Which Azure Monitor feature is used to collect and analyze diagnostic logs from Azure resources such as Azure Data Factory and Azure Databricks?

   • ALog Analytics workspaces
   • BAzure Service Health
   • CAzure Advisor
   • DApplication Insights
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A data engineering team runs a nightly Azure Data Factory pipeline that loads incremental data from an on-premises SQL Server to Azure Synapse Analytics. Recently, the pipeline has been failing intermittently at the copy activity due to timeouts, but the failures are not consistent. The team needs to identify the root cause and set up proactive notifications. What should they do first?

   • AUse Azure Data Factory's 'Monitor' tab to view the last 24 hours of pipeline runs and manually compare the failed runs to the successful ones.
   • BCreate a diagnostic setting to send ADF activity logs and pipeline metrics to a Log Analytics workspace, then build a KQL query to correlate failures with duration and retry counts.
   • CIncrease the copy activity's degree of copy parallelism and retry count in the pipeline definition to reduce the chance of timeout failures.
   • DEnable Azure Monitor alerts on the pipeline run status metric and set an alert rule to notify the team whenever the pipeline fails.
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A data warehouse in Azure Synapse Analytics has a large fact table that is loaded incrementally every hour. The table has a clustered columnstore index. Queries that filter on a date column have become slower over the past week, even though the data volume has not changed significantly. The team has already updated statistics. What should they investigate next?

   • ASwitch the table to a heap and rebuild the columnstore index.
   • BCreate a nonclustered index on the date column.
   • CCheck the rowgroup quality of the columnstore index and rebuild or reorganize if there are too many compressed rowgroups with low row counts.
   • DIncrease the resource class of the queries that are slow.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which Azure service provides a centralized hub for creating and managing alerts based on metrics and logs from multiple Azure resources?

   • AAzure Security Center
   • BAzure Cost Management
   • CAzure Policy
   • DAzure Monitor
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A data engineering team has a nightly Azure Data Factory pipeline that loads data into a production database. They want to run a test of the pipeline with a subset of data before the production run to validate that the pipeline still works after a recent change. The test must not affect the production data. What should they do?

   • AUse a trigger with a 'scheduled' type and set the pipeline to run with a test dataset by changing the source and sink dynamically.
   • BCreate a separate test pipeline that points to a test database and run it on a schedule before the production pipeline.
   • CRun the production pipeline and then roll back the changes if the test fails.
   • DRun the production pipeline in debug mode with a parameter that limits the data to a subset.
   Reveal Solution Discussion Select an answer first