DP-500 Question #81: Real Exam Question with Answer & Explanation

Question

BI service to an Azure SQL database since the creation of the deployment pipeline. An investigation into the issue identifies the following: - One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows. - When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset. You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production. What should you recommend?

Options

• AFrom Capacity settings in the Power BI Admin portal, reduce the Max Intermediate Row Set Count setting.
• BConfigure the dataset to use a composite model that has a DirectQuery connection to the fact table.
• CEnable the large dataset storage format for workspace.
• DFrom Capacity settings in the Power BI Admin portal, increase the Max Intermediate Row Set Count setting.

Explanation

To reduce the size of queries sent to the database during Power BI dataset publication for a large fact table, configure a composite model with a DirectQuery connection to that table.

Common mistakes.

• A. Reducing the Max Intermediate Row Set Count in Capacity settings affects internal query processing limits within Power BI, not the volume of data sent from the source database during refresh.
• C. Enabling the large dataset storage format allows models to exceed 1 GB, but it does not inherently reduce the size of queries sent to the database or the data imported if the model remains in Import mode.
• D. Increasing the Max Intermediate Row Set Count in Capacity settings would potentially allow larger internal query results within Power BI, but it does not reduce the data volume transferred or the query size sent from the source database during refresh operations.

Concept tested. Power BI composite models and DirectQuery

Reference. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

No community discussion yet for this question.