Microsoft Certified:Azure Database Administrator Associate
Domain 4Objective 3
Create and Manage Database Tasks in Azure 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 34 practice questions to prepare you well beyond it. (estimate)
34questions here
7free pages
10concepts
15–20%of the exam
Questions 16–20
- 16
Which component of an elastic job determines the databases that the job will run against?
Select an answer first - 17
You have an Elastic Job that runs a stored procedure on a target database. The job step fails with the error 'The stored procedure execution failed. See the job history for details.' You checked the job history and found the error 'Cannot find the object 'dbo.usp_DataRefresh' because it does not exist or you do not have permissions.' You verified that the stored procedure exists in the target database. What is the most likely cause?
Select an answer first - 18
Which benefit is provided by using elastic jobs in Azure SQL Database?
Select an answer first - 19
Which component is required to create an elastic job in Azure SQL Database?
Select an answer first - 20
Which Azure Automation component is used to execute scripts that perform database tasks?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.