Tag: PL-300 Exam Hub

Analytics, Business Intelligence, Data Education & Training, PL-300, Power BI January 17, 2026

Practice Questions: Use AI visuals (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Identify patterns and trends
      --> Use AI visuals

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

A business user wants to understand which factors most strongly influence customer churn. They want Power BI to automatically rank those factors. Which AI visual should you use?

A. Decomposition Tree
B. Key Influencers
C. Scatter chart with clustering
D. Anomaly detection

Correct Answer: B

Explanation:
The Key Influencers visual is designed to identify and rank factors that influence a selected outcome, such as churn or customer satisfaction.

Question 2

You want to break down total sales into region, product category, and salesperson, allowing users to dynamically explore contributing factors. Which AI visual is best?

A. Key Influencers
B. Decomposition Tree
C. Waterfall chart
D. Table visual

Correct Answer: B

Explanation:
The Decomposition Tree supports hierarchical exploration and allows AI-assisted or manual splitting of a measure across dimensions.

Question 3

A report shows daily website visits, and you want Power BI to automatically highlight unusual spikes or drops in traffic. Which feature should you use?

A. Key Influencers
B. Binning
C. Anomaly Detection
D. Explain the increase

Correct Answer: C

Explanation:
Anomaly Detection identifies unexpected deviations in time-series data and is ideal for spotting spikes and dips.

Question 4

Which requirement must be met for anomaly detection to work in a Power BI visual?

A. The data must be categorical
B. The visual must include a continuous time field
C. The model must use DirectQuery
D. A calculated column must exist

Correct Answer: B

Explanation:
Anomaly detection requires time-series data with a continuous date or time axis.

Question 5

A user right-clicks a bar in a chart and selects “Explain the increase.” What does Power BI do next?

A. Creates a new DAX measure
B. Filters the dataset
C. Uses AI to identify contributing factors
D. Applies clustering

Correct Answer: C

Explanation:
Explain the increase/decrease uses AI to analyze changes and surfaces factors that contributed to the increase or decrease.

Question 6

Which AI visual is best suited for explaining why a KPI differs across categories rather than how much it differs?

A. Line chart
B. Decomposition Tree
C. Key Influencers
D. Bar chart

Correct Answer: C

Explanation:
Key Influencers focuses on causation and influence, not just comparison.

Question 7

Which statement about AI visuals in Power BI is true?

A. They permanently modify the dataset
B. They replace the need for data modeling
C. Their insights depend on data quality
D. They only work in Power BI Desktop

Correct Answer: C

Explanation:
AI visuals rely heavily on clean, well-modeled data. Poor data quality can produce misleading insights.

Question 8

You want Power BI to automatically suggest the best way to split a metric when analyzing performance drivers. Which visual supports this behavior?

A. Key Influencers
B. Decomposition Tree
C. Matrix
D. Scatter chart

Correct Answer: B

Explanation:
The Decomposition Tree supports AI-generated splits, allowing Power BI to suggest the most meaningful breakdowns.

Question 9

Which of the following scenarios most strongly indicates the use of an AI visual?

A. Formatting a report page
B. Sorting a bar chart
C. Investigating unexpected changes in metrics
D. Applying conditional formatting

Correct Answer: C

Explanation:
AI visuals are ideal for exploratory analysis, especially when investigating unexpected patterns or changes.

Question 10

Why should AI-generated insights always be reviewed by the report author?

A. AI visuals require manual refresh
B. AI visuals are experimental features
C. AI visuals can misinterpret business context
D. AI visuals only work with small datasets

Correct Answer: C

Explanation:
AI visuals identify statistical patterns but do not understand business context, making human validation essential.

Exam Tip Summary

For the PL-300 exam, remember:

Key Influencers → explains why outcomes occur
Decomposition Tree → explores how metrics break down
Anomaly Detection → identifies unusual trends
Explain the increase/decrease → quick AI explanations
AI visuals support, not replace, solid data modeling

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence, Data Education & Training, PL-300, Power BI January 17, 2026

Practice Questions: Use Copilot to summarize the underlying semantic model (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Identify patterns and trends
      --> Use Copilot to summarize the underlying semantic model

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

1. What is the primary purpose of using Copilot to summarize a semantic model in Power BI?

A. To create new calculated measures automatically
B. To optimize model performance and storage
C. To explain the structure, metrics, and insights of the model using natural language
D. To apply row-level security rules

Correct Answer: C

Explanation:
Copilot’s role is to describe and explain the semantic model in natural language, including tables, relationships, and key measures. It does not create measures, optimize performance, or manage security.

2. Which Power BI component does Copilot analyze when generating a summary?

A. The original data source (SQL, Excel, etc.)
B. The report visuals only
C. The semantic model (dataset)
D. The Power Query transformation steps

Correct Answer: C

Explanation:
Copilot uses the semantic model—tables, relationships, and measures—to generate summaries. It does not inspect Power Query steps or source system schemas directly.

3. A business user wants a quick explanation of what a dataset represents and which metrics are most important. Which feature should you recommend?

A. Analyze in Excel
B. Copilot semantic model summary
C. Performance Analyzer
D. Drill-through pages

Correct Answer: B

Explanation:
Copilot is designed to quickly explain datasets and highlight important metrics using natural language, making it ideal for onboarding or high-level understanding.

4. Which of the following is required in order to use Copilot in Power BI?

A. A Premium capacity or Fabric-enabled environment
B. A DirectQuery data model
C. Python visuals enabled
D. Auto date/time disabled

Correct Answer: A

Explanation:
Copilot requires a Fabric-enabled tenant (Premium or equivalent). The other options are unrelated to Copilot functionality.

5. What type of output does Copilot provide when summarizing a semantic model?

A. DAX expressions
B. SQL queries
C. Natural language descriptions
D. Tabular performance metrics

Correct Answer: C

Explanation:
Copilot responds with natural language explanations, not code or performance diagnostics.

6. Copilot summarizes a dataset but does not show certain tables. What is the most likely reason?

A. The tables are hidden or inaccessible to the user
B. The tables contain calculated columns
C. The dataset uses Import mode
D. The tables are part of a snowflake schema

Correct Answer: A

Explanation:
Copilot respects existing permissions and visibility. If a user doesn’t have access to certain tables, Copilot will not include them in its summary.

7. Which scenario best demonstrates the value of Copilot for identifying patterns and trends?

A. Automatically fixing incorrect relationships
B. Highlighting common business metrics and observed data themes
C. Detecting model circular dependencies
D. Refreshing the dataset on a schedule

Correct Answer: B

Explanation:
Copilot helps identify high-level themes and patterns in the data by summarizing metrics and their business meaning.

8. Which statement about Copilot and semantic models is TRUE?

A. Copilot modifies the data model to improve usability
B. Copilot replaces the need for well-designed measures
C. Copilot explains the existing model without changing it
D. Copilot automatically publishes reports

Correct Answer: C

Explanation:
Copilot is read-only and descriptive. It does not alter models, create content, or replace proper modeling practices.

9. A user wants to understand how sales metrics are calculated but does not know DAX. How can Copilot help?

A. By rewriting all measures in SQL
B. By exporting the dataset to Excel
C. By explaining measures in plain language
D. By disabling advanced calculations

Correct Answer: C

Explanation:
Copilot can translate technical model components into plain language, making it easier for non-technical users to understand metrics.

10. From a PL-300 exam perspective, Copilot is best categorized as which type of feature?

A. Data transformation tool
B. AI-assisted insight and explanation feature
C. Performance tuning feature
D. Security configuration feature

Correct Answer: B

Explanation:
Copilot is an AI-assisted feature focused on insight discovery, explanation, and usability—not transformation, tuning, or security.

Final Exam Tips 🧠

Copilot summarizes and explains, it does not build or fix models
It works on the semantic model layer
Outputs are natural language insights
It supports pattern identification and storytelling
Always respects permissions and tenant settings

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Use Reference Lines, Error Bars, and Forecasting (PL-300 Exam Guide)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Identify patterns and trends
      --> Use Reference Lines, Error Bars, and Forecasting

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

A sales manager wants to see how monthly sales compare against a fixed revenue target on a line chart. What feature should you use?

A. Forecast
B. Error bars
C. Constant reference line
D. Decomposition Tree

Correct Answer: C

Explanation:
A constant reference line allows you to display a fixed benchmark, such as a sales target, across a visual.

Question 2

Which pane in Power BI Desktop is used to add reference lines, error bars, and forecasting to a visual?

A. Fields pane
B. Visualizations pane
C. Filters pane
D. Analytics pane

Correct Answer: D

Explanation:
All three features—reference lines, error bars, and forecasting—are configured in the Analytics pane.

Question 3

You want to show how much variation exists around average daily production values. Which feature is most appropriate?

A. Forecast
B. Error bars
C. Average line
D. Percentile line

Correct Answer: B

Explanation:
Error bars visualize variability or uncertainty, making them ideal for showing ranges around a value.

Question 4

Which type of reference line dynamically adjusts based on the data displayed in the visual?

A. Constant line
B. Target line
C. Average line
D. Fixed percentile

Correct Answer: C

Explanation:
An average line recalculates automatically based on the values currently shown in the visual.

Question 5

What is a requirement for using forecasting in Power BI?

A. The dataset must use DirectQuery
B. The visual must be a line chart with a continuous date axis
C. A calculated column must exist
D. The data must be categorical

Correct Answer: B

Explanation:
Forecasting requires a line chart and a continuous time-based axis, such as a date or datetime field.

Question 6

Which statement about forecasting in Power BI is true?

A. Forecasting creates new measures
B. Forecasting permanently modifies the dataset
C. Forecasting uses historical trends to predict future values
D. Forecasting works on all visual types

Correct Answer: C

Explanation:
Power BI forecasting applies time-series analysis to historical data to project future values.

Question 7

A report needs to show whether performance values fall above or below the median. Which reference line should you use?

A. Constant line
B. Percentile line
C. Median line
D. Forecast line

Correct Answer: C

Explanation:
A median line highlights the midpoint of the data and helps compare values above or below it.

Question 8

Which scenario best justifies the use of error bars?

A. Comparing values to a fixed target
B. Explaining why a metric changed
C. Showing uncertainty or confidence ranges
D. Predicting future outcomes

Correct Answer: C

Explanation:
Error bars are used to represent uncertainty, variability, or confidence intervals, not targets or predictions.

Question 9

Which limitation applies to Power BI forecasting?

A. It requires manual DAX calculations
B. It does not support confidence intervals
C. It cannot account for external factors not present in historical data
D. It only works in Power BI Service

Correct Answer: C

Explanation:
Forecasting relies entirely on historical patterns, so it cannot consider external events unless they are reflected in the data.

Question 10

Which combination of features would best support analyzing trends, performance benchmarks, and uncertainty in a single visual?

A. Forecasting only
B. Error bars only
C. Reference line and forecast
D. Reference lines, error bars, and forecasting

Correct Answer: D

Explanation:
Using all three together allows you to show benchmarks (reference lines), variability (error bars), and future projections (forecasting).

PL-300 Exam Tips

Reference lines → benchmarks, averages, targets
Error bars → variability and uncertainty
Forecasting → time-series predictions
All are configured in the Analytics pane
None of these features modify the underlying data

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence, Data Education & Training, PL-300, Power BI January 17, 2026

Practice Questions: Detect outliers and anomalies (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
   --> Identify patterns and trends
      --> Detect outliers and anomalies

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

You want Power BI to automatically identify unexpected spikes in daily sales over time. Which visual feature should you use?

A. Error bars
B. Reference lines
C. Anomaly detection on a line chart
D. Key Influencers visual

✅ Correct Answer: C

Explanation:
Anomaly detection is an AI-driven feature available on line charts that automatically identifies unusual values in time-series data.

Question 2

Which requirement must be met to use Power BI’s built-in anomaly detection feature?

A. The dataset must be in Import mode
B. The visual must use time-based data
C. The model must include DAX measures
D. The data must be refreshed in real time

✅ Correct Answer: B

Explanation:
Anomaly detection works only with time-series data (such as dates or timestamps).

Question 3

A data point appears far above the average line in a bar chart. What does this most likely indicate?

A. A guaranteed data error
B. An outlier that may require investigation
C. An automatically detected anomaly
D. A forecasting failure

✅ Correct Answer: B

Explanation:
Values far from an average reference line are potential outliers, but they are not automatically classified as errors.

Question 4

Which Power BI feature helps you understand why an anomaly occurred by breaking a metric into contributing dimensions?

A. Key Influencers
B. Decomposition Tree
C. Error bars
D. Forecasting

✅ Correct Answer: B

Explanation:
The Decomposition Tree allows users to drill into dimensions (such as region or product) to explain anomalies.

Question 5

Which visual is most effective for identifying outliers when comparing two numeric variables?

A. Line chart
B. Table
C. Scatter chart
D. Gauge

✅ Correct Answer: C

Explanation:
Scatter charts make extreme values stand out when comparing two numerical measures.

Question 6

What information can Power BI display when an anomaly is detected on a line chart?

A. Only the anomalous data point
B. Expected value and confidence bounds
C. A DAX formula used to detect it
D. The exact root cause

✅ Correct Answer: B

Explanation:
Power BI shows the expected value, upper and lower bounds, and highlights the anomalous point.

Question 7

Which statement about outliers is TRUE?

A. All outliers must be removed
B. Outliers are always caused by data errors
C. Outliers may represent meaningful business events
D. Power BI automatically corrects outliers

✅ Correct Answer: C

Explanation:
Outliers can indicate fraud, exceptional performance, or special events, not just data issues.

Question 8

Which feature helps highlight data points that fall outside a defined range but does not automatically detect anomalies?

A. Anomaly detection
B. Error bars
C. AI insights
D. Smart narratives

✅ Correct Answer: B

Explanation:
Error bars show variation and uncertainty but do not automatically identify anomalies.

Question 9

You want to highlight the top 5% of sales values to identify extreme performers. What should you use?

A. Median reference line
B. Forecasting
C. Percentile reference line
D. Anomaly detection

✅ Correct Answer: C

Explanation:
Percentile reference lines (such as the 95th percentile) help identify extreme high or low values.

Question 10

Which limitation of Power BI anomaly detection should you be aware of for the PL-300 exam?

A. It requires Premium capacity
B. It only works with streaming datasets
C. It relies on historical patterns and trends
D. It requires manual DAX calculations

✅ Correct Answer: C

Explanation:
Anomaly detection is based on historical data patterns, meaning unusual external events may not be fully explained.

Final Exam Tips

✔ Expect conceptual questions, not statistical formulas
✔ Know when to use anomaly detection vs visual analysis
✔ Understand that detection ≠ interpretation
✔ Focus on business context and storytelling

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence Platform, Data Education & Training, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Create and configure a workspace (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Manage and secure Power BI (15–20%)
   --> Create and manage workspaces and assets
      --> Create and configure a workspace

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

You want to allow a user to publish reports and update semantic models, but not manage users or workspace settings. Which workspace role should you assign?

A. Viewer
B. Contributor
C. Member
D. Admin

Correct Answer: C. Member

Explanation:
Members can create, edit, publish, and update content but cannot manage workspace settings or users. Contributors can create content but have more limitations than Members. Admins have full control.

Question 2

Which workspace role provides read-only access to reports and dashboards?

A. Viewer
B. Contributor
C. Member
D. Admin

Correct Answer: A. Viewer

Explanation:
Viewers can only consume content. They cannot edit, publish, or share assets. This role is commonly used for business users.

Question 3

You need to use Copilot, deployment pipelines, and large semantic models in a workspace. What must you configure?

A. Assign Admin role to all users
B. Enable dataset endorsements
C. Move the workspace to Premium capacity
D. Publish a Power BI App

Correct Answer: C. Move the workspace to Premium capacity

Explanation:
Advanced features such as Copilot, deployment pipelines, and large semantic models require Premium (or Fabric) capacity.

Question 4

Which object is NOT stored inside a Power BI workspace?

A. Report
B. Dashboard
C. Semantic model
D. Power BI App

Correct Answer: D. Power BI App

Explanation:
Apps are published from workspaces but are not stored as workspace assets themselves.

Question 5

Who can add or remove users from a workspace?

A. Viewer
B. Contributor
C. Member
D. Admin

Correct Answer: D. Admin

Explanation:
Only workspace Admins can manage access and change workspace-level settings.

Question 6

A team wants to collaborate on report development but ensure that end users cannot modify reports. What is the BEST approach?

A. Give all users Member access
B. Share individual reports
C. Publish an app from the workspace
D. Use row-level security

Correct Answer: C. Publish an app from the workspace

Explanation:
Publishing an app provides a read-only, curated experience for consumers while allowing developers to work in the workspace.

Question 7

Which workspace role can create and modify content but cannot publish apps or manage access?

A. Viewer
B. Contributor
C. Member
D. Admin

Correct Answer: B. Contributor

Explanation:
Contributors can build and modify content but cannot manage users or publish apps.

Question 8

You want to ensure support requests and ownership questions are directed correctly. Which workspace setting helps with this?

A. Assigning Admin role
B. Workspace description
C. Contact list
D. App permissions

Correct Answer: C. Contact list

Explanation:
The contact list identifies workspace owners or support contacts and is a recommended best practice.

Question 9

Which scenario BEST justifies creating multiple workspaces instead of a single one?

A. Different teams own different datasets
B. Users want different slicer behavior
C. Reports use different visuals
D. Dashboards need bookmarks

Correct Answer: A. Different teams own different datasets

Explanation:
Workspaces should align with ownership, security boundaries, and business domains, not visual design preferences.

Question 10

Which statement about Power BI workspaces is TRUE?

A. Workspaces can only contain reports
B. Workspace roles apply only to dashboards
C. Apps must be published from a workspace
D. Viewers can publish new content

Correct Answer: C. Apps must be published from a workspace

Explanation:
All Power BI Apps are published from workspaces. Viewers cannot publish content, and workspaces contain multiple asset types.

Quick Exam Tips

Admins manage access and settings
Members publish and collaborate
Contributors build but don’t manage
Viewers consume only
Premium capacity unlocks advanced features
Apps = curated, read-only distribution

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Configure a semantic model scheduled refresh (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Manage and secure Power BI (15–20%)
   --> Create and manage workspaces and assets
      --> Configure a semantic model scheduled refresh

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

1. Which semantic model supports scheduled refresh in the Power BI service?

A. A DirectQuery model connected to Azure SQL Database
B. A live connection to Azure Analysis Services
C. An Import mode model connected to a CSV file
D. A DirectQuery model connected to an on-premises SQL Server

✅ Correct Answer: C

Explanation:
Scheduled refresh is supported only for semantic models that include Import mode tables. DirectQuery and live connection models do not store data in Power BI and therefore do not support scheduled refresh.

2. Where do you configure scheduled refresh for a semantic model?

A. In Power BI Desktop under Data Source Settings
B. In the workspace settings in the Power BI service
C. In the semantic model settings in the Power BI service
D. In Microsoft Fabric capacity settings

✅ Correct Answer: C

Explanation:
Scheduled refresh is configured in the Power BI service by opening the semantic model settings, not in Power BI Desktop.

3. A semantic model uses Import mode and connects to an on-premises SQL Server. What is required to enable scheduled refresh?

A. Azure AD authentication
B. A dataflow
C. An on-premises data gateway
D. A Premium workspace

✅ Correct Answer: C

Explanation:
An on-premises data gateway is required whenever Power BI needs to access data sources located inside a private network.

4. What is the maximum number of scheduled refreshes per day for a dataset in a shared capacity workspace?

A. 4
B. 8
C. 24
D. 48

✅ Correct Answer: B

Explanation:
In shared capacity, Power BI allows up to 8 scheduled refreshes per day per semantic model.

5. Which scenario does NOT require a scheduled refresh?

A. Import mode model using Excel files
B. Composite model with imported tables
C. DirectQuery model connected to Azure SQL Database
D. Import mode model using SharePoint Online

✅ Correct Answer: C

Explanation:
DirectQuery models query the source data in real time and therefore do not use scheduled refresh.

6. A scheduled refresh is failing because credentials have expired. Where should the credentials be updated?

A. Power BI Desktop
B. Gateway configuration tool
C. Semantic model settings in the Power BI service
D. Workspace access settings

✅ Correct Answer: C

Explanation:
Data source credentials are managed within the semantic model settings in the Power BI service.

7. What happens if a dataset contains both Import and DirectQuery tables?

A. Scheduled refresh is disabled
B. Only Import tables are refreshed
C. Only DirectQuery tables are refreshed
D. The dataset must be republished

✅ Correct Answer: B

Explanation:
In composite models, scheduled refresh refreshes only Import mode tables. DirectQuery tables always query data live.

8. Which feature reduces refresh duration by refreshing only new or changed data?

A. Query folding
B. Dataflows
C. Incremental refresh
D. DirectQuery

✅ Correct Answer: C

Explanation:
Incremental refresh minimizes refresh time by refreshing only data partitions that have changed, but it still relies on scheduled refresh to execute.

9. What is a common cause of scheduled refresh failure?

A. Too many visuals on a report page
B. Dataset size exceeding 1 GB
C. Gateway being offline
D. Using DAX measures

✅ Correct Answer: C

Explanation:
If the gateway is offline or misconfigured, Power BI cannot access on-premises data sources, causing scheduled refresh to fail.

10. A dataset in a Premium workspace needs to refresh every 30 minutes. Is this supported?

A. Yes, Premium supports up to 48 refreshes per day
B. Yes, all datasets support 30-minute intervals
C. No, refresh frequency is fixed at 8 per day
D. No, scheduled refresh cannot be automated

✅ Correct Answer: A

Explanation:
Premium capacity supports up to 48 refreshes per day, allowing more frequent refresh intervals than shared capacity.

✔️ Exam Tip Summary

Import mode → scheduled refresh
DirectQuery → no scheduled refresh
On-premises source → gateway required
Refresh settings → Power BI service
Premium capacity → higher refresh limits

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Configure Subscriptions and Data Alerts (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Manage and secure Power BI (15–20%)
   --> Create and manage workspaces and assets
      --> Configure Subscriptions and Data Alerts

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

A sales manager wants to receive an email every Monday morning with a snapshot of the latest sales performance report.
Which Power BI feature should you configure?

A. Data alert
B. Subscription
C. Dashboard tile alert
D. Power Automate flow

Correct Answer: B

Explanation:
Subscriptions are schedule-based and designed to send report or dashboard snapshots via email. Data alerts are triggered only by thresholds, not schedules.

Question 2

You need to notify users immediately when total daily revenue drops below $50,000.
Which requirement must be met to configure this?

A. The visual must be in a report
B. The dataset must be DirectQuery
C. The visual must be a dashboard tile showing a single value
D. A Power BI app must be published

Correct Answer: C

Explanation:
Data alerts can only be created on dashboard tiles that display a single numeric value (such as a Card or KPI).

Question 3

A user attempts to create a data alert on a table visual in a report but cannot find the option. Why?

A. Alerts require Power BI Premium
B. Alerts only work on dashboards
C. Alerts cannot be used with imported data
D. Alerts must be created by workspace admins

Correct Answer: B

Explanation:
Data alerts cannot be configured on report visuals. They must be created on dashboard tiles.

Question 4

Which delivery method is supported by both subscriptions and data alerts?

A. Microsoft Teams messages
B. SMS notifications
C. Email notifications
D. Power BI mobile push only

Correct Answer: C

Explanation:
Both subscriptions and data alerts support email notifications. Other delivery methods require additional tools such as Power Automate.

Question 5

A report uses Row-Level Security (RLS). A subscription is created for multiple users.
What will each user see?

A. The same data as the report owner
B. Filtered data based on their RLS role
C. All data in the dataset
D. Only summary-level data

Correct Answer: B

Explanation:
Subscriptions respect Row-Level Security, meaning each user only sees data they are authorized to view.

Question 6

Which scenario is the best use case for a data alert?

A. Sending a monthly executive summary
B. Monitoring KPIs for threshold breaches
C. Distributing weekly dashboards
D. Sharing reports with external users

Correct Answer: B

Explanation:
Data alerts are designed for exception-based monitoring, triggering notifications when values cross defined thresholds.

Question 7

Which content types support subscriptions in Power BI?

A. Dashboards only
B. Reports only
C. Reports, report pages, and dashboards
D. Dashboard tiles only

Correct Answer: C

Explanation:
Subscriptions can be created for reports, individual report pages, and dashboards.

Question 8

A user wants to temporarily stop receiving notifications without deleting the configuration.
Which feature supports this requirement?

A. Data alerts only
B. Subscriptions only
C. Both subscriptions and data alerts
D. Neither feature

Correct Answer: C

Explanation:
Both subscriptions and data alerts can be turned on or off without being deleted.

Question 9

When are data alert conditions evaluated?

A. At fixed times defined by the user
B. Continuously in real time
C. After the dataset is refreshed
D. When a report is opened

Correct Answer: C

Explanation:
Data alerts are evaluated after dataset refresh. If the data doesn’t refresh, the alert won’t trigger.

Question 10

You need to send scheduled updates to users who should not edit reports but must receive consistent insights.
Which approach is MOST appropriate?

A. Grant Build permissions
B. Configure data alerts
C. Create report subscriptions
D. Enable Analyze in Excel

Correct Answer: C

Explanation:
Subscriptions are ideal for read-only, passive distribution of insights without requiring users to interact with reports.

Final Exam Tip

If the question mentions:

“Threshold,” “exceeds,” “drops below” → Data Alert
“Daily, weekly, scheduled email” → Subscription
“Dashboard tile” → Data Alert
“Passive consumption” → Subscription

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Promote or certify Power BI content (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Manage and secure Power BI (15–20%)
   --> Create and manage workspaces and assets
      --> Promote or certify Power BI content

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

What is the primary purpose of certifying Power BI content?

A. To improve report rendering performance
B. To indicate that content is approved and trusted for organizational use
C. To allow content to refresh more frequently
D. To enable sharing with external users

Correct Answer: B

Explanation:
Certification identifies datasets or dataflows that have been formally reviewed and approved, making them trusted sources for enterprise-wide reporting.

Question 2

Which Power BI artifact can be certified?

A. Report
B. Dashboard
C. Dataset
D. App

Correct Answer: C

Explanation:
Only datasets (semantic models) and dataflows can be certified. Reports and dashboards cannot be certified directly.

Question 3

Who determines which users are allowed to certify Power BI content?

A. Workspace Admin
B. Report Creator
C. Power BI Tenant Administrator
D. Dataset Owner

Correct Answer: C

Explanation:
Certification permissions are controlled at the tenant level by a Power BI administrator.

Question 4

A dataset is reliable but still evolving and has not undergone a formal governance review. What should you do?

A. Certify the dataset
B. Delete the dataset
C. Promote the dataset
D. Publish it as an app

Correct Answer: C

Explanation:
Promotion is appropriate when content is useful and reliable but not formally approved through governance.

Question 5

What happens when a dataset is certified?

A. Only admins can access it
B. It appears higher in search results
C. It automatically refreshes more often
D. Reports using it are locked

Correct Answer: B

Explanation:
Certified datasets are prioritized in search and discovery to encourage reuse of trusted data.

Question 6

Which of the following statements about promoted content is true?

A. It requires tenant admin approval
B. It represents the highest level of trust
C. It can be promoted without a formal review
D. Only IT users can promote it

Correct Answer: C

Explanation:
Promoted content does not require formal approval and signals informal trust.

Question 7

Your organization wants a single source of truth for company-wide KPIs. Which approach is best?

A. Create multiple promoted datasets
B. Certify one centrally governed dataset
C. Share reports individually
D. Use dashboards instead of datasets

Correct Answer: B

Explanation:
Certified datasets are intended to serve as enterprise-wide trusted sources.

Question 8

Where do you promote or certify a dataset?

A. Power BI Desktop
B. Dataset settings in the Power BI Service
C. Power Query Editor
D. Workspace app settings

Correct Answer: B

Explanation:
Promotion and certification are configured in the Power BI Service, not in Desktop.

Question 9

Which of the following is a key benefit of certification?

A. Faster data refresh
B. Reduced report load times
C. Improved data governance and reuse
D. Automatic row-level security

Correct Answer: C

Explanation:
Certification improves governance by guiding users toward trusted, reusable datasets.

Question 10

Why can a report not be certified?

A. Reports do not contain data
B. Reports cannot be shared
C. Certification applies only to datasets and dataflows
D. Reports already inherit certification

Correct Answer: C

Explanation:
Certification is applied to the data source, not the visualization layer.

Exam Tips

Promoted ≠ Certified
Certification requires tenant admin configuration
Certified content supports enterprise BI
Reports inherit trust from their dataset, not certification directly

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Create dashboards (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Manage and secure Power BI (15–20%)
   --> Create and manage workspaces and assets
      --> Create dashboards

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

1. Where can Power BI dashboards be created?

A. Power BI Desktop
B. Power BI Service
C. Power BI Report Server
D. Microsoft Excel

✅ Correct Answer: B

Explanation:
Dashboards can only be created in the Power BI Service. Power BI Desktop is used to create reports, not dashboards.

2. What is the maximum number of pages a Power BI dashboard can have?

A. One
B. Five
C. Ten
D. Unlimited

✅ Correct Answer: A

Explanation:
Dashboards are single-page canvases designed for high-level monitoring.

3. A business user wants to view KPIs from three different datasets on one screen. What should you create?

A. A report with multiple pages
B. A report using composite models
C. A dashboard
D. A paginated report

✅ Correct Answer: C

Explanation:
Dashboards can display visuals from multiple datasets, while reports are limited to one dataset.

4. How is a dashboard tile created?

A. By importing a dataset
B. By saving a report page
C. By pinning content from a report or Q&A
D. By creating a new visual in the Service

✅ Correct Answer: C

Explanation:
Dashboard tiles are created by pinning visuals, pages, or Q&A results to a dashboard.

5. What happens when a user clicks a visual tile on a dashboard?

A. The tile expands in place
B. The dashboard refreshes
C. The source report opens
D. A detailed tooltip appears

✅ Correct Answer: C

Explanation:
Clicking a dashboard tile opens the underlying report that the tile was pinned from.

6. Which tile types support data alerts in Power BI dashboards?

A. Table and matrix
B. KPI, card, and gauge
C. Any visual
D. Image and text box

✅ Correct Answer: B

Explanation:
Data alerts are supported on KPI, card, and gauge tiles, making dashboards useful for monitoring thresholds.

7. A user shares a dashboard with a colleague, but the colleague cannot see the data. What is the most likely reason?

A. The dashboard is unpublished
B. The dataset has not refreshed
C. The colleague lacks access to the dataset
D. The visuals are not interactive

✅ Correct Answer: C

Explanation:
Sharing a dashboard does not grant dataset access. Users must have permission to the underlying dataset.

8. Which statement about dashboards is TRUE?

A. Dashboards store their own data
B. Dashboards can be edited in Power BI Desktop
C. Dashboards support drill-through
D. Dashboards reflect live dataset data

✅ Correct Answer: D

Explanation:
Dashboards do not store data; they reflect the current state of the underlying datasets.

9. What is a key limitation of Power BI dashboards compared to reports?

A. Dashboards cannot be shared
B. Dashboards cannot include visuals
C. Dashboards have limited interactivity
D. Dashboards cannot refresh data

✅ Correct Answer: C

Explanation:
Dashboards are designed for at-a-glance insights and have limited filtering, slicing, and interaction.

10. What is the primary purpose of a Power BI dashboard?

A. Detailed data exploration
B. Data modeling
C. High-level monitoring and summarization
D. Row-level security configuration

✅ Correct Answer: C

Explanation:
Dashboards are built for monitoring key metrics and summarizing performance across the business.

Final Exam Tip

If a question mentions:

Multiple datasets
Single-page view
Pinned visuals
Executive or KPI monitoring

➡️ The correct answer is likely to be Dashboard.

Go back to the PL-300 Exam Prep Hub main page

Analytics, Business Intelligence, Data Education & Training, Microsoft Certification, PL-300, Power BI January 17, 2026

Practice Questions: Choose a distribution method (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Manage and secure Power BI (15–20%)
   --> Create and manage workspaces and assets
      --> Choose a distribution method

Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions

Question 1

You need to distribute a set of certified reports to 300 business users. Users should not be able to modify the reports, and updates should be centrally managed. What is the best distribution method?

A. Share each report individually
B. Grant Viewer access to the workspace
C. Publish a Power BI app
D. Create email subscriptions

✅ Correct Answer: C

Explanation:
Power BI apps provide centralized, read-only distribution to large audiences and allow content to be updated without re-sharing. This is the recommended enterprise distribution method.

Question 2

Which distribution method is most appropriate for collaboration among report developers?

A. Power BI app
B. Publish to web
C. Workspace access
D. Dashboard subscription

✅ Correct Answer: C

Explanation:
Workspace access allows contributors and members to create, edit, and manage content collaboratively. Apps are designed for consumption, not development.

Question 3

An executive wants to receive a weekly snapshot of a sales dashboard without logging into Power BI. What should you configure?

A. Report sharing
B. Power BI app
C. Dashboard subscription
D. Workspace Viewer access

✅ Correct Answer: C

Explanation:
Subscriptions deliver scheduled email snapshots of dashboards or reports and are ideal for passive consumption.

Question 4

Which distribution method should be used only for non-confidential data?

A. Power BI app
B. Secure embed
C. Workspace Viewer access
D. Publish to web

✅ Correct Answer: D

Explanation:
Publish to web makes reports publicly accessible with no authentication. It is inappropriate for sensitive or internal data.

Question 5

You share a report with a user, but they cannot see the data. What is the most likely cause?

A. The user lacks workspace access
B. The dataset permissions were not granted
C. The report is not certified
D. Row-level security is disabled

✅ Correct Answer: B

Explanation:
Sharing a report does not automatically grant access to the underlying dataset unless permissions are explicitly assigned.

Question 6

Your organization wants users to access Power BI reports inside Microsoft Teams. Which distribution option supports this scenario?

A. Publish to web
B. Power BI Embedded
C. SharePoint or Teams embed
D. Dashboard subscription

✅ Correct Answer: C

Explanation:
Power BI reports can be securely embedded in Teams and SharePoint while respecting Power BI permissions.

Question 7

Which distribution method provides the strongest governance and version control?

A. Individual report sharing
B. Workspace access
C. Dashboard subscriptions
D. Power BI app

✅ Correct Answer: D

Explanation:
Apps allow controlled publishing, versioning, and consistent delivery of approved content to users.

Question 8

You want to distribute reports to external customers using a custom web application. What is the best option?

A. Publish to web
B. Power BI Embedded
C. Share reports
D. Power BI app

✅ Correct Answer: B

Explanation:
Power BI Embedded allows secure integration of reports into custom applications with external users.

Question 9

Which statement about workspace access is true?

A. It is the recommended method for executive distribution
B. It restricts users to read-only access
C. It is intended for collaboration and content management
D. It replaces the need for Power BI apps

✅ Correct Answer: C

Explanation:
Workspace access is designed for creators and collaborators, not for broad report consumption.

Question 10

A question on the PL-300 exam describes a scenario involving production reports, a large audience, and controlled access. Which answer is most likely correct?

A. Share reports
B. Workspace Viewer access
C. Publish to web
D. Power BI app

✅ Correct Answer: D

Explanation:
These keywords strongly indicate the use of a Power BI app, which is the exam’s preferred answer for governed distribution scenarios.