Exam DP-201 topic 9 question 4 discussion

Actual exam question from Microsoft's DP-201

Question #: 4
Topic #: 9

DRAG DROP -
Which three actions should you perform in sequence to allow FoodPrep access to the analytical data store? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Show Suggested Answer

Suggested Answer:

Scenario: Litware will build a custom application named FoodPrep to provide store employees with the calculation results of how many prepared food items to produce every four hours.
Step 1: Register the FoodPrep application in Azure AD
You create your Azure AD application and service principal.
Step 2: Create a login for the service principal on the Azure SQL Server
Step 3: Create a user-defined database role that grant access.
To access resources in your subscription, you must assign the application to a role.
You can then assign the required permissions to the service principal.
Reference:
https://docs.microsoft.com/en-us/azure/active-directory/develop/howto-create-service-principal-portal
Design for data security and compliance

by erssiws at June 19, 2021, 5:19 p.m.

Comments

Submit Cancel

erssiws

3 years, 11 months ago

I think it should create the contained user mapping with AAD Grant select access to the contained user

upvoted 4 times

...