PL-300 Online Practice Questions and Answers

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

A. Change the data type of Sales[region_id] to Whole Number.

B. In the Sales table, add a measure for sum(sales_amount).

C. Change the data type of sales[sales_id] to Text.

D. Change the data type of sales [region_id] to Decimal Number.

You have a Power BI workspace named BI Data that contains a dataset named BI Finance. You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace,

You need to connect to BI Finance and create a report.

Which actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. From the Power BI service, create a dataflow to the dataset by using DirectQuery.

B. From Power BI Desktop, connect to a Dataverse data source.

C. From the Power BI service, create a new report and select a published dataset

D. From Power Bl Desktop, connect to a shared dataset

You are building a Power Bl report that uses data from an Azure SQL database named erp1. You Import the following tables.

You need to perform the following analyses:

1.

Orders sold over time that include a measure of the total order value

2.

Orders by attributes of products sold

The solution must minimize update times when interacting with visuals in the report. What should you do first?

A. From Power Query, merge the Orders query and the Order Line Hems query.

B. Calculate the count of orders per product by using a DAX function.

C. Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.

D. From Power Query, merge the Order Line Items query and the Products query.

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

You need to ensure that the users will see the current data when they view the dashboard.

How should you configure the connection to the data source?

A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.

B. Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.

C. Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.

D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.

You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.

What should you do?

A. Create an active relationship between the tables and select Assume referential integrity.

B. Create an inactive relationship between the tables and select Assume referential integrity.

C. Create an inactive relationship between the tables and select Apply security filter in both directions.

D. Create an active relationship between the tables and select Apply security filter in both directions.

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.

Does this meet the goal?

A. Yes

B. No

You need to create a visual that compares profit across 10 product categories for a selected quarter.

What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select the BEST answer.

A. an area chart

B. a clustered bar chart

C. a line chart

D. a funnel chart

HOTSPOT

You need to create a Power Bl report. The first page or the report must contain the following two views:

1.

Sales By Postal Code

2.

Sales by Month

Both views must display a slicer to select a value for a field named Chain.

The Sales By Postal Code view must display a map visual as shown in the following exhibit.

The Sales By Month view must display a column chart visual as shown in the following exhibit.

Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views.

What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

DRAG DROP

You have a Microsoft Power BI workspace.

You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.

Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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:

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: