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

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

HOTSPOT
-

You have a Power BI semantic model named ModelA that contains the following columns:



All of the columns use the Text data type.

Based on the model, you create a report named ReportA that contains the following columns:

• OrderID
• OrderDate
• CustomerID
• ShippingAddress

ReportA is the only report connected to ModelA.

You discover that ReportA has performance issues caused by the size of ModelA.

What should you do to optimize and reduce the size of ModelA? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by b92fc92 at Oct. 1, 2024, 1:05 p.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
FraGuara
Highly Voted 7 months, 2 weeks ago
1) Changing data type from text to whole number. Explanation: Queries using numerical data types can execute faster than those using text data. 2) Delete the OrderTitle and OrderDescription columns. Explanation: Directly reduces the model size without affecting analysis.
upvoted 6 times
...
LuluSkyy
Most Recent 7 months, 1 week ago
The given answer is correct
upvoted 4 times
...
cd5fef3
7 months, 4 weeks ago
https://learn.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction answer is correct
upvoted 4 times
...
ak57
8 months, 1 week ago
I think the answer is correct. Enable summarization will work with there are numbers to be summed by. There is no summarize for column type text.
upvoted 3 times
...
b92fc92
8 months, 1 week ago
I think - Enable Summarization -Delete the OrderTitle and OrderDescription columns
upvoted 1 times
aaf101b
7 months, 3 weeks ago
why , do we need summarization for ID column. it should be disable.
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