Exam AZ-500 All Questions

View all questions & answers for the AZ-500 exam

Exam AZ-500 topic 5 question 21 discussion

Actual exam question from Microsoft's AZ-500

Question #: 21
Topic #: 5

You have a hybrid configuration of Azure Active Directory (Azure AD).
All users have computers that run Windows 10 and are hybrid Azure AD joined.
You have an Azure SQL database that is configured to support Azure AD authentication.
Database developers must connect to the SQL database by using Microsoft SQL Server Management Studio (SSMS) and authenticate by using their on-premises
Active Directory account.
You need to tell the developers which authentication method to use to connect to the SQL database from SSMS. The solution must minimize authentication prompts.
Which authentication method should you instruct the developers to use?

A. SQL Login
B. Active Directory ג€" Universal with MFA support
C. Active Directory ג€" Integrated
D. Active Directory ג€" Password

Show Suggested Answer

Suggested Answer: C 🗳️

by Shaon at April 1, 2020, 8:39 p.m.

Comments

Submit Cancel

kristiann21

Highly Voted 4 years ago

correct. Hybrid AD, and workstations are domain joined. Hence integrated authentication will use a kerberos ticket to authenticate itself to the SQL server using the logged in user of the workstation.

upvoted 33 times

...

AS007

Highly Voted 4 years, 1 month ago

Correct Ans

upvoted 16 times

...

ESAJRR

Most Recent 9 months ago

Selected Answer: C

C. Active Directory Integrated

upvoted 2 times

...

zellck

1 year, 1 month ago

Selected Answer: C

C is the answer. https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16#azure-active-directory-integrated When the Windows domain is synchronized with Azure AD, and a user is logged into the Windows domain, the user's Windows credentials are used for Azure AD authentication.

upvoted 3 times

...

majstor86

1 year, 3 months ago

Selected Answer: C

C. Active Directory Integrated auth

upvoted 3 times

...

F117A_Stealth

1 year, 6 months ago

Selected Answer: C

Active Directory ג€" Integrated

upvoted 1 times

...

Amit3

1 year, 8 months ago

# In Exam 01-Oct-2022, correct answer.

upvoted 2 times

...

jayek

1 year, 9 months ago

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16&viewFallbackFrom=azuresqldb-current

upvoted 1 times

...

MoFami

1 year, 11 months ago

On exam 01 july 2022

upvoted 2 times

...

zioggs

2 years, 7 months ago

Exam - 4/11/21

upvoted 2 times

...

itbrpl

2 years, 7 months ago

Today's exam 20/10/21.. Integrated of course

upvoted 2 times

...

Neophear

2 years, 7 months ago

No federation mentioned, and nothing about MFA being enabled, thus D Password should be the answer

upvoted 2 times

...

poplovic

2 years, 9 months ago

see here https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell Active Directory integrated authentication Use this method if you are logged into Windows using your Azure Active Directory credentials from a federated domain, or a managed domain that is configured for seamless single sign-on for pass-through and password hash authentication. C is correct

upvoted 1 times

...