Plan and implement data platform resources →hardMultiple ChoiceObjective-mapped

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Refer to the exhibit.

```powershell
$params = @{
    ResourceGroupName = 'rg-sql'
    ServerName = 'sqlserver1'
    DatabaseName = 'db1'
    Edition = 'GeneralPurpose'
    ComputeGeneration = 'Gen5'
    VCores = 4
    MaxVCores = 8
    MinVCores = 0.5
    AutoPauseDelayInMinutes = 60
}
New-AzSqlDatabase @params
```

You are deploying an Azure SQL Database using PowerShell as shown in the exhibit. The database will be used by a development team that works intermittently. You need to ensure the database is cost-effective while being available on demand. What is the purpose of the AutoPauseDelayInMinutes parameter?

⚠ Common exam trap

A common mix-up: candidates confuse the auto-pause feature with a manual pause/resume operation or with a scheduled shutdown, and they incorrectly assume AutoPauseDelayInMinutes controls resume speed or maximum pause duration, when in fact it only defines the inactivity threshold before automatic pausing occurs.

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

✓

It controls the automatic pausing of the database after a period of inactivity to save costs.

The AutoPauseDelayInMinutes parameter is used with Azure SQL Database serverless compute tier. It specifies the number of minutes of inactivity (no CPU usage or active sessions) after which the database automatically pauses, stopping compute billing while storage remains billed. This makes the database cost-effective for intermittent development workloads because it eliminates compute costs during idle periods and automatically resumes on the first connection.

Answer analysis

Option-by-option breakdown

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

✗
It configures the database to pause during a disaster recovery scenario.
Why it's wrong here
Auto-pause is not related to disaster recovery.
✓
It controls the automatic pausing of the database after a period of inactivity to save costs.
Why this is correct
Serverless databases pause after inactivity to reduce costs.
✗
It sets the maximum duration for which the database can be paused.
Why it's wrong here
AutoPauseDelayInMinutes sets the inactivity period before pausing.
✗
It determines how long the database takes to resume after a pause.
Why it's wrong here
Resume time is not controlled by this parameter.

Quick reference

Cloud Service Model Comparison

Model	You Manage	Provider Manages	Examples
IaaS	OS, runtime, apps, data	Hardware, hypervisor, networking	EC2, Azure VMs, GCP Compute Engine
PaaS	Apps and data	OS, runtime, middleware, hardware	Elastic Beanstalk, Azure App Service
SaaS	Data and settings only	Everything else	Microsoft 365, Salesforce, Workday
FaaS / Serverless	Function code only	Infra, scaling, runtime	Lambda, Azure Functions, Cloud Run
CaaS	Containers and apps	Kubernetes, OS, hardware	EKS, AKS, GKE

Go deeper

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Cloud Service Model Comparison

Related to this question