Microsoft Azure Data Fundamentals — Question 11

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?

Answer options

• A. service principal authentication
• B. Azure Active Directory (Azure AD) authentication
• C. SQL authentication
• D. certificate authentication

Correct answer: B

Explanation

Azure Active Directory (Azure AD) authentication supports multi-factor authentication, making it the correct choice for securing access to an Azure SQL database. The other options, such as service principal authentication, SQL authentication, and certificate authentication, do not inherently support MFA, thus they are not suitable for this requirement.