DP-300 Question #178: Real Exam Question with Answer & Explanation

Question

Hotspot Question You have an Azure SQL database named db1 on a server named server1. You use Query Performance Insight to monitor db1. You need to modify the Query Store configuration to ensure that performance monitoring data is available as soon as possible. Which configuration setting should you modify and which value should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:

Options

• __typehotspot
• variantdropdown

Explanation

This question tests knowledge of Azure SQL Query Store configuration settings, specifically which setting controls how frequently data is flushed from memory to disk for Query Performance Insight availability.

Approach. The correct configuration setting to modify is 'Data Flush Interval (Minutes)' and it should be set to the minimum value of 1 minute. The Data Flush Interval controls how often Query Store data is persisted from the in-memory buffer to disk storage. By reducing this interval to its minimum (1 minute), performance monitoring data becomes available in Query Performance Insight as quickly as possible. The default value is 15 minutes, which means there could be up to a 15-minute delay before new query performance data appears in the dashboard.

Concept tested. Azure SQL Query Store configuration - specifically the 'Data Flush Interval' setting which determines how frequently in-memory Query Store data is written to disk, directly impacting the freshness and availability of data in Query Performance Insight. Other settings like Statistics Collection Interval affect granularity of data but not the immediacy of availability, and Stale Query Threshold controls data retention, not recency.

Reference. https://learn.microsoft.com/en-us/azure/azure-sql/database/query-performance-insight-use

No community discussion yet for this question.