DP-300 · Question #348
You have an Azure subscription that contains the resources shown in the following table. You plan to use SQLDB11 as an elastic job database to run jobs on SQLDB11 and SQLDB22. What is the minimum…
The correct answer is B. 2. Elastic jobs require database-scoped credentials for each target server or database group they interact with.
Question
Exhibits
Options
- A1
- B2
- C3
- D4
How the community answered
(58 responses)- A3% (2)
- B90% (52)
- C2% (1)
- D5% (3)
Why each option
Elastic jobs require database-scoped credentials for each target server or database group they interact with.
One credential would only allow access to a single target database or server, not both SQLDB11 and SQLDB22.
Since SQLDB11 and SQLDB22 are separate databases on different servers (implied by SQLDB11 and SQLDB22 names for jobs running on both), two database-scoped credentials are required: one for SQLDB11 and one for SQLDB22 to enable job agent connectivity to these targets.
Three credentials are more than necessary as only two distinct target databases (SQLDB11 and SQLDB22) are specified for the jobs.
Four credentials are excessive; the requirement is to run jobs on two specific databases, which means two distinct sets of credentials are sufficient.
Concept tested: Azure SQL Elastic Jobs database-scoped credentials
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview?view=azuresql
Community Discussion
No community discussion yet for this question.