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?

• A.Change any DAX measures to use iterator functions.
• B.Replace the default visuals with AppSource visuals.
• C.Change the imported dataset to DirectQuery.
• D.Remove unused columns from tables in the data model.

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection.
You need to ensure that users can use Q&A from the Power BI service for the dataset.
What should you do?

• A.From the Power BI service, add an enterprise gateway to the dataset.
• B.From Power BI Desktop, add a Q&A visual to the report.
• C.From the Power Bi service, select Turn on Q& A for this dataset.
• D.From Power BI Desktop, add synonyms and suggested questions.

Comment: *

Name: *

Email: *

Verification: *

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.

Correct Answer:

Reference:
https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/

Comment: *

Name: *

Email: *

Verification: *

You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures

Comment: *

Name: *

Email: *

Verification: *

Hotspot Question
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.

You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: CALCULATE
Start with CALCULATE and use a SUMX.
CALCULATE evaluates an expression in a modified filter context.
Box 2: SUM
Box 3: TOPN
TOPN returns the top N rows of the specified table.
Box 4: [TransactionDate]
TOPN Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[,
<orderBy_expression>, [<order>]]...])
The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table.
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax

Comment: *

Name: *

Email: *

Verification: *