Exam DP-201 topic 3 question 30 discussion

Actual exam question from Microsoft's DP-201

Question #: 30
Topic #: 3

HOTSPOT -
You are designing an Azure data factory that will copy data from Azure Blob storage to a data warehouse in Azure Synapse Analytics.
You need to recommend an authentication mechanism that meet the following requirements:
✑ Identities must be validated by using Azure Active Directory (Azure AD).
✑ Development and maintenance effort must be minimized.
Which authentication mechanism should you recommend for each service? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-auth-aad-msi https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse

by dbdev at May 10, 2021, 3:28 p.m.

Comments

Submit Cancel

dbdev

Highly Voted 4 years ago

Both boxes should be Managed Identity: https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-managed-identity

upvoted 16 times

...

Wendy_DK

Highly Voted 4 years ago

After carefully read the reference and the requirement(Development and maintenance effort must be minimized) in the question. Both boxes should be Managed Identity. Here is the reason: By using Managed Identity, it takes two steps By using service principal, it needs three steps Ref. https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse

upvoted 5 times

...

massnonn

Most Recent 3 years, 6 months ago

both Managed indentity, the moc describe that blob storage supported managed identity

upvoted 1 times

...

Wendy_DK

4 years ago

Azure data factory can use Managed Identity and service principal both as authentication. question here is :You are designing an Azure data factory that will copy data from Azure Blob storage to a data warehouse in Azure Synapse Analytics. Answer here is correct. If some one pick up Managed Identity on the second box, it should be correct answer too

upvoted 2 times

...