Which authentication method should you recommend?

You have a hybrid configuration of Azure Active Directory (Azure AD). You have an Azure SQL Database instance that is configured to support Azure AD authentication.

Database developers must connect to the database instance and authenticate by using their on-premises

Active Directory account.

You need to ensure that developers can connect to the instance by using Microsoft SQL Server Management Studio. The solution must minimize authentication prompts.

Which authentication method should you recommend?
A . Active Directory – Password
B . Active Directory – Universal with MFA support
C . SQL Server Authentication
D . Active Directory – Integrated

View Answer

Answer: D

Explanation:

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure