Download Latest PL-300 Questions

Page: 4 / 12

Question 16

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 select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options:

Sync the slicers across the pages.

Replace the slicers with page-level filters.

Replace the slicers with visual-level filters.

Create a bookmark for each slicer value.

Replace the slicers with report-level filters.

Question 17

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to load only the manufacturing reports to a table for analysis.

What should you do in Microsoft Power Bl Desktop?

Options:

Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.

Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the

manufacturing reports library.

Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Question 18

You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.

You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Options:

Question 19

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales You need to create a measure that calculates the total sales from the equivalent month of the previous year.

How should you complete the calculation? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.