DP-200 Azure Data Monitoring and Optimization 2

Question 1

In Azure Data Lake Storage Gen2, what is the recommended file size range for optimal analytics performance?

Accepted Answer

256 MB–1 GB

Answer

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?

Accepted Answer

To provide the query optimizer with data distribution information for generating efficient execution plans

Answer

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?

Accepted Answer

To co-locate related data in the same set of files to improve filter predicate performance

Answer

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?

Accepted Answer

Activity run history in Monitor tab

Answer

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?

Accepted Answer

Action groups with alert rules

Answer

Alert rules evaluate metric or log conditions and trigger action groups that can send emails, call webhooks, or execute automation runbooks.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Azure Data Monitoring and Optimization 2