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?

The correct answer is C. Double the value of Statistics Collection Interval. To avoid Query Store transitioning to read-only state, the runtime statistics for the Last Stale Query Threshold days must fit in the defined Max Size (MB). If the Statistics Collection Interval is increased then less space will be used for the persisted runtime statistics and…

Submitted by diego_uy· Mar 6, 2026Optimize query performance

Question

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?

Options

ADouble the value of Data Flush interval
BDecrease by half the value of Data Flush Interval
CDouble the value of Statistics Collection Interval
DDecrease by half the value of Statistics Collection interval

How the community answered

(27 responses)

A
7% (2)
B
4% (1)
C
78% (21)
D
11% (3)

Explanation

To avoid Query Store transitioning to read-only state, the runtime statistics for the Last Stale Query Threshold days must fit in the defined Max Size (MB). If the Statistics Collection Interval is increased then less space will be used for the persisted runtime statistics and there will be more free space for new data. The Data Flush Interval can delay the transitioning to read-only state, but not minimize the possibility it occurs. https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice