An organization deploys Azure SQL databases using ARM templates. They have a template that creates a server and a database. They want to deploy the template to multiple subscriptions, but they need to ensure that the database is created only if the server deployment succeeds. What is the best way to handle this?

Use a nested template for the database with a condition that checks the server deployment status.

Use a deployment script to check if the server exists before deploying the database.

Deploy the server and database in separate templates and use a script to check the server deployment before deploying the database.

Use the 'dependsOn' element in the database resource to reference the server resource.

A developer is writing a Bicep file to deploy an Azure SQL database. They want to use the output of one resource (e.g., the SQL server name) as an input to another resource (e.g., the database). How should they reference the server name in the database resource definition?

Use the resourceId() function with the server's name.

Use the symbolic name of the server resource, such as 'serverName'.

Use the reference() function with the server's name.

Use the az CLI command to fetch the server name at deployment time.

What is the primary purpose of the 'outputs' section in an ARM template?

To define the resources that will be deployed

To specify the Azure region for the deployment

To declare variables that are used within the template

To return values from the deployment, such as connection strings or resource IDs

Microsoft Certified:Azure Database Administrator Associate

Domain 4Objective 2

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

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 16–20

16expert · hard
An organization deploys Azure SQL databases using ARM templates. They have a template that creates a server and a database. They want to deploy the template to multiple subscriptions, but they need to ensure that the database is created only if the server deployment succeeds. What is the best way to handle this?
Select an answer first
17foundation · easy
Which Azure PowerShell cmdlet is used to create a new Azure SQL Database?
Select an answer first
18application · medium
A developer is writing a Bicep file to deploy an Azure SQL database. They want to use the output of one resource (e.g., the SQL server name) as an input to another resource (e.g., the database). How should they reference the server name in the database resource definition?
Select an answer first
19application · medium
A company uses Azure PowerShell to deploy Azure SQL databases. They need to deploy a new database and then verify that the deployment completed successfully before proceeding with further automation. Which PowerShell cmdlet should they use to check the deployment status?
Select an answer first
20foundation · easy
What is the primary purpose of the 'outputs' section in an ARM template?
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 4)

Questions 16–20

Which Azure PowerShell cmdlet is used to create a new Azure SQL Database?

A developer is writing a Bicep file to deploy an Azure SQL database. They want to use the output of one resource (e.g., the SQL server name) as an input to another resource (e.g., the database). How should they reference the server name in the database resource definition?

A company uses Azure PowerShell to deploy Azure SQL databases. They need to deploy a new database and then verify that the deployment completed successfully before proceeding with further automation. Which PowerShell cmdlet should they use to check the deployment status?

What is the primary purpose of the 'outputs' section in an ARM template?

Keep studying — Configure and manage automation of tasks