Latest Microsoft PL-300 Dumps PDF Questions Answers 2025

Microsoft Power BI Data Analyst Questions and Answers

Question 1

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.

a clustered column chart that shows balances by date (x-axis) and account category (legend) without

filters.

a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.

a pie chart that shows balances by account category without filters.

a ribbon chart that shows balances by quarter and accounts in the legend.

Buy Now

Question 2

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Options:

Question 3

You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.

How should you complete the measure? 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.

Options:

Question 4

You need to grant access to the business unit analysts.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 5

What is the minimum number of datasets and storage modes required to support the reports?

Options:

two imported datasets

a single DirectQuery dataset

two DirectQuery datasets

a single imported dataset

Question 6

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Options:

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

DATESQTD( 'Date'[Date] )

)

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

LASTDATE( 'Date'[Date] )

)

FIRSTNONBLANK ( 'Date' [Date]

SUM( BalanceSheet[BalanceAmount] )

)

CALCULATE (

MAX( BalanceSheet[BalanceAmount] ),

LASTDATE( 'Date' [Date] )

)

Question 7

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.

What should you do?

Options:

From each report in powerbi.com. select Refresh visuals

From Power Bl Desktop, download the PBIX file and refresh the data.

Configure a scheduled refresh without using an on-premises data gateway.

Configure a scheduled refresh by using an on-premises data gateway

Question 8

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 9

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Options:

Question 10

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?

Options:

Create a shared dataset for each standardized entity.

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

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

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.

Question 11

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.

What should you set as the relationship cardinality?

Options:

One to one

Many to one

One to many

Many to many

Question 12

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

Options:

bar chart

scatterplot

pie chart

Question 13

You need to create a relationship in the dataset for RLS.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 14

You need to create a solution to meet the notification requirements of the warehouse shipping department.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct select is worth one point:

Options:

Question 15

You need to create the semantic model.

Which storage mode should you use for the tables in the semantic model?

Options:

live connection

Dual

Import

DirectQuery

Question 16

You need to create a relationship in the data model for RLS.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 17

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Answer:

Explanation:

Box 1: CALCULATE

CALCULATE evaluates an expression in a modified filter context.

Syntax: CALCULATE([, [, [, …]]])

Expression - The expression to be evaluated.

filter1, filter2,… (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.

Box 2: FILTER

FILTER returns a table that represents a subset of another table or expression.

Syntax: FILTER(

Table- The table to be filtered. The table can also be an expression that results in a table.

Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or [Region] = "France"

Box 3: Orders[ShippedDate]> Orders[RequiredDate]

Northwind Traders defines late orders as those shipped after the required shipping date.

[Reference:, https://docs.microsoft.com/en-us/dax/calculate-function-dax, , https://docs.microsoft.com/en-us/dax/filter-function-dax, , ]

Question 18

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

Options:

Add the sales department as a member of the reports workspace

Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

Distribute an app to the users in the Azure Active Directory group of the sales department.

Share each report to the Azure Active Directory group of the sales department.

Question 19

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?

Options:

Merge queries

Append queries

Combine files

Question 20

You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

Options:

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

From Power Bl Desktop, use the Auto date/time option when creating the reports.

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Question 21

You need to create the dataset. Which dataset mode should you use?

Options:

DirectQuery

Import

Live connection

Composite

Question 22

You need to minimize the size of the semantic model. The solution must meet the report requirements.

What should you do?

Options:

Filter out discontinued products while importing the Products table.

Group the Categories table by the CategorylD column.

Change the OrderlD column in the Orders table to the Text data type.

Remove the QuantityPerUnit column from the Products table.

Question 23

You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.

For each of the following statement, select Yes if the statement is true, Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Question 24

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

Options:

Change lite OrderlD column in the Orders table to the text data type.

Filter out discontinued products while importing the Product table.

Remove the QuantityPerUnit column from the Products table

Group the Categories table by the CategorylD column.

Question 25

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 26

You publish the dataset to powerbi.com.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Question 27

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

Options:

FORMAT('Date'[date], "MMM YYYY")

FORMAT('Date' [date], "M YY")

FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

FORMAT('Date' [date_id], "MMM YYYY")

Question 28

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

Options:

Apply row-level security (RLS) to the Region table based on the sales manager username.

Configure a bi-directional relationship between Region and Sales.Region.

Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Question 29

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

Options:

Select Column distribution.

Select the sales_amount column and apply a number filter.

Select Column profile, and then select the sales_amount column.

Transform the sales_amount column to replace negative values with 0.

Question 30

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

Options:

import that uses a Microsoft account

DirectQuery that uses the end-user s credentials

DirectQuery that uses a database credential

Import that uses a database credential

Question 31

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

Options:

Create a security role that has a table filter on the Sales_Manager table where

username = UserName()

Create a security role that has a table filter on the Region_Manager table where

sales_manager_id = UserPrincipalName().

Create a security role that has a table filter on the Sales_Manager table where

name = UserName().

Create a security role that has a table filter on the Sales_Manager table where

username = sales_manager_id.

Question 32

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

Options:

an additional date table named ShipDate, a one-to-many relationship from

Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from

Sales[sales_ship_date_id] to ShipDate[date_id]

an additional date table named ShipDate, a many-to-many relationship from

Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from

Sales[sales_ship_date_id] to ShipDate[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many

relationship from Sales[sales_ship_date_id] to Date[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

Question 33

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

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?

Options:

Select Keep Errors

Edit the query in the Query Errors group.

Select Replace Errors

Select Remove Errors.

Question 34

You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column.

You need to ensure that you can analyze sales by product category.

How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 35

You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns:

* WebsiteName

* URL

You need to create a report named Report1 that will contain a table visual. The solution must meet the following requirements.

* Display the website name

* Enable users to navigate to the website’s URL by selecting the website name.

What should you use?

Options:

Inline hierarchy labels

Data categories

URL icons

Conditional Formatting

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 query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number.

You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.

You need to ensure that nonnumeric values in the CustomerlD column are set to 0.

Solution: From Query Editor, select the CustomerlD column and click Remove Errors.

Does this meet the goal?

Options:

Yes

Question 37

You have a Power B1 report that contains the table visual shown in the following exhibit.

You need to modify the visual to display as shown in the following exhibit.

How should you configure the visual? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 38

You hove a folder that contains 50 JSON files.

You need to use Power 81 Desktop to make the metadata ol the files available as a single semantic model. 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.

Options:

Question 39

You need to create a visualization that compares revenue and cost over time.

Which type of visualization should you use?

Options:

stacked area chart

donut chart

line chart

waterfall chart

Question 40

You have a Power BI workspace that contains a single report named Sales.

You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visual added to the page area added automatically to the dashboard.

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.

Options:

Question 41

What is the minimum number of Power BI datasets needed to support the reports?

Options:

a single imported dataset

two imported datasets

two DirectQuery datasets

a single DirectQuery dataset

Question 42

You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

You need to create a calculated table that v/ill contain the following:

Options:

Question 43

You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:

• Date

• Fiscal year

• Fiscal Quartet

• Month Name

• Calendar Year

• Week Number

• Month Number

• Calendar Quarter

You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

Options:

DATATABLE

ADDCOLUMS

SUMMARIZE

CALCULATE

Question 44

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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload

Does this meet the goal?

Options:

Yes

Question 45

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 custom visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report

You need to recommend a solution to improve the performance of the report.

What should you recommend?

Options:

Split the visuals onto multiple pages.

Implement row-level security (RLS).

Replace the default visuals with custom visuals.

Increase the number of times that the dataset is refreshed.

Question 46

You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.

You add a sheer named Country to each page of the report.

You need to configure the report to meet the following requirements:

• When a user selects a country on the first page, the report must filter the other pages.

• The second and third pages must display only the filtered results.

Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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.Ther

NOTE Each correct selection is worth one point.

Options:

Question 47

You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.

You pin the Sales by month visual to Dashboard1.

In Report1, you change the Sales by month visual to a bar chart.

You need to ensure that bar chart displays on Dashboard1.

What should you do?

Options:

Edit the details for the dashboard tile of Dashboard1.

Select Refresh visuals for Dashboard1.

the Sales by month bar chart to Dashboard1

Refresh the dataset used by Report1 and Dashboard1.

Question 48

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.

Does this meet the goal?

Options:

Yes

Question 49

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.

You need to create a Power BI report that connects to the project management app.

Which connector should you select?

Options:

Microsoft Teams Personal Analytics

SQL Server database

Dataverse

Dataflows

Question 50

You have a Power BI report that contains four pages.

All the pages contain a slicer for a field named Country,

You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by

selections on the other pages,

What should you do?

Options:

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.

Sync the Country slicer on page 1, page 2, and page 3,

Move the Country slicer from page 2 and page 3 to page 1.

Question 51

You have the Performance analyzer results shown in the following exhibit.

Options:

Question 52

You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:

A line chart that shows the number of defective products manufactured by day.

A KPI visual that shows the current daily percentage of defective products manufactured.

You need to be notified when the daily percentage of defective products manufactured exceeds 3%.

What should you create?

Options:

a Q&A visual

a subscription

a smart narrative visual

an alert

Question 53

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.

Options:

Question 54

You are enhancing a Power BI model that has DAX calculations.

You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.

Which DAX functions should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 55

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

Options:

Key influences

Funnel chart

Q&A

Line and clustered column chart

Question 56

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.

You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

What should you recommend?

Options:

Merge tables by using Power Query.

Hide unused columns in the model.

Split the model into multiple models.

Transpose.

Question 57

You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.

What should you do?

Options:

Add a play axis.

Add a slicer for the year.

From the Analytics pane, add an Average line.

Create a DAX measure that calculates year-over-year growth.

Question 58

You are creating reports in Power BI Desktop. The model has the following tables.

There is a relationship between the tables.

You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.

You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published.

How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 59

You have a query that contains customer data in Power Query Editor as shown in the following exhibit.

Options:

Question 60

You have an Azure SQL database that contains sales transactions. The database is updated frequently.

You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.

How should you configure the data connection?

Options:

Add a SQL statement.

Set Data Connectivity mode to DirectQuery.

Set the Command timeout in minutes setting.

Set Data Connectivity mode to Import.

Question 61

You have a Microsoft SharePoint Online site that contains several document libraries.

One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.

What should you do?

Options:

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

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.

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

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

Question 62

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

First name

Last name

Email address

State/Region

Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

Open the Advanced Editor.

Select Column quality.

Enable Column profiling based on entire dataset.

Select Column distribution.

Select Column profile.

Question 63

You attempt to use power Query Editor to create a custom column and receive the error message 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.

Options:

Question 64

You have a Microsoft Power Bl dashboard.

You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.

What should you use?

Options:

Feedback

Comments

Mark as favorite

Exam Detail

Vendor: Microsoft

Certification: Microsoft Certified: Power BI Data Analyst Associate

Exam Code: PL-300

Exam Name: Microsoft Power BI Data Analyst

Last Update: Apr 30, 2025

PL-300 Question Answers

Page: 1 / 16
Total 422 questions

Get PL-300 Full Access Download PL-300 PDF

Month End Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Microsoft PL-300 Dumps Questions Answers

Microsoft Power BI Data Analyst Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation: