nerdexam
Microsoft

DP-500 · Question #117

You have a Power BI tenant and an Azure subscription named Sub1. The Power BI tenant and Sub1 are linked to a single Azure AD tenant. In Sub1, you create a storage account named storage1. You need…

The correct answer is D. Owner E. Storage Blob Data Owner F. Storage Blob Data Reader. To configure a Power BI workspace to store dataflows in ADLS Gen2 under the principle of least privilege, the connecting administrator needs the Owner role, and the Power BI service principal needs Storage Blob Data Owner and Storage Blob Data Reader roles.

Implement and manage a data analytics environment

Question

You have a Power BI tenant and an Azure subscription named Sub1. The Power BI tenant and Sub1 are linked to a single Azure AD tenant. In Sub1, you create a storage account named storage1. You need to configure a Power BI workspace to store dataflows in storage1. The solution must use the principle of least privilege. Which three roles should you assign for storage1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • AReader
  • BStorage Blob Data Contributor
  • CContributor
  • DOwner
  • EStorage Blob Data Owner
  • FStorage Blob Data Reader

How the community answered

(28 responses)
  • A
    11% (3)
  • B
    4% (1)
  • C
    18% (5)
  • D
    68% (19)

Why each option

To configure a Power BI workspace to store dataflows in ADLS Gen2 under the principle of least privilege, the connecting administrator needs the Owner role, and the Power BI service principal needs Storage Blob Data Owner and Storage Blob Data Reader roles.

AReader

The 'Reader' role (classic RBAC) is too broad and does not provide the specific data plane permissions required for the Power BI service to write dataflow files to the storage account.

BStorage Blob Data Contributor

While 'Storage Blob Data Contributor' grants write permissions for blobs, the provided correct answer indicates 'Storage Blob Data Owner' is expected, suggesting a broader set of data plane permissions or specific scenario where it's needed over Contributor.

CContributor

The 'Contributor' role (classic RBAC) grants full management access but does not include data plane access by default for Storage accounts, and it also violates the principle of least privilege compared to more specific data plane roles.

DOwnerCorrect

The 'Owner' role is required for the user who is performing the initial setup and connection of the Power BI workspace to the Azure Data Lake Storage Gen2 account, granting necessary management plane permissions.

EStorage Blob Data OwnerCorrect

The 'Storage Blob Data Owner' role grants the Power BI service principal comprehensive control over blob data, including read, write, and delete permissions, which ensures dataflows can be fully managed and stored in ADLS Gen2.

FStorage Blob Data ReaderCorrect

The 'Storage Blob Data Reader' role is explicitly needed by the Power BI service principal to read existing dataflow files and folders from the Azure Data Lake Storage Gen2 account.

Concept tested: Power BI dataflow ADLS Gen2 integration roles

Source: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-azure-data-lake-storage-gen2-integration

Topics

#Azure Data Lake Storage Gen2#Power BI Dataflows#Azure RBAC#Least Privilege

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice