Drag steps to the numbered slots on the right, or tap a step then tap a slot.
DP-300 Configure and manage automation of tasks Practice Question
Drag and drop the steps to configure an Azure SQL Database elastic pool 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
Create the elastic pool, then add databases to the pool, then configure per-database limits, then monitor pool performance, then scale the pool as needed.
First create the pool, then add databases, configure per-database limits, monitor, and scale.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Create the elastic pool, then add databases to the pool, then configure per-database limits, then monitor pool performance, then scale the pool as needed.
Why this is correct
This is the correct order because you must first create the pool to have a container, then add databases to it, then set per-database limits to control resource usage, then monitor performance to identify scaling needs, and finally scale the pool to adjust resources.
- ✗
Add databases to an existing pool first, then create the elastic pool, then configure per-database limits, then monitor, then scale.
Why it's wrong here
This is incorrect because you cannot add databases before the pool exists; the pool must be created first.
- ✗
Create the elastic pool, then configure per-database limits, then add databases, then monitor, then scale.
Why it's wrong here
This is incorrect because per-database limits apply to databases already in the pool; you must add databases before configuring per-database limits.
- ✗
Create the elastic pool, then add databases, then monitor, then configure per-database limits, then scale.
Why it's wrong here
This is incorrect because configuring per-database limits should be done early to set expectations; monitoring without limits set may show misleading performance data.
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 →
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.