Microsoft PL-300 · Power BI Data Analyst · Updated 2026
Free PL-300 Power BI Data Analyst Practice Exam (2026)
Full-length PL-300 mock exams with a realistic number of questions and the real exam time. Data preparation, modeling, DAX, visualization and workspace security scenarios, answers explained, and your score by domain.
1. Choose a set
2. Choose a mode
50 questions · 1 hour 40 min · same as the real exam
You have an unfinished attempt on this set.
Questions 1–10Page 1 of 5
🏆
Question 1Prepare the Data
Trey Research stores curated Delta tables in a Microsoft Fabric lakehouse. The team wants a semantic model that reads the tables directly from OneLake with performance close to Import, without scheduled data copies. Which storage mode should they use?
Correct answer: A. Direct Lake
Direct Lake loads Delta table data from OneLake into memory on demand, which avoids import refresh copies while giving near Import performance. DirectQuery sends a query to the source for each visual and is usually slower.
Direct Lake loads Delta table data from OneLake into memory on demand, which avoids import refresh copies while giving near Import performance. DirectQuery sends a query to the source for each visual and is usually slower.
Question 2Model the Data
Lucerne Publishing needs one matrix that shows order date year on rows and ship date year on columns, with both filters applied at once. The Orders table has OrderDate and ShipDate keys related to a single Date table. What should the analyst do?
Correct answer: C. Add a second date table for ship date
Only one relationship between two tables can be active, so filtering by order date and ship date together needs a second date table that plays the ship date role. An inactive relationship can only be switched on inside a measure in place of the active one, so it cannot apply both date filters from the same table at once.
Only one relationship between two tables can be active, so filtering by order date and ship date together needs a second date table that plays the ship date role. An inactive relationship can only be switched on inside a measure in place of the active one, so it cannot apply both date filters from the same table at once.
Question 3Visualize & Analyze
Fabrikam wants to show whether stores with higher marketing spend also have higher sales, with one point per store and point size showing store floor area. Which visual should the analyst use?
Correct answer: D. Scatter chart
A scatter chart plots two measures on the X and Y axes with one point per category, and a size field turns the points into bubbles. A combo chart compares measures over a shared axis but does not show the correlation between two measures.
A scatter chart plots two measures on the X and Y axes with one point per category, and a size field turns the points into bubbles. A combo chart compares measures over a shared axis but does not show the correlation between two measures.
Question 4Manage & Secure
Fabrikam's analyst republished an improved version of a report to the workspace that backs a published app. App users still see the old report layout the next day. What should the analyst do?
Correct answer: D. Update the app from the workspace
An app shows the version of workspace content that was published when the app was last updated, so report changes reach app users only after Update app. Refreshing the semantic model updates the data, not the report design that users see.
An app shows the version of workspace content that was published when the app was last updated, so report changes reach app users only after Update app. Refreshing the semantic model updates the data, not the report design that users see.
Question 5Prepare the Data
An analyst at Proseware connected to a SQL Server database with the wrong account. Power BI Desktop now reuses the saved credentials, and the analyst cannot see the expected tables. What should the analyst do?
Correct answer: B. Edit permissions in Data source settings
Data source settings stores credentials per source, and Edit Permissions lets you clear or change them so the next connection uses the right account. Rebuilding the queries would reuse the same saved credentials for that source.
Data source settings stores credentials per source, and Edit Permissions lets you clear or change them so the next connection uses the right account. Rebuilding the queries would reuse the same saved credentials for that source.
Question 6Model the Data
Woodgrove Bank models joint accounts with Customer, a CustomerAccount bridge table, Account, and Transactions. Customer filters CustomerAccount, and Account filters both CustomerAccount and Transactions in a single direction. Selecting a customer does not filter Transactions. What should the analyst change?
Correct answer: B. Set the Account to CustomerAccount relationship to Both
The filter must travel from CustomerAccount up to Account before it can reach Transactions, which requires that relationship to filter in both directions. Changing the Customer side does nothing because Customer already filters the bridge table.
The filter must travel from CustomerAccount up to Account before it can reach Transactions, which requires that relationship to filter in both directions. Changing the Customer side does nothing because Customer already filters the bridge table.
Question 7Visualize & Analyze
Contoso's brand team wants every new Power BI report to use the corporate color palette, fonts, and default visual styles without formatting each visual manually. What should the analyst do?
Correct answer: D. Import a custom report theme JSON file
A report theme JSON file defines colors, fonts and default formatting for visual types, and importing it applies them across the whole report. Format Painter copies formatting one visual at a time, which does not scale.
A report theme JSON file defines colors, fonts and default formatting for visual types, and importing it applies them across the whole report. Format Painter copies formatting one visual at a time, which does not scale.
Question 8Manage & Secure
Litware's executives want one page in the Power BI service that combines KPI tiles pinned from five different reports, each built on a different semantic model. What should the analyst create?
Correct answer: C. A dashboard
A dashboard is a single canvas of tiles that can be pinned from many reports and semantic models. A standard report connects to one semantic model, so its pages cannot mix visuals from five separate models.
A dashboard is a single canvas of tiles that can be pinned from many reports and semantic models. A standard report connects to one semantic model, so its pages cannot mix visuals from five separate models.
Question 9Prepare the Data
A Litware analyst reviews column statistics in the Power Query Editor and notices that the distinct counts look too low for a 2 million row table. The analyst wants the statistics to reflect every row. What should the analyst change?
Correct answer: B. Profile based on entire data set
By default, column profiling uses only the top 1,000 rows, and switching the status bar option to the entire data set computes statistics over all rows. Turning on Column distribution only displays the visuals and still uses the 1,000 row sample.
By default, column profiling uses only the top 1,000 rows, and switching the status bar option to the entire data set computes statistics over all rows. Turning on Column distribution only displays the visuals and still uses the 1,000 row sample.
Question 10Model the Data
Trey Research has no date table in its source systems. The analyst needs a table in the model with one row per day from January 1, 2020, through December 31, 2027, created without changing Power Query. What should the analyst create?
Correct answer: C. A calculated table using CALENDAR
A calculated table defined with CALENDAR and two DATE values generates a contiguous list of dates in the model. A measure returns a single value and cannot create rows.
A calculated table defined with CALENDAR and two DATE values generates a contiguous list of dates in the model. A measure returns a single value and cannot create rows.
Question 11Visualize & Analyze
A Litware bar chart lists sales for 300 products. Managers want the chart to show only the 10 products with the highest sales, and the list should update as other slicers change. What should the analyst configure?
Correct answer: A. A Top N filter on the visual
A visual-level Top N filter keeps the top 10 products by a chosen measure and is re-evaluated as slicers change. A basic filter on 10 named products is fixed and would not update when the top products change.
A visual-level Top N filter keeps the top 10 products by a chosen measure and is re-evaluated as slicers change. A basic filter on 10 named products is fixed and would not update when the top products change.
Question 12Prepare the Data
Coho Winery exports a report from its ERP system where the Region value appears only on the first row of each group and the rows below it are null. The analyst needs Region filled in on every row. What should the analyst use?
Correct answer: B. Fill Down
Fill Down copies the last non-null value into the null cells below it until the next value appears. Fill Up would copy values from the rows below, assigning rows to the wrong region.
Fill Down copies the last non-null value into the null cells below it until the next value appears. Fill Up would copy values from the rows below, assigning rows to the wrong region.
Question 13Model the Data
Tailwind Traders wants a card that shows the selected region name, or the text All regions when no region or several regions are selected in a slicer. Which measure expression should the analyst use?
Correct answer: A. SELECTEDVALUE(Region[Name], "All regions")
SELECTEDVALUE returns the region name when exactly one value is in the filter context and the alternate result otherwise. VALUES returns a multi-row table when several regions are selected, which causes an error in a card.
SELECTEDVALUE returns the region name when exactly one value is in the filter context and the alternate result otherwise. VALUES returns a multi-row table when several regions are selected, which causes an error in a card.
Question 14Visualize & Analyze
Tailwind Traders' column chart uses a Year, Quarter, Month hierarchy. Users want to see every quarter of every year side by side, labeled with its year, instead of drilling into one year at a time. What should users select?
Correct answer: C. Expand all down one level
Expand all down one level shows the quarters of every year together and keeps the parent year in the labels. Go to the next level shows quarters but combines the same quarter across all years, losing the year breakdown.
Expand all down one level shows the quarters of every year together and keeps the parent year in the labels. Go to the next level shows quarters but combines the same quarter across all years, losing the year breakdown.
Question 15Manage & Secure
A Tailwind Traders sales director wants to receive an email every Monday at 8 AM with a snapshot of a report page and a link to it. What should the director set up?
Correct answer: D. A subscription
A report subscription emails a snapshot of the page and a link on the schedule you choose. A data alert notifies you only when a tile value crosses a threshold, not on a fixed weekly schedule.
A report subscription emails a snapshot of the page and a link on the schedule you choose. A data alert notifies you only when a tile value crosses a threshold, not on a fixed weekly schedule.
Question 16Prepare the Data
Alpine Ski House has a sensor table with Timestamp, DeviceID, Metric, and Value columns, where Metric contains Temperature, Humidity, or Wind. The analyst needs one row per device and timestamp with a separate column for each metric. What should the analyst do?
Correct answer: D. Pivot the Metric column
Pivot Column turns each distinct Metric value into a new column filled from Value, and the Don't Aggregate option keeps the original readings. Unpivot does the opposite and would make the table even longer.
Pivot Column turns each distinct Metric value into a new column filled from Value, and the Don't Aggregate option keeps the original readings. Unpivot does the opposite and would make the table even longer.
Question 17Model the Data
Coho Winery's fiscal year ends on June 30, and the model has a marked Date table. The analyst needs a fiscal year-to-date sales measure. Which expression should be used?
Correct answer: A. TOTALYTD([Sales], 'Date'[Date], "6/30")
The optional year end date argument of TOTALYTD sets the fiscal year end, so 6/30 restarts the total each July 1. DATESYTD with 7/1 would treat July 1 as the last day of the year, which shifts every period by one day.
The optional year end date argument of TOTALYTD sets the fiscal year end, so 6/30 restarts the total each July 1. DATESYTD with 7/1 would treat July 1 as the last day of the year, which shifts every period by one day.
Question 18Visualize & Analyze
Fourth Coffee wants a column chart that counts orders in amount ranges of 50 dollars, such as 0 to 49 and 50 to 99, based on a numeric OrderAmount column. The analyst wants to do this without DAX or Power Query. What should the analyst create?
Correct answer: B. Bins of size 50 on OrderAmount
Binning creates a new field that groups a numeric column into equal-size ranges, with no DAX or Power Query needed. A calculated column with SWITCH would also work, but it requires writing DAX.
Binning creates a new field that groups a numeric column into equal-size ranges, with no DAX or Power Query needed. A calculated column with SWITCH would also work, but it requires writing DAX.
Question 19Prepare the Data
Fabrikam receives sales from three regional systems as separate queries with identical columns. The model needs one Sales table that contains all rows from the three queries. What should the analyst do?
Correct answer: D. Append the three queries as new
Append stacks rows from tables with the same columns into one table. A merge joins columns side by side based on matching keys and would not stack the rows.
Append stacks rows from tables with the same columns into one table. A merge joins columns side by side based on matching keys and would not stack the rows.
Question 20Model the Data
Fabrikam's Margin % measure uses [Profit] / [Revenue]. Some products have zero revenue, and those visuals show Infinity or errors. The team wants blank results in those cases. What should the analyst change the expression to?
Correct answer: C. DIVIDE([Profit], [Revenue])
DIVIDE returns blank, or an optional alternate result, when the denominator is zero, and it is optimized for this check. Adding 1 to revenue avoids the error but returns wrong percentages for every product.
DIVIDE returns blank, or an optional alternate result, when the denominator is zero, and it is optimized for this check. Adding 1 to revenue avoids the error but returns wrong percentages for every product.
Question 21Visualize & Analyze
Relecloud has a scatter chart of customers by annual spend and visit frequency. The marketing team wants Power BI to find natural groups of similar customers automatically and add the result as a field. What should the analyst use?
Correct answer: A. Automatically find clusters
The Automatically find clusters option on a scatter chart groups similar data points and creates a cluster field that can be used elsewhere in the report. Bins split one numeric column into equal ranges and do not consider both measures together.
The Automatically find clusters option on a scatter chart groups similar data points and creates a cluster field that can be used elsewhere in the report. Bins split one numeric column into equal ranges and do not consider both measures together.
Question 22Manage & Secure
Northwind Traders configured row-level security on a semantic model. A regional manager who has the Contributor role in the workspace still sees data for every region in the report. What should the analyst do so the RLS filter applies to the manager?
Correct answer: C. Assign the manager the Viewer role
Row-level security applies to workspace Viewers and to users with shared access, but not to Admins, Members or Contributors, who can edit the model. Granting Build permission does not change that and would let the manager create new reports.
Row-level security applies to workspace Viewers and to users with shared access, but not to Admins, Members or Contributors, who can edit the model. Granting Build permission does not change that and would let the manager create new reports.
Question 23Prepare the Data
Northwind Traders wants a list of customers in the Customers query who have no orders in the Orders query, so the team can target them with a campaign. Which merge join kind should the analyst use with Customers as the first table?
Correct answer: A. Left anti
A left anti join returns only rows from the first table that have no match in the second, which is exactly the customers without orders. A left outer join returns all customers, including those who have orders.
A left anti join returns only rows from the first table that have no match in the second, which is exactly the customers without orders. A left outer join returns all customers, including those who have orders.
Question 24Model the Data
Litware has a measure defined as CALCULATE([Sales], Product[Color] = "Red"). When a user selects Blue in a Color slicer, the measure still shows red sales. The team wants it to return blank unless Red is selected. What should the analyst do?
Correct answer: B. Wrap the filter in KEEPFILTERS
A boolean filter in CALCULATE replaces any existing filter on Product[Color], so the slicer is ignored. KEEPFILTERS intersects the new filter with the slicer, so a Blue selection leaves no rows and the measure returns blank.
A boolean filter in CALCULATE replaces any existing filter on Product[Color], so the slicer is ignored. KEEPFILTERS intersects the new filter with the slicer, so a Blue selection leaves no rows and the measure returns blank.
Question 25Visualize & Analyze
Adatum's line chart shows monthly sales. Managers want a horizontal line at the fixed sales target of 2 million so they can see which months fall short. What should the analyst add from the Analytics pane?
Correct answer: A. A Y-axis constant line
A Y-axis constant line draws a horizontal reference at a fixed value such as the target. An average line moves with the data and shows the mean, not the fixed target.
A Y-axis constant line draws a horizontal reference at a fixed value such as the target. An average line moves with the data and shows the mean, not the fixed target.
Question 26Prepare the Data
A Wide World Importers analyst needs a new column that extracts the initials from a FullName column. The analyst does not know M and wants Power Query to infer the logic from a few typed sample values. What should the analyst use?
Correct answer: C. Column From Examples
Column From Examples lets you type the expected output for a few rows, and Power Query generates the M transformation. A custom column requires you to write the M formula yourself.
Column From Examples lets you type the expected output for a few rows, and Power Query generates the M transformation. A custom column requires you to write the M formula yourself.
Question 27Model the Data
A Margie's Travel analyst who is new to DAX needs a running total of bookings by month. The analyst wants Power BI to generate the DAX from a guided dialog. What should the analyst use?
Correct answer: B. A quick measure
Quick measures provide templates such as running total and generate the DAX measure from the fields you choose. A calculated column is computed per row at refresh and cannot respond to the month context in a visual.
Quick measures provide templates such as running total and generate the DAX measure from the fields you choose. A calculated column is computed per row at refresh and cannot respond to the month context in a visual.
Question 28Visualize & Analyze
Margie's Travel wants a line chart of weekly bookings to project the next 12 weeks with a confidence interval that accounts for seasonality. What should the analyst use?
Correct answer: D. Forecast in the Analytics pane
The forecast option on a line chart with a continuous date axis projects future values with a confidence interval and can account for seasonality. A trend line fits a straight line through existing points and does not model seasonality or project ahead with a range.
The forecast option on a line chart with a continuous date axis projects future values with a confidence interval and can account for seasonality. A trend line fits a straight line through existing points and does not model seasonality or project ahead with a range.
Question 29Manage & Secure
Adatum's semantic model is in a workspace on shared capacity, and its users have Power BI Pro licenses. The business wants the imported data refreshed every hour, 24 times a day. What should the analyst recommend?
Correct answer: A. Move the workspace to a Fabric or Premium capacity
Shared capacity with Pro allows up to 8 scheduled refreshes per day, while Fabric and Premium capacities allow up to 48. Incremental refresh shortens each refresh but does not raise the daily limit.
Shared capacity with Pro allows up to 8 scheduled refreshes per day, while Fabric and Premium capacities allow up to 48. Incremental refresh shortens each refresh but does not raise the daily limit.
Question 30Prepare the Data
Contoso's flat Sales query includes ProductID, ProductName, and Category on every row. The analyst wants a Product dimension with one row per ProductID that automatically picks up any cleaning steps added to Sales later. What should the analyst do?
Correct answer: B. Reference Sales, keep product columns, remove duplicates
A referenced query starts from the output of Sales, so later changes to Sales flow into the dimension, and removing duplicates on ProductID leaves one row per product. A duplicated query copies the steps as they are now and would not pick up future changes.
A referenced query starts from the output of Sales, so later changes to Sales flow into the dimension, and removing duplicates on ProductID leaves one row per product. A duplicated query copies the steps as they are now and would not pick up future changes.
Question 31Model the Data
Proseware's analyst wants to write EVALUATE statements in Power BI Desktop to test a measure's results by product before adding the measure to a report. Which feature should the analyst use?
Correct answer: A. DAX query view
DAX query view lets you write and run DAX queries, such as EVALUATE with SUMMARIZECOLUMNS, against the model and even define or update measures. The Advanced Editor edits M queries for data preparation and cannot run DAX.
DAX query view lets you write and run DAX queries, such as EVALUATE with SUMMARIZECOLUMNS, against the model and even define or update measures. The Advanced Editor edits M queries for data preparation and cannot run DAX.
Question 32Visualize & Analyze
Lucerne Publishing added a Q&A visual so managers can type questions. Managers type the word revenue, but the model column is called SalesAmount, and Q&A returns poor results. What should the analyst do?
Correct answer: D. Add a synonym for SalesAmount
Synonyms teach Q&A that revenue refers to SalesAmount, so typed questions resolve to the right field. Renaming the page has no effect on how Q&A interprets field names.
Synonyms teach Q&A that revenue refers to SalesAmount, so typed questions resolve to the right field. Renaming the page has no effect on how Q&A interprets field names.
Question 33Manage & Secure
Woodgrove Bank's analyst created a static RLS role named Europe in Power BI Desktop. Before publishing, the analyst wants to see the report exactly as a member of the Europe role would see it. What should the analyst use?
Correct answer: A. View as the Europe role
View as on the Modeling tab applies the chosen role's filters to the report in Power BI Desktop so you can verify what members will see. The Manage roles dialog is where filters are defined, but it does not preview the result.
View as on the Modeling tab applies the chosen role's filters to the report in Power BI Desktop so you can verify what members will see. The Manage roles dialog is where filters are defined, but it does not preview the result.
Question 34Prepare the Data
Fourth Coffee combines store lists from two systems whose StoreCode values overlap. The analyst needs a unique integer key column on the combined Store dimension that can later be merged into the fact table. What should the analyst add in Power Query?
Correct answer: C. An Index column starting at 1
An Index column assigns a sequential integer to every row, giving the combined dimension a unique surrogate key. Duplicating StoreCode keeps the overlapping values, so the key would still not be unique.
An Index column assigns a sequential integer to every row, giving the combined dimension a unique surrogate key. Duplicating StoreCode keeps the overlapping values, so the key would still not be unique.
Question 35Model the Data
Relecloud's model has 25 date columns across its tables, and the file is larger than expected. The model already has a marked Date table that is used for all time analysis. Which change will reduce the model size?
Correct answer: A. Disable Auto date/time
Auto date/time creates a hidden date table for each date column, which adds size and is not needed when a marked Date table exists. Converting date columns to Text would break date filtering and relationships without a real size benefit.
Auto date/time creates a hidden date table for each date column, which adds size and is not needed when a marked Date table exists. Converting date columns to Text would break date filtering and relationships without a real size benefit.
Question 36Visualize & Analyze
Woodgrove Bank wants a text area on a report page that automatically summarizes key trends in the visuals and updates when users apply filters, without anyone writing the text manually. Which visual should the analyst add?
Correct answer: D. Smart narrative
The smart narrative visual generates text that describes trends and key values and refreshes as filters change. A Q&A visual answers typed questions with charts rather than writing a summary.
The smart narrative visual generates text that describes trends and key values and refreshes as filters change. A Q&A visual answers typed questions with charts rather than writing a summary.
Question 37Prepare the Data
Margie's Travel has a large query that loads a historical currency table that never changes. The analyst wants clicking Refresh in Power BI Desktop to skip this query while still keeping the table in the model. What should the analyst do?
Correct answer: B. Clear Include in report refresh
Clearing Include in report refresh keeps the loaded table in the model but skips it when the report is refreshed. Clearing Enable load would remove the table from the model entirely.
Clearing Include in report refresh keeps the loaded table in the model but skips it when the report is refreshed. Clearing Enable load would remove the table from the model entirely.
Question 38Model the Data
Wide World Importers tries to create a one-to-many relationship from Customer to Sales on CustomerID, but Power BI only allows many-to-many. The Customer table should have one row per customer. What is the most likely cause?
Correct answer: C. Duplicate CustomerID values in Customer
The one side of a relationship needs unique values, so duplicates in Customer[CustomerID] force many-to-many. Duplicates in Sales are expected on the many side and do not prevent a one-to-many relationship.
The one side of a relationship needs unique values, so duplicates in Customer[CustomerID] force many-to-many. Duplicates in Sales are expected on the many side and do not prevent a one-to-many relationship.
Question 39Visualize & Analyze
Contoso's analysts use Power BI Pro in workspaces on shared capacity. They want to use Copilot in Power BI to draft report pages and summarize data, and the administrator has enabled the Copilot tenant setting. What else does Contoso need?
Correct answer: B. A paid Fabric capacity
Copilot in Power BI runs on paid Fabric capacity, such as an F SKU, so the content or users must be linked to a capacity rather than shared capacity alone. Endorsement, storage mode and labels do not enable Copilot.
Copilot in Power BI runs on paid Fabric capacity, such as an F SKU, so the content or users must be linked to a capacity rather than shared capacity alone. Endorsement, storage mode and labels do not enable Copilot.
Question 40Manage & Secure
Lamna Healthcare's HR model contains a Salary column. Users in the Analysts role must not be able to see or query the column at all, while HR users can. Hiding the column is not enough. What should the analyst implement?
Correct answer: D. Object-level security
Object-level security secures tables or columns for specific roles, so the Salary column is removed from metadata and queries for Analysts. Row-level security filters rows but still exposes every column.
Object-level security secures tables or columns for specific roles, so the Salary column is removed from metadata and queries for Analysts. Row-level security filters rows but still exposes every column.
Question 41Prepare the Data
Relecloud's query against Azure SQL Database adds an Index column and then filters to the current year. Refresh is slow, and View Native Query is unavailable on the filter step. What should the analyst do to restore folding?
Correct answer: B. Filter before adding the Index
Adding an Index column usually breaks folding, so every later step runs in Power Query on all rows. Filtering first lets the filter fold to SQL and reduces the rows before the Index is added, while Table.Buffer prevents folding rather than restoring it.
Adding an Index column usually breaks folding, so every later step runs in Power Query on all rows. Filtering first lets the filter fold to SQL and reduces the rows before the Index is added, while Table.Buffer prevents folding rather than restoring it.
Question 42Model the Data
Northwind Traders wants a calculated column in the Product table that shows how many sales rows each product has, for use in a slicer of popular products. A one-to-many relationship exists from Product to Sales. Which expression should the column use?
Correct answer: C. COUNTROWS(RELATEDTABLE(Sales))
RELATEDTABLE returns the Sales rows related to the current product row, and COUNTROWS counts them. COUNTROWS(Sales) alone gets no filter from the row context, so every product would show the total number of sales rows.
RELATEDTABLE returns the Sales rows related to the current product row, and COUNTROWS counts them. COUNTROWS(Sales) alone gets no filter from the row context, so every product would show the total number of sales rows.
Question 43Visualize & Analyze
A Coho Winery analyst needs a running sum of monthly sales in one matrix only. The team does not want to add another measure to the semantic model. What should the analyst use?
Correct answer: A. A visual calculation
Visual calculations are DAX calculations stored on a single visual, and RUNNINGSUM works over the visual's own rows, so nothing is added to the model. A quick measure creates a new measure in the semantic model.
Visual calculations are DAX calculations stored on a single visual, and RUNNINGSUM works over the visual's own rows, so nothing is added to the model. A quick measure creates a new measure in the semantic model.
Question 44Prepare the Data
Adatum's finance team drops a new CSV file with the same columns into a SharePoint folder each month. The report must include every file automatically after each refresh. What should the analyst do?
Correct answer: D. Use SharePoint folder and Combine Files
The SharePoint folder connector lists every file in the folder, and Combine Files applies the same transformations to each file and appends the results, including new files after refresh. Importing files one by one would need a new query every month.
The SharePoint folder connector lists every file in the folder, and Combine Files applies the same transformations to each file and appends the results, including new files after refresh. Importing files one by one would need a new query every month.
Question 45Model the Data
Adatum wants a measure that shows sales for the three months ending on the latest date in the current filter context, for a line chart by month. The model has a marked Date table. Which filter should CALCULATE use?
Correct answer: A. DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -3, MONTH)
DATESINPERIOD returns the dates from the last visible date back three months, which gives a rolling three-month window at each point. PARALLELPERIOD with -3 returns one whole month three months earlier rather than the three months leading up to the current date.
DATESINPERIOD returns the dates from the last visible date back three months, which gives a rolling three-month window at each point. PARALLELPERIOD with -3 returns one whole month three months earlier rather than the three months leading up to the current date.
Question 46Visualize & Analyze
A Proseware manager sees a large jump in sales between March and April in a column chart. The manager wants Power BI to quickly identify which categories contributed most to the change, without building new visuals. What should the manager use?
Correct answer: C. Analyze > Explain the increase
Right-clicking a data point and choosing Analyze > Explain the increase runs an analysis that shows which categories drove the change. Find anomalies flags unusual points in a time series but does not compare two selected periods.
Right-clicking a data point and choosing Analyze > Explain the increase runs an analysis that shows which categories drove the change. Find anomalies flags unusual points in a time series but does not compare two selected periods.
Question 47Manage & Secure
Relecloud's marketing analysts work in a different workspace and need to create their own reports from the Sales semantic model. They must not be able to edit content in the Sales workspace. What should the model owner grant?
Correct answer: D. Build permission on the semantic model
Build permission lets users create reports from the semantic model in other workspaces or in Power BI Desktop without workspace edit rights. The Contributor role would let them change content in the Sales workspace.
Build permission lets users create reports from the semantic model in other workspaces or in Power BI Desktop without workspace edit rights. The Contributor role would let them change content in the Sales workspace.
Question 48Prepare the Data
A Tailwind Traders query imports a postal code column with values such as 02134 and K1A 0B1. Power Query auto-detected the column as Whole Number, so leading zeros are lost and the Canadian codes show errors. What should the analyst do?
Correct answer: D. Edit the Changed Type step to use Text
Changing the type to Text in the original Changed Type step keeps the values exactly as they arrive from the source. A later Text conversion runs after the Whole Number step has already dropped the zeros and created errors, so it cannot restore them.
Changing the type to Text in the original Changed Type step keeps the values exactly as they arrive from the source. A later Text conversion runs after the Whole Number step has already dropped the zeros and created errors, so it cannot restore them.
Question 49Model the Data
Lamna Healthcare's MonthName column in the Date table sorts alphabetically in visuals, so April appears before January. The table also has a MonthNumber column. What should the analyst do?
Correct answer: B. Set Sort by column on MonthName to MonthNumber
Sort by column makes MonthName follow MonthNumber in every visual, so months appear in calendar order. Sorting each visual by MonthName still sorts the text alphabetically.
Sort by column makes MonthName follow MonthNumber in every visual, so months appear in calendar order. Sorting each visual by MonthName still sorts the text alphabetically.
Question 50Visualize & Analyze
Alpine Ski House wants a report page to always show the last 30 days of lift sales, moving forward automatically each day without anyone editing the filter. What should the analyst configure?
Correct answer: C. A relative date filter
A relative date filter or slicer set to the last 30 days recalculates the range from today every time the report runs. A between slicer stores fixed start and end dates that someone must update.
A relative date filter or slicer set to the last 30 days recalculates the range from today every time the report runs. A between slicer stores fixed start and end dates that someone must update.
The real PL-300 exam at a glance
50questions
1h 40mtime limit
MCQmultiple choice
75%+aim for here
Score 75% or more on two different sets before you book the real exam. Need a plan for your weak topics? See how we help you pass, or get a full refund.
More free Microsoft Azure & Power BI practice tests
AZ-900 Practice Test50 questions · Azure FundamentalsAZ-104 Practice Test50 questions · Azure AdministratorAZ-305 Practice Test50 questions · Azure Solutions ArchitectAZ-400 Practice Test50 questions · Azure DevOps Engineer
See all 36 free practice tests →
Original practice questions written by CertOcean in the style of the PL-300 exam. They are not real exam questions. PL-300 and Microsoft are trademarks of their owners. Real exam format: usually 40-60 questions · 100 minutes · passing score 700 on a 1-1000 scale · the real exam can include case studies.