Configure and manage automation of tasks →hardMultiple ChoiceObjective-mapped

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
The elastic pool must be in a different server is incorrect because the database and the elastic pool must reside on the same server.
✓
The database must be in the same server as the elastic pool
Why this is correct
The database must be in the same server as the elastic pool is correct because moving a database into an elastic pool requires the database to be on the same server as the pool.
✗
The database must be in the Basic tier
Why it's wrong here
The database must be in the Basic tier is incorrect because the database can be in any service tier (e.g., Basic, Standard, Premium) to be moved into an elastic pool.
✗
The database size must be less than 10 GB
Why it's wrong here
The database size must be less than 10 GB is incorrect because there is no fixed size limit; the database must fit within the elastic pool's resource limits.

Go deeper

DP-300 Configure and manage automation of tasks Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question