Exam PL-300: Microsoft Power BI Data Analyst — Questions and Answers

Question 1: Which DAX function returns a table with all combinations of values from multiple columns?

CONCATENATE
CROSSJOIN (Correct answer)
UNION
INTERSECT

Correct answer: CROSSJOIN

CROSSJOIN returns a table that is the Cartesian product of all specified tables, containing every combination of rows.

Question 2: What does publishing a Power BI report from Desktop to the Service do?

Exports the report as a PDF to OneDrive
Uploads the report and its dataset to a Power BI workspace (Correct answer)
Creates a live connection to the desktop file
Shares the .pbix file via email

Correct answer: Uploads the report and its dataset to a Power BI workspace

Publishing uploads the .pbix file's report and dataset to the selected Power BI workspace, making it available in the cloud.

Question 3: You create an application that must store data in accordance with the following specifications: - Save historical information from many data sources. - Add data on a recurring basis. Use a denormalized snowflake or star schema. Which database type should you employ?

Azure Table storage
graph
OLTP
OLAP (Correct answer)

Correct answer: OLAP

Online Analytical Processing (OLAP) databases are designed for complex analytical queries and reporting, often using denormalized star or snowflake schemas. They are optimized for reading large volumes of historical data from multiple sources and are typically updated periodically, making them ideal for data warehousing and business intelligence scenarios. OLTP databases are for transactional workloads with frequent updates.

Question 4: What does 'DirectQuery' mode in Power BI mean for data freshness?

Data is cached for 15 minutes before the next refresh
Queries are sent directly to the source every time a visual is interacted with, so data is always current (Correct answer)
Data is refreshed once daily on a schedule
Data must be manually pushed to refresh

Correct answer: Queries are sent directly to the source every time a visual is interacted with, so data is always current

In DirectQuery mode, Power BI sends a live query to the data source each time a user interacts with a report, ensuring the data reflects the latest state of the source.

Question 5: What does 'incremental refresh' do for a Power BI dataset?

Refreshes only a portion of data based on date ranges, rather than reloading the entire dataset (Correct answer)
Refreshes the report visuals without changing the data
Refreshes in small increments to reduce Gateway load
Adds new columns incrementally over multiple refreshes

Correct answer: Refreshes only a portion of data based on date ranges, rather than reloading the entire dataset

Incremental refresh loads only new and updated data for defined date ranges, dramatically reducing refresh times and resource usage for large datasets.

Question 6: In Power BI Service, what is a 'workspace'?

A local storage location in Power BI Desktop
An individual user's personal dashboard collection
A Power BI Premium capacity region
A collaborative environment where teams can create, share, and manage Power BI content (Correct answer)

Correct answer: A collaborative environment where teams can create, share, and manage Power BI content

Workspaces in Power BI Service are collaborative containers where teams can store, manage, and share reports, dashboards, and datasets.

Question 7: How often can a Power BI dataset be scheduled to refresh with a Pro license?

Once per day
Up to 48 times per day
Up to 8 times per day (Correct answer)
Unlimited refreshes

Correct answer: Up to 8 times per day

With a Power BI Pro license, you can schedule up to 8 daily refreshes per dataset; Premium capacities allow up to 48 refreshes per day.

Question 8: Which Power BI visual type always shows category proportions that sum to 100% by normalizing all bars?

Ribbon chart
Clustered bar chart
100% stacked bar chart (Correct answer)
Waterfall chart

Correct answer: 100% stacked bar chart

The 100% stacked bar chart normalizes all values so each bar represents 100%, making relative proportions directly comparable across groups.

Question 9: Microsoft Power Platform is employed by a business. The business must read text from photographs that have been uploaded. You must choose the connector to use. Which connector should you utilize?

Microsoft Teams
Microsoft Dataverse
Azure Cognitive Services (Correct answer)
Azure Blob storage

Correct answer: Azure Cognitive Services

To read text from uploaded photographs, the 'Azure Cognitive Services' connector should be utilized. Azure Cognitive Services provides powerful AI capabilities, including Optical Character Recognition (OCR), which can extract text from images. This connector allows Power Platform components to leverage these advanced AI features for text extraction and analysis.

Question 10: What is a 'shared dataset' in the Power BI service?

A dataset shared only within My Workspace
A read-only snapshot exported from another system
A dataset published to the service that multiple reports across different workspaces can connect to and reuse (Correct answer)
A dataset hosted on a shared file server

Correct answer: A dataset published to the service that multiple reports across different workspaces can connect to and reuse

Shared datasets allow multiple reports to connect to a single published dataset, ensuring consistent metrics and reducing duplication across teams.

Question 11: Dynamics 365 Customer Engagement apps are employed by a corporation. The information for an account, as well as the associated leads and opportunities, must be easily found. Which option should you select?

Advanced Find
Categorized Search (Correct answer)
Quick Find
Advanced Filter

Correct answer: Categorized Search

'Categorized Search' (also known as Relevance Search) in Dynamics 365 Customer Engagement apps allows users to quickly find records across multiple entities simultaneously. It provides a comprehensive search experience, returning results grouped by record type, which is ideal for efficiently finding an account and its associated leads and opportunities.

Question 12: What is the primary role of Dataverse in the Power Platform?

To provide a secure, scalable data storage and management service for apps (Correct answer)
To deploy chatbots created in Power Virtual Agents
To manage user authentication for Power Apps portals
To host Power BI reports in the cloud

Correct answer: To provide a secure, scalable data storage and management service for apps

Dataverse provides a low-code data platform with built-in security, business logic, and storage that underpins model-driven apps and many Power Platform solutions.

Question 13: What is the main advantage of using DirectQuery mode instead of Import mode in Power BI?

Supports all DAX functions without limitation
Reduces load on the source database
Data is always current because queries go directly to the source (Correct answer)
Faster query performance due to in-memory storage

Correct answer: Data is always current because queries go directly to the source

DirectQuery sends queries to the source database in real time, ensuring data is always up-to-date without requiring scheduled refreshes.

Question 14: In Power BI, what is the key difference between cross-highlighting and cross-filtering between visuals?

Cross-highlighting applies only to bar charts; cross-filtering applies to all visual types
Cross-highlighting removes unrelated data; cross-filtering keeps all data but dims unrelated items
Cross-filtering removes unrelated data from other visuals; cross-highlighting keeps all data visible but dims unrelated items (Correct answer)
They perform identical operations but use different syntax

Correct answer: Cross-filtering removes unrelated data from other visuals; cross-highlighting keeps all data visible but dims unrelated items

Cross-filtering removes non-selected data from other visuals entirely, while cross-highlighting keeps all data visible but dims items not related to the selection.

Question 15: What is a dataflow in Power BI?

A reusable data preparation process stored in the Power BI service using Power Query (Correct answer)
A connector for external APIs
A scheduled email report
A live streaming dataset from IoT devices

Correct answer: A reusable data preparation process stored in the Power BI service using Power Query

Dataflows are cloud-based Power Query transformations stored in the Power BI service, enabling reusable, centralized data prep across multiple datasets.

Question 16: Think about dividing your query into two pieces. Which options from the list below would you utilize in Power BI?

Split Query
Format Query
Mark Query
Extract previous (Correct answer)

Correct answer: Extract previous

In Power Query Editor, the 'Extract previous' option (specifically 'Extract Previous' when right-clicking a step) allows you to refactor a query by creating a new query from a selected step and all preceding steps. This effectively divides the original query's logic into two parts: the extracted portion becomes a new query, and the original query then references this new query, enabling modularity and reuse of common transformation steps.

Question 17: Which Dynamics 365 app provides functionality for managing recruiting, onboarding, benefits, and leave management?

Dynamics 365 Human Resources (Correct answer)
Dynamics 365 Finance
Dynamics 365 Commerce
Dynamics 365 Project Operations

Correct answer: Dynamics 365 Human Resources

Dynamics 365 Human Resources covers the full employee lifecycle including recruiting, onboarding, benefits administration, and leave and absence management.

Question 18: What is a Power BI App?

A packaged collection of dashboards and reports distributed to a broad audience from a workspace (Correct answer)
A mobile application for viewing reports
A Python or R script embedded in a report
The Power BI Desktop application

Correct answer: A packaged collection of dashboards and reports distributed to a broad audience from a workspace

Power BI Apps bundle workspace content (dashboards, reports) into a single polished package that can be distributed to large audiences with controlled access.

Question 19: You launch Power Query Editor and open a query. The percentage of empty values in each column must be rapidly determined. Which Data Preview selection is best?

Show whitespace
Column profile
Column distribution
Column quality (Correct answer)

Correct answer: Column quality

Column quality in Power Query Editor provides a quick visual summary of each column's data, including the percentage of valid, error, and empty values. This feature is designed for rapid assessment of data completeness and quality directly within the data preview. By enabling it, you can instantly see the percentage of empty cells for every column.

Question 20: What is a Power BI workspace?

A premium feature only available in Power BI Premium
A collaborative environment in the Power BI service for sharing datasets, reports, and dashboards (Correct answer)
A local folder for storing .pbix files
A virtual machine for running Power BI Gateway

Correct answer: A collaborative environment in the Power BI service for sharing datasets, reports, and dashboards

Workspaces are containers in the Power BI service where teams collaborate on datasets, reports, and dashboards with shared access.

Question 21: What is the purpose of 'Sensitivity Labels' in Power BI?

To classify and protect data by applying Microsoft Information Protection labels to datasets and reports (Correct answer)
To mark reports as confidential from external sharing only
To tag reports by topic for easier search
To set report visual themes

Correct answer: To classify and protect data by applying Microsoft Information Protection labels to datasets and reports

Sensitivity labels from Microsoft Information Protection can be applied to Power BI content to classify data and enforce protection policies like encryption.

Question 22: Which Power Query step type is responsible for combining rows from two tables with identical column structures?

Union transform
Join queries
Append queries (Correct answer)
Merge queries

Correct answer: Append queries

Append queries stacks rows from two or more tables with the same columns, equivalent to a SQL UNION ALL operation.

Question 23: What does the EARLIER function do in DAX?

Filters to earlier time periods
References an outer row context within a nested row context iteration (Correct answer)
Returns the first value in a sorted column
Returns the earlier of two dates

Correct answer: References an outer row context within a nested row context iteration

EARLIER accesses the value of a column from an outer row context when working in nested iterations, commonly used in calculated columns with FILTER.

Question 24: What is the purpose of the ALLEXCEPT function in DAX?

Returns all rows except blank values
Applies filters to all tables except the one specified
Removes all filters from a table except those applied to specified columns (Correct answer)
Removes all filters from the model except calculated columns

Correct answer: Removes all filters from a table except those applied to specified columns

ALLEXCEPT removes all context filters from a table except for filters on the columns you explicitly list, useful for ratio calculations that need to preserve certain filter context.

Question 25: In Power BI, what is the purpose of a 'gateway'?

To share dashboards with external users
To publish reports to the web
To enable scheduled refresh of on-premises data sources (Correct answer)
To connect Power BI to Azure Active Directory

Correct answer: To enable scheduled refresh of on-premises data sources

A Power BI gateway acts as a bridge that enables secure data transfer between on-premises data sources and the Power BI service for scheduled refreshes.

Question 26: What does the Selection Pane in Power BI allow report developers to manage?

Which report pages are included when the report is published
Which row-level security roles apply to the current report view
Which data fields from the model are available to use in visuals
The visibility and layer order (z-order) of visuals on a report page (Correct answer)

Correct answer: The visibility and layer order (z-order) of visuals on a report page

The Selection Pane provides a list of all visuals on the page and allows developers to show or hide individual visuals and adjust their layering (z-order).

Question 27: What happens when you disable 'Include in Report Refresh' for a query in Power Query?

The query output is cached permanently
The query is excluded from scheduled and manual dataset refreshes (Correct answer)
The query runs only during initial load
The query is deleted from the model

Correct answer: The query is excluded from scheduled and manual dataset refreshes

Disabling 'Include in Report Refresh' prevents a query from running during refresh cycles, which is useful for static reference tables that never change.

Question 28: What is the role of 'Entitlements' in Dynamics 365 Customer Service?

Granting users access to specific security roles
Setting agent response time targets
Configuring product warranty replacement policies
Defining the support terms a customer is entitled to, such as number of cases or support hours (Correct answer)

Correct answer: Defining the support terms a customer is entitled to, such as number of cases or support hours

Entitlements in Dynamics 365 Customer Service define the support coverage a customer has purchased, including limits on case counts, channels, or support hours.

Question 29: In Azure, what does 'geo-redundant storage (GRS)' provide that 'locally redundant storage (LRS)' does not?

Replication of data to a secondary region hundreds of miles away (Correct answer)
Automatic indexing of blob metadata
Encryption of data in transit between availability zones
Higher IOPS performance for block storage

Correct answer: Replication of data to a secondary region hundreds of miles away

GRS replicates data asynchronously to a paired secondary Azure region, protecting against a full regional outage, whereas LRS only replicates within a single data center.

Question 30: What is the role of a Power BI Gateway in an enterprise environment?

It caches report pages for faster loading in the browser
It enforces row-level security for published datasets
It serves as a bridge to allow Power BI Service to access on-premises or private network data sources (Correct answer)
It compresses data before loading it into Power BI Desktop

Correct answer: It serves as a bridge to allow Power BI Service to access on-premises or private network data sources

The Power BI On-premises Data Gateway enables secure data transfer between Power BI Service in the cloud and data sources inside a corporate network.

Question 31: What language is used for transformations in Power Query?

SQL
Python
DAX
M (Power Query Formula Language) (Correct answer)

Correct answer: M (Power Query Formula Language)

Power Query uses the M language (Power Query Formula Language) to define all data transformation steps.

Question 32: Which Power Platform component allows you to create automated workflows that connect different apps and services without writing code?

Power Apps
Power BI
Power Virtual Agents
Power Automate (Correct answer)

Correct answer: Power Automate

Power Automate is designed to automate workflows and business processes across apps and services using a visual, no-code interface.

Question 33: What Power BI license is required to share content with colleagues in your organization using the Power BI service?

Power BI Free
Microsoft 365 Basic
Power BI Desktop only
Power BI Pro or Premium Per User (PPU) (Correct answer)

Correct answer: Power BI Pro or Premium Per User (PPU)

Power BI Pro or Premium Per User (PPU) is required to share reports and dashboards with others and collaborate in workspaces.

Question 34: Which Dynamics 365 app is best suited for an organization that needs to manage procurement, vendor invoices, and accounts payable?

Dynamics 365 Human Resources
Dynamics 365 Finance (Correct answer)
Dynamics 365 Customer Insights
Dynamics 365 Marketing

Correct answer: Dynamics 365 Finance

Dynamics 365 Finance includes full accounts payable, procurement, and vendor invoice management capabilities as part of its financial management suite.

Question 35: You set up a canvas app to monitor and purchase office supplies. Users of the app can order a variety of stationery products. Every time a user reopens the app, the items they previously selected must be reset. User choices must be stored. Which one should you select?

Variable
SharePoint
Dataverse
Collection (Correct answer)

Correct answer: Collection

To store user selections temporarily within a canvas app session, where the data resets each time the app is reopened, a 'Collection' is the appropriate choice. Collections are in-memory tables that allow you to store and manipulate data locally within the app, making them ideal for managing temporary selections or shopping cart items that don't need persistent storage.

Question 36: What is the Decomposition Tree visual in Power BI primarily designed for?

Showing how data flows through Power Query transformation steps
Visualizing machine learning decision tree model outputs
Breaking down a metric across multiple dimensions interactively to identify contributors (Correct answer)
Displaying a file or folder directory structure visually

Correct answer: Breaking down a metric across multiple dimensions interactively to identify contributors

The Decomposition Tree visual lets users interactively drill into a metric across multiple dimensions to discover which factors drive that value up or down.

Question 37: Which Dynamics 365 feature allows organizations to configure automated processes that run when specific conditions are met, without writing code?

Power Automate flows
Azure Logic Apps
Business rules (Correct answer)
SSRS reports

Correct answer: Business rules

Business rules in Dynamics 365 allow no-code configuration of automated logic that applies when defined field conditions are met on a form.

Question 38: What is a Power Query function?

A DAX function called from Power Query
A reusable M query that accepts parameters and returns a value or table (Correct answer)
A built-in connector for external APIs
A SQL stored procedure called during refresh

Correct answer: A reusable M query that accepts parameters and returns a value or table

Power Query functions are reusable M queries parameterized to accept inputs, enabling you to apply the same transformation logic to multiple data sources.

Question 39: What does the 'Endorsement' feature in Power BI do?

Encrypts a dataset with a customer-managed key
Marks datasets, dataflows, or reports as Promoted or Certified to signal quality and trustworthiness (Correct answer)
Locks a dataset to prevent changes
Approves a report for external sharing

Correct answer: Marks datasets, dataflows, or reports as Promoted or Certified to signal quality and trustworthiness

Endorsement (Promoted or Certified) labels help consumers identify trusted, high-quality content in the Power BI service.

Question 40: How can you reference a parameter in a Power Query M expression?

Using @ symbol prefix
By importing it with a SQL variable
By typing the parameter name directly as a value in the expression (Correct answer)
Using the #{} syntax

Correct answer: By typing the parameter name directly as a value in the expression

Power Query parameters are referenced by their name directly in M expressions, and they appear as named values in the query context.

Exam PL-300: Microsoft Power BI Data Analyst

This exam certifies data professionals who design and build scalable data models, clean and transform data, and enable advanced analytic capabilities using Microsoft Power BI.

Questions

120 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds