Administering Relational Databases on Microsoft Azure — Question 60

You have an Azure subscription that contains an Azure SQL database named DB1.

You need to host elastic jobs by using DB1. DB1 will also be configured as a job target. The solution must support the use of location-based Conditional Access policies.

What should the elastic jobs use to access DB1?

Answer options

• A. a system-assigned managed identity
• B. Azure SQL sign-in credentials
• C. database-scoped credentials
• D. a user-assigned managed identity

Correct answer: D

Explanation

The correct answer is D, as a user-assigned managed identity allows for the implementation of location-based Conditional Access policies and can be assigned specifically to resources like DB1. The other options, while useful in certain contexts, do not meet the specific requirement of supporting these policies effectively.