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 61 discussion

Actual exam question from Microsoft's PL-300
Question #: 61
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. 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 Hide Answer
Suggested Answer: B 🗳️
by gaouas at Jan. 10, 2023, 9:22 a.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
hufi
Highly Voted 2 years, 2 months ago
deja vu
upvoted 51 times
...
ewelaela
Highly Voted 2 years, 3 months ago
Selected Answer: B
B is correct same as questions 53 and 56
upvoted 21 times
...
desibaby09
Most Recent 5 months 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
5 months, 2 weeks 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
8 months, 3 weeks 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
8 months, 1 week 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, 1 month ago
This question and the CSV complaint question: all-time most repeated questions.
upvoted 3 times
...
user28272615
1 year, 2 months ago
Was at the exam on February 12th 2024
upvoted 5 times
...
robert95
1 year, 5 months ago
You should also minimize the amount of visuals on that particular page.
upvoted 1 times
...
Igetmyrole
1 year, 7 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, 8 months ago
Deja vu
upvoted 1 times
...
AGlassOfWater
1 year, 11 months ago
This question is making me question my own memory.
upvoted 7 times
madyjoe21
1 year, 7 months ago
lol lol lol
upvoted 1 times
...
...
RazaTheLegend
2 years ago
Selected Answer: B
B is correct same as questions 53 and 56
upvoted 3 times
...
kail85
2 years, 3 months ago
Selected Answer: B
This question appears several times and B is the correct answer.
upvoted 5 times
...
SayanChiku
2 years, 3 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, 3 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, 1 month 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, 1 month ago
Thank you for this reminder!
upvoted 1 times
...
...
ewelaela
2 years, 3 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 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, 2 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
...
...
...
Sushvij
2 years, 3 months ago
B is correct Removing unwanted columns from the data model is a good trick to improve the performance
upvoted 1 times
...
gaouas
2 years, 3 months ago
"Increase the number of times that the dataset is refreshed" is the correct answer
upvoted 1 times
mambamota
2 years, 3 months ago
But it will not improve performance
upvoted 1 times
...
Danylessoucis
2 years, 3 months ago
Refresh has nothing to do with performance. Answer B is correct.
upvoted 1 times
...
GuerreiroJunior
2 years, 3 months ago
i donot agree with you. remove column will reduce the size of the model and automaticaly it will improve the perfomance.
upvoted 1 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