DP-300 Practice Question: Monitor, configure, and optimize database resources
Which TWO metrics are available in Azure Monitor for an Azure SQL Database that can be used to set autoscale rules? (Select two.)
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
✓
CPU percentage
Options A and D are correct because CPU percentage and DTU percentage are standard metrics for autoscaling Azure SQL Database. Option B is wrong because Log write throughput is not typically used for autoscale rules. Option C is wrong because Deadlock count is an event, not a continuous metric. Option E is wrong because Query Store size is not a metric source for autoscaling.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
CPU percentage
Why this is correct
CPU percentage is a standard metric used for autoscaling Azure SQL Database.
- ✗
Log write throughput
Why it's wrong here
Log write throughput is not typically used for autoscale rules because it is not a resource utilization metric.
- ✗
Deadlock count
Why it's wrong here
Deadlock count is an event counter, not a continuous metric suitable for autoscaling decisions.
- ✓
DTU percentage
Why this is correct
DTU percentage is a key metric for autoscaling when using DTU-based purchasing model.
- ✗
Query Store size
Why it's wrong here
Query Store size is a storage metric, not directly used for autoscaling.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
Key term
Query Store
Query Store is a built-in SQL Server feature that captures and stores a history of query execution plans and performance data for easy monitoring and troubleshooting.
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.