Exam DP-500 topic 1 question 115 discussion

Actual exam question from Microsoft's DP-500

Question #: 115
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. Enable the large dataset storage format for workspace.
B. In the dataset, delete the fact table.
C. Create a dataset parameter to reduce the fact table row count in the development and test pipelines.
D. From Capacity settings in the Power BI Admin portal, reduce the Max Intermediate Row Set Count setting.

Show Suggested Answer

Suggested Answer: C 🗳️

by konitoki at July 19, 2023, 11:03 a.m.

Comments

Submit Cancel

Deloro

1 year, 9 months ago

Selected Answer: C

see comment below

upvoted 1 times

...

Deloro

1 year, 9 months ago

the question is, you need to reduce the size when they are sent > a parameter reduces the size, but can be disabled online so the pbix is published faster

upvoted 1 times

...

konitoki

1 year, 11 months ago

C seems to be best available option, however we should have full data in both production and test env so I wouldn't pick C having something better

upvoted 1 times

...