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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 5 Question 114 Discussion

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?
B) Double the value of Statistics Collection Interval.
A) Halve the value of Data Flush Interval.
C) Halve the value of Statistics Collection Interval.
D) Double the value of Data Flush Interval.

Microsoft DP-300 Exam - 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

by Hailey at Apr 30, 2025, 08:54 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Laquanda
8 months ago
I’ve heard that doubling the Data Flush Interval can help too!
upvoted 0 times
...
Carol
9 months ago
Definitely agree with halving the Statistics Collection Interval!
upvoted 0 times
...
Xuan
9 months ago
Halve the Data Flush Interval to keep it active.
upvoted 0 times
...
Gerald
9 months ago
Wait, are we sure about halving the Data Flush Interval? Seems risky.
upvoted 0 times
...
Lou
9 months ago
I think doubling the Statistics Collection Interval is a better option.
upvoted 0 times
...
Micheal
9 months ago
I vaguely remember that increasing the Data Flush Interval could lead to issues, so maybe doubling it isn't the best option?
upvoted 0 times
...
Mabel
10 months ago
I feel like halving the Statistics Collection Interval might help, but I’m not entirely confident about how that impacts the Query Store.
upvoted 0 times
...
Pearline
10 months ago
I think I practiced a question where adjusting the Statistics Collection Interval helped with performance, but I can't recall if doubling or halving was better.
upvoted 0 times
...
Lashaun
10 months ago
I remember something about the Data Flush Interval affecting how often data is written to the Query Store, but I'm not sure if halving it is the right move.
upvoted 0 times
...
Glenn
10 months ago
Alright, time to put on my thinking cap. Hmm, I wonder if halving the Data Flush Interval would be the best approach here.
upvoted 0 times
...
Matt
11 months ago
I've dealt with Query Store issues before, so I'm feeling pretty confident about this. I think option C is the way to go.
upvoted 0 times
...
Francesco
11 months ago
I'm not too sure about this one. The wording is a bit confusing, but I'll give it my best shot and see what happens.
upvoted 0 times
...
Leah
11 months ago
Okay, let's see. I think the key is to minimize the data being flushed and collected, so I'm leaning towards option C.
upvoted 0 times
...
Paola
11 months ago
Hmm, this one seems tricky. I'll need to think through the Query Store settings and how they impact the read-only state.
upvoted 0 times
...
Cassie
1 year ago
This question is making my head spin like a tornado. I might just flip a coin and hope for the best! *laughs* But seriously, I think I'll go with B.
upvoted 0 times
Fausto
1 year ago
User2: Yeah, I agree. Let's go with that.
upvoted 0 times
...
Adelaide
1 year ago
User1: I think B sounds like a good option.
upvoted 0 times
...
...
Jeniffer
1 year ago
Ah, the age-old dilemma of to double or to halve. I'm going with D - doubling the value of Data Flush Interval seems like the safest bet to me.
upvoted 0 times
...
Asha
1 year ago
Halving the Data Flush Interval? That's a bold move, but I'm not convinced that's the right solution here. Let's think this through a bit more.
upvoted 0 times
Kina
1 year ago
User1: Doubling the value of Data Flush Interval might be a better option. Let's go with that.
upvoted 0 times
...
Carman
1 year ago
User3: I'm not sure about that. Maybe we should double the value of Data Flush Interval instead.
upvoted 0 times
...
Katina
1 year ago
User2: That could work, but what about halving the value of Statistics Collection Interval?
upvoted 0 times
...
Elise
1 year ago
User1: I think we should double the value of Statistics Collection Interval.
upvoted 0 times
...
...
Lisha
1 year 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
1 year 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
Joesph
1 year ago
I agree with you, C seems like the best choice - halving the value of Statistics Collection Interval.
upvoted 0 times
...
Joesph
1 year ago
I think D is the correct option - doubling the value of Data Flush Interval.
upvoted 0 times
...
...
Norah
1 year 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 year 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
Janna
1 year ago
C) Halve the value of Statistics Collection Interval.
upvoted 0 times
...
Irving
1 year ago
B) Double the value of Statistics Collection Interval.
upvoted 0 times
...
Ines
1 year ago
A) Halve the value of Data Flush Interval.
upvoted 0 times
...
...
Hana
1 year ago
I disagree, I believe we should halve the value of Statistics Collection Interval.
upvoted 0 times
...
Norah
1 year ago
I think we should double the value of Data Flush Interval.
upvoted 0 times
...

Save Cancel