You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
For each of the following statements, se lect Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You have a Power BI semantic model that contains two tables named DimCustomer and FactOrderDetails.
The primary key of DimCustomer is CustomerID.
FactOrderDetails contains a column named CustomerID that can be used to relate to DimCustomer. Multiple rows in FactOrderDetails possibly have the same CustomerID value.
You need to create a relationship from FactOrderDetails to DimCustomer. The solution must optimize query performance.
What should you create?
You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.
A user wants to create a report by using the data In DS1 and publish the report to another workspace.
You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.
What should you do?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
From Power Query Editor, you profile the data shown in the following exhibit.
The IoT GUID and IoT ID columns are unique to each row in query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You remove the loT GUID column and retain the loT ID column.
Does this meet the goal?
Hotspot Question
You have a Power BI semantic model named Model1 that contains a table named Sales.
Sales contains 10 million records and the following data.
The related report displays the weekly sales per region.
You need to minimize the size of Model1.
How should you modify the CustomerID column and the PurchaseDateTime column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
