Administering Relational Databases on Microsoft Azure — Question 1

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?

Answer options

• A. Double the value of Data Flush interval
• B. Decrease by half the value of Data Flush Interval
• C. Double the value of Statistics Collection Interval
• D. Decrease by half the value of Statistics Collection interval

Correct answer: B

Explanation

The correct answer is B because reducing the Data Flush Interval helps to manage the size of the Query Store by allowing data to be flushed more frequently, preventing it from reaching its limits. The other options either increase the intervals or do not address the flushing of data, which does not help in minimizing the risk of the Query Store going into a read-only state.