Exam DP-500 topic 1 question 114 discussion

Actual exam question from Microsoft's DP-500

Question #: 114
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. Create a dataset parameter to reduce the fact table row count in the development and test pipelines.
C. Request the authors of the deployment pipeline datasets to reduce the number of datasets republished during development.
D. Turn off auto refresh when publishing the dataset changes to the Power BI service.

Show Suggested Answer

Suggested Answer: B 🗳️

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

Comments

Submit Cancel

Deloro

1 year, 9 months ago

Selected Answer: B

answer d won't reduce the size of the dataset, B will

upvoted 1 times

...

solref

2 years, 2 months ago

Option D, creating a dataset parameter to reduce the fact table row count in the development and test pipelines, is the recommended solution for this scenario. By creating a dataset parameter, the fact table row count can be reduced, and only the required data can be refreshed during the dataset refresh. This approach can significantly reduce the number of queries sent to the database and improve performance. Once the changes are published to the production pipeline, the dataset parameter can be removed to refresh the entire fact table. Chat GPT

upvoted 1 times

...

per_ing

2 years, 5 months ago

Duplicate of question 20

upvoted 2 times

...