QUESTION: 109 Exam Topic: Question Set 2

HOTSPOT (Drag and Drop is not supported)
You have a query named All Sales that imports sales data into a Power BI model.

You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:

-Use All Sales as the source for three other queries named Sales Fact, Product Dimension, and Customer Dimension.
-Minimize maintenance effort.

What should you do to create the Sales Fact query, and for which query should you clear Enable load? 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: 110 Exam Topic: Question Set 2

You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

The model contains the following DAX measure.
Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

Which DAX calculation should you use?

CALCULATE ( [Total Sales], DATEADD (Date[Date],1, QUARTER ) )
CALCULATE ( [Total Sales], DATESQTD (Date[Date] ) )
TOTALQTD ( [Total Sales], Date[Date] )
CALCULATE ( [Total Sales], PARALLELPERIOD (Date[Date], 1, QUARTER ) )

Answer(s): A

Reveal Solution Next Question

QUESTION: 111 Exam Topic: Question Set 2

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.

What should you recommend?

Change any DAX measures to use iterator functions.
Implement row-level security (RLS).
Replace the default visuals with AppSource visuals.
Split the visuals onto multiple pages.

Answer(s): D

Reveal Solution Next Question

QUESTION: 112 Exam Topic: Question Set 3

DRAG DROP (Drag and Drop is not supported)
You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

You plan to build a data model for a Power BI report.
You need to prepare the data so that it is available to the model in the format shown in the following table.

Which three actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Step 1: Select the [Department] and [Stage] columns and unpivot the other columns.
We unpivot the School1, School2, School3, and the School4 columns.
You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column.
Example:

When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns:
* Values (in blue on the left) are unpivoted into a new column (in blue on the right).
* Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.
Step 2: Rename the [Attribute] column as [School] and the [Value] column as [Score[,
Step 3: Group by [Department] and [School] and..