PL-300 Online Practice Questions and Answers

You have multiple dashboards.

You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the

dashboard design.

What should you use?

A. comments

B. tiles

C. Microsoft Information Protection sensitivity labels

D. Active Directory groups

You have the Power BI data model shown in the following exhibit.

The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

Which DAX expression should you use?

A. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])

B. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )

C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))

D. SUM(Sales[Sales])

You embed a Power BI report in a Microsoft SharePoint Online page.

A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: "This content isn't available".

User1 is unable to view the report.

You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

You need to ensure that User1 can view the report form SharePoint Online.

What should you do?

A. Publish the app workspace.

B. Edit the settings of the Power BI web part.

C. Modify the members of the app workplace.

D. Share the dashboards in the app workspace.

You have five sales regions. Each region is assigned a single salesperson.

You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.

Salespeople must see only the data from their region.

You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.

A salesperson reports that she believes she should see more data.

You need to verify what data the salesperson currently sees.

What should you do?

A. Use the Test as role option to view data as the salesperson's user account.

B. Use the Test as role option to view data as the Sales role.

C. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data What should you do?

A. From Power BI Desktop, configure the Data Load settings for the current file.

B. From the Power BI service, configure the dataset permissions.

C. From Power BI Desktop, configure the Report settings for the current file.

D. From Power BI Desktop, modify the data source permissions.

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You enable included in app for all assets.

Does this meet the goal?

A. Yes

B. No

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: From Power Query Editor, you import the table and then add a filter step to the query. Does this meet the goal?

A. Yes

B. No

You have the dashboard shown in the following exhibit.

You need to modify the dashboard to display as shown in the following exhibit.

What should you do?

A. Create and apply a custom dashboard theme.

B. Change the colors of the visuals in the report.

C. Apply the Dark dashboard theme.

D. Upload a snapshot image of the dashboard.

You need to review the data for which there are concerns before creating the data model. What should you do in Power Query Editor?

A. Select Column distribution.

B. Select the sales_amount column and apply a number filter.

C. Select Column profile, and then select the sales_amount column.

D. Transform the sales_amount column to replace negative values with 0.

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 relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]

C. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

D. 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 Date[date_id]

E. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

DRAG DROP

You plan to create a report that will display sales data from the last year for multiple regions

You need to restrict access to individual rows of the data on a per region-basis by using roles.

Which four 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.

Select and Place:

DRAG DROP

You receive annual sales data that must be included in Power BI reports.

From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

You need to create a report that meets the requirements:

1.

Visualizes the Sales value over a period of years and months

2.

Adds a Slicer for the month

3.

Adds a Slicer for the year

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.

Select and Place:

DRAG DROP

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

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.

Select and Place:

DRAG DROP

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.

Every Product has a ProductSubCategory.

Not every ProductsubCategory has a parent ProductCategory.

You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.

How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view

content.

NOTE: Each correct selection is worth one point.

Select and Place:

HOTSPOT

You are creating a Microsoft Power BI model that has two tables named CityData and Sales.

CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

CityData and Sales are related using a many-to-many relationship based upon the State column in each table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Hot Area: