You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:• Date• Product• SalesAmountYou need to create a DAX measure for a rolling 31-day sales total that will return the total sales amount for a selected date and the previous 30 days.Which DAX expression should you use?
Answer(s): B
You publish a semantic model to the Power BI service. The semantic model contains data from the following data sources:• Source1: A Microsoft Excel file stored in Microsoft OneDrive for Business• Source2: An Azure SQL database on a virtual network• Source3: A public websiteWhich data sources require an on-premises data gateway?
HOTSPOT (Drag and Drop is not supported)You have a Power BI semantic model named ModelA that contains the following columns:All of the columns use the Text data type.Based on the model, you create a report named ReportA that contains the following columns:• OrderID• OrderDate• CustomerID• ShippingAddressReportA is the only report connected to ModelA.You discover that ReportA has performance issues caused by the size of ModelA.What should you do to optimize and reduce the size of ModelA? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.
Answer(s): A
You have a Power BI semantic model that contains two queries.You discover that a report based on the model has performance issues.You plan to use Power Query to reduce the data loaded to the model.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct answer is worth one point.
Answer(s): A,C
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 an on-premises data gateway.You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.Solution: You create aggregations to summarize results.Does this meet the goal?
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.