ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 3 question 26 discussion

Actual exam question from Microsoft's DP-203
Question #: 26
Topic #: 3
[All DP-203 Questions]

HOTSPOT -
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.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Azure AD authentication -
Azure AD authentication has the option to include MFA.

Box 2: Contained database users -
Azure AD authentication uses contained database users to authenticate identities at the database level.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
by Skeinofi at Dec. 28, 2021, 4:16 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Skeinofi
Highly Voted 3 years, 3 months ago
Correct
upvoted 22 times
...
Amsterliese
Highly Voted 3 years ago
"SQL Database and Azure Synapse Analytics support Azure Active Directory identities as contained database users" https://docs.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable?view=sql-server-ver15#contained-database-user-model
upvoted 8 times
...
renan_ineu
Most Recent 6 months, 4 weeks ago
Azure AD will enforce MFA Container Users can map to AD and enforce MFA through that
upvoted 1 times
...
kkk5566
1 year, 7 months ago
Correct
upvoted 1 times
...
JG1984
1 year, 9 months ago
Azure Synapse Analytics supports two types of database-level authentication: Azure Active Directory (Azure AD) authentication: This uses your Azure AD identity to authenticate to Synapse SQL. This is the recommended authentication method, as it provides a single sign-on experience and allows you to manage permissions using Azure AD groups. SQL Server authentication: This uses a traditional SQL Server username and password to authenticate to Synapse SQL. This authentication method is less secure than Azure AD authentication, but it may be necessary if you are using legacy applications that do not support Azure AD.
upvoted 2 times
...
Deeksha1234
2 years, 8 months ago
answer is correct
upvoted 4 times
...
dev2dev
3 years, 2 months ago
B is wrong. Contained users not supported by synapse analytics. D is correct ('MS SQL Server logins')
upvoted 4 times
PallaviPatel
3 years, 2 months ago
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview this document says contained users are supported by synapse analytics, so this is correct answer.
upvoted 18 times
dev2dev
3 years, 2 months ago
correct
upvoted 3 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago