exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 3 question 22 discussion

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

DRAG DROP -
You have an Azure Active Directory (Azure AD) tenant that contains a security group named Group1. You have an Azure Synapse Analytics dedicated SQL pool named dw1 that contains a schema named schema1.
You need to grant Group1 read-only permissions to all the tables and views in schema1. The solution must use the principle of least privilege.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Step 1: Create a database role named Role1 and grant Role1 SELECT permissions to schema
You need to grant Group1 read-only permissions to all the tables and views in schema1.
Place one or more database users into a database role and then assign permissions to the database role.
Step 2: Assign Rol1 to the Group database user
Step 3: Assign the Azure role-based access control (Azure RBAC) Reader role for dw1 to Group1
Reference:
https://docs.microsoft.com/en-us/azure/data-share/how-to-share-from-sql

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
LongBao
Highly Voted 4 years, 2 months ago
Does it should be B-D-A ?
upvoted 14 times
Pairon
4 years, 1 month ago
I think the same.
upvoted 2 times
...
...
Wendy_DK
Highly Voted 4 years, 1 month ago
Step 1: Create a database user in dw1 that represents Group1 and uses FROM EXTERNAL PROVIDE clause Step 2: Create a database role named Role1 and grant Role1 SELECT permissions to schema1 Step 3: Assign Rol1 to the Group1 database user
upvoted 12 times
...
cadio30
Most Recent 4 years ago
D, B, A Reference: https://docs.microsoft.com/en-us/azure/data-share/how-to-share-from-sql
upvoted 10 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
Loading ...