ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam
Go to Exam

Exam DP-200 topic 4 question 21 discussion

Actual exam question from Microsoft's DP-200
Question #: 21
Topic #: 4
[All DP-200 Questions]

HOTSPOT -
You need to receive an alert when Azure Synapse Analytics consumes the maximum allotted resources.
Which resource type and signal should you use to create the alert in Azure Monitor? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Resource type: SQL data warehouse
DWU limit belongs to the SQL data warehouse resource type.

Signal: DWU limit -
SQL Data Warehouse capacity limits are maximum values allowed for various components of Azure SQL Data Warehouse.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-insights-alerts-portal
by Pairon at April 11, 2021, 12:57 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Pairon
Highly Voted 4 years, 1 month ago
For me, the answer of the second box should be DWU used...DWU limit is a static value.
upvoted 13 times
111222333
4 years ago
Agree on "DWU used". Reference: https://azure.microsoft.com/nb-no/blog/azure-sql-data-warehouse-february-2016-update/
upvoted 2 times
111222333
4 years ago
DWU limit is a static value that tells you how many resources you have allocated for your DWH. If you set an alert for DWU limit, you will get alerted if the DWU limit is greater than xx. It means you will get alerted if someone changes DWU limit to something greater than xx, i.e. if someone allocates more resources for your DWH . But if you set an alert for DWU used, you get alerted when DWU consumption becomes greater than XX. And you set that XX as a maximum alotted space => you receive an alert when Azure Synapse Analytics consumes the maximum allotted resources.
upvoted 2 times
...
...
...
IAMKPR
Most Recent 4 years ago
As per me, the Signal should be DWU used greater than "X". So the 2nd answer should be DWU used rather than DWU Limit.
upvoted 1 times
...
Maddaa
4 years ago
You can configure an alert for a specific percentage of the DWU limit, e.g. when DWUs used reach 80% of the limit. But the answer is still a bit ambiguous.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago