You import a Power BI dataset that contains the following tables:✑ Date✑ Product✑ Product InventoryThe Product Inventory table contains 25 million rows. A sample of the data is shown in the following table.The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to the Product table by using theProductKey column.You need to reduce the size of the data model without losing information.What should you do?
HOTSPOT -You are enhancing a Power BI model that has DAX calculations.You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.Which DAX functions should you use? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
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.You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.During the development process, you need to import a sample of the data from the Order table.Solution: You add a report-level filter that filters based on the order date.Does this meet the goal?
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.You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:✑ Due Date✑ Order Date✑ Delivery DateYou need to support the analysis of sales over time based on all the date foreign keys.Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.Does this meet the goal?
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.You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:✑ Due Date✑ Order Date✑ Delivery DateYou need to support the analysis of sales over time based on all the date foreign keys.Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date andDelivery Date.Does this meet the goal?
HOTSPOT -You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)The data has the following refresh requirements:✑ Customer must be refreshed daily.✑ Date must be refreshed once every three years.✑ Sales must be refreshed in near real time.✑ SalesAggregate must be refreshed once per week.You need to select the storage modes for the tables. The solution must meet the following requirements:✑ Minimize the load times of visuals.✑ Ensure that the data is loaded to the model based on the refresh requirements.Which storage mode should you select for each table? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
