nerdexam
Microsoft

DP-300 · Question #140

Hotspot Question You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1. You need

Sign in or unlock DP-300 to reveal the answer and full explanation for question #140. The question stem and answer options stay visible for context.

Submitted by haruto_sh· Mar 6, 2026Implement a secure environment

Question

Hotspot Question You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1. You need to recommend an authentication solution for Pool1. The solution must support multi- factor authentication (MFA) and database-level authentication. Which authentication solution or solutions should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:

Exhibit

DP-300 question #140 exhibit

Answer Area

  • MFA:
    Azure AD authenticationMicrosoft SQL Server authenticationPasswordless authenticationWindows authentication
  • Database-level authentication:
    Application rolesContained database usersDatabase rolesMicrosoft SQL Server logins

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Azure Synapse Analytics#SQL pool#authentication#Multi-Factor Authentication (MFA)#Azure Active Directory#contained database users
Full DP-300 Practice