DP-300 Certification Practice Question #116

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?

Accepted Answer

The `MAX_STORAGE_SIZE_MB` limit in Query Store is not strictly enforced in real time; rather, the current size is evaluated only when Query Store writes in-memory data to disk. The frequency of these disk writes is controlled by the Data Flush Interval (`DATA_FLUSH_INTERVAL_SECONDS`). If the size threshold is breached between flush checks, Query Store transitions to a read-only state. Decreasing the Data Flush Interval (Option B) forces the system to check the storage size more frequently, allowing size-based cleanup to run before the threshold is heavily exceeded and avoiding the read-only transition.

More DP-300 practice questions