Practice Test 1 | Microsoft Azure Security Technologies | AZ-500 | Dumps | Mock Test
View Case Study
Which of the following authentication technique would users in whizlabgrp2 use to log into the Azure SQL database when using SQL Server Management Studio? Choose two answers from the options given below
A. Active Directory Password
B. Active Directory Integrated
C. Active Directory Universal with MFA
D. Using Application token authentication
Answer – A and C
In the case studies, we have been given the requirement “The users from the group “whizlabgrp2” need to log into the SQL database using their Azure AD credentials.”
For every contained user relative to an Azure AD user, you can log into the database using either Active Directory Universal with MFA or Active Directory Password.
An example of using Active Directory Universal with MFA is shown below.
Here you specify the Azure AD domain name.
Option B is incorrect since this feature is good if a user has already logged into your on-premise Active Directory domain. and want to connect Azure SQL server but does not want to be prompted for the credential.
Option D is incorrect since this is used to connect from an application.
For more information on database authentication, one can visit the below URL-
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
Comments are closed, but trackbacks and pingbacks are open.