Exam DP-200 topic 1 question 56 discussion

Actual exam question from Microsoft's DP-200

Question #: 56
Topic #: 1

You have an enterprise-wide Azure Data Lake Storage Gen2 account. The data lake is accessible only through an Azure virtual network named VNET1.
You are building a SQL pool in Azure Synapse that will use data from the data lake.
Your company has a sales team. All the members of the sales team are in an Azure Active Directory group named Sales. POSIX controls are used to assign the
Sales group access to the files in the data lake.
You plan to load data to the SQL pool every hour.
You need to ensure that the SQL pool can load the sales data from the data lake.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Create a managed identity.
B. Use the shared access signature (SAS) as the credentials for the data load process.
C. Add the managed identity to the Sales group.
D. Add your Azure Active Directory (Azure AD) account to the Sales group.
E. Create a shared access signature (SAS).
F. Use the managed identity as the credentials for the data load process.

Show Suggested Answer

Suggested Answer: ACD 🗳️
A: The managed identity grants permissions to the dedicated SQL pools in the workspace.
Note: Managed identity for Azure resources is a feature of Azure Active Directory. The feature provides Azure services with an automatically managed identity in

Azure AD -
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-identity

by ACSC at Jan. 2, 2021, 11:08 a.m.

Comments

Submit Cancel

ACSC

Highly Voted 4 years, 4 months ago

Correct answers are A, C, F.

upvoted 69 times

...

ck8.kakade

Most Recent 9 months, 1 week ago

F. Use the managed identity as the credentials for the data load process. A. Create a managed identity. B. Use the shared access signature (SAS) as the credentials for the data load process.

upvoted 1 times