PL-300: Microsoft Power BI Data Analyst Practice Exam

What the PL-300 exam covers

• Prepare the Data182 questions
• Model the Data171 questions
• Visualize and Analyze the Data166 questions
• Deploy and Maintain Assets158 questions

Free PL-300 sample questions

A sample of 10 questions with answers and explanations. Sign up free to practice all 677.

1. Question 1Prepare the Data

   You are connecting to a SQL Server database using Power Query. You notice that some transformation steps have a green bar indicator in the Applied Steps pane. What does this indicate?

   • AThe step uses a native query that cannot be modified
   • BThe step contains an error
   • CThe step is being folded back to the data sourceCorrect
   • DThe step was automatically generated by Power Query
   ✓ Correct answer: C

   In the Applied Steps pane, Power Query indicates query folding capability for steps that it can translate into native source operations such as a SQL statement. When folding occurs, the transformation is executed by the SQL Server engine rather than locally in Power Query's mashup engine, which reduces the volume of data transferred and improves refresh performance. The indicator tells you the source is still doing the work, so keeping folding intact for as long as possible is a key optimization goal.

   Why the other options are wrong

   • AA native query that cannot be modified is not what the folding indicator represents; folding means the step is being translated to native operations, not that you are locked into a fixed native query.
   • BAn error in the step would surface as an error icon or warning, not as the green indicator that signals successful query folding.
   • DAutomatic generation by Power Query is unrelated to folding; the indicator reflects where the step executes (the source) rather than how the step was created.
2. Question 2Prepare the Data

   You need to connect Power BI to an on-premises SQL Server database. The database is behind a corporate firewall. What must you install to enable the connection for scheduled refresh?

   • ASQL Server Integration Services
   • BAzure Data Factory self-hosted runtime
   • COn-premises data gatewayCorrect
   • DPower BI Report Server
   ✓ Correct answer: C

   To connect Power BI to on-premises SQL Server databases behind corporate firewalls with scheduled refresh capability, you must install the On-premises Data Gateway. This gateway acts as an intermediary between Power BI cloud services and your local network, securely tunneling data connections through the firewall. The gateway runs on a local machine and handles authentication and data transfer, enabling the Power BI service to refresh queries from on-premises sources on a scheduled basis.

   Why the other options are wrong

   • ASQL Server Integration Services is incorrect because SSIS is an ETL tool for data integration but does not function as a gateway for Power BI cloud connections.
   • BAzure Data Factory self-hosted runtime is incorrect because while it can integrate with on-premises data, it is a separate service designed for data movement and transformation, not for Power BI scheduled refresh.
   • DPower BI Report Server is incorrect because Report Server is an on-premises deployment of Power BI for on-premises hosting, not a gateway for cloud Power BI to access local databases.
3. Question 3Model the DataSelect all that apply

   You are configuring relationships in your data model. Which TWO statements about relationship cardinality in Power BI are correct? (Choose two.)

   • AOne-to-one relationships cannot be created in Power BI
   • BOne-to-many is the most common relationship type and filters from the one side to the many side by defaultCorrect
   • CPower BI supports direct many-to-many relationships without a bridge tableCorrect
   • DMany-to-many relationships require a bridge table in all cases
   ✓ Correct answer: B, C

   One-to-many relationships are the standard for star schema designs, where a single dimension record relates to many fact records. Filters propagate from the dimension (one) to the fact table (many) automatically. Power BI also supports true many-to-many relationships natively, allowing two tables with multiple matching values to relate directly without requiring an intermediate bridge table.

   Why the other options are wrong

   • AOne-to-one relationships cannot be created in Power BI is incorrect because Power BI fully supports one-to-one relationships when dimension tables need unique mapping.
   • DMany-to-many relationships require a bridge table in all cases is incorrect because modern versions of Power BI support native many-to-many relationships directly.
4. Question 4Model the Data

   A Power BI model has a Fact_Sales table and a Dim_Date table. The relationship uses Dim_Date[DateKey] to Fact_Sales[OrderDateKey] with a one-to-many cardinality and single cross-filter direction from Dim_Date to Fact_Sales. A report author also needs to filter Dim_Date based on whether a date has any sales. What should the analyst do?

   • AAdd a calculated column to Dim_Date that flags dates with sales using COUNTROWS and RELATEDTABLECorrect
   • BRemove the relationship and use LOOKUPVALUE in every measure
   • CCreate a second relationship between the same tables
   • DChange the cross-filter direction to Both on the existing relationship
   ✓ Correct answer: A

   This approach leverages the existing relationship to count related sales rows, creating a column that report authors can use to filter or highlight dates that have actual transaction activity. The RELATEDTABLE function traverses the active relationship backward (from one-side to many-side through bi-directional logic) to identify dates with sales.

   Why the other options are wrong

   • BRemove the relationship and use LOOKUPVALUE in every measure is incorrect because removing the relationship breaks the data model's integrity and requires reimplementing logic in every measure.
   • CCreate a second relationship between the same tables is incorrect because multiple active relationships between the same tables cause ambiguity.
   • DChange the cross-filter direction to Both is incorrect because bidirectional filtering is a sledgehammer solution that can cause unexpected filter propagation and isn't necessary for adding a simple calculated column.
5. Question 5Visualize and Analyze the Data

   An analyst at Graphic Design Institute creates a Power BI report with 15 visuals on a single page. Users complain that the page loads slowly. Which action would most likely improve the page load time?

   • AIncrease the dataset size to include more pre-aggregated data
   • BChange all visuals to the same type to reduce rendering complexity
   • CChange all visuals to use DirectQuery instead of Import mode
   • DReduce the number of visuals on the page and use drillthrough or additional pages for detailCorrect
   ✓ Correct answer: D

   Having 15 visuals on a single page causes performance issues because the Power BI engine must query and render every visual during page load, consuming bandwidth and processing power. Reducing the visual count directly decreases the rendering load. Using drillthrough pages or additional report pages allows you to move detail visuals to separate pages that load only when needed, improving the perceived load time of the primary page.

   Why the other options are wrong

   • AIncreasing the dataset size to include more pre-aggregated data is incorrect because it typically increases memory consumption and may worsen performance.
   • BChanging all visuals to the same type is incorrect because the issue is the number of visuals, not their types; rendering complexity varies by visual configuration, not type.
   • CChanging to DirectQuery instead of Import mode is incorrect because DirectQuery executes separate queries for each visual interaction, which actually worsens performance with multiple visuals.
6. Question 6Deploy and Maintain Assets

   You need to ensure that sensitive data in a Power BI dataset is classified and protected when exported. Which feature should you apply?

   • AObject-level security
   • BSensitivity labelsCorrect
   • CRow-level security
   • DData masking in Power Query
   ✓ Correct answer: B

   Sensitivity labels in Power BI classify data by sensitivity level (e.g., public, internal, confidential) and can be enforced to control access and export behavior. When sensitivity labels are applied to datasets, Power BI respects these labels when users attempt to export data, potentially blocking exports or applying restrictions based on the classification. This ensures that sensitive data is classified appropriately and protected according to organizational data governance policies and compliance requirements.

   Why the other options are wrong

   • AObject-level security is incorrect because object-level security restricts access to specific objects within a dataset based on user identity, but doesn't classify or label sensitivity for export protection purposes.
   • CRow-level security is incorrect because row-level security restricts data visibility based on user context, but doesn't provide sensitivity classification or export controls based on data sensitivity levels.
   • DData masking in Power Query is incorrect because data masking modifies data values during transformation, but doesn't classify sensitivity or provide centralized export controls; it also removes actual data rather than just controlling access.
7. Question 7Deploy and Maintain Assets

   A company has published a Power BI app containing multiple reports and dashboards for the sales team. A new report must be added to the app. What is the correct process?

   • AAdd the new report to the workspace that backs the app, then update the app to include the new report in its content listCorrect
   • BShare the new report directly with each end user through per-item sharing rather than updating the published app at all
   • CDelete the existing sales app entirely and build a brand-new app that republishes every report including the new one together
   • DPublish a second separate app that contains only the new report and distribute it to the same sales team audience
   ✓ Correct answer: A

   A Power BI app publishes content from its backing workspace, so new content is first added to that workspace. You then republish or update the app and include the new report in the app's content and audience configuration so consumers receive it. Updating the existing app preserves the app's URL and audience while adding the report.

   Why the other options are wrong

   • BDirect sharing bypasses the app and gives users an inconsistent experience outside the packaged app.
   • CDeleting and rebuilding the app is disruptive and unnecessary when the app can simply be updated.
   • DA second app fragments the content and forces users to open two apps instead of one updated app.
8. Question 8Prepare the Data

   Data source parameters is a supported feature when implementing solutions for organizations like Contoso Ltd.

   • TrueTrueCorrect
   • FalseFalse
   ✓ Correct answer: True

   Data source parameters is a fully supported feature in Power BI that enables dynamic configuration of data source connections and query behavior without requiring manual changes to the underlying queries. Organizations like Contoso Ltd can implement data source parameters to create flexible, environment-agnostic solutions where connection strings, filter values, and transformation logic adjust automatically based on parameter values supplied at refresh or deployment time.

   Why the other options are wrong

   • FalseFalse is incorrect. The statement is true. Data source parameters is a fully supported feature in Power BI that enables dynamic configuration of data source connections and query behavior without requiring manual changes to the underlying queries.
9. Question 9Visualize and Analyze the Data

   Adatum Corporation is evaluating decomposition tree. Decomposition tree can be used in conjunction with performance analyzer to enhance the overall solution.

   • TrueTrueCorrect
   • FalseFalse
   ✓ Correct answer: True

   Decomposition tree is a Power BI AI-powered visual that enables users to explore data hierarchically and drill into different dimensions to understand root causes and patterns. When used in conjunction with Performance Analyzer, organizations like Adatum Corporation can optimize their analytical solutions significantly. Performance Analyzer provides insights into visual rendering performance, helping identify bottlenecks in decomposition tree interactions. This combination allows administrators to understand not only the data insights but also the performance characteristics of their analytical workloads. Using these tools together creates a comprehensive approach to both data discovery and system optimization.

   Why the other options are wrong

   • FalseFalse is incorrect. The statement is true. Decomposition tree is a Power BI AI-powered visual that enables users to explore data hierarchically and drill into different dimensions to understand root causes and patterns.
10. Question 10Prepare the Data

    A source table has a 'Status' column with values 'A', 'I', and 'P'. You must map these to 'Active', 'Inactive', and 'Pending' and ensure any unexpected new code (e.g., 'X') is mapped to 'Unknown' rather than producing an error or null. Which approach is BEST?

    • AAdd a conditional/custom column using an if...else if...else chain (or a lookup with an 'otherwise' branch) that returns 'Unknown' for unmatched codesCorrect
    • BRun Replace Values three separate times, once for each of the known codes, and simply leave behind any unexpected value such as 'X' unchanged in the column
    • CUse the Pivot Column transformation on the Status column so that each distinct status code is turned into its own separate mapped column
    • DChange the Status column's data type to Text and then rely on the editor's Detect Data Type feature to map the codes to their full labels
    ✓ Correct answer: A

    The Conditional Column dialog or a custom column with 'if [Status]="A" then "Active" else if ... else "Unknown"' guarantees every row resolves to a defined value, including future codes you have not seen. An explicit 'else' / 'otherwise' branch is what makes the mapping resilient to schema drift in the categorical values. A scalable alternative is a small mapping query joined with a left outer merge plus a replace-null step for the default. Either way the design intentionally handles the unmatched case.

    Why the other options are wrong

    • BLeaving unexpected codes unchanged means a new 'X' stays 'X' instead of becoming the required 'Unknown'.
    • CPivot reshapes the column into many columns and does not map individual codes to descriptive labels.
    • DDetect Data Type only sets a data type; it cannot translate coded values into their descriptive text.

Related Microsoft resources

• PL-300 study guideKey concepts
• Microsoft practice examsAll Microsoft
• Certification pathWhere this fits
• Certification exam guides & tipsBlog
• Plans & pricingFree & paid
• SC-200 practice examRelated
• AZ-140 practice examRelated
• AZ-900 practice examRelated

PL-300 practice exam FAQ