Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-300 Topic 5 Question 114 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 114
Topic #: 5
[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

Contribute your Thoughts:

Lisha
6 days ago
I think Hana has a point, reducing the Statistics Collection Interval could also be effective in minimizing the possibility of Query Store becoming read-only.
upvoted 0 times
...
Marnie
15 days ago
Hmm, I'm not so sure. I think C might be the way to go - halving the value of Statistics Collection Interval could be a better approach.
upvoted 0 times
...
Norah
15 days ago
But wouldn't doubling the value of Data Flush Interval help prevent Query Store from transitioning to a read-only state?
upvoted 0 times
...
Nelida
1 months ago
I think the answer is B. Doubling the value of Statistics Collection Interval will minimize the possibility of Query Store transitioning to a read-only state.
upvoted 0 times
Irving
17 days ago
B) Double the value of Statistics Collection Interval.
upvoted 0 times
...
Ines
18 days ago
A) Halve the value of Data Flush Interval.
upvoted 0 times
...
...
Hana
1 months ago
I disagree, I believe we should halve the value of Statistics Collection Interval.
upvoted 0 times
...
Norah
2 months ago
I think we should double the value of Data Flush Interval.
upvoted 0 times
...

Save Cancel