Microsoft PL-300 Practice Test - Questions Answers, Page 21

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

Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. 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?

You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format:

2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns.

The report contains the visuals shown in the following table.

The dataset takes a long time to refresh.

You need to modify Posts and Traffic queries to reduce toad times.

Which two actions will reduce the toad times? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have a Power Bi report for the procurement department. The report contains data from the following tables.

There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals. What should you do?

DRAG DROP

You have a folder that contains 100 CSV files.

You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files. Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order. NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

DRAG DROP

You are creating a Power Bi model and report.

You have a single table in a data mode) named Product Product contains the following fields:

• ID

• Name

• Color

• Category

• Total Sales

You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales. How should you complete the DAX expression? To answer, drag the appropriate values to the coned 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.

DRAG DROP

You are modifying a Power Bi model by using Power Bl Desktop.

You have a table named Sales that contains the following fields.

You have a table named Transaction Size that contains the following data.

You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount. How should you complete the code? 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.

DRAG DROP

You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.

You have a Power Bl dashboard named DashboardA that has Q&A enabled.

You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to Dashboard

A. The solution must minimize development time.

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.

DRAG DROP

You have a Power Bl table named Customer that contains a field named Email Address.

You discover that multiple records contain the same email address.

You need to create a calculated column to identify which records have duplicate email addresses.

How should you complete the OAX expression for the calculated column? 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.