Exam DP-203 topic 1 question 112 discussion

Actual exam question from Microsoft's DP-203

Question #: 112
Topic #: 1

You have an Azure subscription that contains the resources shown in the following table.

You need to implement Azure Synapse Link for Azure SQL Database.

Which two actions should you perform on sql1? Each correct answer presents a part of the solution.

NOTE: Each correct selection is worth one point.

A. Update the firewall rules to allow Azure services to access sql1.
B. Enable the system-assigned managed identity.
C. From the Access control (IAM) settings, assign the Contributor role to the system-assigned managed identity of workspace1.
D. Disable Transparent Data Encryption (TDE).

Show Suggested Answer

Suggested Answer: AB 🗳️

by 9b71f40 at June 2, 2024, 4:31 p.m.

Comments

Submit Cancel

9b71f40

Highly Voted 1 year ago

I think the given answers are correct, Please refer the below link https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database

upvoted 10 times

Sr18

12 months ago

Indeed it will be AB.

upvoted 4 times

...

17lan

Most Recent 6 months, 1 week ago

Selected Answer: AB

Agreed

upvoted 2 times

...

ff5037f

7 months, 3 weeks ago

Selected Answer: AB

AB ARE correct. for reference please check https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/connect-synapse-link-sql-database

upvoted 3 times

...

babaksalarvand

9 months ago

To implement Azure Synapse Link for Azure SQL Database, you'll need to take the following actions on sql1: A. Update the firewall rules to allow Azure services to access sql1. This is necessary because Azure Synapse Link requires the Azure Synapse workspace to be able to connect to the Azure SQL Database. Updating the firewall rules ensures that Azure services can access sql1. B. Enable the system-assigned managed identity. This is important for security and authentication. The system-assigned managed identity allows Azure Synapse to authenticate to Azure SQL Database securely without needing to store credentials. So, the correct actions are A and B.

upvoted 1 times

...

a85becd

9 months, 1 week ago

Selected Answer: AC

To implement Azure Synapse Link for Azure SQL Database, you need to perform the following actions on sql1: Update the firewall rules to allow Azure services to access sql1. Assign the Contributor role to the system-assigned managed identity of workspace1 from the Access control (IAM) settings.

upvoted 1 times

...

NAWRESS96

10 months ago

Selected Answer: AC

i think the answer is : A. Update the firewall rules to allow Azure services to access sql1. C. From the Access control (IAM) settings, assign the Contributor role to the system-assigned managed identity of workspace1.

upvoted 1 times

...