nerdexam
Microsoft

DP-500 · Question #35

You need to store Power BI dataflows in an Azure Storage account. Which two prerequisites are required to support the configuration? Each correct answer presents part of the solution. NOTE: Each…

The correct answer is B. The connection must be created by a user that is assigned the Storage Blob Data Owner role. C. The storage account must have hierarchical namespace enabled. To store Power BI dataflows in an Azure Storage account, the storage account must have hierarchical namespace enabled, and the user establishing the connection needs the Storage Blob Data Owner role.

Implement and manage a data analytics environment

Question

You need to store Power BI dataflows in an Azure Storage account. Which two prerequisites are required to support the configuration? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • AThe storage account must be protected by using an Azure Firewall.
  • BThe connection must be created by a user that is assigned the Storage Blob Data Owner role.
  • CThe storage account must have hierarchical namespace enabled.
  • DDataflows must exist already for any directly connected Power BI workspaces.
  • EThe storage account must be created in a separate Azure region from the Power BI tenant and workspaces.

How the community answered

(22 responses)
  • A
    14% (3)
  • B
    73% (16)
  • D
    5% (1)
  • E
    9% (2)

Why each option

To store Power BI dataflows in an Azure Storage account, the storage account must have hierarchical namespace enabled, and the user establishing the connection needs the Storage Blob Data Owner role.

AThe storage account must be protected by using an Azure Firewall.

While Azure Firewall can protect storage accounts, it is not a prerequisite for Power BI dataflow integration with Azure Storage. The integration relies on network access and permissions, not necessarily a firewall requirement.

BThe connection must be created by a user that is assigned the Storage Blob Data Owner role.Correct

The user establishing the connection between Power BI and Azure Data Lake Storage Gen2 must have the Storage Blob Data Owner role or equivalent permissions on the storage account to ensure Power BI can write, modify, and delete dataflow data. This role provides the necessary data-level access.

CThe storage account must have hierarchical namespace enabled.Correct

Power BI dataflows require an Azure Data Lake Storage Gen2 account, which necessitates enabling the hierarchical namespace feature on the storage account. This feature allows for file system semantics and directory structures required by Power BI dataflows.

DDataflows must exist already for any directly connected Power BI workspaces.

Dataflows do not need to exist prior to connecting a Power BI workspace to an Azure Data Lake Storage account. The connection is a prerequisite for creating dataflows that store data externally.

EThe storage account must be created in a separate Azure region from the Power BI tenant and workspaces.

Power BI recommends creating the storage account in the same region as the Power BI tenant to minimize latency and data transfer costs, not a separate region.

Concept tested: Power BI dataflows external storage prerequisites

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

Topics

#Power BI Dataflows#Azure Data Lake Storage Gen2#Azure Storage Configuration#Azure RBAC

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-500 Practice