Hotspot Question You have the following Azure Resource Manager template. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection…

The correct answer is The template deploys a serverless Azure SQL database. = No; The template deploys a database to an Azure SQL Database managed instance. = Yes; The pricing tier of the database deployment is based on DTUs. = No. The template deploys a database to an Azure SQL Database Managed Instance, as indicated by the resource type 'Microsoft.Sql/managedInstances/databases' in the ARM template. Managed Instances use a vCore-based purchasing model (not DTUs), and they are not serverless - serverless…

Submitted by anjalisingh· Mar 6, 2026Deploy and manage Azure compute resources / Implement and manage Azure SQL solutions - typically mapped to AZ-104 or DP-300 certification objectives covering Azure SQL deployment models and pricing tiers

Question

Hotspot Question You have the following Azure Resource Manager template. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Answer:

Exhibits

Answer Area

The template deploys a serverless Azure SQL database.No
The template deploys a database to an Azure SQL Database managed instance.Yes
The pricing tier of the database deployment is based on DTUs.No

Explanation

The template deploys a database to an Azure SQL Database Managed Instance, as indicated by the resource type 'Microsoft.Sql/managedInstances/databases' in the ARM template. Managed Instances use a vCore-based purchasing model (not DTUs), and they are not serverless - serverless is a compute tier available only for single Azure SQL Databases, not Managed Instances. The 'Yes' answer for the second statement is correct because the resource hierarchy explicitly references a managedInstances parent resource.

Topics

#Azure SQL Database Managed Instance#ARM Templates#vCore vs DTU Purchasing Model#Serverless SQL

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice