Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 61 discussion

Actual exam question from Microsoft's PL-300

Question #: 61
Topic #: 2

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 AppSource visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report.

You need to recommend a solution to improve the performance of the report.

What should you recommend?

A. Replace the default visuals with AppSource visuals.
B. Remove unused columns from tables in the data model.
C. Change the imported dataset to DirectQuery
D. Increase the number of times that the dataset is refreshed.

Show Suggested Answer

Suggested Answer: B 🗳️

by gaouas at Jan. 10, 2023, 9:22 a.m.

Comments

Submit Cancel

hufi

Highly Voted 2 years, 4 months ago

deja vu

upvoted 51 times

...

ewelaela

Highly Voted 2 years, 5 months ago

Selected Answer: B

B is correct same as questions 53 and 56

upvoted 21 times

...

desibaby09

Most Recent 6 months, 2 weeks ago

Selected Answer: B

The best option. C would be a good answer choice if it says it needs "real time data" but it has schedule refreshes so direct query isn't necessary. the compliant is about visuals which means import mode is good

upvoted 1 times

...

jaume

7 months ago

Selected Answer: B

Third time this question is appearing in Topic 2 group of questions. It would be good improving performance by reducing data size :-P

upvoted 1 times

...

Sheree_Data

10 months, 1 week ago

C. There is a reason that the answer options keep changing. DirectQuery can help with performance by querying the data source directly rather than loading all data into memory.

upvoted 1 times

539d541

10 months ago

This isn't correct because that means when the user clicks a visual for interaction, the measures that generate the data to be visuals send the query to the data source - could be a very remote server and force that to do the querying before returning it to the published report. That is going to take longer than if the data was imported/cached on power bi online service.

upvoted 2 times

...

28485e1

1 year, 3 months ago

This question and the CSV complaint question: all-time most repeated questions.

upvoted 3 times

...

user28272615

1 year, 4 months ago

Was at the exam on February 12th 2024

upvoted 5 times

...

robert95

1 year, 6 months ago

You should also minimize the amount of visuals on that particular page.

upvoted 1 times

...

Igetmyrole

1 year, 9 months ago

B is the correct answer. By removing columns that are not needed for the report, you can reduce the size of the data model. This can lead to faster loading times, especially when dealing with large datasets.

upvoted 1 times

...

Kitkat10

1 year, 10 months ago

Deja vu

upvoted 1 times

...

AGlassOfWater

2 years ago

This question is making me question my own memory.

upvoted 7 times

madyjoe21

1 year, 8 months ago

lol lol lol

upvoted 1 times

...

RazaTheLegend

2 years, 2 months ago

Selected Answer: B

B is correct same as questions 53 and 56

upvoted 3 times

...

kail85

2 years, 5 months ago

Selected Answer: B

This question appears several times and B is the correct answer.

upvoted 5 times

...

SayanChiku

2 years, 5 months ago

B is correct Removing unwanted columns from the data model is a good trick to improve the performance

upvoted 5 times

...

jsking

2 years, 5 months ago

Selected Answer: C

Actually both B and C can improve performance but C seems to be the best solution for this case because this can significantly improve performance by allowing the report to retrieve data directly from the data source, rather than loading the large dataset into memory. This can also allow the data to be more fresh, while reducing the burden on the report by limiting the amount of data that needs to be loaded and processed.

upvoted 3 times

Shalaleh

2 years, 2 months ago

Remmember it! from Direct query or Daul we can change to Import mode. But from import mode we cannot change to Direct Query.

upvoted 7 times

JudT

1 year, 2 months ago

Thank you for this reminder!

upvoted 1 times

...

ewelaela

2 years, 5 months ago

But changing to DirectQuery will increase load time for visuals, which already are complained about, so it's not a way to go in this case

upvoted 6 times

semauni

2 years, 1 month ago

Agreed, DirectQuery would be a solution if refresh times were the issue, not visual loading times. That should always be better with Import.

upvoted 3 times

...

Rajaneshk

2 years, 4 months ago

Yes correct. Import mode is the best option if your data is less than 1 GB and isn't constantly updating. Because all data comes from the Power BI Desktop Cache. So in such scenario, an import mode is faster than Direct Query mode when the data file size is below 1 GB. So DirectQuery refresh rate time will be more which impact the performance.

upvoted 3 times

...