Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 100 discussion

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

You have a Power BI semantic model that contains two queries.

You discover that a report based on the model has performance issues.

You plan to use Power Query to reduce the data loaded to the model.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

  • A. Apply group by and summarize techniques.
  • B. Combine the queries by using Append.
  • C. Remove unnecessary columns and rows.
  • D. Combine the queries by using Merge.
  • E. Create a new query group.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
jaume
1 day, 4 hours ago
Selected Answer: AC
Ony options A and C will reduce data size and potentially improving performance. Combining queries (by using Append or Merge) could improve refresh but not report performance as is and a new query group would not impact at all
upvoted 1 times
...
Selected Answer: AC
B. Combine the queries by using Append While combining queries via append can help merge multiple datasets, it typically does not reduce the data size. In fact, it may increase the dataset size unless managed carefully. D. Combine the queries by using Merge Merging queries is useful for joining data from different sources, but it is not inherently a data reduction technique. It may help in certain cases, but it is not directly aimed at reducing the amount of data loaded to the model. E. Create a new query group A query group is simply an organizational tool in Power Query to manage your queries better. It has no impact on performance or data reduction.
upvoted 2 times
...
LuluSkyy
1 month, 1 week ago
A and C are the correct answers
upvoted 2 times
...
VladStan
1 month, 2 weeks ago
Selected Answer: AC
Correct answers https://learn.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
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
Loading ...