You administer an Azure SQL Database that supports Azure AD authentication. You must enable database developers to connect with Microsoft SQL Server Management Studio (SSMS) using their on-premises Active Directory credentials, while minimizing sign-in prompts. Which option should you implement?
Choose an answer
Tap an option to check your answer.
Correct answer: Use Active Directory integrated authentication..
Why this is the answer
Active Directory Integrated authentication allows users to connect to Azure SQL Database using their Windows credentials from a domain-joined machine, providing a seamless single sign-on experience. This minimizes sign-in prompts as the user's existing Kerberos or NTLM credentials are used for authentication. Using an Azure AD token would require manual acquisition and refresh, leading to more prompts. Requiring Azure Multi-Factor Authentication, while enhancing security, would explicitly add an additional sign-in step, contradicting the goal of minimizing prompts. OATH software tokens are typically used for MFA and would also add an extra authentication factor.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed