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.
Question
Options
- AReader
- BStorage Blob Data Contributor
- CContributor
- DOwner
- EStorage Blob Data Owner
- FStorage Blob Data Reader
How the community answered
(28 responses)- A11% (3)
- B4% (1)
- C18% (5)
- D68% (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.
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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.