ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 53 discussion

Actual exam question from Microsoft's PL-300
Question #: 53
Topic #: 2
[All PL-300 Questions]

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. Change any DAX measures to use iterator functions.
  • B. Remove unused columns from tables in the data model.
  • C. Replace the default visuals with AppSource visuals.
  • D. Increase the number of times that the dataset is refreshed.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by GuerreiroJunior at Jan. 10, 2023, 7:52 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
GuerreiroJunior
Highly Voted 2 years, 3 months ago
Selected Answer: B
Dropping unnecessary columns to reduce the data model is indeed a better way to improve query and refresh performance.
upvoted 17 times
GabryPL
2 years, 3 months ago
To me the only correct answer is A. B is wrong because you just reduce the dimension of the dataset but you are not improving the performance and the time needed to load the visualization. correct answer is A
upvoted 4 times
semauni
2 years ago
B is correct, because this will also help for visuals: "A smaller sized data model uses less resources (memory) and achieves faster data refresh, calculations, and rendering of visuals in reports." Source: https://learn.microsoft.com/en-us/training/modules/optimize-model-power-bi/1-introduction
upvoted 6 times
...
MEG_Florida
1 year, 9 months ago
Also image there are 15 unused columns that are being loaded. Since they don't give you a specific number, it could be 0,1 or 100. But its the one thing that for sure would increase performance.
upvoted 1 times
...
reignreign03
1 year, 5 months ago
Iterator functions are used for some scenarios, but don't assume that all visuals need them. In this case, it is not even stated the need for iterator functions. So I'd say, A is wrong since its effect for this question is ambiguous.
upvoted 2 times
...
...
...
jaume
Most Recent 5 months, 1 week ago
Selected Answer: B
Usual solution would be spliting the visuals into different pages but it's not an option here so reducing the data size by moving unused columns would also improve performance
upvoted 1 times
...
rcaliandro
8 months, 1 week ago
Selected Answer: B
B. Remove unused columns from tables in the data model. It makes sense to remove unused columns from the tables in the model if they are not required in the analysis
upvoted 1 times
...
Igetmyrole
1 year, 7 months ago
B is correct. 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. Unused columns contribute to unnecessary overhead and can impact performance.
upvoted 1 times
...
joesal
1 year, 8 months ago
Selected Answer: B
B is correct.
upvoted 2 times
...
rania
1 year, 11 months ago
Selected Answer: B
dropping unused columns may improve the performance
upvoted 2 times
...
RazaTheLegend
2 years ago
Selected Answer: B
Dropping unnecessary columns to reduce the data model is indeed a better way to improve query and refresh performance.
upvoted 3 times
...
ewelaela
2 years, 3 months ago
Selected Answer: B
B, it's always good for performance to remove unused columns
upvoted 2 times
...
Sushvij
2 years, 3 months ago
B is correct. from performance point of view its always good to drop unwanted columns. Avoid complicated DAX and iterator functions as much as possible
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago