Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4
5Step 5
DP-300 Plan and implement data platform resources Practice Question
Drag and drop the steps to troubleshoot a high CPU usage issue in Azure SQL Database in the correct order.
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
✓
Identify high CPU queries, then Analyze execution plans, then Check for missing indexes, then Implement fixes, then Monitor performance.
Start by identifying high CPU queries, analyze plans, check for missing indexes, implement fixes, then monitor.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Identify high CPU queries, then Analyze execution plans, then Check for missing indexes, then Implement fixes, then Monitor performance.
Why this is correct
This is the correct order because you first need to identify which queries are causing high CPU, then analyze their execution plans to understand inefficiencies, check for missing indexes that could improve performance, implement necessary fixes, and finally monitor to ensure the issue is resolved.
- ✗
Identify high CPU queries, then Check for missing indexes, then Analyze execution plans, then Implement fixes, then Monitor performance.
Why it's wrong here
This order is incorrect because you should analyze execution plans before checking for missing indexes. Without understanding the plan, you might miss other optimization opportunities like query rewriting or parameter sniffing issues.
- ✗
Analyze execution plans, then Identify high CPU queries, then Check for missing indexes, then Implement fixes, then Monitor performance.
Why it's wrong here
This order is incorrect because you must first identify which queries are consuming high CPU before analyzing their plans. Without a targeted approach, you might waste time on plans unrelated to the problem.
- ✗
Identify high CPU queries, then Analyze execution plans, then Implement fixes, then Check for missing indexes, then Monitor performance.
Why it's wrong here
This order is incorrect because you should check for missing indexes before implementing fixes. Indexing is a common remedy; if you implement other fixes first, you might miss a simple optimization or apply a solution that is not needed.
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.
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.