exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 188 discussion

Actual exam question from Microsoft's DP-600
Question #: 188
Topic #: 1
[All DP-600 Questions]

You have a Fabric warehouse that contains a table named Table1. Table1 contains three columns named SalesAmount, ProductCategory, and TransactionDate.

You need to create a Microsoft Power BI query that will calculate the total sales amount of each product category for transactions that occurred during the last quarter.

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

NOTE: Each correct selection is worth one point.

  • A. For the TransactionDate column, select Remove duplicates.
  • B. For the TransactionDate column, select Keep top rows and set Number of rows to 90.
  • C. For the TransactionDate column, select Filter rows and set the value to last quarter.
  • D. For the ProductCategory column, select Group by and sum the SalesAmount column.
  • E. For the SalesAmount column, select Transformation number column - Standard, select Add, and then set the value to 90.
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️

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
82a46af
1 week, 6 days ago
Selected Answer: BD
It says 2 actions. B and D together will achieve the goal
upvoted 1 times
82a46af
1 week, 5 days ago
Sorry, should be C & D. B would return top 90 rows w/o considering the date.
upvoted 1 times
...
...
maquint
2 weeks ago
Selected Answer: CD
B does not achieve the goal.
upvoted 2 times
...
Duke_CT
2 weeks ago
Selected Answer: B
I'm gonna take a wild guess and say B. This topic is my weak spot.
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 ...