Microsoft
DP-300 · Question #406
Hotspot Question You have a logical server for Azure SQL Database named Server1 that has an elastic pool named Pool1. You have a database watcher named Watcher1. You run the following KQL query. let l
Sign in or unlock DP-300 to reveal the answer and full explanation for question #406. The question stem and answer options stay visible for context.
Submitted by daniela_cl· Mar 6, 2026Monitor, configure, and optimize database resources
Question
Hotspot Question You have a logical server for Azure SQL Database named Server1 that has an elastic pool named Pool1. You have a database watcher named Watcher1. You run the following KQL query. let logicelServer = @"Server1"; let elacticPoolName = @"Pool1"; let replicaType = "Primary"; let duration = 20h; sqldb_elastic_pool_resource_utilization | where sample_time_utc > ago(duration) | where logical_server_nane =~ logicalServer | where replica_type =~ replicaType | project sample_time_utc, avg_cpu_percent, avg_instance_cpu_percent, avg_data_io_percent, avg_log_write_percent, max_worker_percent | sort by sample_time_utc desc | render timechart; For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Answer:
Exhibit
Answer Area
- The query returns the execution time of individual queries.
- The query returns the resource consumption metrics from the last day.
- The query visualizes the result set and includes a legend for each series.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#database watcher#KQL query#elastic pool metrics#resource utilization
