Hotspot Question
You have a query named All Sales that imports sales data into a Power BI model.
You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:
- Use All Sales as the source for three other queries named Sales Fact, Product Dimension, and Customer Dimension.
- Minimize maintenance effort.
What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You open powerbi.com as 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.
You have a Power Bl report.
You have the following tables.
You have the following DAX measure.
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 the query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.
Does this meet the goal?
You have a Power BI model that contains the following data.
The Date table relates to the Sales table by using the Date columns.
You need to create a calculated table that v/ill contain the following:
