Microsoft
DP-203 · Question #62
Drag and Drop Question 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
Sign in or unlock DP-203 to reveal the answer and full explanation for question #62. The question stem and answer options stay visible for context.
Submitted by minji_kr· Mar 30, 2026Design and Implement Data Security - Configure authentication, authorization, and access control for Azure Synapse Analytics dedicated SQL pools using Azure Active Directory and database-level roles.
Question
Drag and Drop Question 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. Answer:
Exhibit
Answer Area
Drag items
Create a database role named Role1 and grant Role1 SELECT permissions to schema1.Create a database role named Role1 and grant Role1 SELECT permissions to dw1.Assign the Azure role-based access control (Azure RBAC) Reader role for dw1 to Group1.Create a database user in dw1 that represents Group1 and uses the FROM EXTERNAL PROVIDER clause.Assign Role1 to the Group1 database user.
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 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 Security#Azure AD Integration#Least Privilege Access Control