DP-300 · Question #447
Hotspot Question You have an Azure subscription. You deploy resources by using the following Bicep template. For each of the following statements, select Yes if the statement is true, otherwise…
The correct answer is Server1 will support mixed authentication. = Yes; Database1 will scale dynamically based on the load. = No; Server1 will be created as an Azure SQL managed instance. = No. The Bicep template deploys an Azure SQL Server (not a managed instance) with 'administratorLogin' and likely 'azureADOnlyAuthentication: false', which enables mixed authentication (both SQL authentication and Azure AD authentication). The database uses a specific SKU tier…
Question
Exhibits
Answer Area
- Server1 will support mixed authentication.Yes
- Database1 will scale dynamically based on the load.No
- Server1 will be created as an Azure SQL managed instance.No
Explanation
The Bicep template deploys an Azure SQL Server (not a managed instance) with 'administratorLogin' and likely 'azureADOnlyAuthentication: false', which enables mixed authentication (both SQL authentication and Azure AD authentication). The database uses a specific SKU tier (likely Standard or Basic with a fixed DTU or vCore tier) rather than Serverless or Hyperscale with auto-scaling, meaning it does NOT scale dynamically based on load. Azure SQL Managed Instance is a separate resource type ('Microsoft.Sql/managedInstances'), whereas the template uses 'Microsoft.Sql/servers', which is a logical Azure SQL Server - confirming it is NOT a managed instance.
Topics
Community Discussion
No community discussion yet for this question.