exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 108 discussion

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

You have a Power BI semantic model that contains the following data.



You need to create a solution that meets the following requirements:

• Presents transaction amount totals for each month for the current and prior year
• Follows the star schema modeling approach
• Minimizes the data model size

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

NOTE: Each correct selection is worth one point.

  • A. Create one-to-many relationships between the tables.
  • B. In the Transactions query, delete the TransactionID column.
  • C. In the Date query, group by MonthNumber.
  • D. In the Transactions query, group by AccountID and MonthStartDate for TransactionDate. Aggregate by summing the TransAmt column.
  • E. In the Transactions query, add a column that contains the MonthStartDate value for TransactionDate.
  • F. Create many-to-many relationships between the tables.
Show Suggested Answer Hide Answer
Suggested Answer: ABD 🗳️

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
kai_data
4 weeks, 1 day ago
Selected Answer: AB
Selecting D without E, makes no sense as transactions query have no MonthStartDate to aggregate on. But E indeed increase the size of the model.
upvoted 1 times
...
5bf040d
1 month, 1 week ago
Selected Answer: ABD
I believe E is not correct because adding MonthStartDate to the Transactions table would increase the data size, and this information is already available in the Date table.
upvoted 2 times
...
32c0a0b
1 month, 4 weeks ago
Selected Answer: ADE
I'll go for ADE, As with out creating a start month date column we cannot group or aggregate the table: So its: 1) Create Start month date column 2) Group or aggregate 3) create relationships
upvoted 2 times
...
SylUK
2 months ago
Selected Answer: ABD
A B D are the correct answers . E and F go against the requirement .
upvoted 2 times
...
BIT2024
2 months ago
Selected Answer: ADE
for me is ADE
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago