Plan and implement data platform resources →easyMultiple ChoiceObjective-mapped

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Refer to the exhibit.

```
$serverName = "sqlprod-server"
$databaseName = "OrdersDB"
$cmd = @"
SELECT name, state_desc FROM sys.database_service_objectives
WHERE database_id = DB_ID()
"@
Invoke-SqlCmd -ServerInstance $serverName -Database $databaseName -Query $cmd
```

A database administrator runs the PowerShell script shown in the exhibit against an Azure SQL Database. What does the script output?

⚠ Common exam trap

Many candidates confuse Get-AzSqlDatabase with other cmdlets that return schema, backup, or permission details, leading them to select a plausible but incorrect option based on the cmdlet's name alone.

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

✓

Service tier and performance level of the database.

The PowerShell script uses the Get-AzSqlDatabase cmdlet, which retrieves an Azure SQL Database object. The output includes properties such as Edition (service tier) and ServiceObjective (performance level), making option D correct.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Details of table schemas.
Why it's wrong here
The script does not query schemas.
✗
List of backup retention policies.
Why it's wrong here
The script queries service objectives, not backups.
✗
List of users and their permissions.
Why it's wrong here
The script does not query permissions.
✓
Service tier and performance level of the database.
Why this is correct
sys.database_service_objectives provides service tier info.

Go deeper

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question