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

Questions 6–10

1. 6foundation · easy

   When deploying an ARM template from the Azure portal, what must you provide in addition to the template file?

   • AA subscription and resource group
   • BA connection string to the database
   • CAn Azure Active Directory tenant ID
   • DA storage account for logs
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the first step when using Azure CLI to deploy resources?

   • ARun az login to authenticate
   • BRun az account set to select a subscription
   • CRun az configure to set defaults
   • DRun az group create to create a resource group
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A database administrator is using Bicep to deploy an Azure SQL logical server and database. The Bicep file includes a parameter for the administrator login and password. The administrator wants to ensure that the password is not stored in plain text in the Bicep file or in the deployment history. What should the administrator do?

   • AStore the password in a parameter file and reference it in the Bicep file.
   • BUse the `@secure()` decorator on the password parameter in the Bicep file and pass the password as a secure string parameter during deployment.
   • CUse the `az deployment group create` command with the `--parameters` flag to pass the password as a plain text string.
   • DUse the `@description()` decorator to hide the password from the deployment history.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is a key advantage of using Bicep over writing ARM templates directly in JSON?

   • ABicep is a proprietary language that only works with Azure Stack
   • BBicep eliminates the need for resource providers
   • CBicep provides a simpler, more readable syntax that is transpiled to ARM templates
   • DBicep can only be used for database resources
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A database administrator uses Azure PowerShell to deploy an ARM template that creates an Azure SQL database. The deployment fails, but the administrator wants to know the exact error message for the failed resource. Which PowerShell cmdlet should they use?

   • AGet-AzResourceGroupDeployment -ResourceGroupName rg-sql -Name <deployment-name>
   • BGet-AzResourceGroupDeploymentOperation -ResourceGroupName rg-sql -DeploymentName <deployment-name>
   • CGet-AzLog -ResourceGroup rg-sql
   • DGet-AzSqlDatabase -ResourceGroupName rg-sql -ServerName <server-name>
   Reveal Solution Discussion Select an answer first