QUESTION: 105 Exam Topic: Question Set 2

You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit.

You need to shape the query to display the following three columns:

-Month
-Sales
-Year

What should you select in Power Query Editor?

Merge columns
Transpose
Unpivot columns
Pivot column

Answer(s): C

Reveal Solution Next Question

QUESTION: 106 Exam Topic: Question Set 2

HOTSPOT (Drag and Drop is not supported)
You are creating a Power BI model to analyze inventory.

You load data into three tables named Date, Product, and Inventory. The Inventory table relates to the Date and Product tables by using one-to-many relationships.

Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month.

You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.

How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 107 Exam Topic: Question Set 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 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 three dates at the same time.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

Answer(s): A

Reveal Solution Next Question

QUESTION: 108 Exam Topic: Question Set 2

HOTSPOT (Drag and Drop is not supported)
You are creating a Power BI report that will show the number of current employees over time. The report will use Import storage mode for all tables.

The employment data will be imported from Azure SQL Database in a monthly snapshot. The data will be stored in a table named Headcount and will contain the following:

-One row per employee for each month the employee is employed
-In each row, a date key that shows the first day of the month of each snapshot

You have a related date table that contains dates for the years 2020 to 2030.
You need to create a semi-additive DAX measure that will return the count of employees for the last available date in a year, quarter, or month.

How should you complete the measure? To answer, select the appropriate options in the answer area.