exam questions

Exam DP-500 All Questions

View all questions & answers for the DP-500 exam

Exam DP-500 topic 1 question 81 discussion

Actual exam question from Microsoft's DP-500
Question #: 81
Topic #: 1
[All DP-500 Questions]

You have an Azure Synapse Analytics serverless SQL pool.
You need to catalog the serverless SQL pool by using Azure Purview.
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 in Azure Active Directory (Azure AD).
  • B. Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.
  • C. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.
  • D. Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.
  • E. Register a data source.
Show Suggested Answer Hide Answer
Suggested Answer: BCE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Ramiel
Highly Voted 2 years, 6 months ago
Selected Answer: BCE
The Answer should be, in order: E. Register a data source C. Set the Reader role and enter your Microsoft Purview account name. B. Set the Storage blob data reader role and enter your Microsoft Purview account name. Source: https://learn.microsoft.com/en-us/azure/purview/register-scan-synapse-workspace?tabs=MI#authentication-for-enumerating-serverless-sql-database-resources
upvoted 12 times
...
sandyArun108
Most Recent 1 year, 4 months ago
The answer is E, B, C https://microsoftlearning.github.io/mslearn-synapse/Instructions/Labs/10-Synapse-purview.html
upvoted 1 times
...
SamuComqi
1 year, 10 months ago
Selected Answer: BCE
I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: - Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace. - Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace. - Register a data source.
upvoted 3 times
...
Plb2
2 years ago
BCE Not A, because purview MSI is created by using The Microsoft Purview MSI Configuration script.https://learn.microsoft.com/en-us/azure/purview/tutorial-msi-configuration#prerequisites
upvoted 1 times
...
Eltooth
2 years ago
Selected Answer: BCE
B, C and E are correct. Details are listed here: https://learn.microsoft.com/en-us/azure/purview/register-scan-synapse-workspace?tabs=MI
upvoted 2 times
...
ExamPage
2 years, 2 months ago
THe Answer should be ABE Note that assigning the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace (option C) and the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group (option D) are not required to catalog the serverless SQL pool in Azure Purview.
upvoted 1 times
...
solref
2 years, 3 months ago
Selected Answer: BCE
B. C. E https://learn.microsoft.com/en-us/azure/purview/register-scan-synapse-workspace?tabs=MI#azure-synapse-serverless-database
upvoted 2 times
...
Ramiel
2 years, 6 months ago
Managed Identity is optional, you can also set service principal or SQL Authentication: https://learn.microsoft.com/en-us/azure/purview/register-scan-synapse-workspace?tabs=SQLAuth#apply-permissions-to-scan-the-contents-of-the-workspace
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...