Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Microsoft Discussions

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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
hufi
Highly Voted 1 year, 2 months ago
deja vu
upvoted 39 times
...
ewelaela
Highly Voted 1 year, 3 months ago
Selected Answer: B
B is correct same as questions 53 and 56
upvoted 17 times
...
28485e1
Most Recent 1 month, 3 weeks ago
This question and the CSV complaint question: all-time most repeated questions.
upvoted 2 times
...
user28272615
2 months, 2 weeks ago
Was at the exam on February 12th 2024
upvoted 2 times
...
robert95
5 months ago
You should also minimize the amount of visuals on that particular page.
upvoted 1 times
...
Igetmyrole
7 months, 3 weeks 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
8 months, 1 week ago
Deja vu
upvoted 1 times
...
AGlassOfWater
11 months, 1 week ago
This question is making me question my own memory.
upvoted 6 times
madyjoe21
7 months, 1 week ago
lol lol lol
upvoted 1 times
...
...
RazaTheLegend
1 year ago
Selected Answer: B
B is correct same as questions 53 and 56
upvoted 3 times
...
kail85
1 year, 3 months ago
Selected Answer: B
This question appears several times and B is the correct answer.
upvoted 5 times
...
SayanChiku
1 year, 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
1 year, 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 2 times
Shalaleh
1 year, 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 5 times
JudT
1 month ago
Thank you for this reminder!
upvoted 1 times
...
...
ewelaela
1 year, 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
1 year 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
1 year, 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
1 year, 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
1 year, 3 months ago
"Increase the number of times that the dataset is refreshed" is the correct answer
upvoted 1 times
mambamota
1 year, 3 months ago
But it will not improve performance
upvoted 1 times
...
Danylessoucis
1 year, 3 months ago
Refresh has nothing to do with performance. Answer B is correct.
upvoted 1 times
...
GuerreiroJunior
1 year, 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
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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