A PowerShell script deploys an ARM template to create an Azure SQL database. The deployment fails with an error that the 'Microsoft.Sql/servers/databases' resource type is not registered for the subscription. What should the administrator do first?

Create the resource group again with a different location.

Re-run the deployment with the -Verbose flag to get more details.

Run Register-AzResourceProvider -ProviderNamespace Microsoft.Sql

Use the Azure CLI instead of PowerShell to deploy the template.

A database administrator uses Azure PowerShell to deploy an Azure SQL database. They want to ensure that if the deployment fails, the script stops and does not continue to the next step. Which PowerShell concept should they use?

Use the -Verbose parameter to see detailed output.

Use the -ErrorAction Stop parameter on the deployment cmdlet.

Use the -AsJob parameter to run the deployment in the background.

Use the -Force parameter on the deployment cmdlet.

In the Azure portal, where can you view the status of a deployment?

In the 'Activity log' of the subscription

In the 'Access control (IAM)' blade

In the 'Overview' page of the resource

In the 'Deployments' blade of the resource group

Microsoft Certified:Azure Database Administrator Associate

Domain 4Objective 2

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

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 1–5

1application · medium
A PowerShell script deploys an ARM template to create an Azure SQL database. The deployment fails with an error that the 'Microsoft.Sql/servers/databases' resource type is not registered for the subscription. What should the administrator do first?
Select an answer first
2application · medium
A database administrator uses Azure PowerShell to deploy an Azure SQL database. They want to ensure that if the deployment fails, the script stops and does not continue to the next step. Which PowerShell concept should they use?
Select an answer first
3foundation · easy
Which section of an Azure Resource Manager (ARM) template is used to define the actual Azure resources that will be deployed?
Select an answer first
4foundation · easy
In the Azure portal, where can you view the status of a deployment?
Select an answer first
5foundation · easy
Which Azure CLI command shows the status of a resource group deployment?
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 1)

Questions 1–5

A PowerShell script deploys an ARM template to create an Azure SQL database. The deployment fails with an error that the 'Microsoft.Sql/servers/databases' resource type is not registered for the subscription. What should the administrator do first?

A database administrator uses Azure PowerShell to deploy an Azure SQL database. They want to ensure that if the deployment fails, the script stops and does not continue to the next step. Which PowerShell concept should they use?

Which section of an Azure Resource Manager (ARM) template is used to define the actual Azure resources that will be deployed?

In the Azure portal, where can you view the status of a deployment?

Which Azure CLI command shows the status of a resource group deployment?

Keep studying — Configure and manage automation of tasks