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

Exam DP-203 All Questions

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

Exam DP-203 topic 4 question 15 discussion

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

You have a SQL pool in Azure Synapse.
A user reports that queries against the pool take longer than expected to complete. You determine that the issue relates to queried columnstore segments.
You need to add monitoring to the underlying storage to help diagnose the issue.
Which two metrics should you monitor? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Snapshot Storage Size
  • B. Cache used percentage
  • C. DWU Limit
  • D. Cache hit percentage
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️
by HaBroNounen at Jan. 2, 2022, 12:28 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
Deeksha1234
Highly Voted 2 years, 8 months ago
Selected Answer: BD
seems correct
upvoted 6 times
...
Alongi
Most Recent 1 year ago
Selected Answer: AD
Snapshot Storage Size: This metric indicates the size of the snapshot used by the SQL pool. Monitoring this metric can provide information on how much storage space is being utilized by the pool, which can be useful in understanding if there are any storage overutilization issues. Cache hit percentage: This metric indicates the percentage of column cache used for queries. Monitoring this metric can provide insights into how effectively the columns used in queries are being stored in the column cache, which is critical for query performance.
upvoted 3 times
ramnathshenoy10
8 months, 2 weeks ago
Snapshot size has not effect on query performance. Answer is BD.
upvoted 2 times
...
...
kkk5566
1 year, 8 months ago
Selected Answer: BD
go b &D
upvoted 1 times
...
Matt2000
1 year, 8 months ago
This link might be useful. It explains cache hit percentage and cache used percentage: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-resource-utilization-query-activity
upvoted 1 times
...
yogiazaad
2 years, 3 months ago
This article is more relevant here. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to-monitor-cache
upvoted 3 times
...
PallaviPatel
3 years, 3 months ago
Selected Answer: BD
Correct Answer
upvoted 4 times
...
HaBroNounen
3 years, 3 months ago
correct
upvoted 4 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