A database administrator is deploying an ARM template that creates an Azure SQL database. The deployment fails because the template references a parameter that is not provided. What is the most likely cause and solution?

The template syntax is invalid; rewrite the template using Bicep.

The resource group does not exist; create the resource group first.

The template is too large; split it into multiple templates.

The parameter is missing from the parameter file; provide the value in a parameter file or as a command-line parameter.

A database administrator is automating the deployment of an Azure SQL Database using Azure PowerShell. The deployment must be idempotent, meaning that running the script multiple times should not create duplicate resources or fail if the resources already exist. The administrator wants to use a declarative approach. Which PowerShell command should the administrator use?

`New-AzResource` with a `-ResourceType Microsoft.Sql/servers/databases` and a `-IfNotExists` parameter.

`New-AzResourceGroupDeployment` with a template file and a `-Mode Incremental` parameter.

`New-AzSqlDatabase` with a `-IfNotExists` parameter.

`Set-AzSqlDatabase` with a `-Force` parameter.

Before running Azure PowerShell cmdlets to deploy Azure resources, what must you do first?

Connect to your Azure subscription using Connect-AzAccount

Create a resource group using New-AzResourceGroup

Microsoft Certified:Azure Database Administrator Associate

Domain 4Objective 2

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

Part of the Configure and manage automation of tasks domain, which accounts for 15–20% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 2–4 from this objective — we provide 33 practice questions to prepare you well beyond it. (estimate)

33questions here

7free pages

8concepts

15–20%of the exam

Questions 26–30

26foundation · easy
Which Bicep keyword is used to declare a parameter that can be supplied at deployment time?
Select an answer first
27application · medium
A database administrator is deploying an ARM template that creates an Azure SQL database. The deployment fails because the template references a parameter that is not provided. What is the most likely cause and solution?
Select an answer first
28application · medium
A database administrator is automating the deployment of an Azure SQL Database using Azure PowerShell. The deployment must be idempotent, meaning that running the script multiple times should not create duplicate resources or fail if the resources already exist. The administrator wants to use a declarative approach. Which PowerShell command should the administrator use?
Select an answer first
29foundation · easy
Which Azure PowerShell cmdlet can be used to deploy a Bicep file to a resource group?
Select an answer first
30foundation · easy
Before running Azure PowerShell cmdlets to deploy Azure resources, what must you do first?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

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

Questions 26–30

Which Bicep keyword is used to declare a parameter that can be supplied at deployment time?

A database administrator is deploying an ARM template that creates an Azure SQL database. The deployment fails because the template references a parameter that is not provided. What is the most likely cause and solution?

Which Azure PowerShell cmdlet can be used to deploy a Bicep file to a resource group?

Before running Azure PowerShell cmdlets to deploy Azure resources, what must you do first?

Keep studying — Configure and manage automation of tasks