Courseiva

DP-300

Full exam simulation

2:00:00
1

Monitor, configure, and optimize database resources

medium

You are analyzing the exhibit KQL query that queries Azure Diagnostics logs for Query Store runtime statistics. The query is intended to show average CPU time per hour for each database. However, the result shows no data for the last 24 hours, although Query Store is enabled on all databases. What is the most likely reason?

Exhibit

Refer to the exhibit.
```kusto
AzureDiagnostics
| where ResourceProvider == "MICROSOFT.SQL"
| where Category == "QueryStoreRuntimeStatistics"
| summarize avg(avg_cpu_time) by DatabaseName, bin(TimeGenerated, 1h)
| render timechart
```
0 of 50 answered