You have an Azure Automation runbook that runs a stored procedure on an Azure SQL Database. The runbook has been failing with the error 'Login failed for user 'NT AUTHORITY\SYSTEM'.' The runbook uses a Managed Identity to authenticate. What is the most likely cause of this error?

The Managed Identity is not enabled on the Automation Account.

The Managed Identity has not been granted permission to the database.

The runbook is using the wrong connection string.

The database server does not allow Azure services to access it.

When an automated database task fails, what is the first place you should look to identify the cause?

The network security group settings

The Azure subscription's cost management

The database's backup configuration

The logs or execution history of the task

Contoso has 50 Azure SQL databases across 10 logical servers in different resource groups. The DBA team needs to run a weekly index maintenance script against all databases. They want to use Elastic Jobs. What must be created first before the job can be configured?

An Azure SQL Database elastic pool to host all the target databases

A job agent in the same region as the logical servers, then add all databases as members of a target group

A PowerShell runbook in Azure Automation to orchestrate the job steps

A database scoped credential on each of the 50 databases for the job to authenticate

What is the purpose of using an Azure Automation runbook to create a database task?

To provide a graphical interface for database management

To automate the execution of database operations without manual intervention

To replace the need for a database administrator

What is the first step in setting up an alert for an automated database task in Azure Monitor?

Define the alert condition based on a metric or log

Microsoft Certified:Azure Database Administrator Associate

Domain 4Objective 3

Create and Manage Database Tasks in Azure DP-300 Practice Questions (Page 2)

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 6–10

6expert · hard
You have an Azure Automation runbook that runs a stored procedure on an Azure SQL Database. The runbook has been failing with the error 'Login failed for user 'NT AUTHORITY\SYSTEM'.' The runbook uses a Managed Identity to authenticate. What is the most likely cause of this error?
Select an answer first
7foundation · easy
When an automated database task fails, what is the first place you should look to identify the cause?
Select an answer first
8application · medium
Contoso has 50 Azure SQL databases across 10 logical servers in different resource groups. The DBA team needs to run a weekly index maintenance script against all databases. They want to use Elastic Jobs. What must be created first before the job can be configured?
Select an answer first
9foundation · easy
What is the purpose of using an Azure Automation runbook to create a database task?
Select an answer first
10foundation · easy
What is the first step in setting up an alert for an automated database task in Azure Monitor?
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.