Automate Deployment of Database Resources DP-300 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   An administrator is reviewing an ARM template that deploys an Azure SQL database. They notice that the template has a 'resources' array with a 'dependsOn' element. What is the purpose of the 'dependsOn' element?

   • AIt defines the order in which resources are deployed, ensuring dependencies are created first.
   • BIt sets the access policies for the resources.
   • CIt specifies the resource group where the resources will be deployed.
   • DIt determines the pricing tier for the database.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   An administrator is troubleshooting a failed ARM template deployment. The error message says 'The resource 'Microsoft.Sql/servers/mysqlserver' is not found in the resource group 'rg-sql'.' The template includes a SQL server resource with the name 'mysqlserver'. What is the most likely cause?

   • AThe SQL server resource was not deployed because a dependency was not met.
   • BThe template is using the wrong API version.
   • CThe resource group name is incorrect.
   • DThe SQL server name is already in use in another resource group.
   Reveal Solution Discussion Select an answer first
4. 13expert · hard

   A deployment of an ARM template to create an Azure SQL managed instance fails after 30 minutes. The error message is generic: 'Deployment failed. Please see details for more information.' The administrator needs to identify the root cause quickly. What is the most efficient first step?

   • AReview the Azure Activity Log for the resource group.
   • BContact Azure support immediately.
   • CRe-run the deployment with a different resource group.
   • DCheck the deployment operations in the Azure portal or via CLI to see which resource failed and the specific error.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which Azure CLI command is used to deploy a Bicep file?

   • Aaz resource create
   • Baz group create
   • Caz bicep deploy
   • Daz deployment group create
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A database administrator is deploying an ARM template that creates an Azure SQL logical server and a database. The deployment fails with an error message stating that the resource group 'rg-sql-dev' does not exist. The administrator has verified that the resource group name is correct. What is the most likely cause of the failure?

   • AThe administrator does not have permission to create resources in the resource group.
   • BThe ARM template has a syntax error in the `resources` section.
   • CThe resource group is in a different subscription than the one the administrator is currently authenticated to.
   • DThe ARM template is using an incorrect API version for the SQL server resource.
   Reveal Solution Discussion Select an answer first