AZ-204 Certification Practice Question #14

Question

You manage an Azure SQL database that allows for Azure AD authentication.
You need to make sure that database developers can connect to the SQL database via Microsoft SQL Server Management Studio (SSMS). You also need to make sure the developers use their on-premises Active Directory account for authentication. Your strategy should allow for authentication prompts to be kept to a minimum.
Which of the following should you implement?

Accepted Answer

Active Directory integrated authentication (now Microsoft Entra Integrated) allows users logged into a Windows domain-joined machine to authenticate to Azure SQL resources using their current Windows credentials without entering a password. For this to work, the on-premises Active Directory domain must be federated or configured for seamless single sign-on with Azure Active Directory (Microsoft Entra ID). This provides a seamless connection from SSMS with minimal authentication prompts, utilizing the credentials of the logged-in Windows user.

More AZ-204 practice questions