Microsoft Power BI Data Analyst (PL-300) — Questions and Answers

Question 1: When connecting Power BI to an Excel file, which structural elements can be loaded as individual tables?

Excel Tables, named ranges, and entire worksheets (Correct answer)
Only named ranges
Only Excel Tables (ListObjects)
Only entire worksheets

Correct answer: Excel Tables, named ranges, and entire worksheets

Power BI can load Excel Tables, named ranges, and entire worksheets as separate tables, giving flexibility in how Excel data is structured for analysis.

Question 2: What is 'filter context' in DAX?

The color filter applied to a visual
The WHERE clause written in Power Query
The set of active filters from slicers, rows, columns, and report filters that affect a DAX calculation (Correct answer)
The row limit applied to a table visual

Correct answer: The set of active filters from slicers, rows, columns, and report filters that affect a DAX calculation

Filter context in DAX is the combination of all active filters — from slicers, page filters, visual filters, and row/column headers — that constrain what data a measure evaluates.

Question 3: What does the 'Drill Through' feature in Power BI reports allow?

Drilling down into nested DAX calculations
Navigating from a summary visual to a detailed report page filtered to the selected data point (Correct answer)
Drilling into the underlying SQL query of a visual
Expanding a hierarchy within a single visual

Correct answer: Navigating from a summary visual to a detailed report page filtered to the selected data point

Drill Through lets users right-click a data point in a visual and navigate to a dedicated detail page that is automatically filtered to that specific context.

Question 4: Which feature lets users ask questions in natural language to generate visuals?

Q&A (Correct answer)
Bookmarks
Quick Insights
Sync slicers

Correct answer: Q&A

The Q&A feature interprets natural-language questions and produces visuals automatically.

Question 5: What is 'Cross-report Drill Through' in Power BI?

Comparing data between two reports side by side
Drilling from a Power BI report into an Excel spreadsheet
Drilling from Power BI Service into Power BI Desktop
Navigating from a visual in one report to a detail page in a different report while carrying filter context (Correct answer)

Correct answer: Navigating from a visual in one report to a detail page in a different report while carrying filter context

Cross-report Drill Through allows users to navigate from a data point in one report directly to a detail page in another report, passing the filter context across reports.

Question 6: What visual is best for showing a part-to-whole relationship of a single category?

Funnel for trends
Scatter chart
Pie or donut chart (Correct answer)
Line chart

Correct answer: Pie or donut chart

Pie and donut charts display how categories contribute to a whole.

Question 7: What is 'Bring Your Own Key (BYOK)' in Power BI Premium?

Using your own SSL certificates for embedded Power BI
A feature allowing users to use their own API keys for connectors
A method for bringing existing Power BI reports into Premium workspaces
A security feature enabling organizations to use their own Azure Key Vault encryption keys to encrypt Power BI data at rest (Correct answer)

Correct answer: A security feature enabling organizations to use their own Azure Key Vault encryption keys to encrypt Power BI data at rest

BYOK (Bring Your Own Key) lets organizations use their own Azure Key Vault encryption keys to control encryption of their Power BI data at rest in Premium, providing stronger data sovereignty.

Question 8: What is a 'Waterfall chart' best used for in Power BI?

Showing cumulative totals over time
Displaying hierarchical data as nested rectangles
Visualizing how positive and negative values contribute to a running total (Correct answer)
Comparing parts of a whole across categories

Correct answer: Visualizing how positive and negative values contribute to a running total

A Waterfall chart shows how a starting value is affected by a series of positive and negative incremental values to arrive at a final value.

Question 9: What does the DAX time intelligence function TOTALYTD() calculate?

The total for the current year only, ignoring slicers
The cumulative total from the start of the year to the current date in context (Correct answer)
The total for the last 12 months
The year-over-year growth percentage

Correct answer: The cumulative total from the start of the year to the current date in context

TOTALYTD() calculates the cumulative total of an expression from the beginning of the current year through the last date in the current filter context.

Question 10: Which of the following best describes a 'Push dataset' in Power BI?

A dataset that automatically exports data to external systems
A dataset that receives data sent programmatically via the Power BI REST API for real-time updates (Correct answer)
A dataset published from Power BI Desktop to the Power BI Service
A dataset pushed from Power BI Service to a SharePoint document library

Correct answer: A dataset that receives data sent programmatically via the Power BI REST API for real-time updates

A Push dataset accepts data sent via the Power BI REST API, enabling real-time ingestion that immediately updates pinned dashboard tiles without a scheduled refresh.

Question 11: What is the purpose of a 'Slicer' visual in Power BI?

To slice a dataset into smaller datasets
To provide an on-canvas filter that users can interact with to filter other visuals on the page (Correct answer)
To display trend data over time
To partition report pages

Correct answer: To provide an on-canvas filter that users can interact with to filter other visuals on the page

A Slicer is an interactive filter visual placed on the report canvas that allows users to click or select values to filter all other visuals on the page.

Question 12: What is the fundamental difference between Import mode and DirectQuery mode in Power BI?

Import requires a gateway; DirectQuery never requires one
Import caches data in Power BI's in-memory engine; DirectQuery queries the source at render time (Correct answer)
Import supports all DAX functions; DirectQuery supports none
Import is for cloud sources only; DirectQuery is for on-premises sources only

Correct answer: Import caches data in Power BI's in-memory engine; DirectQuery queries the source at render time

Import mode loads and compresses data into Power BI's in-memory VertiPaq engine, while DirectQuery forwards each visual's query to the source system in real time.

Question 13: Power Bl portable application is accessible for all these with the exception of—

Windows Phone
IOS
BlackBerry (Correct answer)
Android

Correct answer: BlackBerry

The Power BI mobile application is widely available for major mobile operating systems, including iOS (Apple), Android, and Windows Phone. However, it is not available for BlackBerry devices, reflecting BlackBerry's significantly smaller market share and app ecosystem compared to the other platforms.

Question 14: What does the DAX function CALCULATE() do?

Returns a value from a related table
Performs mathematical calculations on columns
Counts rows in a table
Evaluates an expression in a modified filter context (Correct answer)

Correct answer: Evaluates an expression in a modified filter context

CALCULATE() evaluates a DAX expression after applying the specified filter modifications to the filter context.

Question 15: Which gateway type is required to support scheduled refresh from an on-premises SQL Server in a shared Power BI Service workspace?

No gateway is required
Standard (Enterprise) On-premises Data Gateway (Correct answer)
VNet Data Gateway
Personal gateway

Correct answer: Standard (Enterprise) On-premises Data Gateway

The Standard (Enterprise) On-premises Data Gateway is required for shared workspaces to refresh on-premises SQL Server data; the Personal gateway cannot be shared across an organization.

Question 16: What is the 'Microsoft Purview Integration' with Power BI used for?

Managing Power BI license purview across the tenant
Purging unused datasets from Power BI
Purifying data during ETL processes
Cataloging Power BI datasets and lineage in Microsoft Purview for enterprise data governance and discoverability (Correct answer)

Correct answer: Cataloging Power BI datasets and lineage in Microsoft Purview for enterprise data governance and discoverability

Microsoft Purview integration scans Power BI and registers datasets, reports, and data lineage in the Purview Data Catalog, enabling organization-wide data governance.

Question 17: What type of security in Power BI restricts access to specific columns in a dataset?

Row-Level Security (RLS)
Field-Level Security (FLS)
Object-Level Security (OLS) (Correct answer)
Column-Level Security (CLS)

Correct answer: Object-Level Security (OLS)

Object-Level Security (OLS) in Power BI allows you to restrict access to specific tables or columns so that unauthorized users cannot see those fields even in the report or data model.

Question 18: What does ALL() do when used inside CALCULATE()?

Removes filters from the specified table or columns (Correct answer)
Applies all slicers to the calculation
Adds all rows to the calculation
Returns all unique values in a column

Correct answer: Removes filters from the specified table or columns

ALL() removes any existing filters on the specified table or columns, allowing the measure to calculate across all data regardless of slicers.

Question 19: What is 'Scheduled Refresh' in Power BI Service?

A nightly backup of all .pbix files
A feature that refreshes the browser tab automatically
An automated data refresh of an imported dataset at configured times without manual intervention (Correct answer)
A real-time streaming refresh for DirectQuery datasets

Correct answer: An automated data refresh of an imported dataset at configured times without manual intervention

Scheduled Refresh automatically updates an imported dataset's data at configured times (up to 8 times/day on Pro, 48 times/day on Premium) by re-running the data load pipeline.

Question 20: What is the 'Key Influencers' visual in Power BI used for?

A visual that ranks the top contributors by sales value
Showing KPI metrics for sales influencers
Displaying social media influencer data
Analyzing and explaining which factors (fields) statistically drive a specific metric up or down (Correct answer)

Correct answer: Analyzing and explaining which factors (fields) statistically drive a specific metric up or down

The Key Influencers visual uses machine learning to analyze your data and explain which fields have the most statistical influence on a selected metric.

Question 21: What connection mode allows Power BI to query data directly from the source without importing it into the data model?

Live Connection mode
Push mode
Import mode
DirectQuery mode (Correct answer)

Correct answer: DirectQuery mode

DirectQuery mode sends queries directly to the data source each time a visual renders, without caching data in Power BI's in-memory engine.

Question 22: What is the 'Dataverse' connector in Power BI commonly used for?

Accessing data stored in Microsoft's data center
Connecting to diverse data sources using a universal connector
Importing data from Microsoft Dataverse (formerly Common Data Service) used by Power Apps and Dynamics 365 (Correct answer)
Connecting Power BI to the open data verse research platform

Correct answer: Importing data from Microsoft Dataverse (formerly Common Data Service) used by Power Apps and Dynamics 365

The Dataverse connector allows Power BI to import or DirectQuery data from Microsoft Dataverse, the cloud database behind Power Apps, Dynamics 365, and the Power Platform.

Question 23: What does 'Tenant Setting: Export Data' control in the Power BI Admin Portal?

Whether users are allowed to export data from Power BI visuals to Excel, CSV, or other formats (Correct answer)
The maximum file size for exported reports
Whether paginated reports can be exported
Whether datasets can be exported to Azure

Correct answer: Whether users are allowed to export data from Power BI visuals to Excel, CSV, or other formats

The 'Export Data' tenant setting controls whether users in the organization can export underlying data from Power BI visuals to CSV or Excel files.

Question 24: What is the maximum dataset size supported in a Power BI Pro shared workspace?

10 GB
1 GB (Correct answer)
100 GB
400 GB

Correct answer: 1 GB

Power BI Pro workspaces cap individual dataset sizes at 1 GB, whereas Power BI Premium capacity supports up to 100 GB or more per dataset.

Question 25: In inquiry supervisor, what is the M dialect's capacity to sort a segment?

Sort.Table (Correct answer)
Table Sort
Table.Sort
Sort Column

Correct answer: Sort.Table

In Power Query Editor, the M language function used to sort a table by one or more columns is `Table.Sort`. This function takes a table and a list of columns to sort by, along with their respective sort orders (e.g., `Order.Ascending`). Although the option is presented as `Sort.Table`, it refers to the core functionality of sorting data within a table structure in M, which is precisely achieved using the `Table.Sort` function.

Question 26: What is the purpose of 'Report Themes' in Power BI Desktop?

Applying seasonal themes to dashboard tiles
Selecting pre-built report templates from AppSource
Defining a JSON-based set of colors, fonts, and formatting defaults applied consistently across all visuals in a report (Correct answer)
Applying a database schema theme to the model

Correct answer: Defining a JSON-based set of colors, fonts, and formatting defaults applied consistently across all visuals in a report

Report Themes allow you to define a consistent visual style (colors, fonts, backgrounds, default formatting) in a JSON file that applies to all visuals in the report at once.

Question 27: What is 'Conditional Formatting' in Power BI visuals?

A formatting template that applies to all visuals at once
Auto-formatting applied when a measure exceeds a threshold
Formatting that only applies on mobile layouts
Dynamic formatting of visual elements (colors, icons, data bars) based on data values or measures (Correct answer)

Correct answer: Dynamic formatting of visual elements (colors, icons, data bars) based on data values or measures

Conditional Formatting dynamically changes the color, icon, or data bar of a visual's elements based on field values or measure results, highlighting important data points.

Question 28: What is a 'Scorecard' in Power BI Service?

A feature for tracking goals and metrics with defined targets, owners, and check-ins aligned to strategic objectives (Correct answer)
A type of bar chart for scoring surveys
A report page dedicated to KPI cards only
An automated performance review dashboard

Correct answer: A feature for tracking goals and metrics with defined targets, owners, and check-ins aligned to strategic objectives

Power BI Scorecards allow organizations to define, track, and manage key metrics against targets with ownership, status updates, and notes for business goal alignment.

Question 29: Which Power BI component is used to author reports and connect to data on the desktop?

Power BI Gateway
Power BI Mobile
Power BI Desktop (Correct answer)
Power BI Report Server admin

Correct answer: Power BI Desktop

Power BI Desktop is the free Windows application for building data models and authoring reports.

Question 30: What is a 'Decomposition Tree' visual used for in Power BI?

Displaying a decision tree from a machine learning model
Enabling users to interactively break down a metric across multiple dimensions in an exploratory, tree-like layout (Correct answer)
Decomposing time series data into trend and seasonality
Showing a file system directory structure

Correct answer: Enabling users to interactively break down a metric across multiple dimensions in an exploratory, tree-like layout

The Decomposition Tree visual lets users interactively drill into a measure by adding dimensions one at a time, revealing which categories contribute most to the metric.

Question 31: What does the 'Private Links' feature in Power BI Premium provide?

Links that expire after a set time period
A private network connection between Power BI Service and your Azure resources, bypassing the public internet (Correct answer)
Password-protected report sharing links
Encrypted export download links

Correct answer: A private network connection between Power BI Service and your Azure resources, bypassing the public internet

Private Links use Azure Private Link to route all Power BI traffic through private network endpoints, ensuring data never traverses the public internet.

Question 32: What is the primary purpose of the On-premises Data Gateway in Power BI?

To automatically create table relationships in imported data
To enable Power BI Service to securely access on-premises data sources (Correct answer)
To increase scheduled refresh frequency in Power BI Service
To compress datasets before uploading them to the cloud

Correct answer: To enable Power BI Service to securely access on-premises data sources

The On-premises Data Gateway acts as a secure bridge, enabling Power BI Service to reach data stored on local networks without exposing those sources directly to the internet.

Question 33: In Power BI Service, what are 'data source credentials' used for?

Encryption keys used to secure dataset files at rest
Credentials that Power BI admins use to log into the admin portal
Authentication details stored in the Service so that scheduled refresh can connect to underlying data sources (Correct answer)
The login credentials required by end users to view a published report

Correct answer: Authentication details stored in the Service so that scheduled refresh can connect to underlying data sources

Data source credentials in Power BI Service store the authentication information (username/password, OAuth token, etc.) that the Service uses to connect to data sources during scheduled refresh.

Question 34: What is the difference between DISTINCTCOUNT() and COUNT() in DAX?

They are identical in behavior
DISTINCTCOUNT counts unique non-blank values; COUNT counts all non-blank values including duplicates (Correct answer)
COUNT only works on numeric columns; DISTINCTCOUNT works on text
COUNT counts blanks; DISTINCTCOUNT does not

Correct answer: DISTINCTCOUNT counts unique non-blank values; COUNT counts all non-blank values including duplicates

DISTINCTCOUNT counts the number of unique, non-blank values in a column, while COUNT counts all non-blank values including duplicates.

Question 35: What is an 'ArcGIS Maps' visual in Power BI primarily used for?

Advanced geographic mapping and spatial analysis with features like heat maps, clustering, and reference layers (Correct answer)
Plotting GPS-tracked shipment routes
Displaying data stored in ArcGIS databases
Creating floor plan maps for office layouts

Correct answer: Advanced geographic mapping and spatial analysis with features like heat maps, clustering, and reference layers

ArcGIS Maps for Power BI, provided by Esri, offers advanced mapping capabilities including heat maps, drive-time analysis, demographic reference layers, and spatial clustering beyond standard map visuals.

Question 36: Which Power BI refresh strategy updates only the newly added or changed data partitions rather than reloading the entire dataset?

Full refresh
Scheduled refresh
Incremental refresh (Correct answer)
Manual refresh

Correct answer: Incremental refresh

Incremental refresh in Power BI defines date-based partitions and refreshes only the most recent range, dramatically reducing refresh duration and resource consumption for large datasets.

Question 37: What does the DAX function FILTER() return?

A scalar value after applying a filter
The number of rows matching a condition
A list of column names that pass a filter
A filtered table based on a Boolean condition (Correct answer)

Correct answer: A filtered table based on a Boolean condition

FILTER() returns a table that contains only the rows satisfying the specified Boolean condition, and is commonly nested inside CALCULATE().

Question 38: What do you use in Power BI to group your queries?

There is no alternative
Union Queries
Join Queries (Correct answer)

Correct answer: Join Queries

In Power BI, when you need to combine data from multiple tables or queries based on common columns, you use "Join Queries" (specifically, merge queries in Power Query Editor). This operation links rows from two tables, effectively grouping their data together into a single, more comprehensive query result. This is distinct from appending queries, which stacks rows from tables with identical column structures.

Question 39: What does enabling 'Responsive' layout for a Power BI visual do?

Makes the visual interactive on touch screens only
Enables the visual to respond to API calls
Makes the visual refresh in real time
Allows the visual to automatically resize and reformat to fit different screen sizes and mobile layouts (Correct answer)

Correct answer: Allows the visual to automatically resize and reformat to fit different screen sizes and mobile layouts

Enabling Responsive layout allows a visual to adapt its display and layout automatically when the report is viewed on different screen sizes, particularly mobile devices.

Question 40: What is 'Power BI Premium' and what is its main differentiator from Power BI Pro?

Premium provides dedicated cloud capacity, allowing report sharing with users who don't need individual Pro licenses (Correct answer)
Premium removes the 1GB dataset size limit only
Premium is required for using Power BI Desktop
Premium is the mobile version of Power BI Pro

Correct answer: Premium provides dedicated cloud capacity, allowing report sharing with users who don't need individual Pro licenses

Power BI Premium provides dedicated capacity in the cloud, enabling features like larger dataset sizes, more frequent refreshes, and allowing Free users to consume Premium workspace content without Pro licenses.

Question 41: What is a 'Treemap' chart in Power BI best suited for?

Displaying hierarchical data as nested, proportionally sized rectangles (Correct answer)
Comparing two categories side by side
Tracking changes in rankings over time
Showing relationships between nodes in a network

Correct answer: Displaying hierarchical data as nested, proportionally sized rectangles

A Treemap displays hierarchical data as nested rectangles where the size of each rectangle is proportional to its value, making it easy to see relative proportions within categories.

Question 42: What does the 'Block Public Internet Access' setting in Power BI Premium do?

Prevents users from browsing the internet from Power BI
Blocks public Power BI embed codes
Prevents data sources from reaching the internet
Disables all public internet endpoints for the Premium capacity, allowing only private link access (Correct answer)

Correct answer: Disables all public internet endpoints for the Premium capacity, allowing only private link access

Enabling 'Block Public Internet Access' disables the public-facing HTTPS endpoints for a Premium capacity, requiring all connections to go through Azure Private Link.

Question 43: Which authentication method does Power BI use when connecting to Azure SQL Database with organizational credentials?

Anonymous authentication
Basic (username/password) authentication
OAuth2 / Microsoft account (Azure AD) (Correct answer)
Windows authentication (Kerberos)

Correct answer: OAuth2 / Microsoft account (Azure AD)

Azure SQL Database in Power BI supports OAuth2 authentication via Azure Active Directory, allowing users to sign in with their organizational Microsoft account.

Question 44: What is Power BI Embedded and who is it primarily designed for?

A tool for embedding Excel within Power BI
A mobile app for embedding Power BI on phones
A feature to embed Power BI in Teams
An Azure service that lets ISVs and developers embed Power BI reports into their own applications without end-user Power BI licenses (Correct answer)

Correct answer: An Azure service that lets ISVs and developers embed Power BI reports into their own applications without end-user Power BI licenses

Power BI Embedded is an Azure capacity-based offering allowing developers to embed interactive Power BI reports into custom applications, with customers not needing individual Power BI licenses.

Question 45: What is the 'Page Navigation' button type in Power BI reports used for?

Creating a clickable button that navigates the user to another page within the same report (Correct answer)
Navigating between Power BI workspaces
Jumping to a specific visual on the current page
Linking to external websites

Correct answer: Creating a clickable button that navigates the user to another page within the same report

Page Navigation buttons allow report designers to create custom navigation experiences, routing users to specific pages with a click, replacing the default page tabs.

Question 46: In Power BI Composite Models, what does 'Dual' storage mode mean for a table?

The table is refreshed twice per scheduled refresh cycle
The table has two independent primary keys
The table is mirrored in two separate databases
The table behaves as Import or DirectQuery depending on which is more efficient for the query (Correct answer)

Correct answer: The table behaves as Import or DirectQuery depending on which is more efficient for the query

A table in Dual storage mode is cached locally like an Import table but can also be queried live like a DirectQuery table, allowing the engine to choose the most efficient path.

Question 47: What is the 'Selection Pane' in Power BI Desktop used for?

Managing row-level security selections
Managing the visibility, order, and names of all visual objects on a report page (Correct answer)
Selecting data from external databases
Selecting color themes for the report

Correct answer: Managing the visibility, order, and names of all visual objects on a report page

The Selection Pane lists all objects on a report page and lets you control their visibility (show/hide), layer order (z-order), and names, which is essential for bookmark-based interactivity.

Question 48: What does 'Small Multiples' in Power BI allow you to create?

A grid of the same chart repeated for each value in a selected dimension, enabling easy comparison (Correct answer)
Multiple copies of a report for different users
Multiple datasets refreshed in parallel
Multiple measures displayed as KPI cards in a row

Correct answer: A grid of the same chart repeated for each value in a selected dimension, enabling easy comparison

Small Multiples (also called trellis or panel charts) create a grid of the same visual type, each showing a different segment, making it easy to compare trends across categories.

Question 49: Which built-in Power BI connector is specifically designed to connect to Salesforce CRM data?

Salesforce Objects connector (Correct answer)
Web connector
OData Feed connector
Generic REST API connector

Correct answer: Salesforce Objects connector

Power BI includes a native Salesforce Objects connector that authenticates directly with Salesforce and exposes its standard and custom objects as tables.

Question 50: In Power BI Desktop's Import mode, what limits how many rows can be loaded from a data source?

Available system memory — there is no fixed row cap (Correct answer)
A hard limit of 10 million rows
A hard limit of 1 million rows
A hard limit of 100 million rows

Correct answer: Available system memory — there is no fixed row cap

Power BI Desktop imposes no hard row limit for Import mode; the practical ceiling is determined by available RAM on the machine.

Question 51: What is 'Dynamic Row-Level Security' in Power BI?

RLS that adapts to user slicer selections
RLS where the filter is based on the logged-in user's identity, typically using the USERNAME() or USERPRINCIPALNAME() DAX function (Correct answer)
RLS applied automatically without DAX configuration
RLS that changes based on the time of day

Correct answer: RLS where the filter is based on the logged-in user's identity, typically using the USERNAME() or USERPRINCIPALNAME() DAX function

Dynamic RLS uses the current user's login (via USERNAME() or USERPRINCIPALNAME()) and a security table to automatically filter data to only what that user is authorized to see.

Microsoft Power BI Data Analyst (PL-300)

The PL-300 exam validates skills in preparing and modeling data, creating and publishing reports and dashboards, and managing Power BI assets using Microsoft Power BI. Passing earns the Microsoft Certified: Power BI Data Analyst Associate credential.

Questions

35 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