Your organization uses hybrid Azure AD and all users sign in on hybrid Azure AD–joined Windows 10 devices. An Azure SQL Database supports Azure AD authentication. Developers must connect to the database from SQL Server Management Studio using their on-premises AD accounts while minimizing authentication prompts. Which authentication method should they use?
Choose an answer
Tap an option to check your answer.
Correct answer: Active Directory integrated authentication..
Why this is the answer
Active Directory Integrated authentication is the correct choice because it leverages the existing on-premises Active Directory credentials directly. Since users are already signed into hybrid Azure AD-joined Windows 10 devices with their on-premises AD accounts, this method allows for single sign-on (SSO) to Azure SQL Database, minimizing authentication prompts. Azure AD token authentication would require obtaining an Azure AD access token separately, which might involve additional prompts or configuration. Azure Multi-Factor Authentication (MFA) is a security feature, not an authentication method in itself for this scenario; while it could be enabled on top of other methods, it would increase authentication prompts, not minimize them.
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