Exam AZ-500 topic 2 question 22 discussion

Azure Active Directory - Password ---> Use this method for connecting to SQL Database if you are logged in to Windows using credentials from a domain that is not federated with Azure Active Directory - Integrated ---> Use this method for connecting to SQL Database if you are logged in to Windows using your Azure Active Directory credentials from a federated domain. Our keyword is "SSO" so option D should be the answer

The hint of this question is "You have a hybrid configuration of Azure Active Directory (Azure AD) that has Single Sign-On (SSO) enabled". So basically when SSO, users don't need to type in their passwords to sign in to Azure AD, and usually, even type in their usernames. This feature provides your users easy access to your cloud-based applications without needing any additional on-premises components. And Microsoft already recommends to use Integrated Authentication 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 (https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell#active-directory-integrated-authentication) Option A (AD - Password) sounds like a correct answer if you set Remember password. However the most correct answer is Option D as it minimizes authentication prompt.

On exam 1/2/24

in exam 08/12/2023

Az-500 today on exam. Passed 826/1000. No labs on the online exam. One Case Study with 5 questions.

In exam 13 Oct

The question was given on the October 9, 2023 exam.

D. Active Directory - Integrated

To allow database developers to connect to the Azure SQL Database instance from their domain-joined devices and authenticate using their on-premises Active Directory account with minimum authentication prompts, you should recommend the "Active Directory - Integrated" authentication method. The "Active Directory - Integrated" authentication method enables seamless authentication using the current user's Active Directory credentials without requiring an additional prompt for authentication. It leverages the domain-joined device's established trust relationship with Azure AD to authenticate the user. By using this authentication method, developers can connect to the Azure SQL Database instance using Microsoft SQL Server Management Studio without the need to enter separate credentials, providing a more streamlined and user-friendly experience.

D 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.

In Exam April 11, 2023

D. Active Directory - Integrated

D. Active Directory - Integrated

# In EXAM - 01-Oct-2022

D is correct answer.

On today's exam 06/01/22

correct answer