DP-200 Azure Data Monitoring and Optimization 2 — Questions and Answers
Question 1: In Azure Data Lake Storage Gen2, what is the recommended file size range for optimal analytics performance?
- 1–10 KB
- 256 KB–1 MB
- 256 MB–1 GB (Correct answer)
- 10–50 GB
Correct answer: 256 MB–1 GB
Analytics frameworks like Spark perform best with files in the 256 MB–1 GB range, as very small files create excessive metadata overhead.
Question 2: What is the purpose of statistics in Azure Synapse Analytics dedicated SQL pool?
- To enforce data integrity constraints
- To provide the query optimizer with data distribution information for generating efficient execution plans (Correct answer)
- To monitor real-time query throughput
- To compress data at the column level
Correct answer: To provide the query optimizer with data distribution information for generating efficient execution plans
Statistics describe column value distribution and help the Synapse query optimizer choose optimal join strategies, aggregation methods, and data movement operations.
Question 3: In Azure Databricks, what is the purpose of Z-ordering a Delta table?
- To sort data alphabetically within each file
- To co-locate related data in the same set of files to improve filter predicate performance (Correct answer)
- To compress data using Z-standard compression
- To partition data by date automatically
Correct answer: To co-locate related data in the same set of files to improve filter predicate performance
Z-ordering organizes data in files so that rows with similar values in the Z-ordered columns are physically co-located, improving data skipping for filter queries.
Question 4: What Azure Data Factory monitoring feature allows you to view the detailed execution status and duration of each activity within a pipeline run?
- Pipeline templates
- Activity run history in Monitor tab (Correct answer)
- Linked service diagnostics
- Trigger history
Correct answer: Activity run history in Monitor tab
The Monitor tab in ADF shows pipeline and activity run history, including status, duration, input/output, and error details for each activity execution.
Question 5: Which Azure Monitor feature allows you to define automated actions—such as sending an email or triggering a runbook—when a metric crosses a threshold?
- Diagnostic settings
- Action groups with alert rules (Correct answer)
- Log Analytics workspaces
- Azure Advisor recommendations
Correct answer: Action groups with alert rules
Alert rules evaluate metric or log conditions and trigger action groups that can send emails, call webhooks, or execute automation runbooks.
Question 6: What does enabling diagnostic settings on an Azure data service do?
- Applies automatic performance tuning recommendations
- Routes resource logs and metrics to a destination like Log Analytics, Storage, or Event Hubs (Correct answer)
- Enables automatic backups for the service
- Configures high availability for the service
Correct answer: Routes resource logs and metrics to a destination like Log Analytics, Storage, or Event Hubs
Diagnostic settings route a resource's platform logs and metrics to one or more destinations (Log Analytics, Storage, Event Hubs) for analysis and archiving.
DP-200 Azure Data Monitoring and Optimization 2
In Azure Data Lake Storage Gen2, what is the recommended file size range for optimal analytics performance?