Exam DP-500 topic 1 question 104 discussion

Actual exam question from Microsoft's DP-500

Question #: 104
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. Request the authors of the deployment pipeline datasets to reduce the number of datasets republished during development.
B. In the dataset, delete the fact table.
C. Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.
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 per_ing at Jan. 22, 2023, 8:33 a.m.

Comments

Submit Cancel

ajaysharma2061

2 years, 3 months ago

Option C: Direct Query Given the scenario, the best solution to reduce the size of queries sent to the database when dataset changes are published to development, test, or production is to configure the dataset to use a composite model that has a DirectQuery connection to the fact table. Using a DirectQuery connection allows you to keep the data in the data source and query it directly when needed, rather than importing the entire dataset into Power BI. This can significantly reduce the amount of data that needs to be transferred between the data source and Power BI, which in turn can reduce the number of queries sent to the data source.

upvoted 1 times

...