Practice Test 1 | Microsoft Azure Security Technologies | AZ-500 | Dumps | Mock Test
A company currently has an on-premise data center and an Azure subscription. An Azure SQL database is in place that supports Azure AD authentication. The database developers need to authenticate to the database using Microsoft SQL Server Management Studio. They need to authenticate using their on-premise Active Directory account. They also want to ensure that the solution minimizes the authentication prompts. Which of the following authentication type should they use in Microsoft SQL Server Management Studio to connect?
A. SQL Login
B. Active Directory – Universal with MFA support
C. Active Directory – Integrated
D. Active Directory – Password
Answer – C
When you need to use a federated solution with your on-premise Active Directory you should use the authentication type as Active Directory – Integrated in Microsoft SQL Server Management Studio
The Microsoft documentation mentions the following.
Since this is clearly mentioned in the Microsoft documentation, all other options are incorrect.
For more information on configuring client computers for Active Directory authentication with Azure SQL databases, one can visit the below URL-
Comments are closed, but trackbacks and pingbacks are open.