DP-300 Practice Question: Monitor, configure, and optimize database resources
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 ```
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?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The diagnostic settings are not configured to send QueryStoreRuntimeStatistics to Log Analytics.
Query Store runtime statistics are sent to Azure Diagnostics only if diagnostic settings are configured to collect that category. Option A is wrong because Query Store is enabled. Option C is wrong because the query is correct. Option D is wrong because the KQL query syntax does not require 'project' before 'summarize'; placement does not affect results.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Query Store is not enabled on the databases.
Why it's wrong here
The stem says Query Store is enabled.
- ✓
The diagnostic settings are not configured to send QueryStoreRuntimeStatistics to Log Analytics.
Why this is correct
Without that category, no data is collected.
- ✗
The time range in the query is too narrow and excludes the last 24 hours.
Why it's wrong here
The bin function uses TimeGenerated; the query does not filter time, so it should show all data.
- ✗
The query syntax is incorrect and needs to use 'project' before 'summarize'.
Why it's wrong here
The query syntax does not require 'project' before 'summarize'; 'summarize' can directly follow a table reference or other operators, and the query would still be syntactically valid. The lack of data is due to missing diagnostic settings, not syntax.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DP-300 question from scratch — 906 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.