the given answer is correct: A will reduce the amount of data in the model. D also will decrease the model size but it can be slower especially for complex queries as it needs to query the source each time.
A- is the answer.
Presented answer is correct, Removing unnecessary columns will directly reduce the model's size by eliminating data that isn't needed. This change won't affect query performance since the excluded data is not part of the model. The others B. Unpivot unnecessary columns: Increases model size by adding rows.
C. Rename unnecessary columns: Doesn't reduce size, only changes labels.
D. Change to DirectQuery: May reduce size but can slow down query performance.
upvoted 4 times
...
This section is not available anymore. Please use the main Exam Page.PL-300 Exam Questions
Log in to ExamTopics
Sign in:
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.
SylUK
5 months agoOdidepse
5 months, 2 weeks ago