3/11/23, 11:09 PM PL-300 Exam – Free Actual Q&As, Page 2 | ExamTopics

Question #6 Topic 1

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:

Correct Answer:

Box 1: Inner -
Every Product has a ProductSubCategory.
A standard join is needed.
One of the join kinds available in the Merge dialog box in Power Query is an inner join, which brings in only matching rows from both the left and
right tables.

Box 2: Left outer -

Not every ProductsubCategory has a parent ProductCategory.
One of the join kinds available in the Merge dialog box in Power Query is a left outer join, which keeps all the rows from the left table and brings

https://www.examtopics.com/exams/microsoft/pl-300/view/2/ 2/6
3/11/23, 11:09 PM PL-300 Exam – Free Actual Q&As, Page 2 | ExamTopics

in any matching rows from the right table.

Reference:
https://docs.microsoft.com/en-us/power-query/merge-queries-inner https://docs.microsoft.com/en-us/power-query/merge-queries-left-outer

Question #7 Topic 1

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

You need to perform the following analyses:

✑ Orders sold over time that include a measure of the total order value
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 Order Line Items query and the Products query. Most Voted

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

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

D. From Power Query, merge the Orders query and the Order Line Items query. Most Voted

Correct Answer: D
A merge queries operation joins two existing tables together based on matching values from one or multiple columns.
Join the Orders and the Order Line Items tables.
Reference:
https://docs.microsoft.com/en-us/power-query/merge-queries-overview

Community vote distribution

D (64%) A (36%)

https://www.examtopics.com/exams/microsoft/pl-300/view/2/ 3/6
3/11/23, 11:09 PM PL-300 Exam – Free Actual Q&As, Page 2 | ExamTopics

Question #8 Topic 1

You have a Microsoft SharePoint Online site that contains several document libraries.
One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data
structure.
You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.
What should you do?

A. Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library.
Most Voted

B. Get data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing
reports library.

C. Get data from a SharePoint folder, enter the site URL, and then select Combine & Load.

D. Get data from a SharePoint list, enter the site URL, and then select Combine & Load.

Correct Answer: A
Get Data from SharePoint folder + select Combine & Load to load the data from all of the files in the SharePoint folder directly into your app.
Note: Connect to a SharePoint folder from Power Query Desktop
To connect to a SharePoint folder:
1. From Get Data, select SharePoint folder.
2. Paste the SharePoint site URL you copied in Determine the site URL to the Site URL text box in the SharePoint folder dialog box. In this
example, the site URL is https://contoso.sharepoint.com/marketing/data. If the site URL you enter is invalid, a warning icon. warning icon will
appear next to the URL text box.
SharePoint folder selection.
3. Select OK to continue.
4. If this is the first time you've visited this site address, select the appropriate authentication method. Enter your credentials and choose which
level to apply these settings to. Then select Connect.
5. When you select the SharePoint folder you want to use, the file information about all of the files in that SharePoint folder are displayed. In
addition, file information about any files in any subfolders is also displayed.
6. Select Combine & Transform Data to combine the data in the files of the selected SharePoint folder and load the data into the Power Query
Editor for editing. Or select Combine & Load to load the data from all of the files in the SharePoint folder directly into your app.
Reference:
https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder

Community vote distribution

A (87%) 8%

https://www.examtopics.com/exams/microsoft/pl-300/view/2/ 4/6
3/11/23, 11:09 PM PL-300 Exam – Free Actual Q&As, Page 2 | ExamTopics

Question #9 Topic 1

DRAG DROP -
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.
Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no
duplicate values.

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.
Select and Place:

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

https://www.examtopics.com/exams/microsoft/pl-300/view/2/ 5/6
3/11/23, 11:09 PM PL-300 Exam – Free Actual Q&As, Page 2 | ExamTopics

Question #10 Topic 1

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 in 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?

A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

B. Change the data type of the Logged column to Date.

C. Split the Logged column by using at as the delimiter. Most Voted

D. Apply a transformation to extract the first 11 characters of the Logged column.

Correct Answer: D
Extract the date, which is the first 11 characters.
CSV files have no data types.
Note: A CSV is a comma-separated values file, which allows data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet
but with a . csv extension. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets.
Reference:
https://www.bigcommerce.com/ecommerce-answers/what-csv-file-and-what-does-it-mean-my-ecommerce-business/

Community vote distribution

C (94%) 4%

 Previous Questions Next Questions 

https://www.examtopics.com/exams/microsoft/pl-300/view/2/ 6/6