DP-300 Configure and manage automation of tasks Practice Question
You have an Azure SQL Database that must be automatically restarted every night to clear the procedure cache. You plan to use elastic jobs in Azure SQL Database. What should you create first?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
An elastic job agent
An elastic job agent is the top-level resource that orchestrates jobs. Before creating any jobs, you must create the elastic job agent. The job database (A) stores job definitions but is created as part of agent setup or after. Target groups (C) and job credentials (D) are created after the agent exists.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A job database
Why it's wrong here
The job database is specified when creating the job agent.
- ✓
An elastic job agent
Why this is correct
The job agent is required before creating jobs, targets, and credentials.
- ✗
A target group
Why it's wrong here
Target groups are defined after the job agent.
- ✗
A job credential
Why it's wrong here
Credentials are created after the job agent.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.