Drag and Drop Question
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation:
https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/

Comment: *

Name: *

Email: *

Verification: *

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform?
Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A.Add the same slicer to each page and configure Sync slicers.
• B.Edit the interactions of the slicer that is on the same page as the KPI visualization.
• C.Configure a page-level filter.
• D.Edit the interactions of the KPI visualization.
• E.Configure a report-level filter.

Comment: *

Name: *

Email: *

Verification: *

You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.

You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation
1) Duplicate Customer query
2) Group by CustId by Max ModifiedDate (only 2 columns to keep)
3) Merge two queries on CustId and ModifiedDate inner join (to retreive other customer informations related to latest Date)

Comment: *

Name: *

Email: *

Verification: *

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A.Configure a report-level filter.
• B.Edit the interactions of the KPI visualization.
• C.Edit the interactions of the slicer that is on the same page as the KPI visualization.
• D.Configure a page-level filter.
• E.Add the same slicer to each page and configure Sync slicers.

Comment: *

Name: *

Email: *

Verification: *