QUESTION: 77

You import a Power BI dataset that contains the following tables:
-Date
-Product
-Product Inventory
The Product Inventory table contains 25 million rows. A sample of the data is shown in the following table.
The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to the Product table by using the
ProductKey column.
You need to reduce the size of the data model without losing information.
What should you do?

Change Summarization for DateKey to Don't Summarize.
Remove the relationship between Date and Product Inventory
Change the data type of UnitCost to Integer.
Remove MovementDate.

Answer(s): D

Reveal Solution Next Question

QUESTION: 78

HOTSPOT (Drag and Drop is not supported)
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.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: CALCULATE
Example:
Total sales on the last selected date =
CALCULATE (
SUM ( Sales[Sales Amount] ),
'Sales'[OrderDateKey] = MAX ( 'Sales'[OrderDateKey] )
)
Box 2: SUM
Box 3: SAMEPERIODLASTYEAR
SAMEPERIODLASTYEAR returns a set of dates in the current selection from the previous year.
Example:
-- SAMEPERIODLASTYEAR returns the selected period shifted back one year.
EVALUATE
VAR StartDate = DATE ( 2008, 07, 25 )
VAR EndDate = DATE ( 2008, 07, 31 )
RETURN
CALCULATETABLE (
SAMEPERIODLASTYEAR ( 'Date'[Date] ),
'Date'[Date] >= StartDate &&
'Date'[Date] <= EndDate
)
ORDER BY [Date]

Reference:

https://docs.microsoft.com/en-us/dax/calculate-function-dax
https://dax.guide/sameperiodlastyear/

Reveal Solution Next Question

QUESTION: 79

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 will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a report-level filter that filters based on the order date.
Does this meet the goal?

Yes
No

Answer(s): B

Reveal Solution Next Question

QUESTION: 80

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 will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
-Due Date
-Order Date
-Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.
Does this meet the goal?

Yes
No

Answer(s): B

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 21)

QUESTION: 77

QUESTION: 78

Explanation:

Reference:

QUESTION: 79

QUESTION: 80

PL-300 Exam Discussions & Posts