Configure and manage automation of tasks →mediumMultiple ChoiceObjective-mapped

DP-300 Configure and manage automation of tasks Practice Question

Exhibit

Refer to the exhibit.

$params = @{
    ResourceGroupName = 'rg-sql'
    ServerName = 'sqlserver123'
    DatabaseName = 'mydb'
    Edition = 'Standard'
    RequestedServiceObjectiveName = 'S2'
    ElasticPoolName = 'pool1'
}
Set-AzSqlDatabase @params

Refer to the exhibit. You execute this PowerShell script to automate database configuration. The script runs without errors, but the database remains in the 'Standard' edition with S2 performance level. What is the most likely reason?

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 is being moved into an elastic pool, which overrides the edition and SLO

When the -ElasticPoolName parameter is specified, the database is moved into the elastic pool, and the -Edition and -RequestedServiceObjectiveName parameters are ignored because the elastic pool's service tier and performance level determine the database's settings. The script runs without errors, but the database remains at Standard S2 because the pool's tier overrides the specified edition and SLO. Option A is incorrect because the command succeeded, indicating the pool exists. Option B is incorrect because the parameter is correctly spelled. Option D is incorrect because the script succeeded without privilege errors.

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 does not exist
Why it's wrong here
If the pool didn't exist, the script would fail.
✗
The -RequestedServiceObjectiveName parameter is misspelled
Why it's wrong here
The parameter name is correct.
✓
The database is being moved into an elastic pool, which overrides the edition and SLO
Why this is correct
When specifying ElasticPoolName, the database inherits the pool's service tier.
✗
The script requires administrative privileges that the user does not have
Why it's wrong here
The script ran without errors, so permissions are sufficient.

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