Microsoft Exam DP-200 Topic 2 Question 19 Discussion

Actual exam question for Microsoft's DP-200 exam

Question #: 19
Topic #: 2

You manage an enterprise data warehouse in Azure Synapse Analytics.

Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.

You need to monitor resource utilization to determine the source of the performance issues.

Which metric should you monitor?

AData Warehouse Units (DWU) used

BDWU limit

CCache hit percentage

DData IO percentage

Show Suggested Answer

Suggested Answer: C

The Azure Synapse Analytics storage architecture automatically tiers your most frequently queried columnstore segments in a cache residing on NVMe based SSDs designed for Gen2 data warehouses. Greater performance is realized when your queries retrieve segments that are residing in the cache. You can monitor and troubleshoot slow query performance by determining whether your workload is optimally leveraging the Gen2 cache.

Note: As of November 2019, Azure SQL Data Warehouse is now Azure Synapse Analytics.

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache

https://docs.microsoft.com/bs-latn-ba/azure/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity

by Alecia at May 07, 2022, 04:08 AM

Limited Time Offer

25%

Off

Get Premium DP-200 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!