DP-300 Certification Practice Question #198

Question

You need to deploy an Azure SQL Database elastic pool by using a Bicep template.

How should you complete the template? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

The Azure Resource Manager (ARM/Bicep) resource type for elastic pools is `Microsoft.Sql/servers/elasticPools` — making **servers** the correct parent path segment. For serverless elastic pools, `minCapacity` specifies the minimal capacity (in vCores) that the pool will not shrink below when not paused, which is exactly what the HOTSPOT template is asking for. The `Capacity` property belongs to the SKU object (total capacity), while `maxCapacity` is a per-database setting inside `perDatabaseSettings`.

More DP-300 practice questions