PL-300 Online Practice Questions and Answers

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:

Customer ID Customer Name Phone Email Address Address ID

Address contains the following columns:

Address ID Address Line 1 Address Line 2 City State/Region Country Postal Code

The Customer ID and Address ID columns represent unique rows.

You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.

What should you do?

A. Merge the Customer and Address tables.

B. Transpose the Customer and Address tables.

C. Group the Customer and Address tables by the Address ID column.

D. Append the Customer and Address tables.

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl. You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets.

What should you recommend?

A. Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.

B. In the same workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

C. Create separate workspaces for development and production. Grant the end users access to the production workspace.

D. Create one workspace for development. From the workspace, publish an app for production.

Your organization has a team of power users who recently created 20 Power BI dashboards.

The power users share the dashboards with other users in the organization.

When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards. What should you do first?

A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

B. From the Power BI Admin portal, modify the Privacy Settings.

C. From the properties of each dashboard, modify the Share dashboard settings.

D. Instruct each user to install Microsoft Office 2016.

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.

In powerbi.com, when users load the visual, they only see some of the customers.

What is the cause of the issue?

A. The visual was built by using a different version of R.

B. The data comes from a Microsoft SQL Server source.

C. The data is deduplicated.

D. Too many records were sent to the visual.

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 Power BI model that contains two tables named Sales and Date. Sales contains four

columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.

The tables have the following relationships:

Sales[DueDate] and Date[Date]

Sales[ShipDate] and Date[Date]

Sales[OrderDate] and Date[Date]

The active relationship is on Sales[DueDate].

You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.

Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.

Does this meet the goal?

A. Yes

B. No

You are creating a visual to show the ranking of product categories by sales revenue.

Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant

Which approach provides the widest variety of visuals while adhering to the security policy?

A. Use default visuals or custom visuals uploaded from a .pbiviz file.

B. Use only default visuals.

C. Use default or any custom visuals from the marketplace.

D. Use default or certified custom visuals.

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

A. Create a shared dataset for each standardized entity.

B. Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

C. For every report, create and use a single shared dataset that contains the standardized data.

D. For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

HOTSPOT

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

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Hot Area:

HOTSPOT

You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.

You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:

1.

Create reports that use the HR dataset.

2.

Publish the reports to WorkspaceB.

3.

Prevent the ability to modify the HR dataset.

4.

Prevent the ability to add users to WorkspaceB.

Hot Area:

HOTSPOT

You have a Power 31 data model that contains a table named Stores. The table has the following columns:

1.

Store Name

2.

Open Date

3.

Status

4.

State

5.

City

You need to create a calculated column named Active Store Name that meets the following requirements:

Hot Area: