Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 4 question 47 discussion

Actual exam question from Microsoft's DP-200

Question #: 47
Topic #: 4

You have an enterprise data warehouse in Azure Synapse Analytics.
You need to monitor the data warehouse to identify whether you must scale up to a higher service level to accommodate the current workloads.
Which is the best metric to monitor?
More than one answer choice may achieve the goal. Select the BEST answer.

A. CPU percentage
B. DWU used
C. DWU percentage
D. Data IO percentage

Show Suggested Answer

Suggested Answer: B 🗳️
DWU used, defined as DWU limit * DWU percentage, represents only a high-level representation of usage across the SQL pool and is not meant to be a comprehensive indicator of utilization. To determine whether to scale up or down, consider all factors which can be impacted by DWU such as concurrency, memory, tempdb, and adaptive cache capacity. We recommend running your workload at different DWU settings to determine what works best to meet your business objectives.
Reference:
https://docs.microsoft.com/bs-latn-ba/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity

by cmihai at July 18, 2020, 2:22 a.m.

Comments

Submit Cancel

cmihai

Highly Voted 4 years, 10 months ago

It is better to monitor DWU %, as it would be a consistent way to monitor independent of the absolute DWU used value (which can increase or decrease over time)

upvoted 24 times

Tommy65

4 years, 9 months ago

Agree, that would keep consistency in the way of operating regardless the size of Synapse

upvoted 1 times

...

M0e

Highly Voted 4 years, 8 months ago

DWU percentage is the correct answer.

upvoted 5 times

...

brieucboonen1

Most Recent 3 years, 3 months ago

Selected Answer: C

DWU percentage = Maximum between CPU percentage and Data IO percentage DWU used = DWU limit * DWU percentage C is the answer

upvoted 2 times

...

Maddaa

4 years, 1 month ago

From the reference link in the answer: "To determine whether to scale up or down, consider all factors which can be impacted by DWU such as concurrency, memory, tempdb, and adaptive cache capacity."

upvoted 1 times

...

gobeyot404

4 years, 3 months ago

From microsoft docs: Things to consider when viewing metrics and setting alerts: ***DWU used*** represents only a high-level representation of usage across the SQL pool and ***is not meant*** to be a comprehensive indicator of utilization.

upvoted 5 times

...

ssantos

4 years, 4 months ago

Based on referenced link the anwser "DWU used" seems correct.

upvoted 1 times

NamishBansal

4 years, 1 month ago

Really? From the reference link I quote: 'DWU used represents only a high-level representation of usage across the SQL pool and is not meant to be a comprehensive indicator of utilization

upvoted 2 times

...

ACSC

4 years, 5 months ago

Answer is B. DWU used, defined as DWU limit * DWU percentage, represents only a high-level representation of usage across the SQL pool and is not meant to be a comprehensive indicator of utilization. As mentioned, it is not a comprehensive indicator, but is the best in the list. DWU percentage indicates only a maximum value between CPU and Data I/O.

upvoted 4 times

...

syu31svc

4 years, 6 months ago

DWU percentage = Maximum between CPU percentage and Data IO percentage DWU used = DWU limit * DWU percentage C is the answer

upvoted 3 times

...