DP-300 Configure and manage automation of tasks Practice Question
Exhibit
Refer to the exhibit. $resourceGroup = "rg-sql" $databaseName = "sqldb1" $elasticPoolName = "ep1" Set-AzSqlDatabase -ResourceGroupName $resourceGroup ` -DatabaseName $databaseName ` -ElasticPoolName $elasticPoolName
Refer to the exhibit. A PowerShell script is used to move an Azure SQL Database into an elastic pool. The script runs without error. Which condition must be true before the script runs?
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
✓
The database must be in the same server as the elastic pool
Moving a database into an elastic pool requires the database to be in the same server as the pool. Option A is wrong because the elastic pool must be in the same server as the database, not a different server. Option C is wrong because the database can be any service tier (Basic, Standard, Premium, etc.) as long as it fits within the pool's resource limits. Option D is wrong because the database size can be any size up to the pool's max size limit, which is not necessarily less than 10 GB.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The elastic pool must be in a different server
Why it's wrong here
An elastic pool and the database must reside on the same server; pools cannot span servers. It tempts because pools are server-scoped resources, but the correct condition is same-server placement, so a different server directly contradicts the requirement rather than satisfying it.
- ✓
The database must be in the same server as the elastic pool
Why this is correct
Elastic pools group databases sharing resources within a single logical server, so a database must already reside on that same server before being added. Moving a database across servers requires a separate operation, such as export/import or geo-restore, which the script does not perform. This satisfies the same-server constraint.
- ✗
The database must be in the Basic tier
Why it's wrong here
Elastic pools accept databases from any service tier except Hyperscale; Basic tier is not a prerequisite. It tempts because Basic databases are common pool candidates, but the actual requirement concerns the pool's service tier and region matching the database, not the database's own tier.
- ✗
The database size must be less than 10 GB
Why it's wrong here
Elastic pool membership is not capped at 10 GB; databases up to the pool's storage limit, including larger General Purpose sizes, can be added. It tempts because Basic databases max out at 2 GB, but the script's precondition concerns server, region and pool compatibility, not a fixed size ceiling.
Go deeper
Related to this question
Learn chapter
Managing Environment Configurations and Resource Governance
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 574-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.