Microsoft Updated PL-300 Exam Questions and Answers by maliha

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 a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect

Does this meet the goal?

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?

You have a Power BI model that has the following tables:

Product (Product_id, Product_Name)

Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)

Salesperson (Salesperson_id, Salesperson_name, address)

You plan to create the following measure.

Measure1 = DISTINCTCOUNT(Sales[ProductID])

You need to create the following relationships:

Sales to Product

Sales to Salesperson

The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.

How should you configure the relationships? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power Bi report that contains five bookmarks.

You need to add an object to the report from which users can navigate between three specific bookmarks.

How should you complete the task? To answer, drag the appropriate actions to the correct steps, each action may be used once more than once, or not at all. You may need to drag the split bar between panes or scroll lo view content.

NOTE: Each correct selection is worth one point.