PL-300 exam

You have a sales system that contains the tables shown in the following table. The Date table is marked as a date table. DatelD is the date data type. You need to create an annual sales growth percentage measure. Which DAX expression should you use?A . SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])B...

Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?A . videoB . custom streaming dataC . text boxD . web contentView AnswerAnswer: D Explanation: https://docs.microsoft.com/en-us/stream/portal-embed-video https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add-web-content

HOTSPOT You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area....

HOTSPOT You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories. You import a fact table named Sales as shown in the exhibit....

HOTSPOT You need to grant access to the business unit analysts. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: The Viewer role to the workspace The Viewer role gives a read-only...

You have the visual shown in the exhibit. (Click the Exhibit tab.) You need to show the relationship between Total Cost and Total Sales over time. What should you do?A . Add a play axis.B . Add a slicer for the year.C . From the Analytics pane, add an Average...

You plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?A . Create a horizontal line that has a fixed value of 24,000.B . Add a measure to the visual that...

You have a Microsoft Power Bl dashboard. You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard. What should you use?A . FeedbackB . SubscribeC . CommentsD . Mark as favoriteView AnswerAnswer: C Explanation: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment

You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?A . 1318B . 1319C . 21318 Lasalle StreetD . 21319 Lasalle StreetView AnswerAnswer: D Explanation:...

DRAG DROP You are modeling data in table named SalesDetail by using Microsoft Power Bl. You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions. Which three actions should you...