Microsoft PL-300 Actual Free Exam Questions – Questions 21-40 with Answers

 

Microsoft PL-300 Free Exam Questions 21-40 with Answers

Scenario-based practice questions for the Microsoft PL-300 Power BI Data Analyst exam. Each question includes a clear answer, a plain-English explanation, and a reference link to official Microsoft documentation. Work through them as a diagnostic, then focus your study time on the gaps they reveal.

PL-300 Practice Questions 21-25

Question 21

HOTSPOT
You have the Azure SQL databases shown in the following table.

Certget Microsoft PL-300 Free Dumps - 21

You plan to build a single PBIX file to meet the following requirements:
• Data must be consumed from the database that corresponds to each stage of the development lifecycle.
• Power BI deployment pipelines must NOT be used.
• The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Certget Microsoft PL-300 Free Dumps - 21a

Answer:

Certget Microsoft PL-300 Free Dumps - 21b

Use a Power Query parameter to define the database server or database name, and reference that parameter in the connection. This lets one PBIX file point to different databases per stage without deployment pipelines.

Reference: Power Query parameters

Question 22

You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.

Certget Microsoft PL-300 Free Dumps - 22

You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Delete the Country column.
  • B. Remove duplicates from the table.
  • C. Remove duplicates from the City column.
  • D. Delete the City column.
  • E. Remove duplicates from the Country column.
Answer: D. Delete the City column and E. Remove duplicates from the Country column
Removing the City column leaves only Country, and removing duplicates produces a unique country list.

Reference: Remove duplicates in Power Query

Question 23

DRAG DROP
You use Power Query Editor to preview the data shown in the following exhibit.

Certget Microsoft PL-300 Free Dumps - 23

You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.
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.

Certget Microsoft PL-300 Free Dumps - 23a

Answer:

Certget Microsoft PL-300 Free Dumps - 23b

Select the discount column, select Replace Errors, and enter 0.05 as the replacement value. Replace Errors keeps all rows and swaps error values with the replacement value.

Reference: Replace values in Power Query

Question 24

HOTSPOT
You attempt to use Power Query Editor to create a custom column and receive the error message shown in the following exhibit.

Certget Microsoft PL-300 Free Dumps - 24

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.

Certget Microsoft PL-300 Free Dumps - 24a

Answer:

Certget Microsoft PL-300 Free Dumps - 24b

The error is caused by an invalid expression in the custom column formula, and the fix is to correct the formula syntax before applying it.

Reference: Add a custom column in Power Query

Question 25

From Power Query Editor, you attempt to execute a query and receive the following error message.
Datasource.Error: Could not find file.
What are two possible causes of the error? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. You do not have permissions to the file.
  • B. An incorrect privacy level was used for the data source.
  • C. The file is locked.
  • D. The referenced file was moved to a new location.
Answer: A. You do not have permissions to the file and D. The referenced file was moved to a new location
A “Could not find file” error usually means the path is no longer valid or the account running the query cannot see the file.

Reference: File connectors in Power Query

PL-300 Practice Questions 26-30

Question 26

You have data in a Microsoft Excel worksheet as shown in the following table.

Certget Microsoft PL-300 Free Dumps - 26

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:
• If the discount column returns an error, a discount of 0.05 must be used.
• All the rows of data must be maintained.
• Administrative effort must be minimized.
What should you do in Power Query Editor?

  • A. Select Replace Errors.
  • B. Edit the query in the Query Errors group.
  • C. Select Remove Errors.
  • D. Select Keep Errors.
Answer: A. Select Replace Errors.
Replace Errors keeps every row and substitutes the error values with 0.05.

Reference: Replace values in Power Query

Question 27

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 the Parse function from the Data transformations options to the Logged column.
  • B. Change the data type of the Logged column to Date.
  • C. Split the Logged column by using at as the delimiter.
  • D. Create a column by example that starts with 2018-12-31.
Answer: C. Split the Logged column by using at as the delimiter.
The date portion can then be set to the Date data type and Power BI builds the date hierarchy.

Reference: Transform columns in Power Query

Question 28

DRAG DROP
You have two Microsoft Excel workbooks in a Microsoft OneDrive folder.
Each workbook contains a table named Sales. The tables have the same data structure in both workbooks.
You plan to use Power BI to combine both Sales tables into a single table and create visuals based on the data in the table. The solution must ensure that you can publish a separate report and dataset.
Which storage mode should you use for the report file and the dataset file? To answer, drag the appropriate modes to the correct files. Each mode 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.

Certget Microsoft PL-300 Free Dumps - 28

Answer:

Certget Microsoft PL-300 Free Dumps - 28a

Use Import mode for both the report file and the dataset file. Import mode supports publishing a separate report and dataset and gives fast visual response times.

Reference: Storage modes in Power BI Desktop

Question 29

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.
You need to combine the tables into a single query that contains the unique columns of each table.
What should you select in Power Query Editor?

  • A. Merge queries
  • B. Combine files
  • C. Append queries
Answer: A. Merge queries
Merge joins the two tables on Order ID and brings the unique columns of each table into one query.

Reference: Merge queries overview

Question 30

HOTSPOT
You have a folder that contains 50 JSON files.
You need to use Power BI Desktop to make the metadata of the files available as a single dataset. The solution must NOT store the data of the JSON files.
Which type of data source should you use, and which transformation should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Certget Microsoft PL-300 Free Dumps - 30

Answer:

Certget Microsoft PL-300 Free Dumps - 30a

Use the Folder data source and remove the data columns. This keeps file metadata as a dataset without storing the JSON content.

Reference: Folder connector

PL-300 Practice Questions 31-35

Question 31

Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
General Overview
Northwind Traders is a specialty food import company.
The company recently implemented Power BI to better understand its top customers, products, and suppliers.
Business Issues
The sales department relies on the IT department to generate reports in Microsoft SQL Server Reporting Services (SSRS). The IT department takes too long to generate the reports and often misunderstands the report requirements.
Existing Environment. Data Sources
Northwind Traders uses the data sources shown in the following table.

Certget Microsoft PL-300 Free Dumps - 31

Source2 is exported daily from a third-party system and stored in Microsoft SharePoint Online.
Existing Environment. Customer Worksheet
Source2 contains a single worksheet named Customer Details. The first 11 rows of the worksheet are shown in the following table.

Certget Microsoft PL-300 Free Dumps - 31a

All the fields in Source2 are mandatory.
The Address column in Customer Details is the billing address, which can differ from the shipping address.
Existing Environment. Azure SQL Database
Source1 contains the following tables:
• Orders
• Products
• Suppliers
• Categories
• Order Details
• Sales Employees
The Orders table contains the following columns.

Certget Microsoft PL-300 Free Dumps - 31b

The Order Details table contains the following columns.

Certget Microsoft PL-300 Free Dumps - 31c

The address in the Orders table is the shipping address, which can differ from the billing address.
The Products table contains the following columns.

Certget Microsoft PL-300 Free Dumps - 31d

The Categories table contains the following columns.

Certget Microsoft PL-300 Free Dumps - 31e

The Suppliers table contains the following columns.

Certget Microsoft PL-300 Free Dumps - 31f

The Sales Employees table contains the following columns.

Certget Microsoft PL-300 Free Dumps - 31f1

Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
Requirements. Report Requirements
Northwind Traders requires the following reports:
• Top Products
• Top Customers
• On-Time Shipping
The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.
The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category. The report must also show which suppliers provide the top products.
The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
• The percentage of orders that were shipped late by country and shipping region
• Customers that had multiple late shipments during the last quarter
Northwind Traders defines late orders as those shipped after the required shipping date.
The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%.
The reports must show historical data for the current calendar year and the last three calendar years.
Requirements. Technical Requirements
Northwind Traders identifies the following technical requirements:
• A single dataset must support all three reports.
• The reports must be stored in a single Power BI workspace.
• Report data must be current as of 7 AM Pacific Time each day.
• The reports must provide fast response times when users interact with a visualization.
• The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.
Requirements. Security Requirements
Access to the reports must be granted to Azure Active Directory (Azure AD) security groups only. An Azure AD security group exists for each department.
The sales department must be able to perform the following tasks in Power BI:
• Create, edit, and delete content in the reports.
• Manage permissions for workspaces, datasets, and reports.
• Publish, unpublish, update, and change the permissions for an app.
• Assign Azure AD groups role-based access to the reports workspace.
Users in the sales department must be able to access only the data of the sales region to which they are assigned in the Sales Employees table.
Power BI has the following row-level security (RLS) Table filter DAX expression for the Sales Employees table.
[EmailAddress] = USERNAME()
RLS will be applied only to the sales department users. Users in all other departments must be able to view all the data.
You need to create the semantic model.
Which storage mode should you use for the tables in the semantic model?

  • A. DirectQuery
  • B. Dual
  • C. Import
  • D. live connection
Answer: C. Import
Import mode provides fast response times when users interact with visuals and minimizes the size of the dataset.

Reference: Storage modes in Power BI Desktop

Question 32

HOTSPOT
You have a Power BI semantic model that contains the data sources shown in the following table.

Certget Microsoft PL-300 Free Dumps - 32

You need to configure the privacy levels of the data sources.
What should you configure for each data source? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.

Certget Microsoft PL-300 Free Dumps - 32a

Answer:

Certget Microsoft PL-300 Free Dumps - 32b

Set Organizational for internal organizational data sources and Private for personal or unknown sources. Privacy levels control how data is combined across sources.

Reference: Privacy levels in Power BI

Question 33

You plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps.
From Power BI Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:
• Use Analytics views.
• Filter data from the cloud.
Which connector should you use?

  • A. OData queries
  • B. Azure DevOps (Boards only)
  • C. Azure DevOps Server (Boards only)
  • D. OData Feed
Answer: D. OData Feed
The OData Feed connector supports Analytics views and cloud filtering for Azure DevOps.

Reference: Azure DevOps connector in Power BI

Question 34

HOTSPOT
You use Power Query Editor to preview the data shown in the following exhibit.

Certget Microsoft PL-300 Free Dumps - 34

You confirm that the data will always start on row 3, and row 3 will always contain the column names.
How should you shape the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Certget Microsoft PL-300 Free Dumps - 34a

Answer:

Certget Microsoft PL-300 Free Dumps - 34b

Remove the top 2 rows and use the first row as headers. This aligns the data so row 3 becomes the header row and the rest is data.

Reference: Transform table data in Power Query

Question 35

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 data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You implicitly convert the values into the required type.
Does this meet the goal?

  • A. Yes
  • B. No
Answer: B. No
Implicit conversion does not fix case-sensitive values that cause undefined values and errors in DirectQuery mode.

Reference: DirectQuery in Power BI

PL-300 Practice Questions 36-40

Question 36

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 data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You change the semantic model mode.
Does this meet the goal?

  • A. Yes
  • B. No
Answer: B. No
Changing the semantic model mode does not fix case-sensitive values that cause undefined values and errors.

Reference: DirectQuery in Power BI

Question 37

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 data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You normalize casing in the source query or Power Query Editor.
Does this meet the goal?

  • A. Yes
  • B. No
Answer: A. Yes
Normalizing casing in the source query or Power Query Editor resolves case-sensitive mismatches that cause undefined values and errors.

Reference: Transform columns in Power Query

Question 38

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 data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You add an index key and normalize casing in the data source.
Does this meet the goal?

  • A. Yes
  • B. No
Answer: A. Yes
Adding an index key and normalizing casing in the data source addresses the case-sensitive mismatch that causes undefined values and errors.

Reference: Add an index column in Power Query

Question 39

You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI semantic model.
You need to ensure that the semantic model can be refreshed in PowerBi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. Web
  • B. Excel Workbook
  • C. Folder
  • D. Text/CSV
  • E. SharePoint folder
Answer: B. Excel Workbook and E. SharePoint folder
Both connectors support cloud refresh in the Power BI service when the file is stored in OneDrive or SharePoint.

Reference: Data refresh in Power BI

Question 40

You use Power Query Editor to preview a column named Date as shown in the following exhibit.

Certget Microsoft PL-300 Free Dumps - 41

You need to change the Date column to contain only the year. The solution must minimize administrative effort.
What should you do?

  • A. Split the column by delimiter.
  • B. Split the column by number of characters.
  • C. Extract the text after the delimiter.
  • D. Transform the column to contain only the year.
Answer: D. Transform the column to contain only the year.
The built-in Year transformation extracts the year with no manual steps.

Reference: Transform columns in Power Query

Need more questions or guidance for the exam? Visit the certification page.

 

error: Content is protected !!