PL-300 exam

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 dat a. The users require insights on the completeness of the data and the value distributions. Which three actions should...

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 need to create relationships to meet the reporting requirements of the customer service department. What should you create?A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]B . an additional date table named ShipDate, a many-to-many...

HOTSPOT 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. View AnswerAnswer: Explanation: Box 1: CALCULATE CALCULATE evaluates an expression...

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can...

You have four sales regions. Each region has multiple sales managers. You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role. You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The...

HOTSPOT You need to create a relationship in the dataset for RLS. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: many-to-one Each employee in the Sales Employees table is assigned to...

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create?A . bar chartB . scatterplotC . pie chartView AnswerAnswer: A Explanation: Scenario: The On-Time Shipping report will show the following metrics for...

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.) What occurred at 12:03:06 PM?A . A user pressed F5B . A new transaction...

HOTSPOT You have a report page that contains the visuals 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. View AnswerAnswer: Explanation: Box 1: cross-filter...