A company uses Azure Automation runbooks to perform nightly database maintenance tasks on Azure SQL Databases. The runbook needs to connect to the databases securely without storing credentials in the runbook. What is the recommended way to authenticate?

Store the SQL username and password as variables in the Automation account and use them in the runbook.

Use a connection asset in the Automation account to store the SQL connection string.

Create a certificate in the Automation account and use it to authenticate to SQL.

Use an Azure Automation Run As account and grant it access to the databases.

Why are alerts and notifications important for automated database tasks?

They automatically fix any issues that occur during task execution

They allow administrators to be informed of task failures or issues promptly

They are required for all automated tasks to run

They replace the need for monitoring database performance

A company wants to automate a complex database maintenance task that involves multiple steps, including running a PowerShell script and then a T-SQL script. They want to use a single service to manage this. What should they use?

Azure Data Factory pipeline with a PowerShell activity and a SQL activity.

Azure Automation runbook that includes both PowerShell and T-SQL steps.

Elastic Job with multiple job steps, one for PowerShell and one for T-SQL.

Azure Logic App with a PowerShell connector and a SQL connector.

You created an Elastic Job that runs a stored procedure on a target database. The job fails with the error 'The target database is not in an elastic job target group.' You verified that the database is in the target group. What is the most likely cause of this error?

The target database is in a different region than the job agent.

The job agent's database user does not have permission to view the target group.

The job step is using the wrong credential to connect to the target database.

The job agent is not in the same resource group as the target database.

Microsoft Certified:Azure Database Administrator Associate

Domain 4Objective 3

Create and Manage Database Tasks in Azure 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 34 practice questions to prepare you well beyond it. (estimate)

34questions here

7free pages

10concepts

15–20%of the exam

Questions 26–30

26application · medium
A company uses Azure Automation runbooks to perform nightly database maintenance tasks on Azure SQL Databases. The runbook needs to connect to the databases securely without storing credentials in the runbook. What is the recommended way to authenticate?
Select an answer first
27foundation · easy
Which component in Azure Automation is used to trigger a runbook at a specific time?
Select an answer first
28foundation · easy
Why are alerts and notifications important for automated database tasks?
Select an answer first
29application · medium
A company wants to automate a complex database maintenance task that involves multiple steps, including running a PowerShell script and then a T-SQL script. They want to use a single service to manage this. What should they use?
Select an answer first
30expert · hard
You created an Elastic Job that runs a stored procedure on a target database. The job fails with the error 'The target database is not in an elastic job target group.' You verified that the database is in the target group. What is the most likely cause of this error?
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.