Exam AZ-500 topic 1 question 18 discussion

The authentication method the developers should use is Active Directory integrated authentication. Active Directory integrated authentication: Seamless integration with on-premises Active Directory, minimizing authentication prompts and ensuring efficient user experience. Azure AD token: Not suitable for on-premises Active Directory authentication in a hybrid environment. Azure Multi-Factor authentication: Adds unnecessary complexity and authentication steps, not ideal for minimizing prompts. 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

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.

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

Answer: C, Active Directory integrated authentication Reason: This method allows seamless authentication using the developers' on-premises Active Directory accounts, which are synchronized with Azure AD in the hybrid setup. It minimizes authentication prompts by leveraging the existing Windows login credentials on their hybrid Azure AD joined Windows 10 computers. Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql#connecting-using-azure-ad-identities

The authentication method the developers should use is Active Directory integrated authentication. Active Directory integrated authentication: Seamless integration with on-premises Active Directory, minimizing authentication prompts and ensuring efficient user experience. Azure AD token: Not suitable for on-premises Active Directory authentication in a hybrid environment. Azure Multi-Factor authentication: Adds unnecessary complexity and authentication steps, not ideal for minimizing prompts. 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

C. Active Directory integrated authentication.

C. Active Directory integrated authentication.

C is correct.

It is correct. I am using the same config in Prod env.

C is Correct, Tested in lab environment

C is correct.