Configure and manage automation of tasks →mediumMultiple ChoiceObjective-mapped

DP-300 Configure and manage automation of tasks Practice Question

Exhibit

Refer to the exhibit.

{
  "type": "Microsoft.Sql/servers/databases",
  "apiVersion": "2023-05-01-preview",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "maxSizeBytes": 5368709120,
    "requestedServiceObjectiveName": "S2",
    "zoneRedundant": false,
    "autoPauseDelay": 60
  }
}

Refer to the exhibit. You deploy this ARM template for an Azure SQL Database. The deployment succeeds. Which statement about the deployed database is true?

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 provisioned tier

The ARM template specifies `requestedServiceObjectiveName: S2`, which corresponds to a provisioned tier (S2). The `autoPauseDelay` property is only applicable to serverless databases; when used with a provisioned tier, it is ignored and does not cause the deployment to fail. Therefore, the database is deployed as a provisioned tier S2 database. Option A is correct. Option B is incorrect because the database is not serverless. Option C is incorrect because `zoneRedundant` is set to false. Option D is incorrect because `maxSizeBytes` is 5 GB, which is less than 250 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 database is provisioned tier
Why this is correct
S2 is a provisioned tier service objective.
✗
The database is in serverless tier
Why it's wrong here
autoPauseDelay is ignored, but S2 is provisioned.
✗
The database is zone redundant
Why it's wrong here
zoneRedundant is false.
✗
The database maximum size is 250 GB
Why it's wrong here
maxSizeBytes is 5 GB.

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 Configure and manage automation of tasks Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Cloud Service Model Comparison

Related to this question