A data warehouse in Azure Synapse Analytics has a large fact table that is partitioned by date. The table is loaded with new data every hour. Queries that filter on the partition column have become slower, and the query plan shows a high number of row estimates vs. actual rows. The team suspects stale statistics. What should they do to resolve the issue without causing excessive overhead?

Update statistics only on the partition column for the newly added partitions after each load.

Run a full UPDATE STATISTICS on the entire fact table after every load.

Rebuild all indexes on the fact table to improve query performance.

Change the query to use a different filter column that has more current statistics.

In Azure Monitor, what does a 'TimeoutException' in application logs typically indicate?

An operation took longer than the allowed time and was aborted

The application was successfully deployed

The application ran out of memory

The application failed to authenticate

Microsoft Certified:Azure Data Engineer Associate

Domain 3Objective 2

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

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 11–15

11expert · hard
A data warehouse in Azure Synapse Analytics has a large fact table that is partitioned by date. The table is loaded with new data every hour. Queries that filter on the partition column have become slower, and the query plan shows a high number of row estimates vs. actual rows. The team suspects stale statistics. What should they do to resolve the issue without causing excessive overhead?
Select an answer first
12foundation · easy
In Azure Monitor, what does a 'TimeoutException' in application logs typically indicate?
Select an answer first
13foundation · easy
Which metric is commonly used to monitor the health of an Azure Stream Analytics job?
Select an answer first
14foundation · easy
In Azure Synapse Analytics, which command is used to update statistics on a table column?
Select an answer first
15foundation · easy
Which Azure service is specifically designed to run and monitor real-time stream processing jobs?
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 3)

Questions 11–15

In Azure Monitor, what does a 'TimeoutException' in application logs typically indicate?

Which metric is commonly used to monitor the health of an Azure Stream Analytics job?

In Azure Synapse Analytics, which command is used to update statistics on a table column?

Which Azure service is specifically designed to run and monitor real-time stream processing jobs?

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