DP-600 · Question #196
DP-600 Question #196: Real Exam Question with Answer & Explanation
Sign in or unlock DP-600 to reveal the answer and full explanation for question #196. The question stem and answer options stay visible for context.
Question
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.
Options
- AFor the TransactionDate column, select Remove duplicates.
- BFor the TransactionDate column, select Keep top rows and set Number of rows to 90.
- CFor the TransactionDate column, select Filter rows and set the value to last quarter.
- DFor the ProductCategory column, select Group by and sum the SalesAmount column.
- EFor the SalesAmount column, select Transformation number column - Standard, select Add,
Unlock DP-600 to see the answer
You've previewed enough free DP-600 questions. Unlock DP-600 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.