DP-300 Practice Question: Monitor, configure, and optimize database resources
You have an Azure SQL Database that is configured with geo-replication. You need to optimize read performance for reporting queries that run on the secondary replica. Which three actions should you take? (Choose three.)
⚠ Common exam trap
Many candidates assume that enabling automatic tuning on the primary automatically benefits the secondary, or that forcing query plans on the primary will propagate to the secondary, when in fact each replica maintains its own query store and plan cache.
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
✓
Enable automatic tuning on the secondary.
Enabling automatic tuning on the secondary replica allows the database to automatically create, drop, and force index recommendations based on the workload running on that replica. This is particularly beneficial for reporting queries, as the secondary can independently optimize its own index strategy without affecting the primary. Automatic tuning on a readable secondary helps maintain query performance by adapting to the read-heavy workload patterns typical of reporting scenarios.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Enable automatic tuning on the secondary.
Why this is correct
Can optimize query performance automatically.
- ✗
Configure the secondary as a readable secondary.
Why it's wrong here
Already readable by default in geo-replication.
- ✓
Create nonclustered indexes on the secondary replica.
Why this is correct
Improves query performance on the secondary.
- ✗
Force query plans on the primary replica to benefit the secondary.
Why it's wrong here
Query plans are separate on each replica.
- ✓
Use read-only routing to direct reporting queries to the secondary.
Why this is correct
Routes queries to the secondary, offloading the primary.
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
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.