Learn the minimum number of database scoped credentials needed when using an Azure SQL database as an elastic job database to run jobs on multiple target databases.
Table of Contents
Question
You have an Azure subscription that contains the resources shown in the following table.
| Name | Type | Description |
|---|---|---|
| SQLSVR1 | Logical SQL server | Hosts one Azure SQL database |
| SQLDB11 | Azure SQL database | Is hosted by SQLSVR1 |
| SQLSVR2 | Logical SQL server | Hosts two Azure SQL database |
| SQLDB21 | Azure SQL database | Is hosted by SQLSVR2 |
| SQLDB22 | Azure SQL database | Is hosted by SQLSVR2 |
You plan to use SQLDB11 as an elastic job database to run jobs on SQLDB11 and SQLDB22.
What is the minimum number of database scoped credentials required for the elastic jobs?
A. 1
B. 2
C. 3
D. 4
Answer
B. 2
Explanation
To run elastic jobs on Azure SQL databases using one database as the job database, you need a minimum of 2 database scoped credentials:
- A credential for the elastic job database itself (SQLDB11 in this scenario). This credential allows the elastic job agent to connect to the job database to retrieve job metadata and store job execution history.
- A credential for the target logical SQL server that hosts the databases you want to run jobs on (SQLSVR2 in this scenario, which hosts SQLDB22). This credential allows the job database to connect to the target databases and execute the job steps.
You do not need separate credentials for each individual target database, just one for the logical SQL server hosting them.
So in this case, with the job database SQLDB11 running jobs on itself and one other database SQLDB22 on a different server, only 2 database scoped credentials are required. The credential for SQLSVR1 is not necessary since elastic jobs are not running on any additional databases it hosts.
Microsoft DP-300 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Microsoft DP-300 exam and earn Microsoft DP-300 certification.