Exam DP-300 topic 2 question 44 discussion

Actual exam question from Microsoft's DP-300

Question #: 44
Topic #: 2

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?

A. 1
B. 2
C. 3
D. 4

Show Suggested Answer

Suggested Answer: B 🗳️

by voodoo_sh at Aug. 15, 2024, 10:25 p.m.

Comments

Submit Cancel

2f5c7cd

8 months ago

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

upvoted 1 times

...

bingomutant

8 months, 2 weeks ago

To 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.

upvoted 1 times

...

voodoo_sh

10 months, 1 week ago

Since SQLDB11 and SQLDB22 are on different Logical SQL Servers, hence 2 separate credentials are needed to connect to those servers

upvoted 1 times

...