How many database scoped credentials are required for Azure SQL elastic jobs?
Short answer
B 2
Question
Key Takeaways
The exam tests whether you know that elastic jobs authenticate per logical server, not per database, so each distinct logical server hosting target databases requires its own database scoped credential.
Azure SQL elastic jobs use database scoped credentials stored in the job database to authenticate against target databases. When target databases reside on different logical SQL servers, a separate credential is required for each server.
Common mistake: Many candidates choose 1, assuming a single credential can cover all target databases regardless of which logical server they live on, overlooking that credentials are scoped to the logical server connection.
Expert Analysis
Why the Answer Is Correct
The correct answer is B (2). SQLDB11 resides on SQLSVR1 and SQLDB22 resides on SQLSVR2, which are two different logical SQL servers. Database scoped credentials used by elastic jobs authenticate against the logical server, so one credential is needed for SQLSVR1 and another for SQLSVR2. The credentials themselves are created inside the job database (SQLDB11), but each maps to a distinct target logical server.
Why the Other Options Are Wrong
Option A (1) is wrong because a single credential cannot authenticate against two different logical servers; each logical server requires its own credential. Option C (3) is wrong because there is no third logical server or additional target group requiring a separate credential. Option D (4) is wrong because it incorrectly assumes a credential is needed per database or per server plus job database, which is not how elastic job authentication works.
Community Comment Notes
Comment [1] correctly points learners to the official elastic jobs overview page that explains authentication via database scoped credentials created in the job database. Comment [2] clearly explains that because SQLDB11 and SQLDB22 are on different logical servers, two separate credentials are required, one per logical server. Comment [3] reinforces the same conclusion, confirming that different logical servers demand separate credentials.
Official Reference
This link opens the official vendor documentation in a new tab.
Exam Strategy
When an elastic job question mentions multiple target databases, first identify how many distinct logical servers host them. The number of required database scoped credentials equals the number of distinct logical servers, not the number of databases.
Discussion 3 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 3
-
bingomutant 👍 1To run elastic jobs across databases on different logical SQL servers, you will need a database-scoped credential for each logical SQL server where jobs need to be executed. Since SQLDB11 and SQLDB22 are on different logical servers (SQLSVR1 and SQLSVR2, respectively), you will need: A database-scoped credential for SQLSVR1 (for SQLDB11). A database-scoped credential for SQLSVR2 (for SQLDB22). Thus, the minimum number of database-scoped credentials required is 2, one for each logical server.
-
2f5c7cd 👍 1The 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
-
voodoo_sh 👍 1Since SQLDB11 and SQLDB22 are on different Logical SQL Servers, hence 2 separate credentials are needed to connect to those servers
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 →