Question 41
You have a Power BI model that has the following tables:
Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 42
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.

For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.

Question 43
You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 44
You have a query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?
Question 45
You are creating a Power Bi model in Power BI Desktop
You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.

You need to create a calculated table named Numbers that will contain all the integers from -100 to 100. How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.







