HOTSPOT - (Topic 3)
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.
Solution:
Does this meet the goal?
Correct Answer:
A
HOTSPOT - (Topic 4)
You have a column named UnitslnStock as shown in the following exhibit
UnitsInStock has 75 non-null values, of which 51 are unique.
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.
Solution:
Does this meet the goal?
Correct Answer:
A
DRAG DROP - (Topic 4)
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.
Sheet2 contains the following table named Table2.
You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.
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.
Solution:
Does this meet the goal?
Correct Answer:
A
- (Topic 4)
You have a report in Power Bl named report1 that is based on a shared dataset.
You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.
What should you do?
Correct Answer:
C
HOTSPOT - (Topic 2)
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Solution:
Box 1: Using a workspace membership Scenario:
The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.
Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of dashboards, reports, and datasets in it.
Box 2: A mail-enabled security group Scenario: Security Requirements
The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.
Does this meet the goal?
Correct Answer:
A
