You are building a Power Bl report that uses data from an Azure SQL database named erp1.
You Import the following tables.

You need to perform the following analyses:
* Orders sold over time that include a measure of the total order value
* Orders by attributes of products sold
The solution must minimize update times when interacting with visuals in the report. What should you do first?

• A.From Power Query, merge the Orders query and the Order Line Hems query.
• B.Calculate the count of orders per product by using a DAX function.
• C.Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.
• D.From Power Query, merge the Order Line Items query and the Products query.

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You have a report page that contains the visuals shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You build a report about warehouse inventory dat
a. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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:

1 - Add a column named ProductName that contains all the text between the third and fourth . symbol in the ProductDescription column.
2 - Create a product hierarchy of ProductCategory,ProductSubcategory,Manufacturer, ProductName, and ProductSpecifications.
3 - Replace the use of ProductDescription,,,,,,

Comment: *

Name: *

Email: *

Verification: *

You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Box 1: The Viewer role to the workspace
The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can't browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to "Members can only view Power BI content".

Box 2: Build
The analysts must be able to build new reports from the dataset that contains the profit and loss data.
Scenario: The reports must be made available to the board from powerbi.com.
The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.
Reference:
https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html

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:

1 - Duplicate Customer query
2 - Group by CustId by Max ModifiedDate
3 - Merge two queries on CustId and ModifiedDate inner join

Comment: *

Name: *

Email: *

Verification: *