Home » Microsoft » 70-762 » Which three actions should you perform Each correct step presents part of the solution.
You have a Microsoft Azure SQL Database. You enable Query Store for the database and configure the store to use the following settings
SIZE_BASED_CLEANUP_MODE = OFF
STALE_QUERY_THRESHOLD_DAYS = 60
MAX_STORAGE_SIZE_MB = 100
QUERY_CAPTURE_MODE = ALL
You use Azure Query Performance Insight to review queries. You observe that new queries are not displayed after 15 days and that the Query Store is set to read-only mode.
If the Query Store runs low on data space, the store must prioritize queries that run regularly or queries that consume applicant resources.
You must set the Query Store to read_write mode and determine the performance of queries from the past 60 days.
Which three actions should you perform Each correct step presents part of the solution.
NOTE Each correct selection is worth one point.
A. Set the value of the CLEANUP_POLICY setting to (STALE_QUERY_THRESHOLD_DAYS = 75)
B. Set the value of the QUERY_CAPTURE_MODE setting to AUTO
C. Increase the value for the MAX_STORAGE_SIZE_MB setting
D. Set the value of the SIZE_BASED_CLEANUP_MODE setting to AUTO
E. In the Azure portal, navigate to Query Performance Insight. Use the Custom tab to select a period of 2 months.
Correct Answer: BCD
Explanation/Reference:
Reference
B Capture mode
All – Captures all queries. This is the default option.
Auto – Infrequent queries and queries with insignificant cost are ignored. (Ad hoc recommended) None – Query Store stops capturing new queries.
C Max Size (MB) Specifies the limit for the data space that Query Store can consume within the database. This is the most important setting that directly affects operation mode of the Query Store.
While Query Store collects queries, execution plans and statistics, its size in the database grows until this limit is reached. When that happens, Query Store automatically changes the operation mode to read-only and stops collecting new data. You should monitor this closely to make sure you have sized the store appropriately to contain the full history you’d like to retain.
D Size Based Cleanup Mode Specifies whether automatic data cleanup will take place when Query Store data size approaches the limit.
It is strongly recommended to activate size-based cleanup to makes sure that Query Store always runs in read-write mode and collects the latest data.
References
httpsdocs.microsoft.comen-ussqlrelational-databasesperformancebest-practice-with-the-query-store