Practice Free PL-300 Exam Online Questions

HOTSPOT

You have two Azure SQL databases that contain the same tables and columns.

For each database, you create a query that retrieves data from a table named Customers.

You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Append Queries as New.

There are two primary ways of combining queries: merging and appending.

When you have one or more columns that you’d like to add to another query, you merge the queries.

When you have additional rows of data that you’d like to add to an existing query, you append the query.

Box 2: Disable loading the query to the data model

For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.

Reference:

https://docs.microsoft.com/en-us/power-query/append-queries

https://community.powerbi.com/t5/Power-Query/Append-vs-Append-as-new-for-performance/td-p/1822710

You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.

The finance team at your company is NOT currently a member of any Power B1 workspace roles.

You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.

What should you do?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.

What should you do?

Reveal Solution Hide Solution

DRAG DROP

You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.

The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.

You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales.

For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.

How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value 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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Divide, Calculate, AllSelected.

Reference: https://docs.microsoft.com/en-us/dax/allselected-function-dax

DRAG DROP

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.

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

You need to create a calculated table that v/ill contain the following:

Reveal Solution Hide Solution

Correct Answer:

DRAG DROP

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

You create two row-level security (RlS) roles named Manager and CFO.

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters.

The solution must meet the following requirements:

• Each manager must see only the data in the Sales and Human Resources tables for their own country.

• The CFO must be prevented from seeing the data in the Human Resources table.

• The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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.

The Country table contains the following data.

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters.

The solution must meet the following requirements:

• Each manager must see only the data in the Sales and Human Resources tables for their own country.

• The CFO must be prevented from seeing the data in the Human Resources table.

• The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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.

Reveal Solution Hide Solution

Correct Answer:

Your company has employees in 10 states.

The company recently decided to associate each state to one of the following three regions: East, West, and North.

You have a data model that contains employee information by state. The model does NOT include region

information.

You have a report that shows the employees by state.

You need to view the employees by region as quickly as possible.

What should you do?

Reveal Solution Hide Solution

HOTSPOT

Your company plans to use Power BI for 20 users in the sales department.

The users will perform the following tasks:

✑ Access a published Power BI app

✑ Modify reports in an app workspace

✑ Share dashboards created in My Workspace

You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.

Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps

https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace