Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-300 Topic 8 Question 1 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 1
Topic #: 8
[All DP-300 Questions]

You have an Azure SQL database named sqldb1.

You need to minimize the possibility of Query Store transitioning to a read-only state.

What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: B

The Max Size (MB) limit isn't strictly enforced. Storage size is checked only when Query Store writes data to

disk. This interval is set by the Data Flush Interval (Minutes) option. If Query Store has breached the maximum

size limit between storage size checks, it transitions to read-only mode.

Incorrect Answers:

C: Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed in

minutes. The default is 60 minutes. Consider using a lower value if you require finer granularity or less time to

detect and mitigate issues. Keep in mind that the value directly affects the size of Query Store data.


https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store

Comments

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


Save Cancel