Exam DP-500 topic 1 question 94 discussion

Actual exam question from Microsoft's DP-500

Question #: 94
Topic #: 1

You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode.
A database administrator reports a drastic increase in the number of queries sent from the Power 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?

A. From Capacity settings in the Power BI Admin portal, reduce the Max Intermediate Row Set Count setting.
B. Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.
C. Enable the large dataset storage format for workspace.
D. From Capacity settings in the Power BI Admin portal, increase the Max Intermediate Row Set Count setting.

Show Suggested Answer

Suggested Answer: B 🗳️

by per_ing at Jan. 22, 2023, 8:13 a.m.

Comments

Submit Cancel

TheSwedishGuy

1 year, 6 months ago

C says ChatGPT.

upvoted 1 times

...

Eltooth

1 year, 10 months ago

Selected Answer: B

B is the correct answer.

upvoted 3 times

...

stfglv

2 years, 3 months ago

Not only what per_ing said, but also A and D apply only to DirectQuery mode (whereas the Q clearly states Import) and the Large format setting makes no sense for a dataset of the size 1GB considering that the Premium capacity has the 10GB limit and we know we are talking about Premium because that is the prerequisites for deployment pipelines altogether. In short, the system of elimination (if not common sense) leaves us with B.

upvoted 4 times

...

per_ing

2 years, 3 months ago

Selected Answer: B

I think this is correct as it is one of the suggestions from Microsoft https://learn.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#switch-to-mixed-mode

upvoted 2 times

...

Exam DP-500 All Questions

View all questions & answers for the DP-500 exam