Courseiva

Microsoft Power BI Data Analyst PL-300 (PL-300) — Questions 601–675

966 questions total · 13pages · All types, answers revealed

Take a mock examExam hub
Page 8

Page 9 of 13

Page 10
601
Multi-Selectmedium

You are designing a Power BI data model for a sales analysis. The model includes a table named Sales with columns: OrderID, OrderDate, CustomerID, ProductID, Quantity, UnitPrice. You need to create a star schema. Which TWO tables should you create as dimension tables?

Select 2 answers
A.Calendar
B.Product
C.Sales
D.Orders
E.Customer
AnswersB, E

Product is a dimension containing descriptive attributes about products.

Why this answer

In a star schema, dimension tables contain descriptive attributes that provide context for the measures stored in the fact table. Product is a classic dimension because it holds product details (e.g., name, category) that describe the sales facts. Customer is also a dimension because it stores customer attributes (e.g., name, region) used for slicing and dicing sales data.

Exam trap

The trap here is that candidates often mistake the Sales table (which contains both measures and foreign keys) as a dimension table, or they incorrectly think Orders should be a dimension instead of recognizing it as part of the fact table's grain.

Full explanation →
602
Multi-Selectmedium

Which TWO of the following are valid reasons to use a calculated table in Power BI instead of a table from the source?

Select 2 answers
A.To create a bridge table for many-to-many relationships
B.To aggregate data from the source before loading
C.To create a date table for time intelligence
D.To enable incremental data refresh
E.To reduce the overall storage size of the model
AnswersA, C

Bridge tables are often created as calculated tables.

Why this answer

Options B and D are correct. Calculated tables can be used to create a date table or to create a bridge table for many-to-many relationships. Option A is wrong because calculated tables cannot be incremental refreshed.

Option C is wrong because calculated tables are stored in the model, not to reduce storage. Option E is wrong because calculated tables are not for aggregating data at source; they are created in the model.

Full explanation →
603
MCQhard

Your organization is deploying Power BI content to multiple stages (dev, test, prod) using deployment pipelines. You need to ensure that test data is not visible to production users. What is the best approach?

A.Manually replace the dataset in the production workspace after deployment.
B.Apply row-level security to filter test data in production.
C.Create separate Power BI tenants for each stage.
D.Use deployment pipelines with separate datasets per stage and configure data source parameters to point to different databases.
AnswerD

This automates environment separation.

Why this answer

Option B is correct because deployment pipelines allow assigning different datasets to different stages. Option A is wrong because it's manual. Option C is wrong because RLS is for within a dataset, not between stages.

Option D is wrong because it's inefficient.

Full explanation →
604
MCQmedium

You are creating a Power BI dataset from a SQL Server data warehouse. The warehouse contains a fact table with 500 million rows and dimension tables. You need to minimize the data refresh time while ensuring that the dataset meets the reporting requirements. Which approach should you recommend?

A.Create a composite model using DirectQuery for the fact table and Import for dimensions.
B.Use DirectQuery mode for the dataset.
C.Configure incremental refresh on the fact table.
D.Use Import mode but filter rows and reduce columns in Power Query to only those needed.
AnswerD

Importing only necessary data reduces the amount of data loaded, directly decreasing refresh time while still supporting fast query performance.

Why this answer

Option D is correct because importing only the necessary columns and rows reduces the data volume, which directly minimizes refresh time. With 500 million rows, Import mode is generally faster than DirectQuery for large fact tables in Power BI, as it avoids querying the source on every interaction. Filtering and column reduction in Power Query ensures the dataset remains lean while meeting reporting requirements.

Exam trap

The trap here is that candidates often choose incremental refresh (Option C) thinking it always reduces refresh time, but it does not address the initial full load or the need to minimize data volume; the key is to reduce the data imported, not just partition it.

How to eliminate wrong answers

Option A is wrong because a composite model with DirectQuery on the fact table would still require live queries against 500 million rows, leading to slow report performance and potential timeouts, not minimizing refresh time. Option B is wrong because DirectQuery mode does not have a refresh process; it queries the source on demand, which would be extremely slow for a 500-million-row fact table and does not reduce data transfer. Option C is wrong because incremental refresh only partitions the fact table for scheduled refreshes, but it still requires importing all historical data initially and does not minimize the initial or ongoing refresh time as effectively as reducing the data volume.

Full explanation →
605
Multi-Selectmedium

Which TWO of the following are best practices for designing a Power BI data model?

Select 2 answers
A.Use a star schema to reduce model complexity.
B.Use surrogate keys in dimension tables to link to fact tables.
C.Store dimension attributes directly in fact tables for faster queries.
D.Enable bi-directional cross-filtering on all relationships.
E.Create calculated columns instead of Power Query transformations when possible.
AnswersA, B

Star schema is the recommended design.

Why this answer

Options A and D are correct. Option A: Using a star schema reduces complexity. Option D: Using surrogate keys improves performance and stability.

Option B is wrong because bi-directional cross-filtering can cause ambiguity. Option C is wrong because storing full names in the fact table increases size. Option E is wrong because calculated columns are less efficient than Power Query.

Full explanation →
606
MCQmedium

You are a data analyst for a retail company. You receive daily sales data in CSV files stored in an Azure Blob Storage container. The files have a consistent naming convention: Sales_YYYYMMDD.csv. You need to load only the latest file into Power BI each day, using Power Query. You want to automate this process so that each time you refresh the dataset, it picks up the most recent file. You have already created a connection to the container. What should you do in Power Query to ensure only the latest file is loaded?

A.Use 'From Azure Blob Storage' and filter by last modified date.
B.Use 'Combine Files' and then filter to the latest date.
C.Use 'From Folder' connector, filter by creation date to keep only the latest file.
D.Create a parameter for the file name and update it manually.
AnswerC

Automatically picks latest file on refresh.

Why this answer

Option C is correct because the 'From Folder' connector in Power Query allows you to connect to a folder (including Azure Blob Storage containers mapped as folders) and then filter files by creation date or last modified date. By filtering to keep only the latest file, you ensure that each refresh loads the most recent CSV without manual intervention. This approach fully automates the process, as Power Query will evaluate the filter each time the query refreshes.

Exam trap

The trap here is that candidates often confuse 'From Azure Blob Storage' with 'From Folder', not realizing that 'From Folder' provides direct access to file metadata like creation date, which is essential for filtering to the latest file, while the blob storage connector is more suited for direct file selection without metadata filtering.

How to eliminate wrong answers

Option A is wrong because 'From Azure Blob Storage' connector in Power Query does not natively support filtering by last modified date within the connector itself; it requires additional steps like listing blobs and filtering via Power Query functions, which is less direct than using 'From Folder'. Option B is wrong because 'Combine Files' is used to merge multiple files into a single table, not to select a single latest file; filtering after combining would still process all files, defeating the purpose of loading only the latest. Option D is wrong because creating a parameter for the file name and updating it manually defeats the automation requirement; the goal is to pick the latest file automatically without manual intervention.

Full explanation →
607
MCQeasy

You need to create a hierarchy in Power BI that allows drilling down from Year to Quarter to Month. What is the correct approach?

A.Create separate measures for each level
B.Use the Drillthrough feature
C.Use the DATESYTD function
D.Create a hierarchy in the Date table using Year, Quarter, Month columns
AnswerD

Hierarchies enable drill-down in visuals.

Why this answer

Option C is correct because creating a hierarchy in the Date table using these columns enables drill-down. Option A does not create a hierarchy. Option B is a DAX function.

Option D is not a hierarchy.

Full explanation →
608
MCQmedium

Your organization uses Power BI with large datasets from Azure Synapse Analytics. You need to reduce model size and improve query performance. You decide to use aggregations. Which type of aggregation table is most appropriate for pre-aggregating data at the year and category level?

A.Calculated table
B.Table-based aggregation
C.Measure-based aggregation
D.In-memory aggregation
AnswerB

Table-based aggregations store pre-aggregated data.

Why this answer

Option B is correct because a table-based aggregation stores precomputed summaries in a separate table, commonly used for large datasets. Option A is not a standard aggregation type. Option C is incorrect because calculated tables are computed at refresh time and not pre-aggregated for performance.

Option D is incorrect because measures are not stored.

Full explanation →
609
MCQmedium

A company has a Power BI dataset that imports data from a SQL Server database. The dataset includes a table with 10 million rows. The data model uses a single table and does not include any calculated columns or measures. The report users report that the dataset refresh takes too long. Which action should you take to improve refresh performance?

A.Increase the scheduled refresh frequency to every 15 minutes.
B.Enable Query Folding on all steps in Power Query.
C.Change the storage mode to DirectQuery.
D.Remove unused columns from the table in Power Query.
AnswerD

Reduces data volume and improves refresh speed.

Why this answer

Removing unused columns from the table in Power Query reduces the amount of data loaded into the Power BI dataset. With 10 million rows, every unnecessary column adds significant I/O and memory overhead during refresh. This directly improves refresh performance by minimizing the data volume transferred and processed.

Exam trap

The trap here is that candidates often confuse refresh performance with query performance, leading them to choose DirectQuery (Option C) which solves query latency but does not improve the import refresh time that the question explicitly targets.

How to eliminate wrong answers

Option A is wrong because increasing the scheduled refresh frequency to every 15 minutes does not improve the performance of a single refresh; it only makes refreshes happen more often, which could actually increase load on the source system. Option B is wrong because Query Folding pushes transformations back to the SQL Server, but the question states the dataset imports data from SQL Server and has no calculated columns or measures; enabling Query Folding on all steps is not a guaranteed performance improvement if the steps are already foldable, and it does not address the core issue of a large single table with 10 million rows. Option C is wrong because changing the storage mode to DirectQuery would avoid importing the data, but it shifts performance burden to query-time latency and is not a refresh performance improvement; the question specifically asks about improving dataset refresh time, not report query performance.

Full explanation →
610
MCQhard

Refer to the exhibit. You are reviewing a Power BI data source privacy configuration. The SalesSQL data source is set to 'Organizational' and the MarketingCSV is set to 'Private'. You plan to combine these two sources in a query. What will happen when the query is executed?

A.The query will succeed, but the MarketingCSV data will be treated as Organizational.
B.The query will succeed without any restrictions because the combine is allowed between Organizational and Private.
C.The query will fail with a privacy level error because the levels are incompatible.
D.The query will succeed, but the combination may be blocked or data may be limited to protect the Private source.
AnswerD

Power BI will restrict data flow to prevent the Private source from being exposed to the Organizational source.

Why this answer

Option C is correct because when combining an Organizational source with a Private source, Power BI restricts data propagation to protect the Private source. The Organizational data will be limited to what can be sent to the Private source, potentially causing performance degradation or blocking the combine operation. Option A is wrong because the combination is not entirely blocked, but limited.

Option B is wrong because the Private level does not override the Organizational; instead, the most restrictive applicable rules apply. Option D is wrong because the combine is not allowed at full speed.

Full explanation →
611
Multi-Selecthard

Which TWO of the following actions can be performed by a user who has the 'Contributor' role on a Power BI workspace?

Select 2 answers
A.Update the workspace description.
B.Create new reports and dashboards in the workspace.
C.Share a report with other users.
D.Delete the workspace.
E.Add new members to the workspace.
AnswersB, C

Contributors can create content.

Why this answer

Options B and C are correct. Contributors can create and edit content in the workspace, and they can share items (like reports) with others if sharing is enabled by the admin. Option A is wrong because only admins can update the workspace description.

Option D is wrong because only admins can add members to the workspace. Option E is wrong because only admins can delete the workspace.

Full explanation →
612
Multi-Selecthard

Which THREE of the following are valid ways to share a Power BI report with users who do not have a Power BI Pro license? (Select THREE.)

Select 3 answers
A.Embed the report in a secure portal or website using the embed option for internal users.
B.Share the report directly from the Power BI service by entering the user's email address.
C.Export the report to PowerPoint or PDF and share the file.
D.Publish the report to the web (public) and share the link.
E.Publish the report to a Power BI Premium capacity workspace and grant viewer access.
AnswersA, C, E

Embedding in a portal can allow access without Pro if the capacity is Premium.

Why this answer

Options A, C, and E are correct. Option B is wrong because sharing via email requires Pro. Option D is wrong because publishing to web makes report public, which may not be desired.

Full explanation →
613
MCQmedium

An organization uses Power BI with Microsoft Purview Information Protection. A report contains sensitive customer data. The administrator wants to ensure that when the report is exported to Excel, the sensitivity label is automatically applied. What must be configured?

A.Configure the Excel workbook to inherit the label from Power BI
B.Enable auto-labeling in the Power BI admin settings and configure the sensitivity label policy
C.Use row-level security to restrict access to sensitive data
D.Require users to manually apply a sensitivity label before exporting
AnswerB

Auto-labeling automatically applies labels based on policy.

Why this answer

Option B is correct because Power BI supports automatic sensitivity labeling based on data classification, which can propagate to exports. Option A is wrong because manual labeling is not automatic. Option C is wrong because RLS does not affect labeling.

Option D is wrong because the label is applied by Power BI, not Excel.

Full explanation →
614
MCQeasy

You want to create a Power BI report that allows users to ask questions in natural language and get visual answers. Which feature should you enable?

A.Q&A visual
B.Key influencers visual
C.Copilot for Power BI
D.Decomposition tree
AnswerA

Correct. Q&A allows natural language queries.

Why this answer

Option C is correct because Q&A (natural language query) allows users to ask questions. Option A is wrong because Copilot is for AI assistance, but not specifically for natural language queries in reports. Option B is wrong because Key influencers is a visual for analysis.

Option D is wrong because Decomposition tree is for hierarchical drill-down.

Full explanation →
615
MCQhard

Refer to the exhibit. You have a DAX measure that ranks products by sales amount. When you add this measure to a table visual with ProductID and Sales Amount, you notice that the rank resets for each year when you add a Year slicer. What should you modify to ensure ranking is always across all products regardless of slicer?

A.Change ALL to ALLSELECTED(Sales[ProductID])
B.Change ALL to ALLEXCEPT(Sales, Sales[Year])
C.Change ALL to ALL(Sales) and add a filter to ignore year
D.Change ALL to VALUES(Sales[ProductID])
AnswerC

ALL(Sales) removes all filters; you can then add a filter to keep only needed context.

Why this answer

Option A is correct because ALL removes all filters, but if you want to ignore the year slicer, you need to use ALLSELECTED or modify to ALL(Product[ProductID]) but also use ALL to ignore year filter. Option B is wrong because ALLSELECTED respects slicer selection. Option C is wrong because VALUES respects filters.

Option D is wrong because ALLNOBLANKROW is similar to ALL.

Full explanation →
616
Multi-Selectmedium

Which TWO of the following are best practices for modeling many-to-many relationships in Power BI?

Select 2 answers
A.Use a bridge table to resolve the many-to-many relationship
B.Set cross-filter direction to both for all relationships
C.Use a composite model with DirectQuery for one of the tables
D.Use a measure that iterates over the bridge table with SUMX
E.Create a calculated table that combines the two tables
AnswersA, D

A bridge table is the standard approach.

Why this answer

Option A and C are correct. Option A is correct because a bridge table normalizes many-to-many relationships. Option C is correct because using a measure with SUMX and a bridge table is a common pattern.

Option B is wrong because bidirectional filtering can cause ambiguity. Option D is wrong because composite models are not specifically for many-to-many. Option E is wrong because ignoring the relationship is not a solution.

Full explanation →
617
MCQhard

You are analyzing a DAX query. What is the purpose of the 'Filter Context' column in the result?

A.It returns the total sales for the current year, ignoring category.
B.It returns the total number of sales rows regardless of product category.
C.It returns the number of product categories in the current context.
D.It counts the number of distinct products in the current filter context.
AnswerB

ALL('Product') removes product filter, so count is overall.

Why this answer

Option D is correct. CALCULATE(COUNTROWS('Sales'), ALL('Product')) counts all sales rows ignoring any filter on the Product table. This is useful to compare category-level sales against total sales.

Option A is wrong because it does not count distinct products. Option B is wrong because it does not filter by current year. Option C is wrong because it counts sales rows, not product rows.

Full explanation →
618
MCQeasy

You are merging two tables in Power Query: Orders and Customers. The Orders table has a CustomerID column, and the Customers table has a CustomerID column. You want to keep all rows from Orders and only matching rows from Customers. Which join kind should you use?

A.Full Outer
B.Inner
C.Left Outer
D.Right Outer
AnswerC

Left outer join preserves all rows from the left table.

Why this answer

Option C (Left Outer) is correct because it returns all rows from the Orders table regardless of whether a matching CustomerID exists in the Customers table. When no match is found, the Customers columns will contain null values. This is the standard behavior for a left outer join in Power Query, which preserves the left table's rows entirely.

Exam trap

The trap here is that candidates often confuse Left Outer with Right Outer, mistakenly thinking that 'keeping all rows from Orders' means the Orders table should be on the right side, when in Power Query the join direction is determined by which table is selected as the primary table in the Merge dialog.

How to eliminate wrong answers

Option A is wrong because a Full Outer join would return all rows from both tables, including unmatched rows from both sides, which is not what the requirement specifies. Option B is wrong because an Inner join would only return rows where CustomerID exists in both tables, discarding any Orders rows without a matching Customer in Customers. Option D is wrong because a Right Outer join would keep all rows from Customers and only matching rows from Orders, which is the opposite of the stated requirement.

Full explanation →
619
Multi-Selectmedium

Which TWO actions can improve the performance of a Power BI report that uses DirectQuery?

Select 2 answers
A.Create calculated columns instead of measures.
B.Push transformations to the data source.
C.Reduce the number of columns in the query.
D.Use bidirectional cross-filtering.
E.Increase cross-filter direction to both.
AnswersB, C

Reduces load on Power BI.

Why this answer

Options A and D are correct. Reducing columns reduces data transfer; setting bidirectional cross-filtering can cause performance issues, but increasing it is not recommended; using calculated columns in DirectQuery is slow; you should push transformations to the source. Option B is wrong because bidirectional cross-filtering can degrade performance.

Option C is wrong because calculated columns are evaluated row-by-row in DirectQuery. Option E is wrong because increasing cross-filtering direction adds complexity.

Full explanation →
620
Multi-Selectmedium

Which TWO actions are required to enable Microsoft Copilot for Power BI in your tenant? (Choose two.)

Select 2 answers
A.Deploy a custom Azure OpenAI model.
B.Enable the 'Allow Copilot for Power BI' tenant setting.
C.Configure Azure OpenAI Service in your tenant.
D.Ensure your Power BI capacity is in a supported region.
E.Assign a Microsoft Copilot for Microsoft 365 license to each user.
AnswersB, D

This setting is required to activate Copilot.

Why this answer

Options A and D are correct. Copilot for Power BI requires enabling the tenant setting 'Allow Copilot for Power BI' and ensuring that the capacity is in a supported region. Option B is incorrect because a separate Copilot license is not required; it is included with premium.

Option C is incorrect because Microsoft 365 Copilot is not required. Option E is incorrect because Copilot uses Azure OpenAI, but you do not need to deploy it yourself.

Full explanation →
621
MCQhard

You are designing a Power BI data model for a retail chain. You have three fact tables: Sales, Inventory, and Returns. Which modeling approach is best for cross-filtering between these facts?

A.Use calculated columns to link facts
B.Use role-playing dimensions
C.Merge all fact tables into one
D.Create separate dimensions for each fact table
AnswerB

Role-playing dimensions allow multiple facts to share the same dimension tables.

Why this answer

Option B is correct because role-playing dimensions allow sharing common dimensions like Date, Product, Store. Option A causes ambiguity. Option C is not a standard approach.

Option D is unnecessary if dimensions are shared.

Full explanation →
622
MCQmedium

You are working on a Power BI project for a marketing department. You have a CSV file with customer survey responses. The file contains columns: CustomerID, SurveyDate, Response (text with ratings from 1 to 5), Comments (free text). The file is 10 MB. You need to load the data into Power BI and create a measure that calculates the average rating. However, when you load the file, you notice that the Response column is imported as text instead of whole number. Also, there are some rows with missing values in the Response column. You need to ensure the data is correctly typed and handle missing values appropriately. What is the best approach?

A.Use the 'Column from Examples' feature to create a new column with numeric values.
B.In Power Query, split the Response column by delimiter and then use the first part.
C.Use a DAX calculated column to convert text to number.
D.Change the data type of Response to whole number in Power Query, then filter out or replace null values.
AnswerD

Directly resolves the type issue and handles nulls.

Why this answer

Option D is correct because Power Query is the designated tool for data type transformations and null handling during the load phase. Changing the Response column's data type to Whole Number in Power Query automatically converts valid text numbers and flags errors, while filtering out or replacing null values ensures clean data before the data model is built. This approach follows the best practice of performing data cleansing in Power Query rather than in DAX, which would add unnecessary overhead and complexity.

Exam trap

The trap here is that candidates often think data type conversion can be done in DAX (Option C) because it seems simpler, but the PL-300 exam emphasizes that Power Query is the correct place for data preparation tasks like type changes and null handling, not the data model layer.

How to eliminate wrong answers

Option A is wrong because the 'Column from Examples' feature is designed for extracting or combining values based on patterns, not for bulk data type conversion; it would be inefficient and error-prone for converting a column of text numbers to numeric values. Option B is wrong because splitting the Response column by delimiter assumes the text contains a delimiter, which is not the case here (the column contains simple ratings like '1' or '5'), and it would create unnecessary columns without solving the type conversion or null handling. Option C is wrong because using a DAX calculated column to convert text to number is possible but is inefficient and violates the principle of performing data type transformations in Power Query; it also does not handle null values in the source data, which would still need to be addressed separately.

Full explanation →
623
MCQmedium

You have a Power BI data model with a fact table and multiple dimension tables. You notice that many-to-many relationships cause ambiguous results. What is the best practice to resolve this?

A.Change the relationship to one-to-one
B.Use a bidirectional cross-filter direction
C.Create a calculated table to merge the dimensions
D.Add a bridge table with appropriate relationships
AnswerD

A bridge table normalizes the many-to-many relationship into two one-to-many relationships.

Why this answer

Option C is correct because introducing a bridge table with a many-to-one relationship to both sides resolves many-to-many ambiguity. Option A changes cardinality but loses data. Option B could cause ambiguity.

Option D is not applicable because a calculated table does not fix relationships.

Full explanation →
624
MCQmedium

You have the above M query. You need to load only the top 10 customers by sales. What should you add to the query?

A.Add a step to use Table.SelectRows with a condition on rank.
B.Add a filter to keep only rows where [Total Sales] is in the top 10 values.
C.Add Table.FirstN(#"Sorted Rows", 10) after sorting.
D.Add a step to use Table.StopAfter(#"Sorted Rows", 10).
AnswerC

Table.FirstN keeps the first N rows after sorting.

Why this answer

The query already sorts by Total Sales descending. To get top 10, you need to add a step to keep the first 10 rows, using Table.FirstN.

Full explanation →
625
MCQhard

You are building a Power BI semantic model that uses a large fact table from a data warehouse. The fact table has a date column and you want to create a date dimension. The organization requires that the date dimension includes all dates from 2010 to 2030, including weekends and holidays. What is the best practice for creating the date dimension?

A.Use the CALENDAR function in DAX to generate the date range
B.Mark the date column from the fact table as a date table and disable Auto Date/Time
C.Create a date dimension by using DISTINCT on the fact table's date column
D.Create a date table in Power Query by generating a list of dates from 1/1/2010 to 12/31/2030 and then add columns for attributes
AnswerD

Power Query can generate a complete date range and allows adding custom columns for holidays.

Why this answer

Option D is correct because it follows the best practice of creating a dedicated date dimension table in Power Query, which ensures full control over the date range (2010–2030) and allows you to add custom attributes like holidays. This approach avoids relying on the fact table's date column, which may have gaps or missing dates, and ensures the date dimension is complete and independent for robust time intelligence calculations.

Exam trap

The trap here is that candidates often choose Option C (DISTINCT on the fact table) thinking it is efficient, but they overlook that it will miss dates with no transactions, violating the requirement to include all weekends and holidays from 2010 to 2030.

How to eliminate wrong answers

Option A is wrong because the CALENDAR function in DAX creates a calculated table that is volatile and recalculates on every refresh, which can degrade performance with large models; it also lacks the ability to easily add custom columns like holidays in Power Query. Option B is wrong because marking a date column from the fact table as a date table is not recommended when the fact table may have missing dates (e.g., weekends or holidays), and disabling Auto Date/Time is a separate setting that does not create a proper date dimension. Option C is wrong because using DISTINCT on the fact table's date column will only include dates that exist in the fact table, which may omit weekends or holidays if no transactions occurred on those days, resulting in an incomplete date dimension.

Full explanation →
626
Multi-Selecthard

Which TWO are best practices for optimizing Power Query performance? (Choose two.)

Select 2 answers
A.Disable the 'Enable background refresh' option in the query settings.
B.Merge tables as early as possible in the query to combine data.
C.Keep all columns in the table to avoid missing data.
D.Filter data as early as possible in the query to reduce row counts.
E.Split columns by delimiter to normalize data.
AnswersA, D

Disabling background refresh can improve performance by preventing simultaneous refreshes.

Why this answer

Option A is correct because disabling 'Enable background refresh' prevents Power Query from running queries in the background while you continue working in Power BI Desktop. This ensures that query execution is synchronous, which can improve performance by avoiding resource contention and allowing you to monitor progress directly. Background refresh can cause delays and unexpected behavior when multiple queries run simultaneously, especially with large data sources.

Exam trap

The trap here is that candidates often confuse data transformation best practices (like merging or splitting columns) with performance optimization techniques, leading them to select options B or E instead of focusing on reducing data volume and controlling query execution.

Full explanation →
627
Multi-Selecthard

Which TWO are valid ways to create a calculated table in Power BI?

Select 2 answers
A.VALUES(Customer[Country])
B.CALCULATE(SUM(Sales[Amount]), ALL(Sales))
C.FILTER(Products, Products[Color] = "Red")
D.CALENDARAUTO()
E.SUMMARIZE(Sales, Sales[ProductID], "Total", SUM(Sales[Amount]))
AnswersD, E

CALENDARAUTO() returns a table of dates.

Why this answer

Option D is correct because `CALENDARAUTO()` is a dedicated DAX function that automatically generates a single-column calculated table containing a contiguous range of dates based on the data model's date columns. This is a standard and valid method for creating a calculated table in Power BI, commonly used for time intelligence calculations.

Exam trap

The trap here is that candidates confuse table functions (like `VALUES`, `FILTER`, and `SUMMARIZE`) that return tables but are not valid standalone calculated table definitions, with the specific requirement that a calculated table must be created using a DAX expression that returns a table object and is assigned directly in the 'Calculated table' dialog.

Full explanation →
628
MCQmedium

You have a Power BI report that shows sales by product category. The report is used by the sales team, who need to see the data at a regional level. You want to allow users to switch between viewing data for all regions and a specific region without creating multiple pages. Which feature should you use?

A.Use bookmarks with a region slicer.
B.Add a tooltip page that shows regional data.
C.Create drillthrough pages for each region.
D.Enable the Q&A visual and let users type the region.
AnswerA

Bookmarks can capture a state with a specific slicer selection and allow switching.

Why this answer

Option B is correct because bookmarks allow you to capture different states of a report page (e.g., with a specific slicer selection) and let users switch between them. Option A is wrong because drillthrough navigates to a different page. Option C is wrong because tooltips show additional info on hover.

Option D is wrong because Q&A is a natural language query feature.

Full explanation →
629
MCQmedium

You are modeling data from multiple sources: a SQL Server database for sales, an Excel file for budget, and a SharePoint list for product targets. You need to combine these into a single Power BI report. What is the recommended approach for handling data refresh?

A.Import each source into separate Power BI Desktop files and manually update.
B.Use Excel Online as the single source and import all data into it first.
C.Use Power Query to combine data from all sources into a single dataset, then schedule a daily refresh in the Power BI service.
D.Create separate datasets for each source and use composite models with DirectQuery.
AnswerC

Power Query can merge data from different sources, and a single refresh is efficient.

Why this answer

Option D is correct because using Power Query to combine data and scheduling a single refresh is efficient. Option A is wrong because live connections are not possible with all sources. Option B is wrong because it duplicates work.

Option C is wrong because Excel Online is not supported for direct refresh.

Full explanation →
630
Multi-Selecteasy

Which TWO of the following are valid methods to share a Power BI report with external users who do not have an internal Microsoft Entra ID account? (Select two.)

Select 2 answers
A.Publish to public web (Publish to web)
B.Deploy the report to Power BI Report Server and configure anonymous access
C.Invite them as guest users in Microsoft Entra ID (B2B)
D.Send them an email subscription with the report attached
E.Embed the report in a SharePoint Online page and share the link
AnswersB, C

Report Server can be configured for external access.

Why this answer

Option B is correct: Use Azure AD B2B guest accounts. Option C is correct: Publish to Power BI Report Server (on-premises) allows anonymous access or forms auth. Option A is wrong: Publish to web makes the report public.

Option D is wrong: Email subscription sends a snapshot, not interactive. Option E is wrong: Embed in SharePoint requires internal users.

Full explanation →
631
MCQmedium

You are developing a Power BI semantic model for an e-commerce company. The source data comes from a CSV file containing order details: OrderID, OrderDate, CustomerID, ProductID, Quantity, UnitPrice, Discount, and ShippingCost. The file is updated daily. You need to model the data to support the following analyses: 1) Total sales amount (Quantity * UnitPrice - Discount) by product and month. 2) Average shipping cost per order by customer region (CustomerRegion is in a separate table). 3) Year-over-year comparison of sales. You need to create the measures and ensure optimal performance. What should you do?

A.Use Power Query to add a calculated column for sales amount and shipping cost per order, then import.
B.Create a single table by appending the customer region to each row in the CSV using Power Query, then import.
C.Use DirectQuery on the CSV file to avoid storing data in Power BI.
D.Import both tables into Power BI, create a date table, and build measures using SUMX and time intelligence.
AnswerD

This leverages in-memory engine and efficient DAX.

Why this answer

Option C is correct because importing the CSV and CustomerRegion table into Power BI and creating a star schema with relationships allows efficient measure calculation. Option A is wrong because calculated columns in source increase storage. Option B is wrong because DirectQuery on CSV is not supported.

Option D is wrong because a flat table with appended customer region would duplicate data.

Full explanation →
632
MCQeasy

You need to create a visual that shows the contribution of each product category to total sales over time. Which visual type is most appropriate?

A.Waterfall chart
B.Stacked area chart
C.Pie chart
D.Scatter plot
AnswerB

Stacked area charts are ideal for showing how categories contribute to a total over time.

Why this answer

Option A is correct because a stacked area chart shows cumulative proportions over time. Option B is wrong because a scatter plot shows correlation, not composition. Option C is wrong because a waterfall chart shows incremental changes, not proportions.

Option D is wrong because a pie chart shows parts of a whole at a single point in time, not over time.

Full explanation →
633
MCQeasy

Your organization uses Microsoft Teams to collaborate on Power BI reports. You need to ensure that only members of a specific team can view a report embedded in a Teams tab. What should you do?

A.Share the report directly with the team in Microsoft Entra ID.
B.Assign the team owner as the report owner.
C.Set the report to 'Public' in the tenant settings.
D.Add the team to the workspace as a 'Member' role.
AnswerA

Direct sharing with the team group grants access.

Why this answer

Option C is correct because sharing the report with the team grants access. Option A is wrong because the report link is publicly accessible. Option B is wrong because app permissions are for workspace access.

Option D is wrong because team owners don't automatically get access.

Full explanation →
634
MCQhard

You are a data analyst at a retail company. You are building a Power BI report to analyze sales performance across stores. The data source is a SQL Server database with a table called 'SalesTransactions' containing 500 million rows. The table has columns: TransactionID, StoreID, ProductID, Quantity, UnitPrice, Discount, TransactionDate. You have imported the data into Power BI using Import mode. The report is slow when users filter by date or store. The initial data load took 45 minutes, and scheduled refreshes are failing because they exceed the 2-hour refresh limit. You need to reduce the refresh time and improve query performance. The business requires that users can see all historical data and that the report is always up-to-date (refreshed daily). What should you do?

A.Create aggregations on the SalesTransactions table.
B.Implement Incremental refresh with a policy to keep the last 5 years of data and detect changes.
C.Switch to DirectQuery mode to avoid data import.
D.Use a live connection to the SQL Server database.
AnswerB

Reduces refresh time and keeps history.

Why this answer

Option B is correct because incremental refresh in Power BI allows you to partition large tables (like 500M rows) into smaller date-based ranges, refreshing only the most recent data (e.g., last 5 years) while keeping historical partitions static. This drastically reduces refresh time and avoids the 2-hour refresh limit, while still meeting the requirement for daily updates and full historical visibility. The 'detect changes' option further optimizes by only refreshing partitions where data has changed.

Exam trap

The trap here is that candidates often choose aggregations (Option A) thinking they solve performance issues, but they fail to realize that aggregations do not reduce the volume of data imported during refresh—only incremental refresh addresses both refresh time and query performance for massive fact tables.

How to eliminate wrong answers

Option A is wrong because creating aggregations improves query performance for summarized queries but does not reduce the data import or refresh time; the full 500M rows still need to be loaded during refresh, so it fails to address the refresh timeout. Option C is wrong because switching to DirectQuery would avoid data import but would result in poor query performance on 500M rows due to live query overhead, and it would not meet the 'always up-to-date' requirement as effectively as incremental refresh with daily scheduling. Option D is wrong because a live connection (DirectQuery to SQL Server) has the same performance drawbacks as DirectQuery and does not reduce refresh time—it eliminates import but shifts performance burden to the source, which is not optimal for large fact tables.

Full explanation →
635
Multi-Selecthard

Which THREE actions can improve query performance in a Power BI DirectQuery model?

Select 3 answers
A.Limit the columns retrieved from the source.
B.Create calculated columns in DAX rather than Power Query.
C.Use pre-aggregated tables in the source.
D.Reduce the number of rows returned by applying filters early.
E.Add more visuals to a single page to reduce page count.
AnswersA, C, D

Fewer columns means less data transferred.

Why this answer

Reducing columns and rows selected reduces data transfer. Increasing the number of visuals on a page can increase the number of queries, hurting performance. Using summarized tables can reduce the amount of data queried.

Creating calculated columns in Power Query (rather than DAX) improves performance because they are materialized at refresh.

Full explanation →
636
MCQhard

Refer to the exhibit. You have a Sales table. You create a measure: TotalSales = SUM(Sales[SalesAmount]). You then create another measure: SalesAboveAverage = CALCULATE([TotalSales], FILTER(Sales, Sales[SalesAmount] > AVERAGE(Sales[SalesAmount]))). What is the value of SalesAboveAverage?

A.1000
B.800
C.450
D.550
AnswerD

Sum of rows where SalesAmount > average (200): 300+250=550.

Why this answer

Option D is correct. The average of SalesAmount is (100+200+300+150+250)/5 = 200. The rows with SalesAmount > 200 are: 300 and 250.

Sum = 550. Option A is wrong because it includes all rows. Option B is wrong because it uses total sum.

Option C is wrong because it includes 200? No, 200 is not > 200. So correct is 550.

Full explanation →
637
MCQeasy

You are connecting Power BI to a SQL Server database. The database contains a table with millions of sales transactions. You need to design a data model that minimizes load time and memory usage while still allowing analysis of sales by date, product, and customer. Which modeling approach should you use?

A.Use a composite model with some tables in DirectQuery and others in Import.
B.Use DirectQuery mode to avoid storing data in Power BI.
C.Import the data into Power BI, creating a star schema with date, product, and customer dimension tables and the sales fact table.
D.Use a live connection to an existing SQL Server Analysis Services tabular model.
AnswerC

Import mode with a star schema optimizes performance and memory usage.

Why this answer

Option C is correct because importing the data into Power BI and modeling it as a star schema with separate dimension tables (date, product, customer) and a sales fact table minimizes load time and memory usage through columnar compression and optimized query performance. Import mode stores data in the VertiPaq engine, which compresses data efficiently, especially when using a star schema, reducing memory footprint and enabling fast in-memory analysis. This approach balances storage efficiency with analytical flexibility for millions of rows.

Exam trap

The trap here is that candidates often choose DirectQuery (Option B) thinking it saves memory by not storing data, but they overlook that Import mode with a star schema actually minimizes memory usage through compression and is faster for interactive analysis, while DirectQuery increases load on the source and can degrade performance.

How to eliminate wrong answers

Option A is wrong because a composite model with some tables in DirectQuery and others in Import introduces complexity and potential performance overhead from cross-source query federation, which does not inherently minimize load time or memory usage compared to a fully imported star schema. Option B is wrong because DirectQuery mode avoids storing data in Power BI, but it does not minimize load time or memory usage; instead, it shifts query execution to the source database, which can lead to slower performance for interactive analysis and does not leverage Power BI's in-memory compression. Option D is wrong because a live connection to an existing SSAS tabular model does not minimize load time or memory usage in Power BI itself—it delegates processing to SSAS, which may not be optimized for the specific star schema design needed, and adds dependency on an external service without reducing Power BI's resource consumption.

Full explanation →
638
MCQhard

You are using the above KQL query as a source in Power Query for a Power BI semantic model. The query runs successfully but takes a long time to execute. You need to improve performance. What should you do?

A.Use the 'Run KQL command' option in Power Query to pass the query directly.
B.Add additional transformations in Power Query to reduce rows.
C.Enable query folding to push the query to the Kusto source.
D.Disable query folding to improve performance.
AnswerA

Running the KQL command directly in Power Query avoids pulling all rows into Power Query for additional transformations, improving performance.

Why this answer

Option A is correct because using the 'Run KQL command' option in Power Query sends the entire KQL query directly to Azure Data Explorer (or Kusto) for execution, allowing the Kusto engine to process and filter data at the source. This minimizes data transfer and leverages Kusto's optimized query engine, significantly improving performance compared to pulling all data into Power Query for transformation.

Exam trap

The trap here is that candidates often confuse 'query folding' (which applies to SQL-based sources like SQL Server) with the native KQL command execution in Power Query, incorrectly assuming that toggling a folding setting will push the query to Kusto when the correct approach is to use the dedicated 'Run KQL command' option.

How to eliminate wrong answers

Option B is wrong because adding additional transformations in Power Query after data is loaded does not reduce the initial data transfer; it only processes data locally, which can actually worsen performance by increasing memory and processing overhead. Option C is wrong because query folding is already implicitly enabled when using a native KQL query in Power Query; explicitly enabling it does not change behavior, and the performance gain comes from pushing the query to the source, not from a folding toggle. Option D is wrong because disabling query folding would force Power Query to pull all raw data from Kusto before applying any transformations, defeating the purpose of source-side filtering and drastically increasing load times.

Full explanation →
639
Multi-Selecthard

Which THREE factors should you consider when designing a star schema in Power BI?

Select 3 answers
A.A separate date table should be created for time intelligence.
B.Use natural keys instead of surrogate keys in dimension tables.
C.Fact tables should contain only foreign keys and numeric measures.
D.Use a snowflake schema to reduce data redundancy.
E.Dimension tables should be denormalized.
AnswersA, C, E

A dedicated date table enables time-based calculations.

Why this answer

A separate date table is required for time intelligence functions in Power BI because DAX time intelligence functions (e.g., TOTALYTD, SAMEPERIODLASTYEAR) rely on a continuous, contiguous date range with no gaps. Power BI automatically marks a table as a date table only if it contains a complete set of dates from the earliest to the latest transaction, enabling functions like DATEADD and DATESBETWEEN to work correctly across all granularities.

Exam trap

The trap here is that candidates confuse the theoretical normalization benefits of a snowflake schema (reducing redundancy) with the practical performance requirements of Power BI, where denormalization and surrogate keys are essential for optimal query execution and time intelligence calculations.

Full explanation →
640
Multi-Selecthard

A company has a Power BI dataset that includes a table 'Orders' with columns: OrderID, CustomerID, OrderDate, ShipDate, and Amount. They want to create a measure that calculates the number of orders shipped within 3 days of the order date. Which THREE of the following steps are necessary to create this measure?

Select 3 answers
A.Use FILTER to filter the Orders table based on the condition.
B.Use COUNTROWS without any filter.
C.Use SUM to add up the Amount column.
D.Use COUNTROWS inside CALCULATE.
E.Use DATEDIFF to calculate the difference between ShipDate and OrderDate.
AnswersA, D, E

FILTER is required to restrict rows to those shipped within 3 days.

Why this answer

Option A is correct because FILTER is necessary to iterate over the Orders table and apply a row-by-row condition to identify orders shipped within 3 days. In DAX, FILTER returns a table that can be used as a filter argument inside CALCULATE, enabling context transition and dynamic filtering. Without FILTER, you cannot evaluate the date difference condition for each row individually.

Exam trap

The trap here is that candidates often think COUNTROWS alone is sufficient, forgetting that CALCULATE is required to apply the filter context from FILTER; or they mistakenly choose SUM because they confuse counting orders with summing amounts.

Full explanation →
641
MCQmedium

Refer to the exhibit. You run a PowerShell script to list workspaces and their users. You need to ensure that only members of the sales security group can access the Sales workspace. What should you do?

A.Restore the Marketing workspace and move the reports there.
B.Add the sales security group as a Contributor to the Sales workspace.
C.Change the sales security group's role to Viewer.
D.Remove the individual users (user1 and user2) from the Sales workspace.
AnswerD

Removing individual users leaves only the security group, ensuring access through group membership.

Why this answer

Option B is correct because the exhibit shows that the sales security group is already an Admin in the workspace. However, user1 and user2 are individual users with Member and Contributor roles. To restrict access to only the security group, you must remove these individual users.

Option A is wrong because the security group is already added as Admin, which is sufficient for access. Option C is wrong because the Marketing workspace is deleted and irrelevant. Option D is wrong because changing the security group role to Viewer would reduce permissions, but the core issue is the individual users.

Full explanation →
642
MCQhard

You are troubleshooting a Power BI report that uses a measure with the following formula: Profit Margin = DIVIDE(SUM(Transactions[Profit]), SUM(Transactions[Revenue])). The measure returns blank for rows where revenue is zero. You want to display 0% instead of blank. What should you do?

A.Use COALESCE([Profit Margin], 0).
B.Add a third argument to DIVIDE: DIVIDE(SUM(Transactions[Profit]), SUM(Transactions[Revenue]), 0).
C.Use IFERROR( [Profit Margin], 0).
D.Wrap the measure with IF(ISBLANK([Profit Margin]), 0, [Profit Margin]).
AnswerB

Correct. The third argument returns 0 when denominator is 0.

Why this answer

Option A is correct because the third argument of DIVIDE specifies an alternate result when division by zero occurs. Option B is wrong because ISBLANK does not prevent division by zero. Option C is wrong because IFERROR does not catch blank from DIVIDE.

Option D is wrong because COALESCE replaces blank with 0 after the fact, but DIVIDE still returns blank.

Full explanation →
643
MCQeasy

A Power BI report in a shared workspace needs to be embedded in a SharePoint Online page. Users accessing the page must see the report without signing in again. Which capability is required?

A.Use the 'Embed for SharePoint' option in Power BI.
B.Use the 'Embed for your organization' option.
C.Share the report directly with each user via email.
D.Publish the report to the web and embed the iframe.
AnswerA

Correct. This provides seamless authentication.

Why this answer

Option A is correct because 'Embed for SharePoint' allows seamless integration with SharePoint Online, leveraging the user's existing authentication. Option B is wrong because 'Publish to web' makes the report public. Option C is wrong because that method is for custom apps.

Option D is wrong because direct sharing requires sign-in.

Full explanation →
644
Multi-Selectmedium

Which TWO actions can you take in Power Query Editor to improve data quality and reduce load time? (Choose two.)

Select 2 answers
A.Split columns by delimiter to create more columns.
B.Filter out empty rows.
C.Sort the data by a key column.
D.Promote headers to use the first row as column names.
E.Merge queries to combine data from multiple sources.
AnswersB, D

Removing empty rows reduces the amount of data loaded.

Why this answer

Filtering out empty rows in Power Query Editor directly reduces the number of rows loaded into the data model, which decreases memory usage and improves refresh performance. This action also enhances data quality by removing incomplete records that could cause errors in measures or relationships.

Exam trap

The trap here is that candidates often confuse actions that improve data quality (like filtering or promoting headers) with actions that merely reorganize data (like sorting or splitting), leading them to select options that do not actually reduce load time or enhance data integrity.

Full explanation →
645
MCQmedium

You are importing data from a large CSV file (5 GB) into Power BI. The import takes too long and you need to reduce the data volume. What is the most effective approach in Power Query?

A.Disable loading of unrelated queries.
B.Increase query parallelism in options.
C.Filter rows and remove unnecessary columns in Power Query.
D.Enable 'Query Reduction' settings.
AnswerC

Directly reduces the amount of data loaded.

Why this answer

Option C is correct because filtering rows and removing unnecessary columns in Power Query directly reduces the amount of data loaded into Power BI's data model. This is the most effective way to reduce data volume from a large CSV file, as it minimizes the data that Power Query must process and store, directly addressing the import time issue.

Exam trap

The trap here is that candidates often confuse 'Query Reduction' settings (which affect report interaction queries) with data volume reduction during import, leading them to incorrectly select Option D.

How to eliminate wrong answers

Option A is wrong because disabling loading of unrelated queries does not reduce the data volume of the specific CSV file being imported; it only prevents other queries from being loaded into the model, which does not address the size of the target CSV. Option B is wrong because increasing query parallelism in Power Query options can improve processing speed by running multiple queries concurrently, but it does not reduce the data volume of the large CSV file; it may even increase resource contention without addressing the root cause of excessive data. Option D is wrong because 'Query Reduction' settings in Power BI are designed to optimize report performance by reducing the number of queries sent to the data source during report interaction (e.g., disabling cross-highlighting), not to reduce the volume of data imported during the initial data load from a CSV file.

Full explanation →
646
Multi-Selecteasy

You are creating a Power BI report to analyze customer feedback. You need to display the distribution of feedback ratings (1-5 stars) and also show the trend of average rating over time. Which two visual types should you use?

Select 2 answers
A.Pie chart
B.Column chart
C.Histogram
D.Scatter chart
E.Line chart
AnswersB, E

A column chart can show the count of each rating.

Why this answer

A histogram is not a standard Power BI visual; a column chart can show distribution. For trend, a line chart is appropriate. So correct: B and D.

Option A (histogram) is not a native visual; Option C (pie chart) shows proportion but not distribution; Option E (scatter chart) is for relationships.

Full explanation →
647
MCQeasy

You have a Power BI report that uses a measure with a filter context. You want to override the filter context for a specific calculation. Which function should you use?

A.ALL
B.FILTER
C.CALCULATE
D.VALUES
AnswerC

CALCULATE modifies filter context.

Why this answer

Option D is correct because CALCULATE changes filter context. Option A is wrong because FILTER returns a table. Option B is wrong because ALL removes filters.

Option C is wrong because VALUES returns distinct values.

Full explanation →
648
MCQhard

You have a Power BI dataset that uses a DirectQuery connection to Azure Synapse Analytics. Users report that the report is slow. You need to improve query performance without changing the data source. What should you do?

A.Reduce the cardinality of calculated measures.
B.Disable row-level security (RLS) on the dataset.
C.Increase the scheduled refresh frequency.
D.Reduce the number of visuals on each report page.
AnswerD

Fewer visuals mean fewer queries to the source.

Why this answer

Option C is correct because reducing the number of visuals on a page reduces the number of queries sent to the data source. Option A is incorrect because increasing scheduled refresh does not affect DirectQuery. Option B is incorrect because disabling RLS would not improve performance significantly.

Option D is incorrect because reducing the cardinality of measures does not reduce the number of queries.

Full explanation →
649
Multi-Selecteasy

You are designing a Power BI report page. Which two actions can you take to improve the accessibility of the report?

Select 2 answers
A.Use a dark background with light text
B.Avoid using images in visuals
C.Add data labels to visuals
D.Use a high-contrast theme
E.Remove all tooltips to reduce clutter
AnswersC, D

Data labels help users with cognitive disabilities interpret visuals.

Why this answer

Options B and D are correct. Option A is wrong because high contrast can be achieved via themes, not just dark background. Option C is wrong because tooltips are not required.

Option E is wrong because images should have alt text.

Full explanation →
650
MCQeasy

You need to create a calculated column that categorizes sales amounts into 'Low', 'Medium', and 'High' based on thresholds. Which DAX function should you use?

A.LOOKUPVALUE
B.CALCULATE
C.SWITCH
D.IF
AnswerC

SWITCH allows multiple conditions in a clean syntax.

Why this answer

Option B is correct because SWITCH can evaluate multiple conditions. Option A (IF) can also work but becomes nested. Option C (LOOKUPVALUE) is for looking up values.

Option D (CALCULATE) modifies filter context.

Full explanation →
651
Multi-Selectmedium

Which THREE of the following are valid reasons to create a calculated table in Power BI?

Select 3 answers
A.To add a column that computes a value based on other columns in the same table.
B.To combine two tables by merging columns from one table into another.
C.To create a date table that is not available in the data source.
D.To create a disconnected table for use in what-if analysis (e.g., parameter slicers).
E.To create a summary table that pre-aggregates data for better performance.
AnswersC, D, E

CALENDAR or CALENDARAUTO can create a date table for time intelligence.

Why this answer

Option C is correct because calculated tables in Power BI are created using DAX and stored in memory, allowing you to generate a date table when no suitable date table exists in the data source. This is a common pattern to ensure a complete date range for time intelligence functions, as Power BI requires a continuous date table for functions like TOTALYTD or SAMEPERIODLASTYEAR.

Exam trap

The trap here is that candidates often confuse calculated tables with calculated columns or Power Query merges, thinking any table-like operation qualifies, but Power BI strictly distinguishes between row-level calculations (calculated columns) and table-level transformations (calculated tables).

Full explanation →
652
MCQmedium

You are importing a large CSV file (200 MB) into Power BI Desktop. The import is very slow and sometimes fails. What should you do to improve performance?

A.Use Power BI Service to import the file instead.
B.Remove all relationships before import.
C.Filter rows and columns during import using Power Query to reduce data size.
D.Upgrade to Power BI Premium.
AnswerC

Reducing data volume before loading improves performance.

Why this answer

Option C is correct because filtering rows and columns during import using Power Query reduces the data volume loaded into the Power BI Desktop model, directly addressing the root cause of slow imports and failures when handling a 200 MB CSV file. Power Query's query folding capabilities push data reduction operations (e.g., removing unnecessary columns, filtering rows based on conditions) upstream, minimizing memory and processing overhead during the import phase. This approach is a standard best practice for optimizing data ingestion in Power BI Desktop, especially for large flat files.

Exam trap

The trap here is that candidates often assume upgrading to Premium or using the Service will magically fix performance issues, but the PL-300 exam emphasizes that data reduction during import (via Power Query filtering) is the primary technique to optimize large file ingestion in Power BI Desktop.

How to eliminate wrong answers

Option A is wrong because Power BI Service does not import CSV files directly; it relies on Power BI Desktop or dataflows to prepare and publish data, and the import speed bottleneck is typically local memory and processing, not the destination service. Option B is wrong because removing all relationships before import does not reduce the data size or improve import performance; relationships are metadata that affect query performance after loading, not the initial data ingestion from a CSV file. Option D is wrong because upgrading to Power BI Premium increases capacity limits (e.g., dataset size up to 400 GB) but does not inherently speed up the import of a 200 MB CSV file in Power BI Desktop; the import process is constrained by local resources and data volume, not licensing tier.

Full explanation →
653
MCQmedium

You are building a Power BI data model that combines Sales data from SQL Server and Marketing data from a CSV file. The Sales table has a unique 'OrderID' column, and the Marketing table has a 'CampaignID' column. You need to create a relationship between Sales and Marketing to analyze campaign effectiveness. What should you do?

A.Use an inactive relationship between Sales and Marketing and activate it with USERELATIONSHIP in measures.
B.Create a bridge table containing unique combinations of OrderID and CampaignID.
C.Create a separate table for each campaign and relate to Sales.
D.Merge the Marketing table into the Sales table using a left outer join.
AnswerB

A bridge table properly resolves the many-to-many relationship between Sales and Marketing.

Why this answer

Option B is correct because a bridge table resolves the many-to-many relationship between Sales (OrderID) and Marketing (CampaignID). Since there is no direct key match, creating a bridge table with unique combinations of OrderID and CampaignID allows Power BI to model the relationship correctly and analyze campaign effectiveness without data duplication or ambiguity.

Exam trap

The trap here is that candidates often assume an inactive relationship or a merge can handle mismatched keys, but Power BI requires a common key column for relationships, and merging destroys the normalized model needed for accurate many-to-many analysis.

How to eliminate wrong answers

Option A is wrong because an inactive relationship requires a common key to exist between the tables; here, OrderID and CampaignID have no direct match, so an inactive relationship cannot be created. Option C is wrong because creating a separate table for each campaign would fragment the data, making it impossible to relate to Sales without a common key and violating star schema best practices. Option D is wrong because merging the Marketing table into Sales using a left outer join would create a single flat table, duplicating Sales rows for multiple campaigns and losing the ability to model the many-to-many relationship properly in Power BI.

Full explanation →
654
MCQeasy

A Power BI workspace contains a report that uses a shared dataset. The dataset owner leaves the company. The report still works, but the dataset cannot be refreshed. What should the administrator do to restore refresh capability?

A.Reassign the dataset ownership to another user in the workspace settings
B.Create a new dataset and link the report to it
C.Reconfigure the gateway to use a service principal
D.Take over the dataset as an administrator and update the data source credentials
AnswerD

Administrators can take over ownership and update credentials.

Why this answer

Option C is correct because taking over the dataset allows the administrator to configure credentials and refresh. Option A is wrong because reassigning ownership is not a direct feature; take over is. Option B is wrong because creating a new dataset would break the report linkage.

Option D is wrong because the data source credentials are stored in the dataset, not the gateway.

Full explanation →
655
MCQmedium

You are building a Power BI model with a fact table and multiple dimension tables. You want to enforce a rule that each fact row must have a matching row in a related dimension. Which modeling technique should you use?

A.Set the relationship cardinality to many-to-many.
B.Set the cross-filter direction to both.
C.Use a calculated column to check for existence.
D.Assume referential integrity in the relationship settings.
AnswerD

Power BI can assume referential integrity to optimize queries, but enforcement is typically done at the data source.

Why this answer

Option C is correct because referential integrity ensures every fact foreign key matches a dimension primary key. Option A is wrong because cardinality does not enforce integrity. Option C is correct.

Option D is wrong because cross-filter direction affects filtering, not integrity.

Full explanation →
656
Multi-Selectmedium

Which THREE of the following are benefits of using a star schema in Power BI? (Select three.)

Select 3 answers
A.Simplified DAX formulas
B.Supports many-to-many relationships natively
C.Improved query performance
D.Increased data redundancy
E.Easier for business users to understand
AnswersA, C, E

Less complex relationships lead to simpler measures.

Why this answer

Option A is correct because star schemas reduce the number of table joins and filter context complexity, which simplifies DAX formulas. Measures and calculated columns in Power BI rely on unambiguous relationships; a star schema ensures each fact table connects to dimension tables via one-to-many relationships, allowing DAX to propagate filters automatically without complex cross-filtering logic.

Exam trap

The trap here is that candidates confuse star schemas with snowflake schemas or assume that many-to-many relationships are a native benefit, when in fact star schemas rely on one-to-many relationships for optimal performance and simplicity.

Full explanation →
657
Multi-Selecteasy

Which TWO Power BI visuals can be used to display hierarchical data? (Select two.)

Select 2 answers
A.Scatter plot
B.Card
C.Decomposition tree
D.Matrix
E.Pie chart
AnswersC, D

Decomposition tree is designed for hierarchical drill-down.

Why this answer

The Decomposition tree (C) is correct because it is a Power BI custom visual designed specifically for hierarchical data, allowing users to drill down into dimensions interactively. The Matrix (D) is correct because it supports hierarchical row and column headers, enabling multi-level grouping and expansion of data.

Exam trap

The trap here is that candidates often confuse the Matrix with a simple table or think the Decomposition tree is only for AI insights, missing that both are valid for hierarchical data display.

Full explanation →
658
MCQeasy

A company has a Power BI semantic model that uses Import mode. The model contains a table with 10 million rows. The data source is a SQL Server view that takes 5 minutes to execute. The scheduled refresh is set to every hour. What is the likely impact on refresh performance?

A.Refresh will fail due to timeout on the gateway.
B.The model will automatically use incremental refresh to split the load.
C.Refresh will complete in parallel with the view execution.
D.Refresh will take at least 5 minutes plus data loading time.
AnswerD

The view execution time adds to the overall refresh duration.

Why this answer

Option D is correct because the refresh process must first execute the SQL Server view to retrieve data, which takes at least 5 minutes, and then load that data into the Import mode model. The total refresh time is the sum of the query execution time and the data loading time, so it will be at least 5 minutes plus additional time for loading 10 million rows.

Exam trap

The trap here is that candidates may assume the gateway has a default 5-minute timeout, leading them to choose Option A, but the actual default timeout is 10 minutes, and the question does not specify any custom timeout settings.

How to eliminate wrong answers

Option A is wrong because the default gateway timeout for SQL Server is 10 minutes, which is longer than the 5-minute view execution time, so a timeout is unlikely unless other factors like network latency or resource contention exist. Option B is wrong because incremental refresh is not automatic; it must be manually configured by the model designer using Power Query date-range parameters and policy settings, and it does not automatically split the load for a view that takes 5 minutes. Option C is wrong because refresh is a sequential process: the view must finish executing before any data loading can begin; there is no parallel execution between the view query and the data load in Import mode.

Full explanation →
659
MCQhard

You are reviewing a Power BI model definition in TMSL. The model has incremental refresh configured with two partitions. When the model refreshes on July 1, 2024, which data will be refreshed in Partition1?

A.Only new rows added since last refresh.
B.No data, because the partition is in the past.
C.Only data modified since the last refresh.
D.All rows where OrderDate is between 2024-01-01 and 2024-04-01.
AnswerD

That's the partition's range; on July 1 it's past data and will be fully refreshed.

Why this answer

Option C is correct. Incremental refresh partitions use parameters like RangeStart and RangeEnd. In this example, the partitions are hardcoded dates.

On July 1, 2024, Partition1 covers data from Jan 1 to Apr 1, which is in the past, so it will be fully refreshed. Option A is wrong because only past data is refreshed. Option B is wrong because incremental refresh refreshes all data in the partition, not just changes.

Option D is wrong because the partition is not excluded.

Full explanation →
660
MCQhard

You need to create a measure that calculates the total sales for the previous month, regardless of any filters on the date slicer. The data model includes a separate date table with a relationship to the sales table. Which DAX expression should you use?

A.CALCULATE(SUM(Sales[Amount]), DATEADD('Date'[Date], -1, MONTH))
B.CALCULATE(SUM(Sales[Amount]), DATESMTD(DATEADD('Date'[Date], -1, MONTH)))
C.CALCULATE(SUM(Sales[Amount]), PREVIOUSMONTH('Date'[Date]), ALL('Date'))
D.CALCULATE(SUM(Sales[Amount]), 'Date'[Month] = FORMAT(TODAY()-30, 'MMMM'))
AnswerC

PREVIOUSMONTH with ALL removes slicer filters and returns previous month.

Why this answer

Option B is correct because PREVIOUSMONTH returns the previous month based on the current filter context, but it is affected by slicer filters. To ignore slicer, you can use a combination like CALCULATE with ALL to remove filters, then use PREVIOUSMONTH. However, among given options, only B uses PREVIOUSMONTH with ALL.

Option A uses DATEADD which can also work but is more complex. Option C uses DATESMTD which is month-to-date, not previous month. Option D uses a hardcoded date which is not dynamic.

Full explanation →
661
MCQeasy

A Power BI developer needs to model data from two sources: an on-premises SQL Server database and a cloud-based Salesforce instance. The developer wants to create a star schema in Power BI. Which approach should the developer use to combine the data?

A.Use DirectQuery for both sources and create relationships in the model.
B.Use Power Query in Power BI Desktop to import both sources and merge/append queries as needed.
C.Use Power BI dataflows to ingest both sources and then reference them in a dataset.
D.Create a composite model using DirectQuery for SQL Server and Import for Salesforce.
AnswerB

Power Query can import from multiple sources and shape data.

Why this answer

Option B is correct because Power Query in Power BI Desktop is the appropriate tool to import data from both an on-premises SQL Server database and a cloud-based Salesforce instance, allowing the developer to merge or append queries as needed to shape the data into a star schema. This approach supports combining disparate sources into a single import model, which is essential for creating a star schema with fact and dimension tables. Using Power Query ensures that all data is loaded into memory, enabling fast query performance and full modeling capabilities.

Exam trap

The trap here is that candidates may think a composite model (Option D) is the best approach for combining on-premises and cloud sources, but the question specifically asks for creating a star schema, which is most easily achieved by importing all data into a single in-memory model using Power Query, avoiding the limitations and complexity of mixed storage modes.

How to eliminate wrong answers

Option A is wrong because using DirectQuery for both sources would prevent the developer from merging or appending data at query time; DirectQuery sends queries directly to the source and does not support combining data from multiple sources in a single query unless a composite model is used, and it limits star schema design due to performance constraints. Option C is wrong because Power BI dataflows are used for data preparation and storage in the Power BI service, but they are not the primary tool for combining data within a single Power BI Desktop model; referencing dataflows in a dataset still requires import or DirectQuery, and the question asks for the approach to combine data in the model, not just ingest it. Option D is wrong because creating a composite model with DirectQuery for SQL Server and Import for Salesforce would allow combining data, but it introduces complexity with mixed storage modes, potential performance issues, and limitations on relationships (e.g., many-to-many relationships require specific configurations), and it is not the simplest or most straightforward approach for building a star schema; importing both sources is preferred for full control over data shaping.

Full explanation →
662
MCQmedium

Your organization uses Microsoft Entra ID for identity management. You have created a Power BI app workspace and assigned users to the Viewer role. However, some viewers report that they cannot export report data to Excel. What is the most likely reason?

A.Viewers do not have a Power BI Pro license.
B.The 'Allow viewers to export data' setting is disabled in the workspace.
C.The Viewer role does not have permission to view reports.
D.Microsoft Entra ID conditional access policies block data export.
AnswerB

Correct. This setting must be enabled.

Why this answer

Option B is correct because the 'Export data' permission is controlled by the app workspace setting 'Allow viewers to export data', which is disabled by default. Option A is wrong because Viewer role can generally view reports. Option C is wrong because licensing affects creation, not basic export.

Option D is wrong because Entra ID settings do not block export at the workspace level.

Full explanation →
663
Multi-Selectmedium

You are a Power BI administrator. Your organization wants to use Microsoft Defender XDR to monitor Power BI activity for suspicious behavior. Which two components are essential for this integration? (Choose two.)

Select 2 answers
A.Microsoft Purview data classification policies.
B.Power BI activity logs streamed to Microsoft Sentinel.
C.Microsoft Defender XDR advanced hunting.
D.Microsoft Foundry AI models.
E.Microsoft Intune device compliance policies.
AnswersB, C

Sentinel can ingest Power BI activity logs for security monitoring.

Why this answer

Option A (Power BI activity logs streamed to Microsoft Sentinel) and Option D (Microsoft Defender XDR advanced hunting) are correct. Option A provides the data source. Option D allows querying the data for anomalies.

Option B is wrong because Microsoft Intune manages devices, not Power BI. Option C is wrong because Microsoft Purview is for compliance, not threat detection. Option E is wrong because Microsoft Foundry is for AI workloads.

Full explanation →
664
MCQmedium

A Power BI report uses a measure that calculates Year-over-Year sales growth. Users report that the measure shows incorrect values for January 2024 when compared to January 2023. The data model contains a Date table with a continuous date range from January 1, 2020 to December 31, 2024. Which DAX function is most likely causing the issue?

A.PARALLELPERIOD
B.DATEADD
C.SAMEPERIODLASTYEAR
D.PREVIOUSYEAR
AnswerC

SAMEPERIODLASTYEAR is the most likely cause because it returns the same period from the previous year, but if the Date table lacks data for the entire previous period, it can produce incorrect results for month-over-month comparisons.

Why this answer

SAMEPERIODLASTYEAR is the most likely cause of the issue because it returns a set of dates from the previous year that exactly matches the current period's date range. For January 2024, it will return January 1–31, 2023, but if the Date table does not have a full contiguous range (e.g., missing weekends or holidays), or if the measure relies on a different granularity, the comparison may produce incorrect values. The other functions shift dates differently or return entire periods, which can cause mismatches in Year-over-Year calculations.

Exam trap

The trap here is that candidates often confuse SAMEPERIODLASTYEAR with DATEADD or PARALLELPERIOD, not realizing that SAMEPERIODLASTYEAR returns the exact same relative dates (e.g., same day numbers) while DATEADD shifts by an interval and PARALLELPERIOD returns full periods, making SAMEPERIODLASTYEAR the correct choice for precise Year-over-Year comparisons when the Date table is continuous.

How to eliminate wrong answers

Option A is wrong because PARALLELPERIOD shifts a set of dates by a specified number of intervals (e.g., month, quarter, year) but returns the full period (e.g., entire month) rather than the exact same relative dates, which can cause misalignment for partial periods. Option B is wrong because DATEADD shifts dates by a specified interval (e.g., -1 year) but returns the exact shifted dates, which may not align with the Date table's contiguous range if there are gaps or if the shift crosses a boundary (e.g., leap year). Option D is wrong because PREVIOUSYEAR returns all dates in the previous year (e.g., all of 2023) regardless of the current filter context, so it would compare January 2024 against the entire year 2023, not just January 2023.

Full explanation →
665
Multi-Selectmedium

A Power BI report includes a slicer for 'Year' and a line chart showing monthly sales. The report designer wants to ensure that when a user selects a year in the slicer, the line chart shows only the months of that year, with month names on the x-axis sorted chronologically. Which TWO actions must be taken?

Select 2 answers
A.Mark the Date table as a date table in the model.
B.Create a date hierarchy with Year and Month.
C.Set the slicer to 'Single select' mode.
D.Set the 'Sort by Column' property for Month to a numeric month number column.
E.Hide the Month column in the Date table.
AnswersA, D

Marking the table as a date table enables time intelligence functions and ensures proper date behavior.

Why this answer

Option A is correct because marking the Date table as a date table ensures that Power BI recognizes the table as containing a contiguous date range, which is required for time intelligence functions and proper date-based filtering. When a slicer filters by Year, the line chart must respect the date relationship; without a marked date table, the filter may not propagate correctly to the month level, and the x-axis may not display months in chronological order.

Exam trap

The trap here is that candidates often think creating a date hierarchy (Option B) automatically sorts months chronologically, but hierarchies only organize fields for drill-down, not sort order; the 'Sort by Column' property is the specific mechanism required for chronological month sorting.

Full explanation →
666
Multi-Selecteasy

Which TWO of the following are valid options when connecting to an on-premises SQL Server database from Power BI service? (Select TWO.)

Select 2 answers
A.DirectQuery mode with an on-premises data gateway
B.Using a SharePoint Online list connector pointing to SQL Server
C.DirectQuery using cloud credentials without a gateway
D.Import mode with an on-premises data gateway
E.Scheduling refresh in Power BI Desktop
AnswersA, D

DirectQuery also requires a gateway for on-premises sources.

Why this answer

Option A is correct because DirectQuery mode in Power BI service requires an on-premises data gateway to translate cloud-based queries into native SQL queries against the on-premises SQL Server. The gateway acts as a secure bridge, enabling real-time query execution without moving data to the cloud.

Exam trap

The trap here is that candidates often confuse 'connection mode' (DirectQuery vs. Import) with 'authentication method' (cloud credentials vs. gateway), mistakenly thinking DirectQuery can bypass the gateway for on-premises sources.

Full explanation →
667
MCQmedium

Refer to the exhibit. You have a Power BI measure defined as shown. Users report that when they filter by region, the measure always shows sales for the North region regardless of the filter. What is the most likely cause?

A.The filter argument in CALCULATE overrides the existing filter context on Region.
B.The SUM function ignores filters applied to the Sales table.
C.The measure syntax is invalid and defaults to no filter.
D.The filter is applied to the entire Sales table, not just the Region column.
AnswerA

CALCULATE's filter argument replaces the outer filter context.

Why this answer

Option A is correct because the CALCULATE function includes a filter argument that overrides any existing filter context on the Region column. Option B is wrong because SUM does not ignore filters. Option C is wrong because the measure syntax is valid.

Option D is wrong because the filter is on Region, not on the entire table.

Full explanation →
668
MCQeasy

You are importing data from a CSV file into Power BI. The file contains a column 'SalesAmount' with values like '$1,234.56'. When you load the data, the column is detected as text. What is the most efficient way to convert this column to a numeric type in Power Query?

A.Use 'Replace Values' to remove the dollar sign and comma, then change the column type to decimal.
B.Use 'Detect Data Type' and hope it automatically converts.
C.Change the column type to decimal directly and ignore errors.
D.Split the column by delimiter ',' and then convert the first part.
AnswerA

This directly cleans the text and converts to number.

Why this answer

Option A is correct because it directly addresses the root cause: the dollar sign and comma are non-numeric characters that prevent automatic type conversion. By using 'Replace Values' to remove these characters first, you clean the data so that Power Query can then safely change the column type to decimal. This is the most efficient approach because it avoids error rows and preserves data integrity.

Exam trap

The trap here is that candidates assume Power BI's automatic data type detection or direct type conversion can handle formatted currency values, but Power Query requires explicit cleaning of non-numeric characters before conversion.

How to eliminate wrong answers

Option B is wrong because 'Detect Data Type' relies on the current column values, which still contain non-numeric characters, so it will continue to detect the column as text and not perform any conversion. Option C is wrong because changing the column type to decimal directly without cleaning will cause errors for every row containing '$' or ',', resulting in null values or query failures. Option D is wrong because splitting by comma is unnecessary and destructive; it would separate the thousands separator from the number, losing the decimal precision and requiring additional steps to recombine values.

Full explanation →
669
Multi-Selecteasy

You are preparing data from multiple Excel files. Each file has a different structure; some have merged cells, empty rows, and inconsistent column names. Which TWO actions should you take to clean the data in Power Query? (Choose two.)

Select 2 answers
A.Remove blank rows that result from merged cells.
B.Group rows by a key column to summarize data.
C.Merge columns to create a single identifier.
D.Unpivot columns to normalize the data.
E.Promote the first row to headers.
AnswersA, E

Merged cells often create blank rows; removing them cleans the data.

Why this answer

Option A is correct because merged cells in Excel often introduce blank rows when the data is loaded into Power Query. Using 'Remove Blank Rows' in Power Query eliminates these extraneous rows that do not contain meaningful data, ensuring the dataset is clean and ready for transformation.

Exam trap

The trap here is that candidates often confuse data-cleaning actions (like removing blank rows and promoting headers) with data-transformation actions (like grouping, merging, or unpivoting), leading them to select options that reshape data rather than fix structural inconsistencies.

Full explanation →
670
MCQhard

You are reviewing a Power BI model definition in JSON. The Sales table contains a ProductID column but the Product table does not have a ProductID column; instead it has a ProductID column with dataType string. What issue will occur when you try to create a relationship?

A.The relationship will fail because the data types are incompatible
B.The relationship will fail because the column names must be different
C.The relationship will create a cross filter direction of single
D.The relationship will work but be many-to-many due to different data types
AnswerA

Relationships require matching data types between the columns.

Why this answer

Option C is correct because the data types do not match: Sales.ProductID is int64, while Product.ProductID is string. Power BI relationships require matching data types. Option A is wrong because the column names match, so no rename is needed.

Option B is wrong because many-to-one is allowed, but the data type mismatch is the problem. Option D is wrong because the relationship direction is not the primary issue.

Full explanation →
671
Multi-Selectmedium

Which TWO of the following are valid ways to create a measure in Power BI?

Select 2 answers
A.From the Modeling tab, click New Measure.
B.Right-click a table in the Fields pane and select New Measure.
C.From the Format pane, add a measure.
D.From Power Query Editor, add a custom column.
E.From the Visualizations pane, click New Measure.
AnswersA, B

This is the standard way to create a measure.

Why this answer

Option A is correct because the Modeling tab in Power BI Desktop provides a dedicated 'New Measure' button that allows users to create calculated measures using DAX (Data Analysis Expressions). This is the primary and most direct method for adding measures to your data model, enabling dynamic aggregations and calculations that are not stored in the table but computed at query time.

Exam trap

The trap here is that candidates often confuse the Format pane or Visualizations pane with measure creation tools, or mistakenly think Power Query Editor can create measures, when in fact measures are exclusively created via the Modeling tab or by right-clicking a table in the Fields pane.

Full explanation →
672
MCQmedium

A company has a Power BI report that uses a DirectQuery dataset from an Azure SQL Database. Users report that the report is slow when filtering by date. Which action should you take to improve performance?

A.Create a separate date dimension table and relate it to the fact table
B.Increase the date range filter to include more data
C.Disable cross-filtering in the report
D.Remove unnecessary columns from the date table
AnswerA

A date dimension improves query performance and enables time intelligence.

Why this answer

Creating a separate date dimension table and relating it to the fact table improves performance by enabling star schema design, which optimizes DirectQuery queries. Without a dedicated date table, Power BI may generate inefficient queries that scan the entire fact table for date filtering. A date dimension also supports time intelligence functions and reduces query complexity by allowing the database to use indexes on the date key.

Exam trap

The trap here is that candidates may think removing columns or disabling features like cross-filtering will fix performance, but the core issue is the lack of a proper date dimension in a DirectQuery model, which forces inefficient query patterns.

How to eliminate wrong answers

Option B is wrong because increasing the date range filter to include more data would worsen performance by forcing the database to scan more rows, not improve it. Option C is wrong because disabling cross-filtering affects interactivity between visuals but does not address the root cause of slow date filtering in DirectQuery. Option D is wrong because removing unnecessary columns from the date table may reduce data volume but does not solve the fundamental issue of missing a dedicated date dimension; the slow filtering is due to query structure, not column count.

Full explanation →
673
MCQhard

You review the output of a PowerShell command listing datasets in a Power BI workspace. Which dataset can be refreshed using the Power BI service and also supports push data via the REST API?

A.None of the datasets satisfy both conditions.
B.Profit Report
C.Inventory Dataset
D.Sales Analysis
AnswerA

No dataset has both properties set to True.

Why this answer

Option A is correct because none of the listed datasets can be refreshed via the Power BI service and also support push data via the REST API. Push datasets are designed for real-time streaming and do not support scheduled or on-demand refresh in the service; they are updated only by pushing new data through the REST API. Conversely, datasets that support refresh (e.g., import or DirectQuery) cannot accept push data because their data source is external and not designed for real-time REST API ingestion.

Exam trap

The trap here is that candidates confuse the term 'dataset' with 'report' or assume that all datasets support both refresh and push operations, failing to recognize that push datasets are mutually exclusive with refresh capabilities.

How to eliminate wrong answers

Option B (Profit Report) is wrong because it is a report, not a dataset; reports cannot be refreshed or receive push data. Option C (Inventory Dataset) is wrong because if it supports push data via the REST API, it is a push dataset and therefore cannot be refreshed in the Power BI service. Option D (Sales Analysis) is wrong because it is a report, not a dataset; reports do not support refresh or push data operations.

Full explanation →
674
MCQeasy

You are working on a Power BI report for a marketing team. The report includes a page with a line chart showing website visits over time, and a table showing the top 5 marketing campaigns by conversion rate. The marketing manager wants to be able to click on a point in the line chart (representing a specific date) and have the table update to show only campaigns that were active on that date. The campaigns data includes a 'StartDate' and 'EndDate'. You have implemented a measure to filter campaigns based on the selected date. However, when you click on a date point in the line chart, the table does not update. What should you do to enable this interaction?

A.In the 'Edit interactions' settings, disable cross-filtering between the line chart and table.
B.Create a drillthrough page and configure the line chart to drill through to the table page.
C.Add a bookmark for each date and set the line chart to trigger the bookmark on click.
D.In the 'Edit interactions' settings, ensure that the line chart cross-filters the table.
AnswerD

Cross-filtering must be enabled for the line chart to affect the table.

Why this answer

The issue is likely that cross-filtering between the line chart and table is disabled. By default, visuals cross-filter each other, but if it's turned off, clicking won't affect others. Option A is correct: enable the cross-filter interaction.

Option B is incorrect because drillthrough is for page navigation. Option C is incorrect because bookmarks are not needed. Option D is incorrect because editing interactions is the correct approach but the specific action is to enable cross-filtering, not disable.

Full explanation →
675
MCQhard

You are a Power BI developer for a financial services company. You are preparing data from multiple sources: a CSV file containing daily stock prices (ticker, date, close_price), a SQL Server database with company information (ticker, company_name, sector), and an Excel file with quarterly earnings data (ticker, quarter, earnings_per_share). The CSV file has 5 years of daily data (approx 1.3 million rows). The SQL Server table has 5000 rows. The Excel file has 20,000 rows. You need to create a data model that allows users to filter by sector, company, and date range, and to calculate moving averages of stock prices and compare earnings over time. Performance is critical. You must decide the best approach to combine and model this data. What should you do?

A.Use DirectQuery for StockPrices (CSV) and import the other tables.
B.Import only StockPrices and Company, and use the auto date/time feature; ignore Earnings data.
C.Import all tables, create a date table with CALENDAR, and establish relationships: StockPrices[Date] -> DateTable[Date], StockPrices[Ticker] -> Company[Ticker], Earnings[Ticker] -> Company[Ticker], and create a many-to-many relationship between Earnings and DateTable using a bridge table.
D.Import all tables, then in Power Query merge StockPrices with Company and Earnings into a single flat table using left outer joins.
AnswerC

Star schema with proper relationships optimizes performance.

Why this answer

Option C is correct because importing all tables into the in-memory VertiPaq engine ensures optimal performance for large datasets (1.3M rows) and complex calculations like moving averages. Creating a separate date table with CALENDAR enables proper time intelligence, while the bridge table resolves the many-to-many relationship between quarterly earnings and daily dates, allowing accurate filtering by sector, company, and date range without performance degradation.

Exam trap

The trap here is that candidates often choose Option D (flat table) thinking it simplifies the model, but they overlook the severe performance hit from data duplication and the inability to use star schema optimizations for time intelligence and filtering.

How to eliminate wrong answers

Option A is wrong because DirectQuery for a CSV file is not supported in Power BI; CSV files must be imported. Option B is wrong because ignoring Earnings data fails to meet the requirement of comparing earnings over time, and the auto date/time feature can degrade performance and is not recommended for large models. Option D is wrong because merging all tables into a single flat table creates a massive denormalized table (1.3M rows × multiple columns), leading to data duplication, increased storage, and slower calculations, especially for moving averages and time-based comparisons.

Full explanation →
Page 8

Page 9 of 13

Page 10

All pages

12345678910111213

Practice PL-300 by domain

Target a specific domain to shore up weak areas.

Prepare the dataDeploy and maintain assetsModel the dataVisualize and analyze the dataManage and secure Power BI
See all domains with question counts →