You have a Power BI semantic model named Model1 that runs in Import storage mode.You need to reduce the size of Model1.Which two actions should you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
Answer(s): A,D
You have a Power BI semantic model that contains the following data.You need to create a solution that meets the following requirements:• Presents transaction amount totals for each month for the current and prior year• Follows the star schema modeling approach• Minimizes the data model sizeWhich three actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
Answer(s): A,B,D
HOTSPOT (Drag and Drop is not supported)You have a Power BI semantic model that contains three tables named Products, OrderHistory, and Date.The Products table is a dimension table that contains the following columns:• ProductID• ProductNameThe OrderHistory table is a fact table that contains the following columns:• OrderID• ProductID• OrderDateThe Date table is a dimension table that contains the following columns:• Year• Date• Week• MonthYou need to define a relationship from Products to OrderHistory and from OrderHistory to Date.Which cardinality should you configure? To answer, select the appropriate options in the answer area.NOTE: Each correct answer is worth one point.
Answer(s): A
HOTSPOT (Drag and Drop is not supported)You use Microsoft Power BI Desktop to review the data 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.
HOTSPOT (Drag and Drop is not supported)You have a Power BI semantic model that contains two tables named Sales and Forecast. Both tables contain a date column.You need to create a calculated table that will cover the range of dates in both tables.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.
Post your Comments and Discuss Microsoft PL-300 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PL-300 content, but please register or login to continue.