Courseiva

Microsoft Power BI Data Analyst PL-300 (PL-300) — Questions 526–600

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

Take a mock examExam hub
Page 7

Page 8 of 13

Page 9
526
MCQhard

Your Power BI tenant has a capacity-based license (Premium). You want to enforce that only reports with a specific sensitivity label from Microsoft Purview can be exported to PDF. What feature should you use?

A.Microsoft Intune app protection policies
B.Sensitivity labels from Microsoft Purview
C.Data loss prevention (DLP) policies for Power BI
D.Conditional Access policies in Microsoft Entra ID
AnswerB

Sensitivity labels can enforce protection like preventing export.

Why this answer

Sensitivity labels in Power BI can be used to control export actions. Option B is correct because sensitivity labels can restrict exporting based on label. Option A is wrong because data loss prevention (DLP) policies in Power BI are for preventing data exfiltration but not specifically tied to export formats.

Option C is wrong because app protection policies are for mobile devices. Option D is wrong because conditional access policies control access, not export.

Full explanation →
527
Multi-Selectmedium

Which THREE of the following are best practices for designing Power BI reports for accessibility? (Select three.)

Select 3 answers
A.Use 3D effects to make visuals more engaging.
B.Ensure tab order is logical for keyboard navigation.
C.Use high color contrast between text and background.
D.Use as many colors as possible to differentiate data.
E.Provide alt text for all visual elements.
AnswersB, C, E

Correct. Helps keyboard-only users.

Why this answer

Option A is correct because high color contrast helps visually impaired users. Option C is correct because alt text provides descriptions for screen readers. Option D is correct because tab order ensures logical navigation.

Option B is wrong because using many colors can be confusing. Option E is wrong because 3D effects can cause visual clutter.

Full explanation →
528
MCQhard

You are a data analyst for a logistics company. You have a Power BI semantic model that contains a table named Shipments with columns: ShipmentID, OriginCity, DestinationCity, ShipDate, DeliveryDate, Weight, and Cost. The model also contains a table named Cities with columns: City, State, Region, and Population. You need to create a measure that calculates the average delivery time in days for shipments that originated from cities with a population greater than 1 million. The measure should be efficient. Which DAX expression should you use?

A.AVG Delivery Time = SUMX(FILTER(Shipments, RELATED(Cities[Population]) > 1000000), Shipments[DeliveryDate] - Shipments[ShipDate]) / COUNTROWS(FILTER(Shipments, RELATED(Cities[Population]) > 1000000))
B.AVG Delivery Time = CALCULATE(AVERAGE(Shipments[DeliveryDate] - Shipments[ShipDate]), FILTER(Cities, Cities[Population] > 1000000))
C.AVG Delivery Time = CALCULATE(AVERAGE(Shipments[DeliveryDate] - Shipments[ShipDate]), DISTINCT(Cities[Population] > 1000000))
D.AVG Delivery Time = AVERAGEX(Shipments, Shipments[DeliveryDate] - Shipments[ShipDate])
AnswerB

CALCULATE with FILTER applies the filter on Cities table and computes the average of the difference.

Why this answer

Option A uses CALCULATE with a FILTER on the related table, which is correct and efficient. Option B uses SUMX over the entire table, which can be slow. Option C uses an iterator incorrectly.

Option D uses DISTINCT unnecessarily.

Full explanation →
529
MCQeasy

You create a Power BI report that uses a live connection to an Azure Analysis Services (AAS) model. You want to enforce row-level security defined in the AAS model. What should you do?

A.Use object-level security (OLS) instead.
B.No additional configuration needed; RLS from AAS is automatically applied.
C.Use Power BI service to create RLS roles on the dataset.
D.Define the same RLS roles in Power BI Desktop and publish.
AnswerB

Live connection passes through the security.

Why this answer

With a live connection, Power BI respects the RLS defined in the source model. Option A is correct. Option B is wrong because you cannot add RLS in Power BI for a live connection.

Option C is wrong because you cannot define RLS in Power BI for live connections. Option D is wrong because you do not need to redefine.

Full explanation →
530
MCQhard

You are a Power BI analyst for a financial services company. You have a semantic model that contains a 'Transactions' fact table with millions of rows, and a 'Calendar' date dimension table. You need to create a report page that shows the year-to-date (YTD) total transaction amount compared to the same period last year (SPLY). The report must allow users to select a year from a slicer, and the YTD calculation should always be based on the maximum date in the data for the selected year (i.e., show YTD as of the latest available date). You have created the following measures: - Total Amount = SUM(Transactions[Amount]) - YTD Amount = TOTALYTD([Total Amount], 'Calendar'[Date]) - SPLY YTD = CALCULATE([YTD Amount], SAMEPERIODLASTYEAR('Calendar'[Date])) When users select a year from the slicer, the YTD Amount does not correctly show the YTD as of the last date in the selected year; instead, it shows the YTD for each individual date in the context. What is the most likely issue?

A.The relationship between Transactions and Calendar is not active.
B.The slicer is not configured to filter the Calendar table.
C.The YTD measure should be wrapped in a CALCULATE that filters to the last date in the selected period.
D.The TOTALYTD function is not appropriate; you should use DATESYTD instead.
AnswerC

To get a single YTD value, use CALCULATE([YTD Amount], LASTDATE('Calendar'[Date])) or similar.

Why this answer

The TOTALYTD function calculates YTD for each date in the filter context. If the visual has a date field, it will show YTD for each date. To show a single YTD value as of the last date, you need to use a measure that filters to the last date.

Option D is correct: you need to modify the measure to use LASTDATE or MAX to get the YTD as of the last date. Option A is incorrect because TOTALYTD is correct syntax. Option B is incorrect because the relationship is fine.

Option C is incorrect because the issue is not with slicer interaction.

Full explanation →
531
MCQhard

Refer to the exhibit. You have defined row-level security (RLS) in a Power BI semantic model using Role-level security. The JSON shows three rules for the 'Sales' and 'Targets' tables. The user 'john@contoso.com' belongs to this role. John's manager column in the Sales table has the value 'john@contoso.com'. What data will John see when he queries the model?

A.Sales rows where Region is 'West' and Manager is 'john@contoso.com'; Targets rows where Region is 'West'.
B.All Sales and Targets data because John is a manager.
C.Sales rows where Region is 'West' OR Manager is 'john@contoso.com'; Targets rows where Region is 'West'.
D.Only Sales rows where Manager is 'john@contoso.com'; no Targets restriction.
AnswerA

Both filters on Sales are applied with AND.

Why this answer

Option A is correct because RLS rules are combined with AND logic. John will see only Sales rows where Region is 'West' AND Manager is 'john@contoso.com'. For Targets, only rows with Region 'West'.

Option B is incorrect because OR is not used. Option C is incorrect because both rules on Sales apply. Option D is incorrect because all rules apply.

Full explanation →
532
MCQmedium

You need to combine two tables from different sources: 'Orders' from SQL Server and 'Returns' from an Excel file. Both tables have a column named 'OrderID'. You want to include all orders and only matching returns. Which join type should you use in Power Query?

A.Inner Join
B.Right Outer Join
C.Full Outer Join
D.Left Outer Join
AnswerD

Left outer join returns all rows from the first table and matching rows from the second.

Why this answer

In Power Query, a Left Outer Join returns all rows from the first (left) table ('Orders') and only the matching rows from the second (right) table ('Returns'), based on the 'OrderID' column. This matches the requirement to include all orders and only matching returns, ensuring no order is dropped even if it has no corresponding return.

Exam trap

The trap here is that candidates often confuse Left Outer Join with Right Outer Join, mistakenly thinking they need to include all returns instead of all orders, or they default to Inner Join without considering the requirement to preserve unmatched rows from the left table.

How to eliminate wrong answers

Option A is wrong because an Inner Join returns only rows where there is a match in both tables, which would exclude orders without returns. Option B is wrong because a Right Outer Join returns all rows from the right table ('Returns') and only matching rows from the left table ('Orders'), which would include all returns but not all orders. Option C is wrong because a Full Outer Join returns all rows from both tables, including non-matching rows from both sides, which would include returns without orders and is not the requirement.

Full explanation →
533
Multi-Selecthard

You have a Power BI dataset that uses DirectQuery to an Azure Synapse Analytics dedicated SQL pool. You need to improve query performance. Which THREE actions should you take?

Select 3 answers
A.Create indexes on columns used in filters
B.Normalize the data warehouse tables
C.Create aggregated tables in the data source
D.Use materialized views
E.Switch the dataset to Import mode
AnswersA, C, D

Indexes improve query performance.

Why this answer

Creating indexes on columns used in filters is correct because DirectQuery translates Power BI filter operations into SQL queries against the Azure Synapse Analytics dedicated SQL pool. Indexes on those columns accelerate row-level filtering by reducing the number of pages scanned, directly improving query response times.

Exam trap

The trap here is that candidates often assume normalizing data always improves performance, but in analytical DirectQuery scenarios, denormalization (star schema) reduces join complexity and is the recommended approach.

Full explanation →
534
Multi-Selecthard

Which THREE components are required for a Power BI deployment pipeline? (Choose three.)

Select 3 answers
A.A workspace assigned to a Premium capacity.
B.An Azure DevOps repository for version control.
C.A service principal for automated deployments.
D.A deployment pipeline created in the Power BI service.
E.At least three stages (Development, Test, Production).
AnswersA, D, E

Deployment pipelines require Premium.

Why this answer

Options A, B, and C are correct. A deployment pipeline requires a workspace assigned to a Premium capacity, at least three stages (dev, test, prod), and the pipeline must be created in the Power BI service. Option D is incorrect because a separate Azure DevOps repository is not required; deployment pipelines are native to Power BI.

Option E is incorrect because a service principal is optional for automation, not required.

Full explanation →
535
MCQmedium

You are deploying a Power BI solution for a multinational company. The data contains personally identifiable information (PII) subject to GDPR. You need to ensure that users outside the European Union cannot access the underlying data when viewing reports in the Power BI service. What should you implement?

A.Configure Power BI multi-geo and implement row-level security (RLS) based on user region.
B.Apply data classification labels to the datasets and configure protection policies.
C.Use Microsoft Entra ID Conditional Access policies to block access from non-EU IP addresses.
D.Use Microsoft Purview sensitivity labels to restrict access to EU users only.
AnswerA

Multi-geo ensures data residency, and RLS can filter data based on the user's region, effectively preventing non-EU users from seeing EU PII.

Why this answer

Option D is correct because Power BI allows setting geographic data residency at the tenant level, ensuring data is stored in a specific region. Additionally, row-level security (RLS) can restrict data access based on user location, but the question specifically mentions preventing access from outside the EU, which is best achieved by combining multi-geo with RLS. Option A is wrong because Microsoft Entra ID Conditional Access can block access to the service, but not to the data within reports.

Option B is wrong because data classification restricts actions but not access. Option C is wrong because sensitivity labels do not block access.

Full explanation →
536
MCQeasy

You create a bar chart showing sales by product category. You want to sort the categories by total sales descending. What should you do?

A.Click the ellipsis menu on the visual and choose 'Sort by Sales' then 'Sort descending'
B.Sort the visual by category name ascending
C.Create a measure that returns the sales value and sort by that measure
D.In the data model, set the Sort by Column property for Category
AnswerA

The visual's context menu allows sorting by the measure.

Why this answer

Option A is correct because you can sort the visual by the Sales field in descending order. Option B is wrong because sorting by category name is alphabetical. Option C is wrong because the data model does not have a sort by column for this purpose.

Option D is wrong because sorting by a measure is done via the visual's sort options.

Full explanation →
537
MCQhard

You are a Power BI administrator for a large enterprise. You have a Power BI semantic model that uses a single large fact table named Sales (100 million rows) and several dimension tables. The model is used by multiple departments, each with different row-level security (RLS) rules based on the SalesRegion column. You have implemented RLS using static roles. However, you notice that when users from different departments view the same report page, the query performance varies significantly. You suspect that the RLS filters are causing the performance difference. You need to investigate and optimize the RLS performance. What should you do first?

A.Increase the data model's memory limit in Premium capacity.
B.Use Power BI Performance Analyzer to capture query performance for each user role and analyze the generated DAX queries in DAX Studio.
C.Convert all RLS roles to use dynamic RLS with USERPRINCIPALNAME.
D.Remove all RLS roles and implement security at the report level using bookmarks.
AnswerB

This identifies the specific queries and their performance, helping pinpoint RLS impact.

Why this answer

Option A is correct: using Performance Analyzer and DAX Studio can identify which queries are slow and whether RLS is the cause. Option B would not help directly. Option C is a possible optimization but not the first step.

Option D is wrong because dynamic RLS is not necessarily faster.

Full explanation →
538
MCQhard

A Power BI administrator needs to allow an external partner organization to access a specific report without requiring them to have Power BI Pro licenses. The report is stored in a workspace assigned to a Premium capacity. What is the correct configuration?

A.Add the external users as members of the workspace and assign them a Viewer role
B.Publish the report to the web and share the public link
C.Invite the external users as guest users in Microsoft Entra ID, add them to the workspace with Viewer role, and share the report or app
D.Embed the report in a secure portal using the 'embed for your organization' option
AnswerC

B2B guest users can access Premium workspace content without Pro licenses.

Why this answer

Option D is correct because in a Premium capacity workspace, you can share reports with external users (B2B collaboration) and grant access via app or direct sharing; the external user's Microsoft Entra ID tenant is trusted, and they can access without a Pro license if the workspace is on Premium. Option A is wrong because publish to web makes the report public, not secure. Option B is wrong because embedding requires a license or capacity.

Option C is wrong because external users need to be invited as guests.

Full explanation →
539
Multi-Selectmedium

Which TWO actions can improve the performance of a Power BI report that uses DirectQuery? (Select two.)

Select 2 answers
A.Set up aggregations in the data source
B.Use calculated columns instead of measures
C.Add more slicers to allow users to filter data
D.Reduce the number of visuals on the page
E.Increase the cache size in the Power BI service
AnswersA, D

Aggregations can pre-summarize data, reducing query volume.

Why this answer

Options B and C are correct because reducing the number of visuals reduces queries, and setting up aggregations reduces the data scanned. Option A is wrong because increasing cache size does not affect DirectQuery. Option D is wrong because using calculated columns moves computation to Power BI, but they are evaluated row by row and can be slow.

Option E is wrong because using many small visuals increases queries.

Full explanation →
540
Multi-Selecteasy

Which TWO of the following are valid DAX functions for filtering data?

Select 2 answers
A.CALCULATE
B.FILTER
C.SUM
D.ALL
E.DISTINCT
AnswersB, D

FILTER is a filter function.

Why this answer

Options B and E are correct because FILTER and ALL are filter functions. Option A is wrong because SUM is an aggregation. Option C is wrong because CALCULATE is a function that modifies filter context but is not a filter function itself.

Option D is wrong because DISTINCT is a table function but not specifically a filter function.

Full explanation →
541
MCQmedium

You are a Power BI administrator. A user reports that their scheduled data refresh fails every day with the error 'The credentials provided for the data source are invalid.' The user has verified the credentials are correct. What is the most likely cause?

A.The user changed their password after configuring the refresh.
B.The data source requires OAuth authentication, and the refresh token has expired.
C.The on-premises data gateway is offline.
D.The dataset uses incremental refresh, which requires Premium capacity.
AnswerB

OAuth tokens expire; the user needs to re-authenticate the data source credentials in Power BI.

Why this answer

Option D is correct because if the data source uses OAuth, the refresh token may expire and need to be refreshed. Option A is wrong because the gateway status would show a different error. Option B is wrong because the user already verified credentials.

Option C is wrong because incremental refresh does not affect credential validity.

Full explanation →
542
MCQmedium

A Power BI administrator needs to audit which users have exported data from a specific report in the last 30 days. What is the most efficient way to retrieve this information?

A.Use the Microsoft Purview compliance portal to search for 'Export' events.
B.Check the report's usage metrics report for export counts.
C.Query the Power BI activity log using the audit log search in the Microsoft 365 Defender portal.
D.Review the 'Export to Excel' metrics in the Azure Monitor for Power BI Premium.
AnswerC

The Power BI activity log captures export events and can be queried via the Microsoft 365 Defender portal.

Why this answer

Option A is correct because the Power BI activity log contains export events (e.g., 'ExportToCSV', 'ExportToExcel') that can be filtered by report and date. Option B is wrong because Azure Monitor for Power BI Premium provides metrics but not detailed user-level export logs. Option C is wrong because Microsoft Purview audit logs may not include Power BI export events.

Option D is wrong because the usage metrics report only shows aggregate usage, not individual export actions.

Full explanation →
543
Matchingmedium

Match each Power BI component to its purpose.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Transform and clean data

Create calculated columns and measures

Share and collaborate on reports

Create reports and data models

On-premises report hosting

Why these pairings

These are core components of the Power BI ecosystem.

Full explanation →
544
MCQhard

Refer to the exhibit. The Power Query M code imports a CSV file. The import succeeds, but the 'OrderDate' column shows some dates as null even though they appear valid in the CSV. What is the most likely cause?

A.The date format in the CSV is not recognized by the locale used in the transformation.
B.The 'Filtered Rows' step removes rows where Amount > 0, which may include valid dates.
C.The 'Promoted Headers' step incorrectly changes the data type of the OrderDate column.
D.The 'Replaced Value' step replaces 'null' with null, causing the date to become null.
AnswerA

Type conversion to date may fail if the date string does not match the locale's date format.

Why this answer

Option A is correct because the '#Changed Type' step converts the column to type date, which will fail for any value that is not a valid date, resulting in null. If the CSV contains dates in a non-standard format (e.g., 'MM/dd/yyyy' vs 'dd/MM/yyyy'), the conversion may produce null. Option B is wrong because promoted headers only affect the first row.

Option C is wrong because replacing 'null' with null would not affect dates. Option D is wrong because filtering rows does not affect data types.

Full explanation →
545
MCQhard

Refer to the exhibit. You have the above Power Query M expression. You notice that the query is taking a long time to load. You suspect that query folding is not occurring for the filter on the Year column. What is the most likely reason?

A.The Year column is of type datetime, but the filter is an integer.
B.The query uses a native SQL query instead of a table reference.
C.The Year column is stored as text in the database, and Power Query cannot fold the numeric comparison.
D.The data source is using DirectQuery mode, which prevents folding.
AnswerC

If the column is text, the filter 'each [Year] >= 2020' may not fold because the database sees a string comparison. Converting to number might enable folding.

Why this answer

Option C is correct because when the Year column is stored as text in the database, Power Query cannot fold a numeric comparison (e.g., `Year > 2020`) into the source query. Query folding requires data type compatibility between the filter predicate and the source column; a text-to-integer comparison forces Power Query to fetch all rows and apply the filter locally, causing slow performance.

Exam trap

The trap here is that candidates assume any data type mismatch prevents folding, but the key nuance is that Power Query can fold compatible implicit conversions (e.g., datetime to integer for year comparisons) but cannot fold when the source column is text and the filter is numeric, because the engine lacks a safe folding path for that conversion.

How to eliminate wrong answers

Option A is wrong because Power Query can fold comparisons between a datetime column and an integer filter by implicitly converting the integer to a datetime (e.g., interpreting 2020 as a year), so this would not prevent folding. Option B is wrong because using a native SQL query does not inherently prevent folding; in fact, native SQL queries can still be folded if the source supports it, though they may limit further folding steps. Option D is wrong because DirectQuery mode does not prevent folding; in DirectQuery, all query transformations are sent to the source as SQL, so folding is actually maximized, not prevented.

Full explanation →
546
Multi-Selecthard

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

Select 2 answers
A.Using the time intelligence functions like TOTALYTD.
B.Marking an existing table as a date table.
C.Enabling the auto date/time feature.
D.Using DAX function CALENDAR or CALENDARAUTO.
E.Using Power Query with List.Dates.
AnswersD, E

Creates a date table with a range of dates.

Why this answer

Option D is correct because the DAX functions CALENDAR and CALENDARAUTO are specifically designed to generate a single-column table of dates, which can then be used as a date table. CALENDAR requires explicit start and end dates, while CALENDARAUTO automatically scans the model to determine the date range. Both are standard methods for creating a date table in Power BI.

Exam trap

The trap here is that candidates confuse time intelligence functions (like TOTALYTD) with table creation functions, or they assume that marking a table as a date table or enabling auto date/time actually creates a new date table, when in fact those options only configure existing data.

Full explanation →
547
MCQmedium

You are building a Power BI report for a logistics company. The data is stored in a CSV file on a SharePoint Online document library. The CSV file is updated daily with new rows. You need to ensure that the Power BI dataset reflects the latest data every morning at 7:00 AM. The data volume is small, so full refresh is acceptable. You have already published the report to the Power BI service. What should you do to automate the refresh?

A.In the Power BI service, configure a scheduled refresh for the dataset with the desired time.
B.Use Power Automate to trigger a refresh via the Power BI REST API every morning.
C.Enable incremental refresh for the dataset and set the refresh frequency to daily.
D.Install an on-premises data gateway and configure a scheduled refresh.
AnswerA

Correct. Scheduled refresh is the standard way to automate cloud data source refreshes.

Why this answer

Option A is correct because the Power BI service supports scheduled refresh natively for datasets that connect to cloud data sources like SharePoint Online CSV files. By configuring a scheduled refresh in the dataset settings, you can set it to run daily at 7:00 AM without any additional tools or gateways. This ensures the dataset reflects the latest data from the CSV file each morning.

Exam trap

The trap here is that candidates often overcomplicate the solution by choosing Power Automate or incremental refresh, not realizing that the Power BI service's built-in scheduled refresh is sufficient and the simplest option for cloud-based data sources with small data volumes.

How to eliminate wrong answers

Option B is wrong because while Power Automate can trigger a refresh via the Power BI REST API, it is unnecessary overhead for a simple daily refresh of a small dataset from a cloud source; the built-in scheduled refresh in the Power BI service is simpler and more direct. Option C is wrong because incremental refresh is designed for large datasets to partition data and refresh only new or changed rows, but the question states data volume is small and full refresh is acceptable, so incremental refresh adds complexity without benefit. Option D is wrong because an on-premises data gateway is required only for on-premises data sources (e.g., SQL Server on a local network), but the CSV file is stored in SharePoint Online, which is a cloud source accessible directly by the Power BI service without a gateway.

Full explanation →
548
MCQmedium

You are reviewing a Power Query M expression in the advanced editor. The exhibit shows the query. What is the final output of this query?

A.A table with total sales amount per customer for all orders
B.A table with total sales amount per customer for orders after 2023
C.A table with all sales records after 2023
D.A table with all sales records after 2023, excluding Discount column
AnswerB

The query filters, removes columns, and groups by CustomerID summing Amount.

Why this answer

The query filters the Sales table to keep only rows where the OrderDate is in 2024 or later (i.e., after 2023), then groups by CustomerID, summing the SalesAmount for each customer. The final output is a table with one row per customer showing their total sales amount for orders placed after 2023.

Exam trap

The trap here is that candidates often overlook the filter step and assume the query returns all records or all customers, failing to recognize that the date filter and grouping fundamentally change both the row set and the structure of the output.

How to eliminate wrong answers

Option A is wrong because it describes total sales per customer for all orders, but the query includes a filter step that removes orders from 2023 and earlier. Option C is wrong because it suggests all sales records after 2023 are returned, but the query groups the data and aggregates (sums) the sales, so individual records are not preserved. Option D is wrong because it mentions excluding a Discount column, but the query does not remove any columns; it only filters rows and then groups/aggregates.

Full explanation →
549
MCQmedium

You are examining a Power BI dataflow configuration. The dataflow is scheduled to refresh the 'Sales' entity daily and the 'Product' entity hourly. However, the 'Product' entity refresh fails every hour with an error indicating the SharePoint list data source is not accessible. You need to diagnose the issue. What is the most likely cause?

A.The refresh interval is too frequent for the incremental granularity of 'Day'
B.Incremental refresh is not supported for SharePoint list data sources
C.The workspace ID is missing from the dataflow configuration
D.The on-premises data gateway is not configured for the SharePoint list
AnswerA

Hourly refresh with daily granularity can cause overlapping partitions and high load.

Why this answer

Option A is correct because the 'Product' entity is configured to refresh hourly, but the dataflow's incremental refresh policy is set to a 'Day' granularity. Incremental refresh in Power BI requires the refresh frequency to align with or be less frequent than the incremental period; an hourly refresh on a daily partition causes the engine to attempt to query the entire day's data each time, which can lead to timeouts or errors if the source (SharePoint list) cannot handle the repeated full scans. The error 'data source is not accessible' often masks this underlying mismatch between refresh frequency and incremental granularity.

Exam trap

The trap here is that candidates often assume the error is due to gateway configuration or source incompatibility, but the real issue is a misalignment between the refresh schedule and the incremental refresh granularity, which is a subtle but common configuration mistake in dataflows.

How to eliminate wrong answers

Option B is wrong because incremental refresh is supported for SharePoint list data sources when using Power BI dataflows, provided the list has a date/time column for filtering. Option C is wrong because a missing workspace ID would prevent the dataflow from being saved or published, not cause a recurring refresh failure with a specific 'not accessible' error. Option D is wrong because an on-premises data gateway is only required for on-premises SharePoint (e.g., SharePoint Server), not for SharePoint Online lists accessed via the cloud; the error would also typically mention gateway connectivity if that were the issue.

Full explanation →
550
MCQhard

You have a Power BI dataset with a 'Sales' table that includes a 'ProductID' column. You also have a 'Products' table with 'ProductID' and 'Category' columns. You create a relationship between the tables. You want to create a measure that calculates the total sales for products in the 'Electronics' category. Which DAX expression should you use?

A.SUMX(Products, Products[Category] = "Electronics", Sales[Amount])
B.CALCULATE(SUM(Sales[Amount]), RELATED(Products[Category]) = "Electronics")
C.SUM(Sales[Amount])
D.CALCULATE(SUM(Sales[Amount]), Products[Category] = "Electronics")
AnswerD

CALCULATE applies a filter to the sum.

Why this answer

Option A is correct because CALCULATE modifies the filter context to include only 'Electronics' category. Option B is wrong because it sums over the Products table, not Sales. Option C is wrong because it sums the entire Sales table without filter.

Option D is wrong because it uses RELATED incorrectly.

Full explanation →
551
MCQhard

Your organization uses Power BI Premium capacity. You notice that reports are slow during peak hours. You need to identify which workspaces are consuming the most CPU resources on the capacity. What should you use?

A.Open the dataset in Power BI Desktop and view the performance analyzer.
B.Install and review the Power BI Premium Capacity Metrics app.
C.Enable diagnostic logging in Azure Monitor for the capacity.
D.Check the 'Capacity settings' in the Power BI admin portal.
AnswerB

This app provides per-workspace CPU metrics and other performance insights.

Why this answer

Option C is correct because the Power BI Premium Capacity Metrics app provides detailed metrics on CPU consumption per workspace, helping identify resource-intensive workspaces. Option A is wrong because the Admin portal shows overall capacity usage but not per workspace. Option B is wrong because Azure Monitor works only for Azure resources, not Power BI Premium capacities.

Option D is wrong because Power BI Desktop cannot monitor capacity usage.

Full explanation →
552
MCQmedium

A user wants to see the top 10 products by sales but also include a total row at the bottom of the table. How can you achieve this?

A.Apply a Top N filter to the visual and add a measure for total
B.Use the 'Show items with no data' option
C.Create a separate card visual for total sales
D.Enable the total row in the formatting pane of the table visual
AnswerD

Table and matrix visuals have an option to show totals in the formatting pane.

Why this answer

Option B is correct because the 'Show items with no data' option is unrelated, and a total row can be enabled in the formatting pane for table visuals. Option A is wrong because the total row is not a built-in feature for all visuals; it is available in table/matrix visuals. Option C is wrong because the 'Top N' filter does not include a total row.

Option D is wrong because a calculated column is not needed.

Full explanation →
553
Multi-Selecthard

You have a Power BI dataset that uses row-level security (RLS) with roles defined in Power BI Desktop. You publish the dataset to the Power BI service. Which TWO statements are true about RLS behavior?

Select 2 answers
A.RLS affects the refresh schedule of the dataset.
B.Users assigned to a role will only see rows that satisfy the role's DAX filter.
C.Visual titles are automatically filtered based on RLS.
D.RLS can restrict access to specific measures.
E.Role membership must be assigned in the Power BI service after publishing.
AnswersB, E

RLS restricts access to rows based on filters.

Why this answer

Options A and D are correct. A: RLS filters data at the row level based on the user's role. D: Role membership is managed in the Power BI service after publishing.

Option B is wrong because RLS does not affect measures. Option C is wrong because RLS does not automatically filter visual titles. Option E is wrong because RLS does not affect data refresh scheduling.

Full explanation →
554
MCQmedium

You are reviewing a Power BI data source configuration for an Azure SQL Database. The connection uses OAuth2 authentication. However, when scheduling a refresh, the refresh fails with an error that authentication fails. What is the most likely cause?

A.The authority URL should point to the specific Azure AD tenant, not 'common'
B.The connection string has 'Encrypt=True' which is incompatible with OAuth2
C.The server name in the connection string is incorrect
D.The resource URL should be 'https://management.azure.com/'
AnswerA

Using 'common' can cause authentication failures; it should be the specific tenant ID.

Why this answer

When using OAuth2 authentication with Azure SQL Database in Power BI, the authority URL must point to the specific Azure AD tenant (e.g., 'https://login.microsoftonline.com/your-tenant-id') rather than the generic 'common' endpoint. The 'common' endpoint is designed for multi-tenant applications and cannot resolve the tenant-specific authentication context required for scheduled refreshes, leading to authentication failures.

Exam trap

The trap here is that candidates often assume 'common' is always acceptable for OAuth2 flows, but Power BI scheduled refreshes require a tenant-specific authority URL to ensure the authentication context matches the Azure SQL Database's tenant.

How to eliminate wrong answers

Option B is wrong because 'Encrypt=True' is a recommended setting for Azure SQL Database connections and is fully compatible with OAuth2; it does not cause authentication failures. Option C is wrong because an incorrect server name would result in a connection timeout or 'cannot find server' error, not an authentication failure. Option D is wrong because the resource URL for Azure SQL Database should be 'https://database.windows.net/' (the scope for SQL Database), not 'https://management.azure.com/', which is used for Azure Resource Manager APIs.

Full explanation →
555
Drag & Dropmedium

Drag and drop the steps to create a calculated column in Power BI Desktop into the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order

Why this order

Creating a calculated column involves selecting the table, using the New Column button, and writing a DAX expression that evaluates row by row.

Full explanation →
556
MCQeasy

You are importing a CSV file into Power BI. The file contains a date column with values in the format 'MM/dd/yyyy'. However, Power Query interprets the dates as 'dd/MM/yyyy'. What should you do to correctly parse the dates?

A.Change the system region settings of the Power BI service to US
B.Use the 'Using Locale' option in the Change Type step to select the appropriate locale (e.g., English (United States))
C.Change the column data type to Text and then manually replace separators
D.Split the column into day, month, and year, then combine them in the correct order
AnswerB

Using locale allows Power Query to interpret dates correctly based on regional settings.

Why this answer

Option B is correct because Power Query's 'Using Locale' option in the Change Type step allows you to specify the regional format of the source data (e.g., English (United States) for 'MM/dd/yyyy'). This overrides Power Query's default locale-based interpretation, ensuring dates are parsed correctly without altering the data or system settings.

Exam trap

The trap here is that candidates often assume changing system region settings (Option A) will fix the issue, but Power Query's locale handling is independent of the Power BI service region, and the correct approach is to use the 'Using Locale' option within the query editor.

How to eliminate wrong answers

Option A is wrong because changing the Power BI service region settings does not affect how Power Query Desktop interprets date formats during import; locale handling is a Power Query engine feature, not a service-level setting. Option C is wrong because manually replacing separators is error-prone and unnecessary; Power Query already supports locale-aware date parsing without data transformation. Option D is wrong because splitting and recombining columns is a cumbersome workaround that introduces complexity and potential data loss, whereas the 'Using Locale' option directly solves the parsing issue.

Full explanation →
557
MCQhard

You need to design a data model for a sales analysis that includes measures for total sales, sales by product, and sales by customer. The source data has a 'Transactions' table with columns: TransactionID, Date, CustomerID, ProductID, Quantity, Amount. What is the recommended star schema design?

A.Create two fact tables: one for sales and one for customers
B.Create a fact table and separate dimensions for Date, Customer, and Product
C.Create a single table with all columns
D.Create a fact table and one dimension containing Customer and Product
AnswerB

This follows star schema best practices.

Why this answer

Option C is correct because a star schema has a fact table (Transactions) and dimension tables for Date, Customer, Product. Option A is wrong because a single flat table is not a star schema. Option B is wrong because placing Customer and Product in the same dimension violates star schema.

Option D is wrong because splitting into two fact tables is not necessary.

Full explanation →
558
MCQmedium

When importing data from a CSV file, Power Query detects that the first row contains column headers. However, the actual data starts from row 2. The analyst notices that some rows have extra columns due to commas within quoted fields. What is the most efficient way to handle this issue?

A.Remove the top row and then split columns manually.
B.Change the file encoding from UTF-8 to ANSI.
C.Use 'Split Column by Delimiter' and choose 'Comma' with the option to split at each occurrence.
D.Use 'Replace Values' to replace commas with semicolons.
AnswerC

This correctly handles quoted commas.

Why this answer

Option C is correct because the 'Split Column by Delimiter' feature in Power Query, when configured to split at each occurrence of the comma delimiter, correctly handles commas that appear inside quoted fields. Power Query's M engine respects the standard CSV quoting rules (RFC 4180), so quoted commas are not treated as delimiters. This approach is the most efficient as it requires no manual cleanup and preserves data integrity.

Exam trap

The trap here is that candidates may think manual splitting or replacing commas is simpler, but they overlook that Power Query's built-in split function natively respects CSV quoting rules, making it the most efficient and accurate solution.

How to eliminate wrong answers

Option A is wrong because removing the top row and manually splitting columns is inefficient and error-prone; it does not automatically handle commas within quoted fields, requiring manual intervention for each row. Option B is wrong because changing file encoding from UTF-8 to ANSI does not affect how commas inside quoted fields are parsed; encoding only affects character representation, not delimiter logic. Option D is wrong because replacing commas with semicolons would corrupt data by altering legitimate commas inside quoted fields, and it does not solve the problem of extra columns caused by quoted commas.

Full explanation →
559
MCQhard

You are a Power BI administrator. Your organization uses Microsoft Purview to manage sensitivity labels. You need to ensure that when a report is exported to PDF, the sensitivity label is automatically applied to the PDF file. What should you configure?

A.Enable the tenant setting 'Apply sensitivity labels to exported data' in the Power BI admin portal.
B.Enable 'Microsoft Purview Information Protection' file encryption settings.
C.Set the default sensitivity label for the workspace to 'Confidential'.
D.Configure a Microsoft Purview auto-labeling policy for Power BI reports.
AnswerA

This setting ensures that when a report with a sensitivity label is exported, the label is embedded in the exported file.

Why this answer

Option D is correct because Power BI can enforce sensitivity labels on exported files when the tenant setting 'Apply sensitivity labels to exported data' is enabled. Option A is wrong because the labeling policy applies at the report level, not during export. Option B is wrong because file encryption settings in Purview do not control Power BI export behavior.

Option C is wrong because the sensitivity label in the report does not automatically carry over to exports unless the tenant setting is enabled.

Full explanation →
560
Multi-Selecteasy

Which TWO of the following are valid methods to combine data from multiple sources in Power BI?

Select 2 answers
A.Pivot Column
B.Append Queries
C.Unpivot Columns
D.Merge Queries
E.Group By
AnswersB, D

Appends rows from one query to another.

Why this answer

Append Queries is a valid method to combine data from multiple sources in Power BI because it stacks rows from two or more tables into a single table, which is essential when you have similar data structures across different sources (e.g., monthly sales files). This operation is performed in Power Query Editor and corresponds to a UNION operation in SQL, making it a standard data preparation technique.

Exam trap

The trap here is that candidates often confuse data transformation operations (like Pivot, Unpivot, Group By) with data combination operations (Append and Merge), leading them to select options that modify existing data rather than integrate multiple sources.

Full explanation →
561
Multi-Selecteasy

Which TWO data sources can be used with DirectQuery mode in Power BI? (Choose two.)

Select 2 answers
A.Excel workbook
B.SQL Server
C.Azure SQL Database
D.CSV file
E.SharePoint list
AnswersB, C

SQL Server supports DirectQuery.

Why this answer

SQL Server is correct because it is a relational database that supports DirectQuery mode in Power BI, allowing queries to be sent directly to the source without importing data. This enables real-time access to large datasets while leveraging SQL Server's query processing capabilities.

Exam trap

The trap here is that candidates often confuse DirectQuery with Import mode, assuming any data source can be used with DirectQuery, but only relational databases like SQL Server and Azure SQL Database support it, while file-based sources like Excel and CSV do not.

Full explanation →
562
MCQmedium

You are a Power BI developer for a healthcare organization. You have a semantic model that contains a table named PatientVisits with columns: VisitID, PatientID, VisitDate, DiagnosisCode, and Charges. You have a separate table named Diagnosis with columns: DiagnosisCode, DiagnosisDescription, and Category. The Diagnosis table contains duplicate rows for the same DiagnosisCode but with different descriptions due to data entry errors. You need to create a relationship between PatientVisits and Diagnosis on DiagnosisCode. However, the duplicate values in Diagnosis prevent creating a one-to-many relationship. You must ensure that the relationship can be created without removing any rows from the Diagnosis table. What should you do?

A.Create a calculated table in DAX using SUMMARIZE(Diagnosis, Diagnosis[DiagnosisCode], "Description", FIRSTNONBLANK(Diagnosis[DiagnosisDescription], 1)) and use that table for the relationship.
B.In Power Query, remove duplicate rows based on DiagnosisCode, keeping the first occurrence.
C.Create a many-to-many relationship between PatientVisits and Diagnosis.
D.Create a composite key in PatientVisits by concatenating VisitID and DiagnosisCode, and relate to Diagnosis on that key.
AnswerA

This creates a distinct DiagnosisCode table with one description, allowing a one-to-many relationship.

Why this answer

Option A is correct: creating a calculated table that groups by DiagnosisCode and takes the first description resolves duplicates. Option B is wrong because removing duplicates in Power Query would remove rows permanently. Option C is wrong because you cannot create a relationship on a dash.

Option D would create a many-to-many relationship, which is not ideal.

Full explanation →
563
MCQmedium

You have a Power BI workspace named Sales. You need to ensure that only users in the Finance security group can view reports in this workspace, while members of the Sales team can edit and share content. What should you do?

A.Add Finance as Viewer, Sales as Member.
B.Add Finance as Contributor, Sales as Member.
C.Add Finance as Viewer, Sales as Admin.
D.Use row-level security to restrict Finance data, add both as Member.
AnswerA

Viewer can only view; Member can edit and share.

Why this answer

Option B is correct because workspace roles allow granular permissions: Viewer for Finance, Member for Sales. Option A is wrong because Contributor cannot share content. Option C is wrong because Admin gives full control.

Option D is wrong because row-level security does not control workspace access.

Full explanation →
564
MCQeasy

You are preparing a Power BI dataset that uses a SQL Server database as the source. Your manager asks you to ensure that the dataset refreshes automatically every morning at 6:00 AM. You have configured a scheduled refresh in the Power BI service. However, after the first scheduled refresh, you notice that it failed with an error: 'The data source credentials are invalid.' What is the most likely cause and solution?

A.The scheduled refresh time is not set correctly.
B.The data source credentials are not configured in the gateway.
C.An on-premises data gateway is not installed.
D.The dataset is too large for scheduled refresh.
AnswerB

Credentials must be set for the gateway to connect.

Why this answer

The error 'The data source credentials are invalid' indicates that the credentials stored in the Power BI service for the data source are incorrect or missing. Since the dataset uses a SQL Server database, which is an on-premises data source, the credentials must be configured within the on-premises data gateway settings in the Power BI service. Option B correctly identifies that the gateway credentials were not set up, causing the refresh to fail despite the scheduled refresh being configured.

Exam trap

The trap here is that candidates often confuse the scheduled refresh configuration with the data source credentials, assuming that setting the refresh time is sufficient, or they mistakenly think the error relates to the user's Power BI login rather than the gateway's stored credentials for the SQL Server database.

How to eliminate wrong answers

Option A is wrong because the scheduled refresh time being set incorrectly would not produce a 'credentials invalid' error; it would either not trigger or trigger at the wrong time. Option C is wrong because if no on-premises data gateway were installed, the error would typically indicate that a gateway is required or that the data source is unreachable, not specifically that credentials are invalid. Option D is wrong because a dataset being too large for scheduled refresh would result in a timeout or capacity error, not a credential validation failure.

Full explanation →
565
MCQhard

You are importing data from a CSV file into Power BI. The file contains a column 'SalesAmount' with values like '1,234.56' and '(987.65)' for negative amounts. You need to transform this column into a decimal number. Which sequence of Power Query steps achieves this?

A.Change Type to Decimal, then Replace Values (',' with ''), then Replace Values ('(' with '-')
B.Replace Values (',' with ''), then Replace Values ('(' with '-'), then Replace Values (')' with ''), then Change Type to Decimal
C.Replace Values (',' with ''), Change Type to Decimal, then Replace Values ('(' with '-')
D.Replace Values ('(' with '-'), Replace Values (')' with ''), Replace Values (',' with ''), then Change Type to Decimal
AnswerD

Correct order: handle negative sign first, then remove comma, then type conversion.

Why this answer

Option D is correct because it first removes the comma thousands separator, then replaces the opening parenthesis with a minus sign, removes the closing parenthesis, and finally changes the data type to Decimal. This sequence ensures that the negative indicator is properly placed before the numeric value and that the string is cleanly formatted for type conversion.

Exam trap

The trap here is that candidates often try to change the data type too early, before cleaning the string, or they forget to remove the closing parenthesis after replacing the opening one, leading to conversion errors.

How to eliminate wrong answers

Option A is wrong because changing the type to Decimal before removing the comma and parentheses will cause errors, as the string '1,234.56' and '(987.65)' are not valid decimal numbers. Option B is wrong because replacing '(' with '-' before removing ')' leaves a trailing parenthesis that will cause the type conversion to fail. Option C is wrong because changing the type to Decimal before handling the parentheses will result in errors for negative values, as the string still contains parentheses.

Full explanation →
566
MCQmedium

You are a Power BI administrator. The company has a premium capacity that many users publish reports to. Recently, users have reported that some reports are slow to load. You suspect that the capacity is being overused by certain large datasets. You need to identify which workspaces and datasets are consuming the most memory and CPU resources on the capacity. You want to use a tool that provides historical metrics and can be queried. What should you do?

A.Install the Power BI Premium Capacity Metrics app from AppSource.
B.Use Performance Analyzer in Power BI Desktop for each report.
C.Use the Power BI admin portal to view capacity metrics in real-time.
D.Enable Power BI activity logs and query Log Analytics for capacity metrics.
AnswerA

The app provides historical metrics and can be queried.

Why this answer

Option D is correct because the Power BI Premium Capacity Metrics app provides detailed historical metrics on memory, CPU, and query activity. Option A is wrong because the admin portal only shows current status. Option B is wrong because Log Analytics requires configuration and may not have historical data.

Option C is wrong because Performance Analyzer is for individual reports, not capacity-wide.

Full explanation →
567
MCQmedium

You are designing a report for mobile users. Which layout consideration is most important to ensure usability on small screens?

A.Arrange visuals horizontally to use screen width.
B.Place all visuals on a single page to avoid page navigation.
C.Use a vertical layout with key metrics placed at the top.
D.Use tooltips to provide additional details on tap.
AnswerC

Vertical layout with key metrics at top optimizes mobile reading.

Why this answer

Option C is correct because mobile reports should have a vertical layout with key metrics at the top to avoid scrolling. Option A is wrong because horizontal scrolling is difficult on mobile. Option B is wrong because many visuals do not support tooltips on mobile.

Option D is wrong because a single page with all visuals is overwhelming on mobile.

Full explanation →
568
MCQeasy

You are a business analyst at a manufacturing company. You receive weekly CSV files from different plants. Each file contains columns: PlantID, Date, ProductID, UnitsProduced, and ScrapUnits. However, the files sometimes have missing values in the ScrapUnits column, and occasionally there are duplicate rows (same PlantID, Date, ProductID). You need to prepare a clean dataset for reporting. The requirements are: 1. Combine all CSV files from a folder into a single table. 2. Replace null values in ScrapUnits with 0. 3. Remove duplicate rows based on PlantID, Date, and ProductID, keeping the first occurrence. 4. Ensure the data types are appropriate (e.g., Date as date, UnitsProduced as whole number). Which sequence of Power Query steps should you use?

A.Connect to folder, replace nulls in each file, combine files, remove duplicates, set data types.
B.Connect to folder, combine files, set data types, replace nulls, remove duplicates.
C.Connect to folder, combine files, remove duplicates, replace nulls, set data types.
D.Connect to folder, combine files, replace nulls, remove duplicates, set data types.
AnswerD

This order ensures nulls are handled before deduplication, and data types are set last to avoid conversion issues.

Why this answer

Option C is correct because the logical order is: connect to folder, combine files, then clean data (replace nulls, remove duplicates) and set data types. Option A is incorrect because setting data types before cleaning can cause errors. Option B is incorrect because removing duplicates before replacing nulls may remove rows that could be fixed.

Option D is incorrect because removing duplicates before combining files would apply to each file individually, not across files.

Full explanation →
569
MCQeasy

You need to create a calculated column in Power BI that shows the full name by combining 'FirstName' and 'LastName' columns with a space. Which DAX expression should you use?

A.FullName = [FirstName] & " " & [LastName]
B.FullName = CONCATENATE([FirstName], " ", [LastName])
C.FullName = CONCATENATEX(Table, [FirstName] & " " & [LastName])
D.FullName = [FirstName] + " " + [LastName]
AnswerA

The ampersand (&) is the correct concatenation operator in DAX.

Why this answer

Option A is correct because the DAX concatenation operator is the ampersand (&). Option B is wrong because CONCATENATE function only takes two arguments. Option C is wrong because CONCATENATEX is for tables.

Option D is wrong because the plus sign is for addition.

Full explanation →
570
MCQhard

Your organization uses Microsoft Purview Information Protection to label sensitive data in Power BI datasets. You need to ensure that when a report is exported to Excel, the sensitivity label is automatically applied. What should you configure?

A.Ensure the dataset has a sensitivity label and that the export inherits the label.
B.Use data loss prevention (DLP) policies in Microsoft Purview.
C.Set a default sensitivity label on the report.
D.Enable 'Apply sensitivity labels to exported data' in the Power BI admin portal.
AnswerA

Power BI automatically applies the dataset's sensitivity label to exported data when inheritance is configured.

Why this answer

Option D is correct because sensitivity labels are inherited from the dataset to downstream exports when the data source inherits the label. Option A is incorrect because labels are not applied via Power BI admin settings directly. Option B is incorrect because labels are not applied at export time; they are part of the data protection.

Option C is incorrect because labels are automatically applied based on the dataset's label, not configured individually on each report.

Full explanation →
571
MCQhard

Refer to the exhibit. You are reviewing a DAX measure for month-over-month sales growth. The measure returns BLANK for all months. What is the likely issue?

A.The FILTER function removes all context from the Date table, causing PriorSales to be calculated over the entire table.
B.The Date table is not marked as a date table.
C.The variable PriorDate returns a blank because MAX is used.
D.The IF condition incorrectly treats zero as blank.
AnswerA

Using ALL('Date') removes the filter context, so PriorSales is not filtered by PriorDate.

Why this answer

Option A is correct because the FILTER function uses ALL('Date') which removes all filters, so the PriorDate filter is not applied correctly. Option B is wrong because the date table has a relationship. Option C is wrong because the variable is correctly defined.

Option D is wrong because the IF condition checks for zero, which may not be the issue.

Full explanation →
572
MCQmedium

You have a Power BI report that uses a live connection to an Azure Analysis Services tabular model. Users report that the report loads slowly when filtering by a specific date range. You need to improve performance without changing the data source. What should you do?

A.Change the storage mode to Import for the fact table.
B.Apply a visual-level filter to limit the date range.
C.Create a field parameter to allow users to select measures.
D.Enable the 'Reduce queries sent to the source' option in the report settings.
AnswerD

This option reduces the number of DAX queries sent to the source by combining filters.

Why this answer

Option C is correct because enabling Query Reduction reduces the number of DAX queries sent to the source by combining filters and applying them in a single query. Option A is wrong because field parameters do not affect performance. Option B is wrong because it requires changing the data source to import mode.

Option D is wrong because visual-level filters do not reduce query load from the source.

Full explanation →
573
Multi-Selectmedium

You are developing a Power BI report to analyze sales performance. The data model includes a 'Sales' fact table with a 'Date' column and a 'Region' dimension table. You need to create a measure that calculates the total sales amount for the current year compared to the previous year. Which TWO of the following steps are required to implement this calculation correctly?

Select 2 answers
A.Use the Quick Measure feature to create a 'Year-over-year change' measure.
B.Create a separate date table and mark it as a date table in Power BI.
C.Apply the CALCULATE function to switch between years.
D.Use the SAMEPERIODLASTYEAR function in a DAX measure.
E.Ensure the 'Sales' table has a relationship to the 'Date' table with a many-to-many cardinality.
AnswersB, D

Required for time intelligence functions.

Why this answer

Option B is correct because a dedicated date table marked as a date table in Power BI is required for time intelligence functions like SAMEPERIODLASTYEAR to work correctly. Time intelligence functions rely on a continuous, contiguous date range with a 'Date' column marked as the date table, ensuring accurate year-over-year comparisons. Without this, the functions may return incorrect or blank results due to gaps or non-standard date hierarchies.

Exam trap

The trap here is that candidates often think using SAMEPERIODLASTYEAR alone is sufficient, but they overlook the prerequisite of having a separate, marked date table, which is a common requirement tested in PL-300 to ensure time intelligence functions work correctly.

Full explanation →
574
Multi-Selectmedium

Which TWO actions should you take to ensure that a Power BI report deployed to production is available to users even if the gateway is offline for maintenance?

Select 2 answers
A.Create a Power BI Premium capacity to ensure high availability.
B.Schedule the dataset refresh to run during the maintenance window.
C.Use DirectQuery instead of Import mode to avoid gateway dependency.
D.Create a separate dataset in the cloud that caches the data.
E.Implement a disaster recovery plan that includes a secondary gateway.
AnswersD, E

A cloud dataset can be refreshed when the gateway is online.

Why this answer

Option D is correct because creating a separate dataset in the cloud that caches the data (e.g., using a scheduled dataflow or a cloud-based dataset with Import mode) ensures that the report can still serve cached data from the Power BI service even when the on-premises gateway is offline for maintenance. This decouples report availability from gateway connectivity, as long as the cached data is refreshed before the maintenance window.

Exam trap

The trap here is that candidates often assume DirectQuery removes all gateway dependency, but in reality, DirectQuery still requires the gateway for on-premises sources and introduces real-time dependency, making it worse for offline scenarios than Import mode with a cached dataset.

Full explanation →
575
MCQeasy

You need to create a relationship between two tables in Power BI. Both tables contain a column named 'ProductID', but the values in one table are integers and in the other are text. What should you do first?

A.Merge the two tables into one in Power Query.
B.Ensure both columns have the same data type, either by changing the data type in Power Query or in the model view.
C.Create a new calculated column that converts the integer to text using FORMAT.
D.Set the relationship to 'Many-to-many' to bypass the type mismatch.
AnswerB

Matching data types is required before creating a relationship.

Why this answer

Option B is correct because Power BI requires matching data types to create a relationship. Option A is wrong because it is not necessary. Option C is wrong because changing the relationship type does not fix data type mismatch.

Option D is wrong because merging is not the first step.

Full explanation →
576
MCQeasy

You are designing a Power BI model for a multinational company. The fact table contains sales data in multiple currencies. You need to convert all amounts to a single reporting currency (USD) using exchange rates from a separate table. What is the recommended approach?

A.Add a calculated column to the fact table that multiplies by the exchange rate from a separate table
B.Create a relationship between the fact table and the exchange rate table on date and currency, then create a measure using SUMX with rate lookup
C.Hard-code the exchange rate in a measure
D.Use Power Query to merge the exchange rate table into the fact table during data load
AnswerB

Dynamic and accurate.

Why this answer

Create a relationship between the fact table and the exchange rate table using date and currency, then create a measure that multiplies the amount by the exchange rate. Option B is correct. Option A is wrong because it does not scale.

Option C is wrong because calculated columns are less flexible. Option D is wrong because Power Query conversion would be static.

Full explanation →
577
MCQeasy

A company publishes a Power BI dataset to the service. They need to ensure that when the underlying data source is updated, the dataset refreshes automatically within 30 minutes. The data source is an on-premises SQL Server database. Which component must be configured to enable this automatic refresh?

A.Publish the dataset with incremental refresh enabled
B.Change the dataset storage mode to DirectQuery
C.Install and configure an on-premises data gateway
D.Enable the XMLA endpoint for the workspace
AnswerC

The gateway enables Power BI to connect to on-premises data sources for scheduled refresh.

Why this answer

To enable automatic refresh of a Power BI dataset from an on-premises SQL Server database, you must install and configure an on-premises data gateway. The gateway acts as a secure bridge, allowing the Power BI service to connect to on-premises data sources and execute scheduled refreshes. Without it, the cloud service cannot directly access the local database.

Exam trap

The trap here is that candidates often confuse incremental refresh or DirectQuery as alternatives to the gateway, not realizing that any on-premises data source—regardless of storage mode—requires a gateway for the Power BI service to access it.

How to eliminate wrong answers

Option A is wrong because incremental refresh optimizes refresh performance by partitioning data, but it does not enable connectivity to on-premises sources; a gateway is still required. Option B is wrong because DirectQuery mode queries the source in real time without importing data, but it still requires a gateway for on-premises sources and does not address the scheduled refresh requirement within 30 minutes. Option D is wrong because enabling the XMLA endpoint allows programmatic management and advanced analytics, but it does not provide the connectivity needed for automatic refresh from an on-premises database.

Full explanation →
578
MCQhard

Your organization is implementing a data security strategy for Power BI. You need to ensure that sensitive data in datasets is protected at rest using customer-managed keys (CMK). What prerequisite must be met?

A.The workspace must be assigned to a Premium capacity (P or EM SKU).
B.Azure Purview must be configured for the tenant.
C.The Power BI tenant must be in a shared capacity.
D.The organization must use Bring Your Own Key (BYOK) for SQL Server.
AnswerA

CMK is only available in Premium capacities.

Why this answer

Option B is correct because Power BI Premium capacity with reserved capacity is required for CMK. Option A is wrong because CMK is not available in shared capacity. Option C is wrong because Azure Key Vault is needed but not sufficient alone.

Option D is wrong because Bring Your Own Key (BYOK) is for encryption keys, not CMK.

Full explanation →
579
MCQmedium

You are building a star schema in Power BI. A fact table contains sales transactions with columns: OrderID, CustomerID, ProductID, Quantity, UnitPrice, Discount, and OrderDate. You need to create a dimension table for customers. Which columns should be included in the Customer dimension?

A.CustomerID, CustomerName, ProductID
B.CustomerID, CustomerName, OrderID
C.CustomerID, CustomerName, OrderDate
D.CustomerID, CustomerName, City, Region
AnswerD

These are descriptive customer attributes with a unique key.

Why this answer

Option B is correct because in a star schema, dimension tables should contain descriptive attributes (e.g., CustomerName, City, Region) and a unique key (CustomerID). Including foreign key columns like CustomerID from the fact table would violate normalization. Option A is wrong because including ProductID is irrelevant for customer dimension.

Option C is wrong because OrderDate belongs to a date dimension. Option D is wrong because OrderID is a fact grain identifier.

Full explanation →
580
MCQhard

You are configuring a Power BI dataset with incremental refresh. The above JSON shows part of the M script parameters. The dataset uses a single SQL Server data source. You need to ensure that incremental refresh works correctly. What must you do?

A.Change the connection string to use a SQL account instead of integrated security.
B.Rename the parameter 'StartDate' to 'RangeStart' and add a 'RangeEnd' parameter.
C.Enable query folding on the SQL Server source.
D.Define the parameters in the Power Query editor instead of the JSON file.
AnswerB

Incremental refresh uses two reserved parameters named RangeStart and RangeEnd to filter the data. The current parameter name is incorrect.

Why this answer

Incremental refresh in Power BI requires two special date/time parameters named 'RangeStart' and 'RangeEnd' (case-sensitive). The JSON snippet shows a parameter named 'StartDate', which is not recognized by the incremental refresh engine. Renaming it to 'RangeStart' and adding a 'RangeEnd' parameter allows Power BI to filter the data source query dynamically during refresh, ensuring only the changed or new rows are loaded.

Exam trap

The trap here is that candidates assume any date parameter name will work for incremental refresh, but Power BI strictly requires the exact names 'RangeStart' and 'RangeEnd' (case-sensitive) to enable the partitioning logic.

How to eliminate wrong answers

Option A is wrong because changing the connection string to use a SQL account instead of integrated security does not affect the incremental refresh mechanism; authentication method is unrelated to the parameter naming convention required by Power BI. Option C is wrong because query folding is automatically enabled for SQL Server sources when using native queries or direct table references; it is not a manual step that needs to be performed separately for incremental refresh to work. Option D is wrong because defining parameters in the Power Query editor is the standard method, but the JSON file shown is the correct way to store them; the issue is the parameter names, not where they are defined.

Full explanation →
581
MCQhard

Your organization uses Power BI with a shared capacity (no Premium capacity). You need to implement row-level security (RLS) on a dataset that is used by multiple reports. Which of the following is a limitation you must consider?

A.RLS is not supported in shared capacity; you need a Premium license.
B.RLS roles must be created in the Power BI service after publishing; they cannot be created in Power BI Desktop.
C.RLS cannot be applied when the dataset uses DirectQuery to a data source that requires single sign-on (SSO) because the user's identity is passed through, and the source must enforce RLS.
D.RLS can only be applied to tables that are imported, not to tables using DirectQuery.
AnswerC

In DirectQuery with SSO, RLS in Power BI is bypassed; the source must enforce security.

Why this answer

Option B is correct because in shared capacity, RLS cannot be applied to datasets that use DirectQuery to Azure Analysis Services or other sources that require single sign-on (SSO) – RLS must be defined in the source. Option A is wrong because RLS works in shared capacity. Option C is wrong because RLS is defined in Power BI Desktop and works with import mode.

Option D is wrong because RLS can be defined in Power BI Desktop using DAX.

Full explanation →
582
Multi-Selecthard

You are using Copilot for Power BI to assist with data preparation. Which THREE tasks can Copilot help you with?

Select 3 answers
A.Generate DAX expressions for calculated columns and measures.
B.Create Power Query M code snippets for common transformations.
C.Set up incremental refresh policies.
D.Suggest transformations to clean and shape data.
E.Configure data source credentials for refresh.
AnswersA, B, D

Copilot can write DAX based on natural language descriptions.

Why this answer

Copilot for Power BI can generate DAX expressions for calculated columns and measures by interpreting natural language prompts, which helps users create complex formulas without deep DAX knowledge. This is a core feature of Copilot's AI assistance in Power BI Desktop.

Exam trap

The trap here is that candidates may assume Copilot can automate administrative tasks like refresh policies or credential configuration, but Copilot is limited to data preparation and transformation assistance within the Power BI Desktop environment.

Full explanation →
583
Multi-Selecthard

Which THREE conditions are required to use a service principal with Power BI? (Choose three.)

Select 3 answers
A.The service principal must have a Power BI Pro or Premium Per User license.
B.The service principal must be added as a member or admin of the workspace.
C.An on-premises data gateway must be installed.
D.Service principal access must be enabled in the Power BI admin portal.
E.The service principal must use XMLA endpoints.
AnswersA, B, D

Service principals need a license to access Power BI.

Why this answer

Options A, C, and E are correct. A: Service principal must have a Power BI license (Pro or Premium Per User). C: The service principal must be enabled in the admin portal.

E: Service principal must be a member of the workspace. Option B is wrong because a gateway is not required. Option D is wrong because XMLA endpoints are not required for all operations.

Full explanation →
584
MCQhard

You are a data analyst for a retail company with stores across 50 states. You have a Power BI dataset that imports sales data from a SQL Server database daily. The fact table contains 200 million rows and includes columns: StoreID, ProductID, DateKey, SalesAmount, Quantity, and Discount. You also have dimension tables for Store, Product, and Date. Users report that a report page with a matrix visual showing SalesAmount by Store and ProductCategory takes over 30 seconds to render. You need to improve the performance of this visual without changing the data source or reducing the data granularity. You have the following options: A. Change the matrix visual to a table visual. B. Create an aggregation table on Store and ProductCategory with pre-calculated SalesAmount. C. Enable 'Show items with no data' on the matrix. D. Use a measure that sums SalesAmount and use the 'Filter' pane to restrict to top 100 rows. Which option should you choose?

A.Change the matrix visual to a table visual
B.Use a measure that sums SalesAmount and use the 'Filter' pane to restrict to top 100 rows
C.Create an aggregation table on Store and ProductCategory with pre-calculated SalesAmount
D.Enable 'Show items with no data' on the matrix
AnswerC

Aggregations reduce the amount of data scanned, improving query speed.

Why this answer

Option B is correct because creating an aggregation table at a higher granularity (Store, ProductCategory) allows Power BI to use aggregated data for the visual, drastically reducing query time. Option A is wrong because a table visual does not improve performance; it may even be slower. Option C is wrong because showing items with no data increases the number of rows displayed.

Option D is wrong because filtering to top 100 rows does not address the underlying query performance; the measure still scans the entire fact table.

Full explanation →
585
MCQmedium

Refer to the exhibit. You apply the above RLS rule to a semantic model. The rule is intended to restrict sales data by the user's region, which is stored in the user's email domain (e.g., user@west.contoso.com). However, the rule does not filter any rows. What is the most likely issue?

A.The Sales table does not have a Region column.
B.USERPRINCIPALNAME() is not available in the current Power BI version.
C.The filter expression compares the full UPN to the Region column, which likely contains only the region name.
D.The RLS rule is not applied to the semantic model.
AnswerC

USERPRINCIPALNAME() returns 'user@west.contoso.com', not just 'West'.

Why this answer

Option B is correct because USERPRINCIPALNAME() returns the full UPN, which includes the domain. The filter expression compares the entire UPN to the Region column, which likely contains only the region part (e.g., 'West'). Option A is wrong because the rule is applied.

Option C is wrong because the table exists. Option D is wrong because USERPRINCIPALNAME() is valid.

Full explanation →
586
MCQmedium

A data modeler is creating a Power BI semantic model for a retail company. The model includes a 'Products' dimension table with columns ProductID, ProductName, Category, and Subcategory. The 'Sales' fact table has columns ProductID, Date, Quantity, and Revenue. The modeler wants to ensure that users can filter by Category and Subcategory. Which relationship type should be created between Products and Sales?

A.One-to-many (Products to Sales)
B.Many-to-one (Sales to Products)
C.Many-to-many
D.One-to-one
AnswerA

Each product can have many sales, so Products is the 'one' side.

Why this answer

In a Power BI semantic model, a one-to-many relationship from Products (the dimension table) to Sales (the fact table) is the standard star schema design. This allows users to filter Sales data by any attribute in Products, such as Category and Subcategory, because each ProductID in Products is unique (the 'one' side) and can be associated with many rows in Sales (the 'many' side). This relationship type ensures proper cross-filtering and aggregation behavior.

Exam trap

The trap here is that candidates might confuse the cardinality direction (one-to-many vs. many-to-one) as being technically different, but Power BI treats them identically; the key is recognizing that the dimension table (Products) should be on the 'one' side to maintain a proper star schema and avoid unnecessary complexity.

How to eliminate wrong answers

Option B is wrong because many-to-one (Sales to Products) is the same cardinality as one-to-many but with the direction reversed; Power BI treats them equivalently, but the question asks for the relationship type between Products and Sales, and the standard convention is to place the dimension on the 'one' side. Option C is wrong because many-to-many relationships are used when both tables have duplicate values on the key columns, which is not the case here (ProductID is unique in Products). Option D is wrong because one-to-one relationships are rare in star schemas and would require each ProductID in Sales to be unique, which contradicts the fact that a product can be sold multiple times.

Full explanation →
587
MCQhard

You have a Power BI semantic model with a fact table 'Orders' and dimension tables 'Customer', 'Product', and 'Date'. The model uses DirectQuery against Azure Synapse. Users report that a measure calculating Year-over-Year growth returns incorrect values for the current year when no data exists for the prior year. Which DAX modification ensures the measure returns blank instead of an incorrect value?

A.Add an IF condition to check if prior year has any rows before computing growth
B.Use DIVIDE with an alternative result of 0
C.Use ISBLANK to check the current year value
D.Use COALESCE to replace blank with 0
AnswerA

Ensures blank when prior year data is missing.

Why this answer

Option B is correct: Using IF(COUNTROWS(...) > 0, ...) checks if prior year data exists. Option A is wrong because DIVIDE with 0 denominator returns blank, but does not handle missing prior year rows. Option C is wrong because ISBLANK on a scalar value doesn't check row existence.

Option D is wrong because COALESCE returns the first non-blank, but the issue is incorrect CALCULATE results when prior year is missing.

Full explanation →
588
Multi-Selecthard

You are preparing data for a Power BI report. The source data has a column 'OrderDate' with date values. You need to create a date hierarchy for drill-down (Year, Quarter, Month). Which TWO actions are required?

Select 2 answers
A.Create a separate date table with a continuous range of dates.
B.Enable auto date/time in Power BI Desktop.
C.Sort the Month column by MonthNumber to ensure proper order.
D.Mark the date table as a date table in Power BI Desktop.
E.Add calculated columns for Year, Quarter, and Month to the date table.
AnswersA, D

A proper date table is needed to create a date hierarchy and support time intelligence.

Why this answer

Options B and D are correct. You need to mark a date table as a date table to enable time intelligence and create a date hierarchy. Creating a date table with a continuous range ensures all periods are represented.

Option A is wrong because auto date/time creates hidden hierarchies but may not be sufficient for custom requirements. Option C is wrong because calculated columns do not create a hierarchy. Option E is wrong because sorting by month number is useful but not required for a hierarchy.

Full explanation →
589
MCQeasy

You are creating a Power BI report and want to allow users to ask questions about the data using natural language. Which feature should you enable?

A.Quick Insights.
B.Key Influencers visual.
C.Q&A visual.
D.Copilot for Power BI.
AnswerC

Q&A allows users to ask questions in natural language.

Why this answer

Option B is correct because Q&A allows natural language queries. Option A is wrong because Copilot is an AI assistant but not specifically for Q&A in the same way. Option C is wrong because Quick Insights generates automatic insights, not Q&A.

Option D is wrong because Key Influencers identifies influencers.

Full explanation →
590
Multi-Selecteasy

Which THREE are data sources that can be imported into Power BI Desktop?

Select 3 answers
A.SQL Server database
B.CSV file
C.PDF file
D.Excel workbook
E.Word document
AnswersA, B, D

Supported relational source.

Why this answer

A is correct because Power BI Desktop includes native connectors for SQL Server databases, allowing direct import of data via T-SQL queries or table selection. This is a first-class data source in the Get Data experience, supporting Windows and SQL Server authentication.

Exam trap

Microsoft often tests the misconception that PDF and Word documents are importable data sources in Power BI Desktop, when in reality only structured data sources like databases, CSV, and Excel are natively supported for import.

Full explanation →
591
MCQeasy

You have a Power BI dataset that connects to an Azure SQL Database. You need to use single sign-on (SSO) so that users' identities are passed to the database. What authentication method should you configure?

A.Windows authentication
B.Key authentication
C.OAuth2 with Microsoft Entra ID
D.Basic authentication with a service account
AnswerC

OAuth2 enables SSO.

Why this answer

Option A is correct because SSO with Azure AD (now Microsoft Entra ID) passes the user identity. Option B is wrong because it uses a fixed identity. Option C is wrong because it's for on-premises data.

Option D is wrong because it's for web services.

Full explanation →
592
MCQmedium

You have a Power BI data model with a table that contains duplicate rows. You want to remove duplicates in Power Query. Which transformation should you use?

A.Replace Values
B.Remove Duplicates
C.Filter Rows
D.Group By
AnswerB

Remove Duplicates eliminates duplicate rows.

Why this answer

Option C is correct because 'Remove Duplicates' removes duplicate rows based on selected columns. Option A filters rows. Option B groups rows.

Option D replaces values.

Full explanation →
593
MCQhard

A Power BI administrator receives a support ticket that users can see reports in the Power BI service but cannot access them, receiving a 'not found' error. The reports are stored in a shared workspace. What should the administrator check first?

A.Verify that the users have Power BI Pro or Premium Per User licenses assigned
B.Confirm that the report is published to the correct workspace
C.Ensure the workspace is assigned to an active capacity (Pro or Premium) and that the capacity is not paused
D.Check if row-level security (RLS) is blocking access to the underlying data
AnswerC

A paused or deleted capacity can cause 'not found' errors despite listing.

Why this answer

Option D is correct because if users are in a workspace with a different capacity, they may see reports due to caching but get 'not found' when trying to open them if the capacity is paused or deleted. Option A is wrong because license assignment is usually global. Option B is wrong because RLS would show data, not 'not found'.

Option C is wrong because the reports exist.

Full explanation →
594
Multi-Selectmedium

Which TWO of the following are valid ways to create a date table in Power BI? (Select two.)

Select 2 answers
A.Using DAX: DateTable = DATESYTD('Date'[Date])
B.Using DAX: DateTable = CALENDARAUTO()
C.Using DAX: DateTable = CALCULATE(DISTINCT(Sales[Date]))
D.Using Power Query: Generate a list of dates from a start to end date
E.Using DAX: DateTable = SUMMARIZE(Sales, Sales[Date])
AnswersB, D

CALENDARAUTO() returns a table with all dates from the model.

Why this answer

Option A is valid by using CALENDARAUTO. Option D is valid by using Power Query to generate a list of dates. Option B is wrong because CALCULATE is a function, not a table constructor.

Option C is wrong because DATESYTD returns a table of dates but only for a year-to-date period, not a full date table. Option E is wrong because SUMMARIZE returns a summary table, not a date table.

Full explanation →
595
Multi-Selectmedium

You are designing a Power BI dashboard for executive review. The dashboard must include a card visual showing the total sales for the current year. You need to ensure that the card visual updates automatically when data refreshes. Which TWO actions should you take?

Select 2 answers
A.Configure a scheduled refresh for the dataset
B.Set the visual to refresh every 5 minutes
C.Use a measure that recalculates on every interaction
D.Enable page auto-refresh in the report settings
E.Set the report to refresh on page load
AnswersA, D

Scheduled refresh ensures data updates automatically.

Why this answer

Options B and C are correct because setting auto-refresh and scheduling a data refresh ensure the visual updates. Option A is incorrect because manual refresh is not automatic. Option D is incorrect because DAX measures update on refresh without additional setting.

Option E is incorrect because page refresh is not the same as data refresh.

Full explanation →
596
MCQmedium

A company deploys Power BI for internal reporting. The security team requires that all report data be encrypted at rest and in transit, and that access be granted only to users with verified identities. Which combination of features should the Power BI administrator use?

A.Apply row-level security (RLS) and use Microsoft Intune for conditional access
B.Leverage Azure SQL Database Transparent Data Encryption (TDE), TLS, and Microsoft Entra ID
C.Use Microsoft Purview for encryption and Microsoft Intune for identity
D.Enable Power BI encryption settings and configure SharePoint permissions
AnswerB

TDE encrypts data at rest, TLS encrypts in transit, and Entra ID provides verified identity.

Why this answer

Option C is correct because Power BI uses Azure SQL Database encryption at rest, TLS for data in transit, and integrates with Microsoft Entra ID for authentication. Option A is wrong because Microsoft Purview is for data governance, not encryption. Option B is wrong because SharePoint is not a core encryption or identity service for Power BI.

Option D is wrong because Microsoft Intune is for mobile management, not encryption.

Full explanation →
597
MCQmedium

You are building a star schema in Power BI. The Sales table contains sales amount, quantity, and discount. You need to create a relationship between Sales and a Date table. The Date table must have a one-to-many relationship with Sales, and all date filters must show sales even if no sales occurred on that date. Which relationship configuration should you use?

A.One-to-many, single direction (Sales filters Date)
B.One-to-many, single direction (Date filters Sales)
C.One-to-many, both directions
D.Many-to-one, single direction (Date filters Sales)
AnswerB

Correct cardinality and filter direction ensures all dates are shown.

Why this answer

Option D is correct: Single direction filter from Date to Sales ensures all dates are shown when used as a filter, and one-to-many is the appropriate cardinality. Option A is wrong because bidirectional filter is unnecessary and can cause ambiguity. Option B is wrong because many-to-one is the reverse relationship.

Option C is wrong because cross-filter direction both is not needed.

Full explanation →
598
MCQmedium

You have a Power BI dataset that includes a date table created using CALENDAR(). You need to ensure that the date table always covers the full range of dates present in the fact table, even after new data is loaded. What should you do?

A.Use a fixed start and end date in the CALENDAR function
B.Create a disconnected date table
C.Create the date table using CALENDAR(MIN('Fact'[Date]), MAX('Fact'[Date]))
D.Enable Auto Date/Time in the model
AnswerC

This dynamic approach updates with the fact table's date range.

Why this answer

Option C is correct because using `CALENDAR(MIN('Fact'[Date]), MAX('Fact'[Date]))` dynamically computes the date range from the fact table's actual data. This ensures that when new data is loaded with dates outside the previous range, the date table automatically expands to cover the full range, maintaining referential integrity for time intelligence calculations.

Exam trap

The trap here is that candidates often choose Option A (fixed dates) because they think a static range is simpler and sufficient, but they overlook the requirement for the date table to dynamically cover the full range after new data loads, which only a dynamic CALENDAR expression can achieve.

How to eliminate wrong answers

Option A is wrong because using a fixed start and end date in the CALENDAR function creates a static date table that will not expand when new data with dates outside that fixed range is loaded, leading to missing dates and broken relationships. Option B is wrong because a disconnected date table is not related to the fact table via a relationship, so it cannot enforce referential integrity or be used for standard time intelligence functions that rely on an active relationship. Option D is wrong because enabling Auto Date/Time creates hidden date tables automatically, but these tables are not user-defined, cannot be customized, and do not guarantee coverage of the exact date range present in the fact table; they also increase model size and are not recommended for production.

Full explanation →
599
MCQhard

A Power BI data model includes a table 'Orders' with columns OrderID, CustomerID, OrderDate, SalesAmount. The model also has a 'Date' table and a 'Customer' table. The relationships are: Orders[CustomerID] -> Customer[CustomerID] (many-to-one, single direction) and Orders[OrderDate] -> Date[Date] (many-to-one, single direction). A user creates a measure that sums SalesAmount and then filters by a slicer on Customer[City]. The slicer works correctly. However, when the user adds another slicer on Date[Year], the measure does not respect both slicers simultaneously. What is the most likely cause?

A.The Customer and Date tables are not related to each other.
B.The relationship between Orders and Date is inactive.
C.The relationships are set to single direction, so filters from Date do not propagate to Orders.
D.The measure might be using ALL or ALLEXCEPT that removes the filter context from the Date table.
AnswerD

If the measure removes filters from Date, then the slicer on Date[Year] would be ignored.

Why this answer

Option D is correct because the measure likely uses ALL or ALLEXCEPT, which removes the filter context from the Date table. Even though the relationships are correctly configured and filters from the Date slicer propagate to Orders via the single-direction relationship, if the measure explicitly ignores those filters using a function like ALL(Date[Year]) or ALLEXCEPT(Orders, ...), the Date slicer will have no effect on the measure. This is a common DAX mistake where filter removal functions override slicer selections.

Exam trap

The trap here is that candidates often assume filter propagation direction is the problem, but the real issue is that DAX filter removal functions like ALL or ALLEXCEPT can silently override slicer filters, making it appear as though the relationship is broken.

How to eliminate wrong answers

Option A is wrong because the Customer and Date tables do not need to be directly related; filters propagate independently through their respective relationships to the Orders table. Option B is wrong because the relationship between Orders and Date is explicitly described as active (many-to-one, single direction), so it is not inactive. Option C is wrong because single-direction relationships do allow filters from the Date table to propagate to Orders; the issue is not with direction but with the measure overriding the filter context.

Full explanation →
600
MCQeasy

You have a date table with columns: Date, Year, Month, Quarter, Day. To enable time intelligence functions like TOTALYTD, what is the minimum requirement?

A.A separate date table with a continuous range of dates and a relationship to the fact table.
B.Mark the date table as a date table in Power BI.
C.Combine date and fact tables into one table.
D.A single date column in the fact table.
AnswerA

This is the standard requirement for time intelligence.

Why this answer

Option B is correct because time intelligence functions require a date table with continuous dates and a many-to-one relationship to the fact table's date column. Option A is wrong because a date column alone is not sufficient; the date table must be marked as a date table. Option C is wrong because marking the date table is required.

Option D is wrong because a single table is not required; a separate date table is preferred.

Full explanation →
Page 7

Page 8 of 13

Page 9

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 →