What is the first step to automate DB3 management using elastic jobs?
Short answer
C Create database-scoped credentials in DB3.
Question
Key Takeaways
The exam tests understanding of elastic job automation prerequisites, specifically that database-scoped credentials must exist in the target database before creating elastic jobs, avoiding unnecessary infrastructure costs.
This question tests the initial step for automating Azure SQL Database management using elastic jobs with database-scoped credentials. Community consensus is split, but the correct first step is creating database-scoped credentials directly in DB3 to minimize costs and administrative effort.
Common mistake: Many candidates incorrectly choose option D (creating a separate database for database-scoped credentials) without recognizing that DB3 already exists and can host the credentials directly, leading to unnecessary costs and complexity.
Expert Analysis
Why the Answer Is Correct
Option C is correct because DB3 already exists in the environment, and the requirement specifically states to use elastic jobs with database-scoped credentials. According to Microsoft documentation, database-scoped credentials can be created directly in the target database that will be managed by elastic jobs. This approach minimizes costs by avoiding the creation of additional databases and reduces administrative effort as required by the business requirements. The credential creation is the foundational first step before elastic job agents can authenticate and execute automated management tasks.
Why the Other Options Are Wrong
Option A is incorrect because Microsoft Entra authentication is not required for elastic jobs using database-scoped credentials - the scenario specifically calls for database-scoped credentials as the authentication method. Option B is wrong because private endpoints relate to network connectivity and security, not the authentication prerequisites for elastic job automation. Option D is incorrect because it suggests creating a new database for credentials, which contradicts the cost minimization requirement and is unnecessary since DB3 already exists and can store the database-scoped credentials directly.
Community Comment Notes
The community shows significant debate with 57 votes for C and 43 for D. Comment [1] correctly identifies that elastic job agents can use database-scoped credentials for authentication. Comment [3] argues for D based on documentation stating credentials must be in the job database, but misses that DB3 itself can serve this purpose. Comment [4] provides the strongest reasoning for C, emphasizing the cost requirement ($30/month savings) and noting DB3 already exists. Comment [5] references documentation about creating job databases but doesn't address that this applies when setting up a dedicated job agent database, not when using existing databases with database-scoped credentials.
Official Reference
https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview?view=azuresql
This link opens the official vendor documentation in a new tab.
Exam Strategy
When answering Azure SQL management questions, always check if existing resources can fulfill requirements before creating new ones. Pay close attention to cost minimization requirements, as they often indicate you should use existing infrastructure rather than provisioning additional resources.
Community Votes
57% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 6 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 6
-
ae8a90c 👍 3 Answered DThe elastic job agent can connect to the server(s)/database(s) specified by the target group via two authentication options: Use Microsoft Entra (formerly Azure Active Directory) authentication with a user-assigned managed identity (UMI). Use Database-scoped credentials.
-
JJJR 👍 2 Answered DI believe this is D: The database-scoped credentials must be created in the job database. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview?view=azuresql#authentication-via-database-scoped-credentials
-
scottytohotty 👍 2 Answered CDB3 already exists, so there is no reason to create a new database as D states??? C seems to fit, but I am not super savvy here.
-
2f5c7cd 👍 1 Answered DCreate or identify an empty S1 or higher Azure SQL Database, using the DTU purchase model. This database should be in the same server as the job agent. This database is used as the job database during elastic job agent creation. You can create a single database via the Azure portal, Azure CLI, Azure CLI (sql up), or PowerShell. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tutorial?view=azuresql#create-and-configure-the-elastic-job-agent
-
voodoo_sh 👍 1 Answered CC: Create db-scoped credentials in DB3. • Minimize costs whenever possible, without affecting other requirements. • Minimize administrative effort. Since S1 database costs $30 per months, so I would go with C and not create a separate database for jobs, to save on costs and administrative efforts.
Show 1 more comment
-
pjfunner 👍 5 Answered CAnswer seems correct. C.
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.
Related Analysis
Practice All DP-300 Questions
Access 105 questions with complete answers and detailed explanations.
View Full DP-300 Practice Test →