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

Question 1: What is the primary function of Dynamics 365 Commerce?

Delivering unified omni-channel retail experiences across physical and digital channels (Correct answer)
Tracking field service work orders
Managing project budgets and timesheets
Managing B2B procurement and vendor invoicing

Correct answer: Delivering unified omni-channel retail experiences across physical and digital channels

Dynamics 365 Commerce provides a unified retail platform supporting e-commerce, point of sale, back-office operations, and call center channels.

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

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

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 3: Which Power Platform tool allows organizations to monitor adoption, usage, and governance of Power Apps and Power Automate across their tenant?

Center of Excellence (CoE) Starter Kit (Correct answer)
Power BI Admin Portal
Dataverse Analytics Dashboard
Microsoft 365 Admin Center

Correct answer: Center of Excellence (CoE) Starter Kit

The CoE Starter Kit is a collection of templates and tools that help organizations establish governance, visibility, and best practices for Power Platform adoption.

Question 4: Which Azure storage option is most appropriate for storing billions of key-value pairs with very low latency and no complex query requirements?

Azure Cosmos DB for NoSQL
Azure SQL Database
Azure Table Storage (Correct answer)
Azure Blob Storage

Correct answer: Azure Table Storage

Azure Table Storage is a simple, cost-effective NoSQL key-value store designed for storing massive amounts of structured, non-relational data with fast key-based lookups.

Question 5: The data from Azure Analysis Services cubes can be queried using which of the subsequent types of explanations? (Choose two correct answers)

PL/SQL
Transact-SQL (T-SQL)
Multidimensional Expressions (MDX) (Correct answer)
Data Analysis Expressions (DAX) (Correct answer)

Correct answer: Multidimensional Expressions (MDX)

Azure Analysis Services (AAS) supports two primary query languages for interacting with its analytical models. Multidimensional Expressions (MDX) is the traditional language used for querying multidimensional cubes, while Data Analysis Expressions (DAX) is used for querying tabular models. Both are powerful functional languages specifically designed for data analysis and are essential for extracting insights and performing calculations on data within AAS cubes.

Question 6: Which Azure service provides a fully managed, scalable Apache Kafka service?

Azure Event Hubs with Kafka protocol support (Correct answer)
Azure Queue Storage
Azure Service Bus
Azure Logic Apps

Correct answer: Azure Event Hubs with Kafka protocol support

Azure Event Hubs supports the Apache Kafka protocol, allowing existing Kafka applications to connect without changing client code.

Question 7: In Azure SQL Database, what is the purpose of 'elastic pools'?

Replicating a database across multiple Azure regions
Partitioning a large table across multiple storage files
Sharing a fixed set of compute resources across multiple databases to optimize cost (Correct answer)
Automatically scaling a single database's CPU during peak load

Correct answer: Sharing a fixed set of compute resources across multiple databases to optimize cost

Elastic pools allow multiple Azure SQL databases to share a pool of eDTUs or vCores, which is cost-effective when databases have unpredictable or varying usage patterns.

Question 8: The creation of a Power BI dashboard is required. What instrument should you use?

Power Query Editor
The Power BI mobile app
The Power BI service (Correct answer)
Power BI Desktop

Correct answer: The Power BI service

Power BI dashboards are created and managed exclusively within the Power BI service (app.powerbi.com). While reports are built in Power BI Desktop, visuals from these published reports are then 'pinned' to a dashboard in the Power BI service. Dashboards provide a consolidated, at-a-glance view of key metrics from multiple reports and datasets.

Question 9: Which security concept in Dynamics 365 Dataverse controls which records a user can see based on their position in the organizational hierarchy?

Field-level security
Business unit hierarchy (Correct answer)
Sharing rules
Role-based access control

Correct answer: Business unit hierarchy

The business unit hierarchy in Dataverse controls record-level access, allowing users to see records owned by themselves, their business unit, or parent units based on their access level setting.

Question 10: You have a sales transaction database stored in Azure SQL. The database is regularly updated. To find phony transactions, you must create reports from the data. After an update, the data must be accessible within five minutes. How should the data connection be set up?

Set the Command timeout in minutes setting.
Add a SQL statement.
Set Data Connectivity mode to Import.
Set Data Connectivity mode to DirectQuery. (Correct answer)

Correct answer: Set Data Connectivity mode to DirectQuery.

For data that is regularly updated and needs to be accessible within minutes (near real-time), the DirectQuery connectivity mode is essential. DirectQuery does not import data into the Power BI model but instead queries the data source directly each time a visual is interacted with, ensuring users always see the latest information without waiting for data refreshes. This provides the most up-to-date view.

Question 11: In Power BI, which DAX function returns the value of the last non-blank row in a column?

LASTDATE
LASTNONBLANK (Correct answer)
CLOSINGBALANCEYEAR
MAXX

Correct answer: LASTNONBLANK

LASTNONBLANK iterates a table and returns the last value where the expression is not blank.

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

Up to 8 times per day (Correct answer)
Once per day
Up to 48 times per day
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 13: A company has a sales management model-driven app. The contact job titles that are presented in the account form's list of contacts must be included. What has to be changed?

app sitemap
account form
contact view (Correct answer)
account view
contact form

Correct answer: contact view

To include contact job titles in the list of contacts displayed within an account form, you need to modify the 'contact view.' Views define which columns (fields) are visible when a list of records is presented. By editing the contact view associated with the subgrid on the account form, you can add the job title column to be displayed.

Question 14: Which Azure service acts as the central metadata and governance hub for tracking data lineage and classifying sensitive data assets across an organization?

Azure Data Factory
Azure Policy
Microsoft Purview (Correct answer)
Azure Monitor

Correct answer: Microsoft Purview

Microsoft Purview provides a unified data governance solution including data cataloging, classification, lineage tracking, and sensitivity labeling.

Question 15: You want to learn as soon as possible the percentage of empty cells or values in each column for the query that was opened in Power Query Editor. Which data preview option from the list below would you choose?

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

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 16: What happens to a Power BI report when the underlying dataset schema changes and a field used in a visual is removed?

Power BI reverts to the last saved schema
The report fails to open entirely
Power BI automatically replaces the missing field with a similar one
The visual shows an error indicating a missing field (Correct answer)

Correct answer: The visual shows an error indicating a missing field

When a field referenced by a visual is removed from the dataset, that visual displays an error icon indicating the missing field, while other visuals continue to function normally.

Question 17: What is the difference between SUMX and SUM in DAX?

SUMX iterates a table row by row using an expression; SUM aggregates a single column directly (Correct answer)
SUM iterates a table; SUMX operates on a single column
SUMX is faster than SUM
They return different data types

Correct answer: SUMX iterates a table row by row using an expression; SUM aggregates a single column directly

SUMX iterates each row of a table, evaluates an expression per row, and sums the results, while SUM simply totals a column's values.

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

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

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 19: Which Dynamics 365 feature allows organizations to configure automated processes that run when specific conditions are met, without writing code?

Power Automate flows
Business rules (Correct answer)
Azure Logic Apps
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 20: A business has an app that uses models. All users must be given access to the app's data. What should you do?

Create a new personal view.
Create a new public view. (Correct answer)
Create a new model-driven app.
Create a new table.

Correct answer: Create a new public view.

To give all users access to the data presented in a model-driven app, you should 'Create a new public view.' Public views define how records are displayed (which columns, filters, and sort order) and are accessible to everyone with appropriate security roles. This ensures consistent data presentation across the organization.

Question 21: What is a Power BI workspace?

A local folder for storing .pbix files
A virtual machine for running Power BI Gateway
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)

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 22: What does the 'Mark as Date Table' option do in Power BI?

Automatically creates a date hierarchy
Enables date filtering in slicers
Imports a calendar from SharePoint
Tells Power BI to use the table's date column for built-in time intelligence functions (Correct answer)

Correct answer: Tells Power BI to use the table's date column for built-in time intelligence functions

Marking a table as a Date Table disables auto date/time tables and tells Power BI to use the specified date column for time intelligence calculations.

Question 23: Which Power BI Service feature enables analysts to subscribe colleagues to a report and send email snapshots on a schedule?

Export to PDF
Usage Metrics
Data Alerts
Email Subscriptions (Correct answer)

Correct answer: Email Subscriptions

Email Subscriptions in Power BI Service allow users to schedule and send report or dashboard snapshots to themselves and others automatically.

Question 24: What is the purpose of a Power BI Gateway?

To embed reports in external websites
To export reports to PDF
To manage user licenses
To enable on-premises data sources to connect to the Power BI service for refresh (Correct answer)

Correct answer: To enable on-premises data sources to connect to the Power BI service for refresh

The On-premises Data Gateway acts as a bridge allowing the Power BI service to securely refresh data from on-premises sources like SQL Server.

Question 25: What is the purpose of the CALCULATE() function in DAX when used without any filter arguments?

It returns an error because filter arguments are required
It calculates across all rows ignoring slicers
It evaluates an expression in a modified filter context, preserving the existing context (Correct answer)
It removes all filters from the model

Correct answer: It evaluates an expression in a modified filter context, preserving the existing context

CALCULATE() with no additional filter arguments still transitions from row context to filter context, which is useful inside iterators.

Question 26: What is a Power BI deployment pipeline used for?

Managing the lifecycle of content across development, test, and production stages (Correct answer)
Deploying Power BI Gateway across multiple servers
Automating dataset refresh schedules
Deploying Azure data infrastructure

Correct answer: Managing the lifecycle of content across development, test, and production stages

Deployment pipelines provide a structured ALM (Application Lifecycle Management) workflow to promote Power BI content through Dev, Test, and Production stages.

Question 27: Which Power BI feature allows you to group related tables and measures into logical sections in the model?

Bookmarks
Perspectives
Hierarchies
Display folders (Correct answer)

Correct answer: Display folders

Display folders let you organize fields and measures into folders in the Fields pane, improving model usability for report authors.

Question 28: 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
Collection (Correct answer)
Dataverse

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 29: 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 Pro or Premium Per User (PPU) (Correct answer)
Power BI Desktop only

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 30: In Microsoft Power BI, what is a 'measure' in DAX?

A calculated aggregation formula evaluated at query time based on filter context (Correct answer)
A scheduled data refresh configuration
A column imported from a source table
A static lookup table used for slicers

Correct answer: A calculated aggregation formula evaluated at query time based on filter context

A DAX measure is a formula that performs an aggregation (like SUM or AVERAGE) and is calculated dynamically based on the current filter context in a report.

Question 31: A report has a slicer for 'Year' and a bar chart. You want the chart to ignore the slicer filter. What should you configure?

Add a visual-level filter to the chart
Delete the slicer and use a page filter instead
Edit interactions and set the slicer to have no filter on the chart (Correct answer)
Use CALCULATE to override the slicer context

Correct answer: Edit interactions and set the slicer to have no filter on the chart

In Power BI, you can use Edit Interactions to control how visuals interact, including setting a slicer to have no filter effect on specific visuals.

Question 32: What is a Power BI App?

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

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 33: What does publishing a Power BI report from Desktop to the Service do?

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

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 34: You have a CSV file with user complaints in it. The file has a column called Logged in it. Each complaint's log entry includes the date and time that it happened. The information in Logged is formatted as follows: 2018-12-31 08:59. You must be able to use an internal date hierarchy and the logged date to assess the complaints. What ought you to do?

Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
Change the data type of the Logged column to Date.
Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date. (Correct answer)

Correct answer: Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

To extract the date part from a datetime string like '2018-12-31 08:59' and enable an internal date hierarchy, 'Column by Example' is an efficient Power Query feature. By providing an example like '2018-12-31', Power Query intelligently infers the transformation to extract the date, and then setting the data type to Date ensures it's correctly recognized for date hierarchy analysis.

Question 35: 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 set report visual themes
To mark reports as confidential from external sharing only
To tag reports by topic for easier search

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 36: Which DAX function in Power BI returns the total sales for all rows regardless of filters applied in the report?

RELATED
SUMX
ALL (Correct answer)
CALCULATE

Correct answer: ALL

The ALL function removes all filters from a specified table or column, enabling measures to calculate values regardless of current report context.

Question 37: Which DAX function is used to iterate over all rows of a table and return a single aggregated value?

RELATED
FILTER
ALLSELECTED
SUMX (Correct answer)

Correct answer: SUMX

SUMX (and other 'X' functions like AVERAGEX, MAXX) iterates each row of a table, evaluates an expression per row, then aggregates the results.

Question 38: In Dynamics 365 Project Operations, what does the Work Breakdown Structure (WBS) define?

The approval workflow for project expenses
The hierarchical decomposition of project tasks and resource assignments (Correct answer)
The billing milestones for a project contract
The organizational chart of project stakeholders

Correct answer: The hierarchical decomposition of project tasks and resource assignments

The Work Breakdown Structure in Project Operations defines the hierarchical list of tasks, durations, dependencies, and resource assignments needed to complete the project.

Question 39: Which type of cloud service gives you the most control over the equipment used to run applications?

Infrastructure as a service (IaaS) (Correct answer)
Platform as a service (PaaS)
Software as a service (SaaS)

Correct answer: Infrastructure as a service (IaaS)

Infrastructure as a Service (IaaS) provides the highest level of control over the underlying computing infrastructure compared to Platform as a Service (PaaS) or Software as a Service (SaaS). With IaaS, users manage virtual machines, operating systems, applications, and network configurations, giving them extensive control over the environment where their applications run.

Question 40: In Power BI Service, what is the function of a 'dataflow'?

Moves dashboards between workspaces
Manages gateway connections for on-premises data
Provides reusable, cloud-based ETL transformations stored as entities (Correct answer)
Schedules report export to PDF

Correct answer: Provides reusable, cloud-based ETL transformations stored as entities

Dataflows are self-service data preparation tools in Power BI Service that create reusable Power Query transformations stored as Common Data Model entities.

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