PL-300 Microsoft Power BI Data Analyst sample Question + Exam 2025 Practice Exam Dumps

Question # 4

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?

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

Change the data type of the Logged column to Date.

Split the Logged column by using at as the delimiter.

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

Full Access

Question # 5

You have an API that returns more than 100 columns. The following is a sample of column names.

client_notified_timestamp

client_notified_source

client_notified_sourceid

client_notified_value

client_responded_timestamp

client_responded_source

client_responded_sourceid

client_responded_value

You plan to include only a subset of the returned columns.

You need to remove any columns that have a suffix of sourceid.

How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access

Question # 6

What should you do to address the existing environment data concerns?

a calculated column that uses the following formula: ABS(Sales[sales_amount])

a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

a measure that uses the following formula: SUM(Sales[sales_amount])

a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

Full Access

Question # 7

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

Which type of visualization should you use?

stacked area chart

donut chart

line chart

waterfall chart

Full Access

Question # 8

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 load only the manufacturing reports to a table for analysis.

What should you do in Microsoft Power Bl Desktop?

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

Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the

manufacturing reports library.

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

Full Access

Question # 9

You have a Power Bl report that contains five pages.

Pages 1 to 4 are visible and page 5 is hidden.

You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.

What should you do first?

Add a blank button to page 1.

Add a bookmark navigation button to page 1.

Create a bookmark for each page.

Add a page navigation button to page 1.

Full Access

Question # 10

You have a source that contains a comumn. The column contains case sensitive date. 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?

Yes

Full Access

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?

One to one

Many to one

One to many

Many to many

Full Access

Question # 12

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

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.

Full Access

Question # 13

You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.

From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium

capacity.

You discover that the dataset refresh fails after the refresh runs out of resources.

What is a possible cause of the issue?

Query folding is not occurring.

You selected Only refresh complete periods.

The data type of the column used to partition the data changed.

A filter is missing on the report.

Full Access

Question # 14

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.

Full Access

Question # 15

You are creating a Power 81 model to analyze inventory.

You load data into three tables named Date Product, and Inventor/. The Inventor/ table relates to the Date and Product tables by using one-to-many relationships.

Inventor)' data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month

You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.

How should you complete the measure? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point

Full Access

Question # 16

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.

Full Access

Question # 17

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.

Full Access

Question # 18

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

Change the data type of Sales[region_id] to Whole Number.

In the Sales table, add a measure for sum(sales_amount).

Change the data type of sales[sales_id] to Text.

Change the data type of sales [region_id] to Decimal Number.

Full Access

Question # 19

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Full Access

Question # 20

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?

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.

Full Access

Question # 21

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

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

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

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

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

Full Access

Question # 22

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

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

Full Access

Question # 23

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

What should you create?

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]

Full Access

Question # 24

What should you create to meet the reporting requirements of the sales department?

a measure that uses a formula of SUM (Sales [sales_id])

a calculated column that use a formula of COUNTA(sales [sales_id])

a measure that uses a formula of COUNTROWS (Sales)

a calculated column that uses a formula of SUM (Sales [sales_id])

Full Access

Question # 25

You publish the semantic model 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.

Full Access

Question # 26

You need to create a visualization to meet the reporting requirements of the sales managers.

How should you create the visualization? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access

Question # 27

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

What should you do?

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.

Full Access

Question # 28

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

What should you include in the solution?

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.

Full Access

Question # 29

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?

bar chart

scatterplot

pie chart

Full Access

Question # 30

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

DirectQuery

Import

Live connection

Composite

Full Access

Question # 31

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.

Full Access

Question # 32

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.

Full Access

Question # 33

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

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.

Full Access

Question # 34

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

What should you do in Power BI Desktop?

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.

Full Access

Question # 35

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:

Full Access

Question # 36

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.

Full Access

Question # 37

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.

Full Access

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 # 38

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?

Merge queries

Append queries

Combine files

Full Access

Question # 39

You need to create the semantic model.

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

live connection

Dual

Import

DirectQuery

Full Access

Question # 40

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.

Full Access

Question # 41

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

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.

Full Access

Question # 42

You create a Power Bl dataset that contains the table shown in the following exhibit.

You need to make the table available as an organizational data type In Microsoft Excel.

How should you configure the properties of the table? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access

Question # 43

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.

From Power Query Editor, you profile the data shown in the following exhibit.

The IOT ID columns are unique to each row in query.

You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.

Solution: You change the IOT DateTime column to the Date data type.

Does this meet the goal?

Yes

Full Access

Question # 44

You are building a Power Bl report.

Users will view the report by using their mobile device.

You need to configure the report to display data based on each user s location.

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

NOTE: Each correct selection is worth one point.

For the relevant columns, set synonyms to match common geographical terms.

From Power Query Editor, detect the data types of the relevant columns.

Use the columns of the geography data type in all visuals.

Create a hierarchy for columns of the geography data type.

In Data Category, set the geographic data category for the relevant columns.

Full Access

Question # 45

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create a median line by using the Salary measure.

Does this meet the goal?

Yes

Full Access

Question # 46

You need to create a visual that compares profit across 10 product categories for a selected quarter.

What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select the BEST answer.

an area chart

a clustered bar chart

a line chart

a funnel chart

Full Access

Question # 47

You have two CSV files named Products and Categories.

The Products file contains the following columns:

ProductID

ProductName

SupplierID

CategoryID

The Categories file contains the following columns:

CategoryID

CategoryName

CategoryDescription

From Power BI Desktop, you import the files into Power Query Editor.

You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:

ProductID

ProductName

SupplierID

CategoryID

CategoryName

CategoryDescription

How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access

Question # 48

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

A user pressed F5

A new transaction was added to the data source.

A user added a comment to a tile.

The dashboard tile cache refreshed.

Full Access

Question # 49

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You publish an app to the entire organization.

Does this meet the goal?

Yes

Full Access

Question # 50

You have more than 100 published datasets.

Ten of the datasets were verified to meet your corporate quality standards.

You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets.

What should you do?

Publish the datasets in an app.

Promote the datasets.

Feature the dataset on the home page.

Certify the datasets.

Full Access

Question # 51

You plan to use Power Bl Desktop to create a bog tracking dashboard that will pull data from Analytics in Azure DevOps.

From Power Bl 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?

OData queries

Azure DevOps (Boards only)

Azure DevOps Server (Boards only)

OData feed

Full Access

Question # 52

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

SQL Server Profiler

Performance Analyzer in Power BI Desktop

Query Diagnostics in Power BI

Microsoft Edge DevTools

Full Access

Question # 53

You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

Create a horizontal line that has a fixed value of 24,000.

Add a measure to the visual that uses the following DAX expression.

Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

Add a measure to the visual that uses the following DAX expression.

Measure = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Full Access

Question # 54

You have a Power BI report named Report' and a dashboard named Dashboard'. 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 the bar chart displays on Dashboard',

What should you do?

Refresh the dataset used by Report1 and Dashboard1.

Select Refresh visuals for Dashboard1.

Edit the details for the dashboard tile Of Dashboar1.

Pin the Sales by month bar chart to Dashboard1.

Full Access

Question # 55

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: You add a WHERE clause to the SQL statement.

Does this meet the goal?

Yes

Full Access

Question # 56

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.

From Power Query Editor, you profile the data shown in the following exhibit.

The IOT ID columns are unique to each row in query.

You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.

Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.

Does this meet the goal?

Yes

Full Access

Question # 57

You create a data model in Power BI.

Report developers and users provide feedback that the data model is too complex.

The model contains the following tables.

The model has the following relationships:

*There is a one-to-one relationship between Sales_Region and Region_Manager.

*There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.

*There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.

You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.

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.

NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Full Access

Question # 58

You are profiling data by using Power Query Editor.

You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is 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.

Full Access

Quick Links

Why Us

Unlimited Packages

Site Secure

TESTED 15 Jan 2025

New Year Special Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

PL-300 Microsoft Power BI Data Analyst Question and Answers

Answer:

Explanation:

Answer:

Explanation:

Answer:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Answer:

Answer:

Answer:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Answer:

Explanation:

Answer:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Answer:

Answer:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Answer:

Explanation:

Answer:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Answer:

Explanation:

Answer:

Answer:

Answer:

Explanation:

Answer:

Answer:

Answer:

Answer:

Answer:

Answer:

Answer:

Answer:

Explanation:

Answer:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Answer:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Answer:

Explanation: