You import a Power Bl dataset that contains the following tables:
* Date
* Product
* Product Inventory
The 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 the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?

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 are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You need to create a measure that will return the percentage of late orders.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have a Power BI imported dataset that contains the data model 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.