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

Exam CSCP All Questions

View all questions & answers for the CSCP exam
Go to Exam

Exam PL-300 topic 2 question 64 discussion

Actual exam question from APICS's CSCP
Question #: 64
Topic #: 1
[All CSCP 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. Enable visual interactions.
  • B. Change any DAX measures to use iterator functions.
  • C. Implement row-level security (RLS).
  • D. Remove unused columns from tables in the data model.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by VasZel at March 30, 2023, 3:15 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
sa56
Highly Voted 1 year, 7 months ago
deja vu
upvoted 26 times
...
Abhi256
Highly Voted 1 year, 7 months ago
Selected Answer: D
Repeated multiple time. Ever time i see this, I thought its a new question. But its the same.
upvoted 11 times
...
rcaliandro
Most Recent 3 months ago
Selected Answer: D
D - Remove unused columns from tables in the data model.
upvoted 1 times
...
RedRoss
8 months, 1 week ago
Selected Answer: D
yes, D
upvoted 1 times
...
08b2ddd
10 months, 3 weeks ago
At least this question will stick in our heads after all the repetition.
upvoted 10 times
...
Igetmyrole
1 year, 2 months ago
D 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
...
RazaTheLegend
1 year, 7 months ago
Selected Answer: D
Repeated 4 times, still remove unneeded columns
upvoted 7 times
...
Minio1
1 year, 7 months ago
I'm wondering same
upvoted 1 times
...
VasZel
1 year, 7 months ago
How many times is this question?!
upvoted 4 times
EwoutBI
1 year, 3 months ago
I bet if you buy the Premium subscription, it will just be this question over and over lol.
upvoted 7 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