QUESTION: 1
Note: This question is part of a series of questions that present the same scenario. Each
question in the series contains a unique solution that might meet the stated goals. Some
question sets might have more than one correct solution, while others might not have a correct
solution.

After you answer a question in this section, you wil NOT be able to return to it. As a result,
these questions wil not appear in the review screen.

You have a Power BI model that contains two tables named Sales and Date. Sales contains
four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column
named Date.

The tables have the following relationships:
? Sales[DueDate] and Date[Date]
? Sales[ShipDate] and Date[Date]
? Sales[OrderDate] and Date[Date]

The active relationship is on Sales[DueDate].

You need to create measures to count the number of orders by [ShipDate] and the orders by
[OrderDate]. You must meet the goal without duplicating data or loading additional data.

Solution: You create a calculated table. You create a measure that uses the new table. Does
this meet the goal?

A. Yes
B. No

Answer(s): B
QUESTION: 2
Note: This question is part of a series of questions that present the same scenario. Each
question in the series contains a unique solution that might meet the stated goals. Some
question sets might have more than one correct solution, while others might not have a correct
solution.

After you answer a question in this section, you wil NOT be able to return to it. As a result,
these questions wil not appear in the review screen.

You have a Power BI model that contains two tables named Sales and Date. Sales contains
four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column
named Date.

The tables have the following relationships:
? Sales[DueDate] and Date[Date]
? Sales[ShipDate] and Date[Date]
? Sales[OrderDate] and Date[Date]