ExamGecko
Home / Microsoft / PL-300 / List of questions
Ask Question

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

List of questions

Question 201

Report
Export
Collapse

For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing dat a. The solution must minimize development effort. Which type ol data source should you use?

a SharePoint folder

a SharePoint folder

Power Bl dataflows

Power Bl dataflows

an Excel workbook

an Excel workbook

Power Bl dataset

Power Bl dataset

Suggested answer: A

Explanation:

Case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.

asked 05/10/2024
Miguel Sartori
35 questions

Question 202

Report
Export
Collapse

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?

Append the Customer and Address tables.

Append the Customer and Address tables.

Transpose the Customer and Address tables.

Transpose the Customer and Address tables.

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

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

Merge the Customer and Address tables.

Merge the Customer and Address tables.

Suggested answer: D
asked 05/10/2024
Sriharsha Janga
43 questions

Question 203

Report
Export
Collapse

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?

Create a column by example that starts with 2018-12-31.

Create a column by example that starts with 2018-12-31.

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date

Apply the parse function from the Date transformations options to the Logged column.

Apply the parse function from the Date transformations options to the Logged column.

Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

Suggested answer: A
asked 05/10/2024
Rio Ordonez
51 questions

Question 204

Report
Export
Collapse

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.

Microsoft PL-300 image Question 171 106428 10052024010716000000

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.

Microsoft PL-300 image Question 171 106428 10052024010716000000

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.

Remove the rows m Traffic in which Traffic [Referring URL] does not start with "/"

Remove the rows m Traffic in which Traffic [Referring URL] does not start with "/"

Remove the rows in Posts m which Post [Publish Date] is in the last seven days.

Remove the rows in Posts m which Post [Publish Date] is in the last seven days.

Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).

Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).

Remove Posts [Full Text] and Posts [Summary].

Remove Posts [Full Text] and Posts [Summary].

Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''

Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''

Suggested answer: D, E
asked 05/10/2024
Robert L Swafford
38 questions

Question 205

Report
Export
Collapse

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

Microsoft PL-300 image Question 172 106429 10052024010716000000

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.

Microsoft PL-300 image Question 172 106429 10052024010716000000

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

Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month

Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month

Merge Suppliers and Uneltems.

Merge Suppliers and Uneltems.

Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).

Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).

Remove the Lineitems[Description] column.

Remove the Lineitems[Description] column.

Suggested answer: D
asked 05/10/2024
Andreas Krieger
34 questions

Question 206

Report
Export
Collapse

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.


Microsoft PL-300 image Question 206 106430 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 206 106430 10052024010716000
asked 05/10/2024
Kevin Zander
32 questions

Question 207

Report
Export
Collapse

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.


Microsoft PL-300 image Question 207 106431 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 207 106431 10052024010716000
asked 05/10/2024
Manohar M
41 questions

Question 208

Report
Export
Collapse

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.

Microsoft PL-300 image Question 175 106432 10052024010716000000

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

Microsoft PL-300 image Question 175 106432 10052024010716000000

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.


Microsoft PL-300 image Question 208 106432 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 208 106432 10052024010716000
asked 05/10/2024
fritz villanueva
48 questions

Question 209

Report
Export
Collapse

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.


Microsoft PL-300 image Question 209 106433 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 209 106433 10052024010716000
asked 05/10/2024
Sergio Zozulenko
40 questions

Question 210

Report
Export
Collapse

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.


Microsoft PL-300 image Question 210 106434 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 210 106434 10052024010716000
asked 05/10/2024
Mohsin Raza
43 questions
Total 370 questions
Go to page: of 37
Search

Related questions