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…

The correct answer is D. a user-assigned managed identity. Elastic jobs support two authentication methods to connect to target databases: Microsoft Entra ID (Azure AD) authentication using a user-assigned managed identity (UMI) or database-scoped Microsoft recommends using user-assigned managed identity (UMI) for authentication…

Submitted by haruto_sh· Mar 6, 2026Implement a secure environment

Question

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?

Options

Aa system-assigned managed identity
BAzure SQL sign-in credentials
Cdatabase-scoped credentials
Da user-assigned managed identity

How the community answered

(36 responses)

A
19% (7)
B
6% (2)
C
8% (3)
D
67% (24)

Explanation

Elastic jobs support two authentication methods to connect to target databases: Microsoft Entra ID (Azure AD) authentication using a user-assigned managed identity (UMI) or database-scoped Microsoft recommends using user-assigned managed identity (UMI) for authentication because it integrates with Azure AD and supports Conditional Access policies, including location-based

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice