DP-300 Certification Practice Question #104

Question

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 number of database scoped credentials required for the elastic jobs?

Accepted Answer

To run elastic jobs, the Elastic Job agent must authenticate to both the job database and the target databases. Since the target databases reside on two different logical SQL servers (SQLSVR1 and SQLSVR2), a separate database-scoped credential is required for each logical server. This means we need one credential for SQLSVR1 (to access SQLDB11) and another credential for SQLSVR2 (to access SQLDB22), resulting in a minimum of 2 database-scoped credentials.

More DP-300 practice questions