nerdexam
Microsoft

DP-500 · Question #19

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…

The correct answer is 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 D. Register a data source E. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace. To catalog an Azure Synapse Analytics serverless SQL pool with Azure Purview, you must register the serverless SQL pool as a data source, then assign the 'Storage Blob Data Reader' role to Purview's MSI for the associated storage account and the 'Reader' role to Purview's MSI…

Implement and manage a data analytics environment

Question

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.

Options

  • ACreate a managed identity in Azure Active Directory (Azure AD)
  • BAssign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace
  • CAssign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group
  • DRegister a data source
  • EAssign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.

How the community answered

(32 responses)
  • A
    16% (5)
  • B
    75% (24)
  • C
    9% (3)

Why each option

To catalog an Azure Synapse Analytics serverless SQL pool with Azure Purview, you must register the serverless SQL pool as a data source, then assign the 'Storage Blob Data Reader' role to Purview's MSI for the associated storage account and the 'Reader' role to Purview's MSI for the Synapse workspace.

ACreate a managed identity in Azure Active Directory (Azure AD)

Creating a managed identity in Azure AD is a prerequisite for Azure Purview's operation, but Purview automatically has a system-assigned managed identity, so explicit creation is not a step performed for cataloging once Purview exists.

BAssign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspaceCorrect

Assigning the 'Storage Blob Data Reader' role to the Azure Purview managed service identity (MSI) for the storage account associated with the Synapse workspace grants Purview the necessary permissions to read data stored in the data lake, which is crucial for serverless SQL pool cataloging.

CAssign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group

Assigning the 'Owner' role to the Azure Purview MSI for the Azure Purview resource group is excessive and not required for cataloging a Synapse serverless SQL pool, as only read permissions on the data source are needed.

DRegister a data sourceCorrect

Registering a data source in Purview is the fundamental step to tell Purview about the serverless SQL pool instance it needs to scan and catalog.

EAssign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.Correct

Assigning the 'Reader' role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace allows Purview to discover and access the metadata of the serverless SQL pool itself within the Synapse workspace.

Concept tested: Azure Purview data source registration and permissions for Synapse SQL pools

Source: https://learn.microsoft.com/en-us/azure/purview/register-scan-azure-synapse-analytics-workspace

Topics

#Azure Purview#Azure Synapse Analytics#Managed Identity#Azure RBAC

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice