Microsoft Power BI Data Analyst PL-300 (PL-300) — Questions 751825

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

Page 10

Page 11 of 13

Page 12
751
MCQeasy

A Power BI admin applies the Azure Policy shown in the exhibit. What is the effect of this policy?

A.No one can read any datasets
B.Users cannot read datasets in the finance workspace
C.All users can read datasets in all workspaces
D.Only users in the finance workspace can read datasets
AnswerD

The condition allows only the finance workspace.

Why this answer

The Azure Policy in the exhibit is configured to deny the 'Read' permission on datasets for all users except those in the 'finance' workspace. This means only users who are members of the finance workspace can read datasets, while all other users are denied read access. Therefore, option D is correct because it accurately describes that only users in the finance workspace can read datasets.

Exam trap

The trap here is that candidates often misinterpret the deny effect as a blanket denial for all users, overlooking the exclusion condition that allows specific users (finance workspace) to read datasets.

How to eliminate wrong answers

Option A is wrong because the policy does not deny read access to all datasets; it specifically allows read access for users in the finance workspace. Option B is wrong because the policy does not restrict reading datasets in the finance workspace; it actually permits it for finance workspace users. Option C is wrong because the policy denies read access to datasets for all users except those in the finance workspace, so not all users can read datasets in all workspaces.

752
Multi-Selecthard

You have a Power BI dataset that includes a Sales table with a column 'TransactionDate'. You need to create a date dimension table using DAX. Which THREE of the following are recommended practices?

Select 3 answers
A.Use CALENDARAUTO() to automatically generate the date range.
B.Use DISTINCT(Sales[TransactionDate]) to create the date table.
C.Include dates from January 1 of the earliest year to December 31 of the latest year in the data.
D.Create each date column manually using ADDCOLUMNS.
E.Mark the table as a date table in Power BI.
AnswersA, C, E

CALENDARAUTO is a convenient function that covers the data range.

Why this answer

Options A, C, and D are correct. A: Including a full calendar year range ensures all dates are covered. C: Marking as date table enables time intelligence functions.

D: CALENDARAUTO automatically adjusts to the data range. Option B is wrong because using DISTINCT on TransactionDate may miss dates without transactions. Option E is wrong because adding columns one by one is inefficient.

753
Multi-Selecteasy

Which TWO methods can you use to share a Power BI report with external users who do not have a Power BI Pro license? (Choose two.)

Select 2 answers
A.Embed the report in a secure portal using 'Embed for your customers'.
B.Publish to a public website (Publish to web).
C.Export the report to PDF and share the file.
D.Share directly via Power BI using the user's email address.
E.Export the report to Excel and attach it to an email.
AnswersA, B

Allows users to view without a Pro license.

Why this answer

Options A and D are correct. You can share a report by publishing to a public website (if allowed) or by embedding it in a secure portal using the 'Embed for your customers' option (requires Premium). Option B is incorrect because sharing via email requires the recipient to have a Pro license.

Option C is incorrect because exporting to PDF does not provide interactive sharing. Option E is incorrect because exporting to Excel is not a sharing method.

754
MCQhard

You are building a report that uses a calculated column with the formula: 'Profit = Sales[Revenue] - Sales[Cost]'. Users report that the Profit column shows negative values for some rows when it should be positive due to a known data issue in the Cost column. What is the best approach to handle this without modifying the source data?

A.Create a measure that filters out rows with negative profit.
B.Apply conditional formatting on the Profit column to hide negative values.
C.Switch the table to DirectQuery mode to retrieve live data.
D.Modify the calculated column to use COALESCE or IF to treat missing or incorrect cost values.
AnswerD

Using DAX functions allows you to correct data quality issues within the model.

Why this answer

Option C is correct because using Data Analysis Expressions (DAX) functions like IF or COALESCE allows you to handle data quality issues within the model. Option A is wrong because it uses DirectQuery, but the issue is in the model, not the query type. Option B is wrong because conditional formatting only changes visual appearance, not the underlying value.

Option D is wrong because removing negative values would hide the issue without fixing it.

755
MCQeasy

You have a Power BI data model with a 'Date' table that contains continuous dates from January 1, 2020, to December 31, 2025. The 'Sales' table has a relationship with the 'Date' table. You need to create a measure that calculates the total sales for the last 12 months from the current context. Which DAX function should you use?

A.PREVIOUSMONTH
B.DATEADD
C.DATESINPERIOD
D.SAMEPERIODLASTYEAR
AnswerC

DATESINPERIOD returns a set of dates in a period from a start date.

Why this answer

Option D is correct. DATESINPERIOD allows you to specify a range of dates (e.g., last 12 months) relative to a end date. Option A is incorrect because SAMEPERIODLASTYEAR returns the same period one year ago, not the last 12 months.

Option B is incorrect because DATEADD shifts dates by an interval. Option C is incorrect because PREVIOUSMONTH returns the previous month only.

756
MCQmedium

You have a table with a column 'Date' in text format (e.g., '2024-01-15'). You need to convert it to a date type. In Power Query, what is the best approach?

A.Split the column into year, month, day and then combine.
B.Use the Excel Power Query add-in.
C.Create a calculated column in DAX using DATEVALUE.
D.Change the column data type to Date in Power Query Editor.
AnswerD

Changing data type is straightforward and efficient.

Why this answer

Option C is correct because changing the data type in Power Query is the standard method. Option A is wrong because DAX calculated columns are for the data model, not for Power Query. Option B is wrong because Power Query can handle this natively.

Option D is wrong because it is not necessary to split the column.

757
MCQhard

During data refresh in Power BI, an error occurs: 'The column 'OrderID' of the table 'Orders' contains a duplicate value and this column is part of a primary key.' The table 'Orders' is imported from an Azure SQL database. What is the most likely cause of this error?

A.The 'Orders' table was reordered in Power Query.
B.Data type mismatch between the source and Power BI.
C.A calculated column is referencing the 'Orders' table.
D.The source table has duplicate 'OrderID' values.
AnswerD

Duplicate values violate the primary key constraint.

Why this answer

Option D is correct because the error message explicitly states that the 'OrderID' column contains a duplicate value and is part of a primary key. In Power BI, when importing from a source like Azure SQL Database, the data model enforces uniqueness on primary key columns. If the source table has duplicate 'OrderID' values, the refresh fails because Power BI cannot maintain the required unique constraint.

Exam trap

The trap here is that candidates may confuse a primary key violation with other common refresh errors like data type mismatches or query folding issues, but the error message's explicit reference to 'duplicate value' and 'primary key' directly points to source data duplication.

How to eliminate wrong answers

Option A is wrong because reordering columns in Power Query does not affect data integrity or primary key uniqueness; it only changes the column sequence in the dataset. Option B is wrong because a data type mismatch would cause a conversion error, not a duplicate value error on a primary key column. Option C is wrong because a calculated column referencing the 'Orders' table does not introduce duplicate values; it computes values based on existing rows and does not alter the source data's uniqueness.

758
MCQhard

You have a Power BI model with a large fact table (100 million rows) and several dimension tables. You need to improve query performance for a report that uses a date slicer. The report currently takes 10 seconds to load. What is the most effective optimization?

A.Partition the fact table by date range.
B.Remove unused columns from the fact table.
C.Increase the Power BI service capacity.
D.Create an aggregated table that summarizes data at the month level.
AnswerA

Date partitioning allows incremental refresh and reduces query data.

Why this answer

Partitioning the fact table by date range allows Power BI to perform query folding and only scan the relevant partitions when a date slicer is applied. This reduces the amount of data loaded into memory and processed, directly addressing the 100-million-row fact table and the 10-second load time. Partitioning is a native optimization for large tables in DirectQuery or Import mode when using date-based filtering.

Exam trap

The trap here is that candidates often choose aggregation (Option D) as a quick fix for performance, but they overlook that the report uses a date slicer requiring day-level granularity, making aggregation inappropriate unless the user is willing to lose detail; partitioning directly addresses the root cause of scanning too many rows.

How to eliminate wrong answers

Option B is wrong because removing unused columns reduces storage and refresh time but does not significantly improve query performance for a date-sliced report; the bottleneck is row scanning, not column width. Option C is wrong because increasing Power BI service capacity (premium SKU) improves concurrency and resource limits, not the per-query scan time for a single report; the issue is data model design, not capacity. Option D is wrong because creating an aggregated table at the month level can improve performance for month-level granularity, but the report uses a date slicer (likely day-level), so aggregation loses detail and may not satisfy the user's need for daily filtering; partitioning is more effective for the exact date range requested.

759
MCQhard

You are a data analyst for a financial services company. You have a Power BI dataset that combines data from two sources: a CSV file in SharePoint Online and an on-premises SQL Server database. The CSV file contains exchange rates that are updated daily. The SQL Server database contains transaction data. You need to ensure that the dataset can be refreshed automatically in the Power BI service. The CSV file is updated at 6:00 AM daily, and the SQL Server database is updated continuously. You have already published the report. What should you do to enable automated refresh?

A.Use Power Automate to refresh the dataset after the CSV is updated.
B.Enable incremental refresh for the SQL Server table to reduce refresh time.
C.Install and configure an on-premises data gateway, then set up a scheduled refresh.
D.Configure a scheduled refresh in the dataset settings. The gateway is not required because the CSV file is in SharePoint Online.
AnswerC

Correct. A gateway is needed for the on-premises SQL Server, and then scheduled refresh works.

Why this answer

Option C is correct because the on-premises SQL Server database requires an on-premises data gateway to bridge the Power BI service with the local network. Even though the CSV file is in SharePoint Online, the dataset combines both sources; the gateway is mandatory for the SQL Server component. Without it, scheduled refresh cannot access the on-premises data, and the dataset will fail to refresh automatically.

Exam trap

The trap here is that candidates assume a gateway is unnecessary because one data source (SharePoint Online) is cloud-based, forgetting that the on-premises SQL Server requires a gateway for any automated refresh in the Power BI service.

How to eliminate wrong answers

Option A is wrong because Power Automate can trigger a refresh but does not solve the underlying connectivity issue for the on-premises SQL Server; the gateway is still required. Option B is wrong because incremental refresh reduces refresh time and data volume but does not enable connectivity to an on-premises data source; it is a performance optimization, not a connectivity solution. Option D is wrong because while the CSV file is in SharePoint Online and does not need a gateway, the on-premises SQL Server database absolutely requires an on-premises data gateway for the Power BI service to reach it; omitting the gateway will cause the scheduled refresh to fail.

760
Multi-Selectmedium

Which TWO actions are best practices for designing accessible Power BI reports? (Choose two.)

Select 2 answers
A.Use complex tab order to navigate quickly
B.Provide descriptive alt text for all visuals
C.Use only high-contrast colors
D.Add alt text to every image, including decorative ones
E.Ensure all visuals have a clear title
AnswersB, E

Alt text helps screen readers describe visuals.

Why this answer

A and D are accessibility best practices. B is wrong because tab order should follow reading order. C is wrong because high contrast is not always better.

E is wrong because decorative elements should be marked as decorative.

761
MCQeasy

A data analyst creates a Power BI report using a dataset that contains sensitive salary information. The analyst needs to ensure that only HR managers can see salary columns. What should the analyst use?

A.Row-level security (RLS).
B.Microsoft Purview sensitivity labels.
C.Object-level security (OLS).
D.Set the dataset security to 'Restrict access'.
AnswerC

OLS hides entire columns from roles.

Why this answer

Option B is correct because object-level security (OLS) hides columns from specific roles. Option A is wrong because RLS filters rows, not columns. Option C is wrong because sensitivity labels are for classification, not access control.

Option D is wrong because the dataset's security settings do not support column-level security natively.

762
MCQhard

You are a data analyst for a multinational corporation. You are building a Power BI report that uses a large fact table (100 million rows) and several dimension tables. The data source is a SQL Server data warehouse. Users need to see near real-time data with a maximum latency of 15 minutes. The current import mode takes too long to refresh. You decide to use DirectQuery mode. However, queries are slow. You need to improve query performance. You consider creating aggregations in the data source. Which approach should you take in Power BI to leverage these aggregations?

A.Create a composite model with an imported aggregated table.
B.Define aggregations in Power BI on the DirectQuery tables.
C.Change the storage mode to Import for the fact table.
D.Create a SQL Server view that aggregates data and use it as the source.
AnswerB

Power BI can use these aggregations for faster queries.

Why this answer

Option B is correct because Power BI allows you to define aggregations on DirectQuery tables, which enables the engine to route queries to pre-aggregated data at the source (e.g., SQL Server indexed views or materialized views) when possible, significantly reducing query latency. This approach leverages the existing aggregations in the data source without changing the storage mode or importing data, maintaining near real-time freshness with a 15-minute latency requirement.

Exam trap

The trap here is that candidates often think creating a SQL Server view (Option D) is the correct Power BI approach, but Power BI cannot automatically leverage such views as aggregations unless they are explicitly defined in the model; the exam tests whether you know that aggregations must be defined within Power BI on DirectQuery tables to enable query rewriting.

How to eliminate wrong answers

Option A is wrong because creating a composite model with an imported aggregated table would reintroduce import mode for that table, breaking the near real-time requirement (import mode refreshes are too slow for 15-minute latency) and adding complexity without leveraging the source aggregations directly. Option C is wrong because changing the storage mode to Import for the fact table would revert to the original slow refresh issue, as importing 100 million rows takes longer than 15 minutes, and it does not use the aggregations defined in the data source. Option D is wrong because creating a SQL Server view that aggregates data and using it as the source is a data-source-side change, not a Power BI approach to leverage aggregations; Power BI would treat the view as a regular table and still require DirectQuery or import, missing the optimization of Power BI's aggregation management.

763
MCQeasy

You need to share a Power BI dashboard with a large group of users in your organization. The users should not be able to edit the dashboard or share it with others. What is the most efficient method?

A.Add all users as Members of the workspace.
B.Share the dashboard directly with each user's email address.
C.Publish the dashboard to the web.
D.Create a workspace app and grant the group Viewer access.
AnswerD

Correct. Scalable and read-only.

Why this answer

Option D is correct because creating a workspace app and granting Viewer access to the group is the most scalable and manageable approach. Option A is wrong because sharing via email is not scalable. Option B is wrong because publish to web is public.

Option C is wrong because granting Member role allows editing and sharing.

764
MCQhard

You are reviewing a Power BI dataset definition (in JSON format). The dataset refreshes daily but takes over 2 hours. You need to reduce the refresh time while ensuring that the most recent 4 years of data is always available. What is the most effective change to the dataset?

A.Add an index on the OrderDate column in the source database.
B.Remove the Amount column from the dataset.
C.Implement Incremental Refresh policy with a date range filter on OrderDate.
D.Modify the M expression to use a native SQL query with a WHERE clause on OrderDate.
AnswerD

This enables Query Folding, reducing data transferred.

Why this answer

Option D is correct because using a native SQL query with a WHERE clause on OrderDate pushes the filtering of data to the source database, reducing the amount of data transferred and processed by Power BI. This is the most effective change to reduce refresh time while ensuring the most recent 4 years of data is available, as it leverages the database engine's indexing and query optimization capabilities.

Exam trap

The trap here is that candidates often choose Incremental Refresh (Option C) thinking it automatically reduces refresh time, but they overlook that the question requires the most effective change and that native SQL query pushdown can be more efficient for reducing data volume at the source, especially when the source database supports query optimization.

How to eliminate wrong answers

Option A is wrong because adding an index on the OrderDate column in the source database can improve query performance but does not directly reduce the volume of data loaded into Power BI; the dataset still imports all rows, so refresh time remains high. Option B is wrong because removing the Amount column reduces the dataset size but does not address the root cause of long refresh time—loading 4+ years of data—and may break report requirements that depend on that column. Option C is wrong because implementing an Incremental Refresh policy in Power BI requires a date-range filter on OrderDate, but the question specifies that the dataset refreshes daily and takes over 2 hours; incremental refresh reduces the amount of data refreshed each time, but it still requires the initial full load and ongoing processing of partitions, which may not be as efficient as pushing the filter to the source via native query.

765
MCQhard

Refer to the exhibit. You are reviewing the privacy levels for a Power BI semantic model that combines data from an on-premises SQL Server (SalesDB) and a local CSV file (MarketingCSV). The SQL Server data source has privacy level 'Organizational' and the CSV file has 'Private'. When you refresh the model, you encounter an error: 'A privacy violation occurred. Please check your privacy settings.' What is the most likely cause?

A.The on-premises data gateway is not configured for the CSV file.
B.The CSV file's privacy level is set to 'Private', which prevents it from being combined with 'Organizational' sources.
C.The SQL Server connection string uses Integrated Security, which is not supported when combining data.
D.The SQL Server table is partitioned, causing a conflict with the CSV file.
AnswerB

'Private' means data cannot be shared with other sources; changing it to 'Organizational' or 'Public' would resolve.

Why this answer

Option B is correct because Power BI enforces privacy level restrictions when combining data from different sources. The CSV file's 'Private' privacy level prevents it from being combined with the SQL Server data source set to 'Organizational', as Power BI will not merge data across these boundaries to avoid leaking private data to organizational sources. This results in the 'privacy violation' error during refresh.

Exam trap

Microsoft often tests the misconception that privacy level errors are caused by gateway configuration or authentication issues, when in fact they are strictly about data isolation rules between sources with incompatible privacy levels.

How to eliminate wrong answers

Option A is wrong because the on-premises data gateway is only required for on-premises data sources like SQL Server, not for local CSV files; the CSV file is accessed directly from the local machine. Option C is wrong because Integrated Security is fully supported when combining data from SQL Server and CSV files; the error is unrelated to authentication methods. Option D is wrong because table partitioning in SQL Server does not cause privacy conflicts with CSV files; partitioning is a storage optimization and does not affect privacy level enforcement.

766
Multi-Selectmedium

Which TWO chart types are appropriate for comparing proportions of a whole? (Select TWO.)

Select 2 answers
A.Waterfall chart
B.100% stacked bar chart
C.Scatter plot
D.Line chart
E.Pie chart
AnswersB, E

100% stacked bar shows relative proportions.

Why this answer

Options A and D are correct. Option B is wrong because a line chart shows trends over time. Option C is wrong because a scatter plot shows correlation.

Option E is wrong because a waterfall chart shows cumulative changes.

767
MCQeasy

You have a Power BI report with a matrix visual showing sales by region and product category. You want to allow users to expand and collapse groups. Which feature should you enable?

A.Page tooltips
B.Drill-down mode
C.Drill-through
D.Row and column subtotals
AnswerD

Subt totals enable expand/collapse for hierarchy levels.

Why this answer

Option D is correct because row subtotals and column subtotals are enabled by default, but the matrix visual supports expand/collapse when the hierarchy is present. Option A is wrong because drill-down is different. Option B is wrong because drill-through navigates to another page.

Option C is wrong because tooltips are for hover information.

768
MCQhard

A Power BI administrator needs to ensure that all reports in a workspace are labeled with a sensitivity label automatically when created. The workspace is used by multiple departments. What should the administrator configure?

A.Set a default sensitivity label for the workspace in the workspace settings.
B.Configure a Microsoft Purview auto-labeling policy for the workspace.
C.Set the default sensitivity label for the entire Power BI tenant.
D.Instruct all users to manually apply the sensitivity label when creating reports.
AnswerA

Workspace-level default labels automatically apply to all new items in that workspace.

Why this answer

Option D is correct because Power BI supports automatic labeling via default labels at the workspace level, which can be set by administrators or workspace owners. Option A is wrong because manual labeling is not automatic. Option B is wrong because Microsoft Purview auto-labeling policies apply to the service as a whole, not per workspace.

Option C is wrong because the tenant default label applies to all workspaces, not a specific one.

769
MCQeasy

You need to ensure that a Power BI report uses the latest data from a cloud-based Azure SQL Database. The report is configured with scheduled refresh. What is the minimum required license for the dataset owner to configure a scheduled refresh?

A.Power BI Premium capacity
B.Power BI Premium Per User
C.Power BI Free
D.Power BI Pro
AnswerD

Pro license is required to schedule refresh in shared capacity.

Why this answer

Option D is correct because Power BI Pro is the minimum license required for a dataset owner to configure a scheduled refresh against a cloud-based Azure SQL Database. Scheduled refresh is a premium feature that is not available with a Power BI Free license, and while Power BI Premium capacity or Premium Per User can also support scheduled refresh, they are not the minimum requirement. The dataset owner must have a Pro license to schedule refreshes for datasets hosted in shared capacity.

Exam trap

The trap here is that candidates often assume that because Azure SQL Database is a cloud source, a Free license might suffice, but Power BI Free does not support any form of scheduled refresh, regardless of the data source being cloud or on-premises.

How to eliminate wrong answers

Option A is wrong because Power BI Premium capacity is an organizational-level licensing option that provides dedicated capacity and additional features, but it is not the minimum license required for an individual dataset owner to configure scheduled refresh. Option B is wrong because Power BI Premium Per User is a per-user license that grants premium features, but it is not the minimum requirement; a Pro license suffices for scheduled refresh in shared capacity. Option C is wrong because Power BI Free license does not allow scheduled refresh; it only permits manual refresh via Power BI Desktop or the service, and the dataset owner cannot configure automatic scheduled refresh without a Pro or higher license.

770
MCQhard

You have a Power BI model with a table 'Sales' and a table 'Date'. The relationship between them is many-to-one (Sales[OrderDate] -> Date[Date]). You notice that when you filter by Date[Year], some sales rows are not included. What is the most likely cause?

A.The relationship has Referential Integrity enforced.
B.The relationship is inactive.
C.The cross filter direction is set to Single.
D.The Date table has blank rows.
AnswerB

Inactive relationships are not used in filter propagation.

Why this answer

Option C is correct. If the relationship is inactive (dashed line), it won't be used unless activated via USERELATIONSHIP. Option A is wrong because cross filter direction being single does not exclude rows; it just prevents bidirectional filtering.

Option B is wrong because blank rows in Date would not cause missing sales; they would cause sales to be unmatched. Option D is wrong because 'Referential Integrity' is a concept in data warehouse, not a setting in Power BI relationships.

771
MCQmedium

You have a Power BI model where the Sales table is filtered by a Customer dimension. Users report that when they filter a measure from the Customer table (e.g., Customer Count), it does not affect the Sales visual. What is the most likely cause?

A.The relationship is inactive
B.The relationship cardinality is many-to-many
C.The cross-filtering direction is set to one direction (Customer -> Sales), but the filter is applied on Customer
D.The security filtering behavior is set to oneDirection
AnswerC

One-direction filtering from Customer to Sales means Sales filters Customer, not the other way.

Why this answer

The crossFilteringBehavior is set to 'oneDirection', which means filters flow only from Customer to Sales, not the other way. To allow Customer filters to affect Sales, it should be 'bothDirections' or use bidirectional cross-filtering. Option A is correct.

Option B is wrong because security filtering does not impact user filtering. Option C is wrong because the relationship is active. Option D is wrong because the cardinality is not specified but oneDirection is the key.

772
MCQmedium

You are designing a Power BI report that will be viewed on mobile devices. The report contains a complex scatter plot with many data points. Users complain that the visual is hard to interact with on small screens. What is the best approach to improve the mobile experience?

A.Use bookmarks to switch between the scatter plot and a table.
B.Keep the scatter plot but add a slicer to filter data.
C.Increase the size of the scatter plot to fill the screen.
D.Create a separate mobile layout and replace the scatter plot with a simpler visual like a line chart.
AnswerD

Correct. Mobile layout optimizes for small screens.

Why this answer

Option B is correct because a phone layout allows you to optimize visuals for mobile. Option A is wrong because increasing size may cause other visuals to be hidden. Option C is wrong because bookmarks do not improve touch interaction.

Option D is wrong because a table visual may also be hard to interact with on mobile.

773
MCQmedium

You need to ensure that only members of a specific security group can view a Power BI dashboard. The dashboard is in a shared workspace. What should you do?

A.Publish the dashboard as an app and set the security group as the audience.
B.Assign the security group the Viewer role on the workspace.
C.Configure row-level security on the underlying dataset to filter by user.
D.Share the dashboard directly with the security group.
AnswerA

App audiences allow restricting access to specific security groups.

Why this answer

Option C is correct because Power BI allows restricting access to a dashboard by using App permissions and audience targeting. Option A is incorrect because workspace roles grant access to all content in the workspace, not specific items. Option B is incorrect because sharing gives access to the dashboard but does not restrict to a security group automatically.

Option D is incorrect because row-level security filters data, not the dashboard visibility.

774
MCQhard

You are examining a Power BI model definition. The Date table is generated via Power Query M code. The partition mode is 'import'. What will happen when the dataset refreshes after December 31, 2025?

A.The existing table will be appended with new rows.
B.The refresh will fail because EndDate is in the past.
C.The table will be refreshed with the same date range (2020-2025).
D.New dates after 2025-12-31 will be added incrementally.
AnswerC

The M code defines a static range; refresh reloads that range.

Why this answer

Option C is correct. Since the partition mode is 'import' (not incremental), the entire table is replaced on each refresh. The M code generates dates from 2020-01-01 to 2025-12-31, so after 2025, no new dates will be added unless the code is updated.

Option A is wrong because incremental refresh is not configured. Option B is wrong because the table is fully reloaded, not appended. Option D is wrong because the refresh will succeed, but no new dates beyond 2025 will appear.

775
MCQhard

You run the above DAX query in DAX Studio. The result set shows a row for each Category and Year combination, but the Total Sales and Total Cost columns are both blank. What is the most likely reason?

A.The Sales[Amount] column contains only BLANK values
B.SUMMARIZECOLUMNS cannot compute two aggregate columns
C.The ORDER BY clause is causing the aggregation to fail
D.There is no active relationship between the Sales table and the Product and Date tables
AnswerD

Without relationships, the filter context does not propagate.

Why this answer

SUMMARIZECOLUMNS automatically adds a filter context. If there is no relationship between Sales and Product or Date, the columns will be blank. Option B is correct.

Option A is wrong because SUMMARIZECOLUMNS can compute multiple expressions. Option C is wrong because BLANK treatment does not affect sum. Option D is wrong because ordering does not affect calculation.

776
MCQmedium

You have a Power BI semantic model with a fact table containing sales data at the transaction level. You need to create a measure that calculates the number of distinct customers who made a purchase in the current period and also made a purchase in the previous period. Which DAX pattern should you use?

A.Use CALCULATE with a filter that intersects customers in both periods.
B.Use the PREVIOUSCUSTOMER function.
C.Use DISTINCTCOUNT over a concatenated key.
D.Add a calculated column to identify returning customers.
AnswerA

This pattern counts customers who appear in both periods.

Why this answer

Option A is correct because the semi-additive pattern using CALCULATE and FILTER with an EARLIER-like approach is typical for retention. Option B is incorrect because DISTINCTCOUNT is not a standard function. Option C is incorrect because a calculated column is less flexible.

Option D is not a standard pattern.

777
MCQhard

You have a measure as shown in the exhibit. The sales amount is not accumulating correctly; instead, it shows the total sales for the selected date only. What is the problem?

A.The measure should use ALLEXCEPT instead of ALL.
B.The ALL('Date') function removes the filter context, so the calculation returns total sales for all dates.
C.The VAR SelectedDate should be MIN instead of MAX.
D.The relationship between Sales and Date is inactive.
AnswerB

ALL removes the filter on Date, so the condition 'Date'[Date] <= SelectedDate applies to all dates, but without a filter, it sums all sales.

Why this answer

Option B is correct because ALL('Date') removes all date filters, causing the CALCULATE to ignore the date filter context. Option A is wrong because VAR does not affect the result. Option C is wrong because relationship direction does not cause this specific issue.

Option D is wrong because ALL does not cause circular dependency.

778
MCQhard

You are a Power BI administrator for a large organization. A team has published a shared dataset to a Premium workspace. They use an XMLA endpoint to programmatically refresh the dataset daily. Recently, the refresh started failing with the error: 'The operation was canceled because the session was terminated by a concurrent operation.' The dataset is not partitioned. You need to ensure the refresh completes without errors. What should you do?

A.Remove all scheduled refreshes and rely solely on the XMLA script.
B.Enable the 'Refresh conflict detection' setting on the dataset to prevent concurrent operations.
C.Change the XMLA script to run less frequently, e.g., once per week.
D.Partition the dataset and refresh partitions sequentially.
AnswerB

This setting detects and blocks overlapping refresh operations, preventing the error.

Why this answer

The error 'The operation was canceled because the session was terminated by a concurrent operation' indicates that two refresh operations are conflicting on the same dataset. Enabling 'Refresh conflict detection' on the dataset prevents concurrent refreshes by queuing or blocking overlapping operations, ensuring the XMLA-triggered refresh completes without interruption.

Exam trap

The trap here is that candidates often assume the error is caused by the XMLA script itself (e.g., frequency or scheduling) and overlook the fact that the conflict is due to concurrent operations, which is directly solved by enabling conflict detection rather than changing the script's schedule or partitioning strategy.

How to eliminate wrong answers

Option A is wrong because removing scheduled refreshes does not address conflicts that could arise from other concurrent operations, such as multiple XMLA scripts or user interactions; the error specifically points to a concurrent session, not just scheduled refreshes. Option C is wrong because reducing the frequency of the XMLA script does not prevent conflicts when the script runs; if another operation occurs at the same time, the conflict persists regardless of frequency. Option D is wrong because partitioning the dataset and refreshing partitions sequentially does not resolve the fundamental issue of concurrent sessions; the error is about session termination, not partition-level parallelism, and sequential partition refreshes can still conflict if multiple sessions attempt to refresh the same dataset.

779
Drag & Dropmedium

Drag and drop the steps to create a relationship between two tables 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

Relationships are created by dragging columns between tables in the Model view, then confirming settings like cardinality.

780
MCQhard

You are troubleshooting a Power BI report that uses a DAX query to summarize sales data. The query returns rows but the TotalSales column shows blank for some ProductID/Region combinations. What is the most likely cause?

A.The syntax of SUMMARIZECOLUMNS is incorrect; it should use ADDCOLUMNS.
B.The filter condition is applied after aggregation, so it cannot filter out rows.
C.The relationships between tables are missing, causing blank values.
D.The FILTER function removes rows where Quantity <= 10 from the entire Sales table, so those combinations have no data to aggregate.
AnswerD

FILTER is applied as a table filter, not a row filter within groups.

Why this answer

Option D is correct because the FILTER function in DAX, when used as a table filter argument in SUMMARIZECOLUMNS, applies a row-level filter to the entire Sales table before aggregation. If Quantity <= 10 for a given ProductID/Region combination, all rows for that combination are removed, leaving no data to aggregate, which results in a blank TotalSales. This is a common cause of unexpected blanks when using FILTER inside SUMMARIZECOLUMNS.

Exam trap

The trap here is that candidates often assume FILTER only affects the measure calculation, not the row context of the entire table, leading them to overlook that FILTER removes rows before aggregation, causing blanks for filtered-out combinations.

How to eliminate wrong answers

Option A is wrong because SUMMARIZECOLUMNS is the correct function for grouping and aggregating columns; ADDCOLUMNS is used to add calculated columns to an existing table, not to replace SUMMARIZECOLUMNS. Option B is wrong because in SUMMARIZECOLUMNS, filter conditions are applied before aggregation (as table filters), not after; the order of operations is filter first, then group and aggregate. Option C is wrong because missing relationships typically cause errors or unexpected behavior in measures or row expansion, but they would not cause blank values for specific combinations if the data exists; blanks here are due to filtering, not relationship issues.

781
Multi-Selecthard

Which TWO actions can improve performance of a Power BI DirectQuery model?

Select 2 answers
A.Switch the model to Import mode
B.Enable bidirectional cross-filtering on all relationships
C.Ensure proper indexing in the source database
D.Use calculated columns with complex logic
E.Reduce the number of columns in the query
AnswersC, E

Indexing speeds up query execution.

Why this answer

Options A and D are correct. Reducing columns and increasing data source indexing improve query performance. Option B is wrong because bidirectional filtering often decreases performance.

Option C is wrong because complex calculated columns slow queries. Option E is wrong because Import mode is not DirectQuery.

782
MCQmedium

You are a Power BI developer for an e-commerce company. You have a semantic model that contains a table named Orders with columns: OrderID, CustomerID, OrderDate, ProductID, Quantity, and SalesAmount. You also have a table named Products with columns: ProductID, ProductName, Category, and Price. You need to create a measure that calculates the percentage of total sales for each product category. The measure should be used in a matrix visual with Category on rows. Which DAX expression should you use?

A.% Total Sales = DIVIDE(SUM(Orders[SalesAmount]), CALCULATE(SUM(Orders[SalesAmount]), ALLSELECTED(Products[Category])))
B.% Total Sales = SUM(Orders[SalesAmount]) / CALCULATE(SUM(Orders[SalesAmount]), ALLSELECTED(Orders))
C.% Total Sales = DIVIDE(SUM(Orders[SalesAmount]), CALCULATE(SUM(Orders[SalesAmount]), ALLEXCEPT(Products, Products[Category])))
D.% Total Sales = DIVIDE(SUM(Orders[SalesAmount]), CALCULATE(SUM(Orders[SalesAmount]), ALL(Products)))
AnswerA

ALLSELECTED keeps the filter context from the visual's slicers but removes the category filter, giving the total for all categories.

Why this answer

Option A is correct: ALLSELECTED respects the current filter context for the denominator, giving the correct percentage. Option B uses ALL, which removes all filters, not just the category. Option C uses ALLEXCEPT, which removes filters from all columns except Category, which is not what is needed.

Option D is incorrect syntax.

783
MCQmedium

You are loading data from an Excel workbook that has multiple sheets. Each sheet contains sales data for a different region. You need to combine all sheets into one table. What is the most efficient approach?

A.Use 'Append Queries' for each sheet individually.
B.Use 'Merge Queries' to join all sheets into one.
C.Load each sheet as a separate table in the model and create a calculated table to union them.
D.Use Power Query's 'From Folder' option to combine all Excel files in a folder, then select 'Combine & Transform' to use the workbook as a sample.
AnswerD

This automatically combines all sheets.

Why this answer

Option D is correct because the 'From Folder' option in Power Query is designed to combine multiple Excel files with the same structure into a single table. By pointing to a folder containing the workbook, Power Query automatically detects all sheets as separate files and uses the 'Combine & Transform' feature to union them, which is more efficient than manually appending each sheet individually.

Exam trap

The trap here is that candidates often confuse 'Append Queries' (union) with 'Merge Queries' (join), or think that loading separate tables and using DAX is more efficient, but Power Query's folder-based combination is the most efficient for multiple sheets in a single workbook.

How to eliminate wrong answers

Option A is wrong because 'Append Queries' requires manually selecting each sheet and appending them one by one, which is inefficient and not the most efficient approach when dealing with multiple sheets in a single workbook. Option B is wrong because 'Merge Queries' performs a join operation (like SQL JOIN) based on matching columns, not a union of rows, so it would not combine all sheets into one table; it would create a combined table with duplicate or merged columns. Option C is wrong because loading each sheet as a separate table and then creating a calculated table to union them is inefficient and unnecessary, as Power Query can combine them directly without adding extra tables to the model.

784
MCQhard

Your Power BI dataset uses DirectQuery to a SQL Server data warehouse. Users report that reports are slow. You need to improve performance without changing the data source. What should you do?

A.Switch the dataset to Import mode.
B.Disable the 'Enable query reduction' option in Power BI Desktop.
C.Create aggregated tables in Power BI using the Aggregations feature.
D.Increase the memory limit of the on-premises data gateway.
AnswerC

Aggregations reduce the amount of data queried from the source.

Why this answer

Option C is correct because creating aggregated tables in Power BI using the Aggregations feature allows you to pre-summarize data at a higher granularity while still using DirectQuery. This reduces the amount of data queried from the SQL Server data warehouse, improving report performance without changing the underlying data source or switching to Import mode.

Exam trap

The trap here is that candidates often assume performance improvements must come from switching to Import mode or tuning the gateway, but the Aggregations feature is specifically designed to optimize DirectQuery performance without altering the source system.

How to eliminate wrong answers

Option A is wrong because switching to Import mode would change the data source behavior by caching data locally, which violates the constraint of not changing the data source and may not be feasible for large datasets due to memory limits. Option B is wrong because disabling 'Enable query reduction' would actually increase the number of queries sent to the data source, making performance worse, not better. Option D is wrong because increasing the memory limit of the on-premises data gateway does not improve query performance for DirectQuery; it only helps with data throughput for gateway operations, not the speed of queries against the SQL Server.

785
MCQmedium

You have a Power BI report that uses a measure to calculate year-over-year growth. Users report that the measure returns blank for certain months. The measure is: YoY Growth = DIVIDE(SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date])), CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]))). What is the most likely cause of the blank values?

A.The Date table is not marked as a date table.
B.The measure uses DIVIDE which returns blank when denominator is zero.
C.The Date table is missing dates for the previous year, causing SAMEPERIODLASTYEAR to return no data.
D.The measure should use TOTALYTD instead of SAMEPERIODLASTYEAR.
AnswerC

Correct. If the date table does not include all dates from the previous year, SAMEPERIODLASTYEAR returns blank.

Why this answer

Option B is correct because SAMEPERIODLASTYEAR requires contiguous dates; missing dates in the previous year cause blanks. Option A is wrong because SAMEPERIODLASTYEAR works with any date granularity. Option C is wrong because the measure uses DIVIDE which handles division by zero as blank, not error.

Option D is wrong because SAMEPERIODLASTYEAR is a time intelligence function that requires a proper date table with continuous dates.

786
MCQhard

A Power BI report contains a table with a column 'Date' of type date. The report users need to filter data by fiscal year, which starts on April 1. What is the best practice to support this requirement during data preparation?

A.Create a separate date table in Power Query with a fiscal year column.
B.Split the date column into year, month, and day columns.
C.Use a DAX calculated table to generate fiscal year dates.
D.Add a calculated column in the existing table using DAX.
AnswerA

A dedicated date table is the recommended approach.

Why this answer

Option A is correct because creating a separate date table in Power Query with a fiscal year column is the best practice for handling fiscal year filtering. This approach ensures the date dimension is independent of fact tables, supports star schema design, and allows you to define fiscal year logic (starting April 1) directly in M code during data preparation, which is more efficient and maintainable than using DAX calculated columns or tables.

Exam trap

The trap here is that candidates often think a DAX calculated column or table is acceptable for fiscal year logic, but the exam emphasizes that data preparation (Power Query) is the correct phase for such transformations to maintain performance and star schema design.

How to eliminate wrong answers

Option B is wrong because splitting the date column into year, month, and day columns does not inherently create a fiscal year hierarchy; it only breaks the date into parts, requiring additional logic to map months to fiscal years, which is inefficient and does not provide a proper date dimension for filtering. Option C is wrong because using a DAX calculated table to generate fiscal year dates is less performant than doing so in Power Query; DAX calculated tables are computed after data load and can increase model size and refresh time, whereas Power Query transformations are applied during data preparation and are more efficient. Option D is wrong because adding a calculated column in the existing table using DAX introduces redundancy and violates star schema best practices; it also computes the fiscal year at query time rather than during data preparation, leading to potential performance issues and lack of reusability across multiple fact tables.

787
Multi-Selectmedium

Which TWO actions improve the accessibility of a Power BI report for users with visual impairments?

Select 2 answers
A.Use a high-contrast color theme.
B.Add alt text to all visuals.
C.Use small font sizes to fit more content.
D.Use high color saturation for all elements.
E.Include complex drillthrough interactions.
AnswersA, B

High contrast improves readability for visually impaired users.

Why this answer

Options A and C are correct. A: Adding alt text to visuals helps screen readers. C: High contrast colors improve readability.

B is wrong because high color saturation may be problematic. D is wrong because small font sizes reduce readability. E is wrong because complex interactions can be confusing.

788
Multi-Selecthard

Which THREE factors can cause a DAX measure to return BLANK unexpectedly?

Select 3 answers
A.Division by zero.
B.Using SUM on a column with blanks.
C.Using FILTER with a false condition.
D.Referencing a column name that does not exist.
E.Using BLANK in arithmetic operations.
AnswersA, D, E

DAX returns BLANK for division by zero.

Why this answer

Option A is correct because division by zero returns BLANK. Option B is correct because referencing a column that doesn't exist causes BLANK. Option C is correct because BLANK propagation in arithmetic can cause BLANK.

Option D is wrong because SUM ignores blanks. Option E is wrong because filters do not return BLANK; they return a table.

789
Multi-Selecthard

Which THREE components must be in place to enable Power BI data sensitivity labels from Microsoft Purview? (Select exactly three.)

Select 3 answers
A.Power BI admin setting to enable sensitivity labels enabled
B.Sensitivity labels published to users or groups in Microsoft Purview compliance portal
C.Power BI Premium capacity assigned to the workspace
D.Microsoft Purview Information Protection subscription (including Azure Information Protection P1/P2)
E.Power BI Pro license for all users
AnswersA, B, D

The admin must turn on the feature.

Why this answer

Options B, C, and D are correct. A Purview Information Protection subscription is required; sensitivity labels must be published to users or groups; and Power BI admin settings must enable sensitivity labels. Option A is wrong because the Power BI license is not a prerequisite; any license can use labels if the admin enables them.

Option E is wrong because a Premium capacity is not required; labels work with Pro and Premium.

790
MCQmedium

Refer to the exhibit. You configure incremental refresh for a Power BI dataset with the above policy. The dataset contains 3 years of historical data. How will the rolling window affect the data?

A.Data older than 30 days will be merged into the history
B.All data older than 30 days will be removed
C.Only the most recent 10 days will be refreshed
D.The entire dataset will be refreshed every 10 days
AnswerC

The rolling window limits incremental refresh to the last 10 days.

Why this answer

The rolling window of 10 days means only the last 10 days are refreshed incrementally. Historical data beyond 30 days is not refreshed unless a full refresh occurs. The mode 'merge' does not affect this.

791
MCQeasy

You have a report page that shows sales by region. You want users to be able to select a region and see the corresponding sales details on the same page without navigating away. Which feature should you use?

A.Slicer
B.Drillthrough
C.Matrix with expand/collapse
D.Card visual
AnswerA

A slicer filters the page based on user selection, showing relevant details.

Why this answer

Option A is correct because a slicer filters the entire page based on the selected value, showing details on the same page. Option B is wrong because drillthrough navigates to a different page. Option C is wrong because a card visual only shows a single value.

Option D is wrong because a matrix with expand/collapse is for hierarchical display, not cross-filtering.

792
MCQmedium

You have a Power BI model with a date table. You need to ensure that time intelligence functions like TOTALYTD work correctly. What is the most important requirement for the date table?

A.The date table must be marked as a date table in Power BI
B.All date columns must be visible
C.The date table must have a single date column
D.The date table must contain continuous dates without gaps
AnswerA

Marking as date table enables time intelligence.

Why this answer

Option A is correct because Power BI requires that a date table be explicitly marked as a date table via the 'Mark as Date Table' option in the Table tools ribbon. This action tells Power BI that the table contains unique, non-blank date values that can be used by time intelligence functions like TOTALYTD, ensuring they reference the correct date column for calculations such as year-to-date aggregation.

Exam trap

The trap here is that candidates often confuse the requirement to mark a date table with the best practice of having continuous dates, leading them to select Option D, but Power BI does not enforce date continuity for time intelligence functions to work.

How to eliminate wrong answers

Option B is wrong because visibility of date columns is irrelevant; Power BI does not require all date columns to be visible for time intelligence functions to work correctly. Option C is wrong because a date table can have multiple date columns (e.g., Date, FiscalDate), but only one column is used as the primary date column when the table is marked; having a single date column is not a requirement. Option D is wrong because while continuous dates without gaps are a best practice for accurate time intelligence, Power BI does not enforce this as a requirement; the table can have gaps and still be marked as a date table, though results may be misleading.

793
MCQmedium

You have a Power BI model with a table 'Sales' and a related 'Product' table. You want to count the number of distinct products sold. Which DAX expression should you use?

A.COUNTROWS(Sales)
B.COUNT(Sales[ProductID])
C.DISTINCTCOUNT(Sales[ProductID])
D.COUNTA(Sales[ProductID])
AnswerC

DISTINCTCOUNT counts unique values.

Why this answer

Option C is correct because DISTINCTCOUNT counts unique values. Option A is wrong because COUNT counts non-blank cells. Option B is wrong because COUNTA counts non-blank values.

Option D is wrong because COUNTROWS counts rows.

794
MCQmedium

You are designing a data model for a report that shows sales by product category and by month. Which table configuration is most efficient?

A.Two fact tables: one for date and one for product.
B.A date dimension table, a product dimension table, and a sales fact table.
C.A single table with all columns.
D.One dimension table containing date and product attributes.
AnswerB

Star schema is efficient for this scenario.

Why this answer

Option D is correct because a star schema with separate tables for date and product is the most efficient for filtering and performance. Option A is wrong because combining date and product into one dimension is not needed. Option B is wrong because a single table is inefficient.

Option C is wrong because a bridge table is not needed for a simple star schema.

795
Multi-Selectmedium

Which TWO actions are required to enable Bring Your Own Key (BYOK) encryption for Power BI datasets? (Select exactly two.)

Select 2 answers
A.Assign the workspace to a Power BI Premium capacity
B.Store the encryption key in the Power BI service admin settings
C.Upload the customer-managed key to Azure Key Vault
D.Configure the Power BI admin settings to use the key from Azure Key Vault
E.Register the encryption key in Microsoft Purview compliance portal
AnswersC, D

The key must be stored in Azure Key Vault.

Why this answer

Options B and D are correct. BYOK requires uploading the encryption key to Azure Key Vault and configuring the Power BI admin settings to use the key. Option A is wrong because the key is stored in Azure Key Vault, not Power BI.

Option C is wrong because BYOK does not require a Premium capacity; it works with Premium Per User or Premium capacity. Option E is wrong because the key is not stored in Microsoft Purview.

796
Multi-Selecthard

Which THREE features are available in Power BI Premium capacity but not in Power BI shared capacity? (Select exactly three.)

Select 3 answers
A.AI visuals and cognitive services integration.
B.Large dataset storage (up to 100 GB per dataset in Premium Gen2).
C.Incremental refresh.
D.XMLA endpoints for read/write operations.
E.Automatic page refresh.
AnswersA, B, D

Premium only.

Why this answer

Premium capacity offers larger data storage, XMLA endpoints for write operations, and AI features. Option A, B, and C are correct. Option D is wrong because incremental refresh is available in shared capacity (with limitations).

Option E is wrong because automatic page refresh is available in shared capacity for DirectQuery.

797
MCQmedium

You have a Power BI dataset that combines sales data from two Excel files: Sales2023.xlsx and Sales2024.xlsx. Both files have the same schema. You need to combine them into a single table without duplicating rows. What is the best approach in Power Query?

A.Use Union in DAX.
B.Use Group By to summarize data.
C.Use Append Queries.
D.Use Merge Queries as a new query.
AnswerC

Append Queries combines rows from two tables.

Why this answer

Option C is correct because Append Queries in Power Query is specifically designed to combine rows from two or more tables with the same schema into a single table, stacking them vertically without duplicating rows. This operation is performed in the Power Query Editor (M language) and is the standard approach for unioning data from multiple sources during the data preparation phase, before loading into the Power BI data model.

Exam trap

The trap here is that candidates often confuse Append Queries (vertical stacking) with Merge Queries (horizontal joining), or mistakenly think DAX Union is appropriate for data preparation, when Power Query is the correct tool for this task.

How to eliminate wrong answers

Option A is wrong because Union in DAX is a function used within calculated tables or measures in the data model, not in Power Query; it operates on tables already loaded into the model and can cause performance issues and duplicate rows if not handled carefully, whereas the requirement is to combine data during the preparation phase. Option B is wrong because Group By is used to aggregate data (e.g., sum, count) by grouping rows based on columns, not to combine two separate tables into one; it would summarize the data rather than preserving all rows. Option D is wrong because Merge Queries is used to join tables horizontally (like SQL JOIN) based on matching keys, adding columns from one table to another, not to stack rows vertically; it would create a wider table, not a longer one, and could introduce duplicates if not configured correctly.

798
Multi-Selecthard

Which TWO DAX functions can be used to implement row-level security (RLS) in Power BI?

Select 3 answers
A.FILTER
B.LOOKUPVALUE
C.USERNAME
D.CALCULATE
E.USERPRINCIPALNAME
AnswersA, C, E

FILTER is commonly used in RLS to restrict rows based on a condition.

Why this answer

LOOKUPVALUE is not used for RLS; it retrieves a single value. FILTER is used within RLS expressions to filter rows. USERNAME and USERPRINCIPALNAME are used to get the current user.

CALCULATE is not directly used in RLS filtering.

799
MCQmedium

You are a Power BI developer for a healthcare organization. You are building a dataset that includes patient data from an on-premises SQL Server database. The database contains a table 'PatientVisits' with columns: PatientID, VisitDate, DiagnosisCode, and Cost. The database also has a table 'DiagnosisLookup' with DiagnosisCode and Description. You need to create a star schema in Power BI. The requirements are: - The dataset must include a date dimension table that covers all dates from 2010 to 2030. - The 'PatientVisits' table should be the fact table. - Diagnosis descriptions should be in a dimension table. - You must use Power Query to create the date dimension table using M code. - The data refresh must be scheduled daily via the on-premises data gateway. You have already loaded the 'PatientVisits' and 'DiagnosisLookup' tables. What should you do next to complete the star schema?

A.Use DAX to create a date table using CALENDAR function in Power BI Desktop, then mark it as a date table.
B.Enable the 'Auto date/time' option in Power BI Desktop and hide the generated date hierarchy.
C.In the model view, create a relationship between PatientVisits[VisitDate] and DiagnosisLookup[DiagnosisCode].
D.In Power Query, create a blank query that generates a date table using the List.Dates function with a custom column for Year, Month, etc. Load it into the model and mark it as a date table.
AnswerD

This creates a proper date dimension in Power Query, which can be used for relationships.

Why this answer

Option D is correct because the requirement explicitly states that the date dimension table must be created using M code in Power Query, and the List.Dates function is the appropriate M function to generate a continuous range of dates from 2010 to 2030. After creating the table with additional columns like Year and Month, you must load it into the model and mark it as a date table to enable time intelligence functions. This approach satisfies the need for a custom date dimension that is not dependent on DAX or auto-generated hierarchies.

Exam trap

The trap here is that candidates often default to using DAX's CALENDAR function (Option A) because it is simpler, but the question explicitly requires M code in Power Query, making DAX-based solutions incorrect even if functionally equivalent.

How to eliminate wrong answers

Option A is wrong because using DAX with the CALENDAR function violates the explicit requirement to create the date dimension table using M code in Power Query. Option B is wrong because enabling 'Auto date/time' generates hidden date hierarchies automatically, which does not create a dedicated date dimension table in Power Query and does not meet the requirement for a custom M-based date table covering 2010 to 2030. Option C is wrong because creating a relationship between PatientVisits[VisitDate] and DiagnosisLookup[DiagnosisCode] is semantically incorrect; VisitDate is a date field and DiagnosisCode is a code field, and the correct relationship should be between PatientVisits[DiagnosisCode] and DiagnosisLookup[DiagnosisCode] to link the fact table to the diagnosis dimension.

800
MCQmedium

You are preparing data in Power BI Desktop. You have a table that includes a 'SalesAmount' column and a 'CurrencyCode' column. You need to create a measure that calculates the total sales amount in USD only, filtering out other currencies. Which DAX expression should you use?

A.SUMX(FILTER(Sales, Sales[CurrencyCode] = "USD"), Sales[SalesAmount])
B.CALCULATE(SUM(Sales[SalesAmount]), Sales[CurrencyCode] = "USD")
C.CALCULATE(SUM(Sales[SalesAmount]), Sales[CurrencyCode] = "USD") + 0
D.SUM(Sales[SalesAmount])
AnswerB

Correctly filters to USD currency.

Why this answer

Option B is correct because it uses CALCULATE to modify the filter context, applying a filter that restricts the SUM of Sales[SalesAmount] to only rows where Sales[CurrencyCode] equals 'USD'. This is the standard DAX pattern for conditional aggregation in Power BI.

Exam trap

The trap here is that candidates often choose SUMX (Option A) because they think they need to explicitly filter rows before summing, not realizing that CALCULATE with a simple filter is the more efficient and correct DAX pattern for this scenario.

How to eliminate wrong answers

Option A is wrong because SUMX iterates over a filtered table and sums the SalesAmount column, which works but is less efficient and not the idiomatic DAX pattern for a simple filter; it also requires an explicit table filter. Option C is wrong because adding zero (+ 0) is unnecessary and does not change the result; it may mislead candidates into thinking it prevents blanks, but CALCULATE already handles blanks naturally. Option D is wrong because SUM(Sales[SalesAmount]) calculates the total sales amount across all currencies, ignoring the USD filter requirement entirely.

801
MCQeasy

A user reports that a Power BI report is not refreshing data from a SQL Server database. The dataset uses Import mode. The gateway cluster shows all gateways are online. What is the most likely cause?

A.The report is using a scheduled refresh with a conflicting time.
B.The gateway version is incompatible with the SQL Server version.
C.The dataset uses DirectQuery mode which requires a live connection.
D.The data source credentials are incorrect or expired.
AnswerD

Correct. Expired or incorrect credentials are a common cause of refresh failures.

Why this answer

Option D is correct because in Import mode, Power BI caches data and refreshes it on a schedule using stored credentials. If those credentials expire or become invalid, the refresh fails even though the gateway cluster shows as online. The gateway being online only indicates network connectivity, not that the stored credentials are still valid for the SQL Server database.

Exam trap

The trap here is that candidates see 'gateway cluster shows all gateways are online' and assume the issue must be elsewhere, but gateway online status does not validate the stored data source credentials, which are a separate authentication layer that can expire or become invalid independently.

How to eliminate wrong answers

Option A is wrong because a conflicting scheduled refresh time would cause a refresh to be skipped or queued, not a persistent failure; the report would still refresh at the next available window. Option B is wrong because gateway version incompatibility with SQL Server version is extremely rare; the gateway communicates via standard TDS protocol and is backward-compatible with most SQL Server versions. Option C is wrong because the question explicitly states the dataset uses Import mode, not DirectQuery mode, so the requirement for a live connection is irrelevant.

802
MCQeasy

You have a Power BI report that includes a line chart showing monthly sales. You want to add a forecast for the next six months. Which feature should you use?

A.Filter pane
B.Analytics pane
C.Format pane
D.Visualization pane
AnswerB

Analytics pane provides forecast, trend line, etc.

Why this answer

The Analytics pane in Power BI provides built-in forecasting capabilities for time-series data. By selecting a line chart and adding a forecast from the Analytics pane, you can configure the forecast length (e.g., six months), confidence intervals, and seasonality, enabling predictive analysis directly within the visual.

Exam trap

The trap here is that candidates confuse the Analytics pane with the Format pane, mistakenly looking for forecast settings under visual formatting options, when in fact forecasting is an analytical overlay available only in the Analytics pane.

How to eliminate wrong answers

Option A is wrong because the Filter pane is used to restrict data displayed in visuals or pages, not to add predictive elements like forecasts. Option C is wrong because the Format pane controls visual appearance (colors, labels, axes) but does not include analytical features such as forecasting. Option D is wrong because the Visualization pane is where you select chart types and assign fields to axes/values, not where you add analytical overlays like trend lines or forecasts.

803
Multi-Selectmedium

Which TWO actions are best practices for optimizing Power BI data models?

Select 2 answers
A.Replace text-based relationship columns with integer keys.
B.Use calculated columns instead of measures where possible.
C.Hide columns that are not used in reports.
D.Remove columns that are not used in reports.
E.Use many-to-many relationships instead of bridge tables.
AnswersA, D

Integer keys improve join performance.

Why this answer

Option A is correct because replacing text-based relationship columns with integer keys (surrogate keys) reduces storage size and improves join performance. Power BI's VertiPaq engine compresses integer columns far more efficiently than text columns, leading to faster query execution and smaller memory footprint.

Exam trap

The trap here is that candidates often confuse 'hiding' columns (which only affects report visibility) with 'removing' columns (which actually reduces model size and improves performance), leading them to select Option C instead of D.

804
MCQhard

You are optimizing a DAX query that returns product-country combinations with total sales over 10,000. The query runs slowly. What is the primary performance issue with this query?

A.The measure [Total Sales] is defined using SUMX which is slow.
B.Using SUMMARIZE instead of SUMMARIZECOLUMNS causes inefficient grouping and measure evaluation.
C.The FILTER function should be replaced with CALCULATETABLE for better performance.
D.The query lacks proper relationships between tables, causing cross joins.
AnswerB

SUMMARIZECOLUMNS is more efficient for grouping with measures.

Why this answer

The query uses SUMMARIZE which can be inefficient for grouping because it performs a table scan and then adds a measure. The better approach is to use SUMMARIZECOLUMNS which is optimized for this scenario. Also, adding columns after grouping can be slower.

Option A is correct. Option B is incorrect because FILTER is not the main issue; it's the grouping. Option C is incorrect because Products and Customers dimensions are typically not the cause.

Option D is incorrect because the measure itself might be fine.

805
Multi-Selectmedium

You are a Power BI developer at a healthcare organization. You are building a report that must comply with HIPAA regulations. You need to ensure that patient data is not exposed to unauthorized users. You plan to use Row-Level Security (RLS) with roles defined in Power BI Desktop. However, you also need to limit the data imported into the model to only necessary columns. The source is an Azure SQL Database with a table 'Patients' containing columns: PatientID, Name, SSN, Diagnosis, AdmissionDate, DischargeDate. Which two actions should you take? (Choose TWO)

Select 2 answers
A.Create RLS roles to restrict access by Diagnosis.
B.Store data source credentials in the Power BI service.
C.Disable query caching for the dataset.
D.Use encrypted connection to the database.
E.Remove the SSN and Name columns in Power Query before loading.
AnswersA, E

Limits what users see based on role.

Why this answer

Option A is correct because creating RLS roles in Power BI Desktop allows you to restrict data access based on the user's identity, ensuring that only authorized users can view specific rows (e.g., by Diagnosis). This is a key requirement for HIPAA compliance, as it prevents unauthorized exposure of patient data. Option E is correct because removing sensitive columns like SSN and Name in Power Query before loading into the model minimizes the data footprint and reduces the risk of exposing personally identifiable information (PII), aligning with the principle of data minimization.

Exam trap

The trap here is that candidates may confuse data security measures (like encrypted connections or credential storage) with data minimization and access control, leading them to select options that protect data in transit or enable refresh but do not directly limit imported columns or enforce row-level filtering.

806
MCQmedium

Refer to the exhibit. You are using DAX Studio to profile a Power BI semantic model. The query above returns a table with sales totals by year and product category. However, you notice that the results do not include rows for years or categories with no sales. Which DAX function should you use to ensure all combinations of year and category appear, even with blank sales?

A.ADDCOLUMNS
B.CROSSJOIN
C.SUMMARIZE
D.EXPAND
AnswerB

CROSSJOIN creates all combinations of the distinct values from the columns.

Why this answer

Option D is correct because CROSSJOIN generates all combinations of the columns, then you can left join with the sales table. Option A is for cross-tabulation. Option B is an older function that may not handle blanks well.

Option C is not a valid DAX function.

807
Multi-Selecthard

Which THREE of the following are valid considerations when using Power BI's AI visuals? (Choose three.)

Select 3 answers
A.AI visuals are only available with an AI workload license.
B.Some AI visuals have a limit on the number of data points they can analyze.
C.AI visuals are deprecated in favor of Copilot.
D.AI visuals may require Power BI Premium capacity for certain features.
E.Certain AI visuals require the data to be in a specific format (e.g., numeric or categorical).
AnswersB, D, E

For example, Key Influencers visual has a limit on distinct values.

Why this answer

Options A, B, and C are correct. Option A is correct because AI visuals (like Key Influencers) have data limits. Option B is correct because some AI visuals require Premium capacity for advanced features.

Option C is correct because AI visuals may need a specific column type (e.g., numeric for decomposition tree). Option D is wrong because AI visuals do not require a separate license beyond Power BI. Option E is wrong because AI visuals are not deprecated.

808
MCQhard

You have a Power BI model with a measure that calculates total sales using SUMX over a filtered table. The measure performs slowly. Which change will most likely improve performance without altering business logic?

A.Add KEEPFILTERS to preserve existing filters
B.Rewrite the measure using CALCULATE with a simple SUM instead of SUMX
C.Change the storage mode of the table from Import to DirectQuery
D.Remove all filter functions from the measure
AnswerB

CALCULATE is more efficient than iterating over rows.

Why this answer

Option B is correct: Using a base measure for SUM of Sales Amount and then applying filter context often performs better than iterating with SUMX. Option A is wrong because removing filters may change logic. Option C is wrong because increasing storage mode changes data source behavior but may not be allowed.

Option D is wrong because KEEPFILTERS can add overhead.

809
MCQhard

You are preparing data for a sales analysis report. The source system provides a table with columns: 'ProductID', 'ProductName', 'Category', 'SubCategory', 'Price', 'Cost'. You need to create a star schema. Which columns should be moved to dimension tables?

A.ProductID, ProductName, Category, and SubCategory
B.ProductID and ProductName only
C.Price and Cost
D.ProductID, ProductName, Price, and Cost
AnswerA

These are all attributes of the product.

Why this answer

In a star schema, dimension tables contain descriptive attributes that provide context to measures. ProductID, ProductName, Category, and SubCategory are all descriptive attributes that should be moved to a dimension table (e.g., DimProduct) to reduce redundancy and enable efficient filtering and grouping. Measures like Price and Cost, however, are numeric values that typically belong in the fact table as additive or semi-additive measures.

Exam trap

The trap here is that candidates often confuse numeric columns like Price and Cost as dimensions because they are static per product, but in a star schema, any column that is a measure (aggregatable numeric value) belongs in the fact table, not the dimension table.

How to eliminate wrong answers

Option B is wrong because it omits Category and SubCategory, which are essential descriptive attributes for hierarchical analysis and should be part of the dimension table to support drill-down and slicing. Option C is wrong because Price and Cost are numeric measures, not descriptive attributes; they should remain in the fact table for aggregation and calculation. Option D is wrong because it includes Price and Cost, which are measures that belong in the fact table, not in a dimension table, and mixing them with descriptive attributes violates the star schema design principle of separating measures from dimensions.

810
MCQmedium

A company is deploying Power BI for the entire organization. They need to prevent users from sharing reports with external email addresses. Which configuration should the Power BI admin use?

A.Disable 'Share content with external users' in the Power BI admin portal.
B.Configure a Conditional Access policy in Microsoft Entra ID.
C.Apply a Microsoft Purview sensitivity label.
D.Set the workspace sharing settings to 'Only existing users'.
AnswerA

This setting prevents sharing with external email addresses.

Why this answer

Option D is correct because the admin portal has a setting to control sharing with external users. Option A is wrong because tenant-level sharing settings are in the admin portal, not Microsoft Entra ID. Option B is wrong because sensitivity labels classify data but do not block sharing.

Option C is wrong because sharing settings are not in workspace settings.

811
Multi-Selecthard

Which THREE are valid methods to handle duplicate rows in Power Query when preparing data?

Select 3 answers
A.Use 'Reverse Rows'
B.Use 'Remove Duplicates' based on key columns
C.Use 'Keep Duplicates'
D.Use 'Sort Ascending'
E.Use 'Group By' to aggregate duplicates
AnswersB, C, E

Removes duplicate rows.

Why this answer

Options A, B, and D are correct. Remove Duplicates deletes duplicates. Group By with aggregation can combine duplicates.

Keep Duplicates retains only duplicates. Option C reverses rows, not handle duplicates. Option E sorts, not handle duplicates.

812
MCQeasy

You are importing data from a folder containing multiple CSV files with the same structure. You want to combine all files into a single table, but only include files that have been modified in the last 7 days. What Power Query transformation should you use?

A.Use 'Sample File' and manually filter
B.Filter the folder contents by 'Date Modified' before combining
C.Use 'Merge Queries' with the folder
D.Combine files using 'Combine & Load', then filter by date modified
AnswerB

This filters files first, then combines only recent ones.

Why this answer

Option D is correct because filtering by date modified before combining reduces data volume. Option A is wrong because combining then filtering loads all data first. Option B is wrong because sample file is for structure.

Option C is wrong because merging is not for appending.

813
Multi-Selectmedium

A Power BI developer is designing a semantic model that will be used by multiple departments. The developer wants to ensure that the model follows best practices for performance and usability. Which TWO actions should the developer take?

Select 2 answers
A.Use a star schema with dimension and fact tables.
B.Hide foreign key columns from report view.
C.Use calculated columns instead of measures for aggregations.
D.Combine all data into a single flat table to simplify the model.
E.Enable bidirectional cross-filtering between all tables.
AnswersA, B

Star schema optimizes query performance and simplifies user understanding.

Why this answer

A star schema organizes data into dimension and fact tables, reducing data redundancy and improving query performance by enabling efficient aggregations and filter propagation. This design aligns with Power BI best practices for semantic models, as it minimizes the number of tables and relationships, leading to faster DAX calculations and better compression.

Exam trap

The trap here is that candidates often confuse calculated columns with measures, thinking both are interchangeable for aggregations, or they assume a flat table simplifies the model, ignoring the severe performance penalties in Power BI's columnar storage engine.

814
MCQeasy

You have a report with a map visual showing store locations by city. However, some cities are not displaying on the map. You verified that the city names are correct. What should you check first?

A.Use ArcGIS Map visual instead of the built-in map.
B.Add latitude and longitude fields to the map visual.
C.Change the map visual to a filled map.
D.Ensure the city column is set to the Text data type.
AnswerB

Coordinates ensure accurate placement even if geocoding fails.

Why this answer

Option D is correct because Power BI map visuals require latitude and longitude coordinates for accurate placement. If only city names are provided, Power BI attempts to geocode them, which may fail for some cities. Providing coordinates ensures accuracy.

Option A is wrong because built-in map visuals support city names. Option B is wrong because ArcGIS Map may also need coordinates. Option C is wrong because the field data type is not the issue.

815
MCQmedium

You are creating a report in Power BI Desktop. You need to design a visual that shows sales trends over time and allows users to drill down from year to quarter to month. Which visual should you use?

A.Decomposition tree
B.Pie chart
C.Scatter chart
D.Gauge
AnswerA

The decomposition tree supports hierarchical drill-down and is ideal for trend analysis.

Why this answer

The decomposed tree visual supports drill-down through hierarchies, making it suitable for trend analysis with drill-down. Options A and C are not ideal for time trends, and D is outdated.

816
Multi-Selectmedium

You are building a Power BI report to analyze sales performance. You need to allow users to dynamically switch between different measures (e.g., Sales Amount, Sales Quantity, Profit Margin) using a single slicer. Which two features should you implement?

Select 2 answers
A.Create a disconnected parameter table with measure names.
B.Implement a calculation group to switch measures.
C.Use a report page tooltip to display measure choices.
D.Use field parameters to allow dynamic measure selection.
E.Create a calculated table to hold measure values.
AnswersA, D

A disconnected table with measure names is used to drive the slicer selection.

Why this answer

The correct combination is using a disconnected parameter table and field parameters. A disconnected parameter table allows switching measures via a slicer, and field parameters (introduced in Power BI Desktop) dynamically change the field used in visuals. A calculation group also works, but the question asks for two features; field parameters and disconnected tables are the standard approach.

Option C (calculated table) is not directly for switching measures; Option D (report page tooltip) is unrelated.

817
Multi-Selecteasy

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

Select 2 answers
A.To calculate measures that require date arithmetic.
B.To enable time intelligence functions like TOTALYTD.
C.To provide a hierarchy of year, quarter, month, and day for filtering.
D.To create many-to-many relationships between fact tables.
E.To allow multiple active relationships from the same fact table to the date table.
AnswersB, C

Time intelligence functions require a marked date table.

Why this answer

Options A and C are correct. A date table is required for time intelligence functions (A) and for filtering by date attributes not present in the fact table (C). Option B is incorrect because relationships are one-to-many.

Option D is incorrect because multiple active relationships cause ambiguity. Option E is incorrect because measures can be calculated without a date table, but time intelligence functions need it.

818
MCQmedium

Refer to the exhibit. You are reviewing a DAX measure in Power BI. The measure is intended to calculate total sales for the year 2024. However, when used in a visual with a slicer on 'Sales[Date]', the measure does not respect the slicer selection. What is the most likely reason?

A.The FILTER function overrides the slicer filter context.
B.The CALCULATE function removes all filters by default.
C.The measure should use ALL(Sales[Date]) to respect slicers.
D.The DATE function syntax is incorrect.
AnswerA

FILTER within CALCULATE replaces the existing filter on the Sales table, ignoring the slicer.

Why this answer

Option A is correct because the FILTER function in the measure creates a new filter context that overrides the existing slicer filter context on 'Sales[Date]'. When CALCULATE evaluates the expression, it applies the FILTER as a table modifier, which replaces any external filters on the Date column, causing the slicer to be ignored. This is a common DAX behavior where explicit filter arguments in CALCULATE take precedence over existing filter contexts.

Exam trap

The trap here is that candidates often assume CALCULATE always respects slicers, but they miss that explicit filter arguments (like FILTER) override external filters on the same columns, leading to the slicer being ignored.

How to eliminate wrong answers

Option B is wrong because CALCULATE does not remove all filters by default; it only modifies the filter context based on its filter arguments, and without a REMOVEFILTERS or ALL function, it preserves existing filters. Option C is wrong because using ALL(Sales[Date]) would remove the slicer filter entirely, making the measure ignore the slicer even more, not respect it; to respect slicers, you should not use ALL or should use KEEPFILTERS. Option D is wrong because the DATE function syntax (DATE(2024,1,1) and DATE(2024,12,31)) is correct and would not cause the measure to ignore slicer selections.

819
MCQmedium

Your organization uses Power BI to analyze sales data stored in Azure SQL Database. The data model includes a fact table with millions of rows. To improve performance, you need to reduce the amount of data loaded into the model. Which action should you take?

A.Apply row-level filters in Power Query to import only relevant rows
B.Use calculated tables in DAX to summarize data
C.Disable the Auto Date/Time feature
D.Configure incremental refresh with a date filter
AnswerA

Filtering rows in Power Query reduces the data imported into the model, improving performance.

Why this answer

Option A is correct because applying row-level filters in Power Query reduces the volume of data imported into the Power BI model by only loading rows that meet specific criteria. This directly minimizes the data footprint in memory, improving query and refresh performance, especially for fact tables with millions of rows stored in Azure SQL Database.

Exam trap

The trap here is that candidates often confuse incremental refresh with reducing the initial data load, but incremental refresh only optimizes refresh cycles over time and does not limit the first full load unless combined with a date filter in Power Query.

How to eliminate wrong answers

Option B is wrong because calculated tables in DAX are created after data is loaded into the model, so they do not reduce the amount of data imported; they can even increase memory usage by duplicating or aggregating data. Option C is wrong because disabling the Auto Date/Time feature reduces the number of hidden date tables generated by Power BI, which improves model size and performance, but it does not reduce the amount of data loaded from the source. Option D is wrong because incremental refresh with a date filter partitions data for refresh scheduling and reduces the volume of data refreshed each time, but it still requires the full historical data to be loaded initially unless combined with a filter that limits the initial load; the question asks specifically about reducing the amount of data loaded into the model, and incremental refresh alone does not achieve that without additional filtering.

820
Multi-Selectmedium

Which TWO approaches can you use to implement row-level security (RLS) in Power BI?

Select 2 answers
A.Assign users to security groups in the dataset.
B.Use column-level security to restrict row visibility.
C.Use object-level security to restrict rows.
D.Create roles with static filters.
E.Use dynamic filters based on USERNAME().
AnswersD, E

Static RLS uses fixed filter expressions.

Why this answer

Option A is correct because static RLS uses roles with filters based on fixed values. Option D is correct because dynamic RLS uses the USERNAME or USERPRINCIPALNAME function to filter based on the current user. Option B is wrong because column-level security is not RLS; it hides columns.

Option C is wrong because object-level security restricts access to entire tables, not rows. Option E is wrong because Power BI does not support RLS based on groups directly; you need to use roles.

821
MCQmedium

A Power BI report shows a line chart of monthly sales. The user wants to add a horizontal line representing the target sales of $100,000. Which approach should you recommend?

A.Add a constant line from the formatting pane
B.Add a gauge visual to display the target
C.Create a calculated column with the target value
D.Use the analytics pane to add a constant line
AnswerD

The analytics pane allows you to add constant lines, min/max lines, and other reference lines.

Why this answer

Option C is correct because a constant line can be added to a line chart to represent a target value. Option A is wrong because the analytics pane provides the constant line feature, not the formatting pane. Option B is wrong because a calculated column would not display as a horizontal line.

Option D is wrong because a gauge visual is not designed for trend lines.

822
MCQhard

You have a Power BI workspace that contains a dataset with a live connection to Azure Analysis Services. You need to configure the dataset so that when a user views a report in the Power BI service, the underlying data is queried from the Azure Analysis Services model using the user's identity. What should you configure in the Power BI dataset settings?

A.Enable single sign-on (SSO) for the dataset.
B.Set the authentication method to 'Use current user's credentials'.
C.Define row-level security (RLS) roles in Power BI Desktop.
D.Configure the 'Effective identity' settings on the dataset.
AnswerD

Effective identity passes the viewing user's identity to Azure Analysis Services for RLS.

Why this answer

Option B is correct because when using a live connection to Azure Analysis Services, the 'Effective identity' setting in Power BI allows you to pass the viewing user's identity to the source, enabling row-level security defined in Azure Analysis Services. Option A is wrong because single sign-on (SSO) is for data sources like SQL Server, not for Analysis Services live connections. Option C is wrong because the 'Use current user's credentials' is not available for live connections; it's for direct query mode.

Option D is wrong because RLS in Power BI is separate from Analysis Services RLS; for live connections, RLS is defined in Analysis Services.

823
MCQhard

You are importing data from an Excel workbook that contains multiple worksheets. One worksheet has a column named 'Sales Amount' that contains values with different currencies (USD, EUR, JPY). You need to split the data into separate columns for each currency. Which Power Query transformation should you use?

A.Unpivot Columns
B.Split Column by delimiter
C.Merge Columns
D.Group By
AnswerB

Splits the column into currency and amount.

Why this answer

The correct transformation is Split Column by delimiter because the 'Sales Amount' column contains values with different currencies (USD, EUR, JPY) that are likely stored as text with a currency symbol or code prefix (e.g., '$100', '€200', '¥300'). Splitting by a delimiter (such as a space or the first character) allows you to separate the currency code from the numeric value into distinct columns, enabling further data type conversion and analysis per currency. This is a standard data cleansing technique in Power Query for parsing multi-currency data from a single column.

Exam trap

The trap here is that candidates may confuse 'splitting data into separate columns' with 'unpivoting' or 'grouping', but the key is recognizing that the currency values are embedded in a single column and need to be parsed into distinct columns based on a delimiter or position.

How to eliminate wrong answers

Option A is wrong because Unpivot Columns is used to transform columns into rows (i.e., normalize data), not to split a single column's values into multiple columns based on content. Option C is wrong because Merge Columns combines multiple columns into one, which is the opposite of what is needed here. Option D is wrong because Group By aggregates data by grouping rows and performing calculations (e.g., sum, average), not for splitting column values into separate columns.

824
Multi-Selectmedium

Which TWO actions can help reduce the size of a Power BI dataset when preparing data?

Select 2 answers
A.Include all historical data
B.Aggregate transaction data to daily level
C.Add calculated columns
D.Remove columns that are not used in reports
E.Use DirectQuery mode
AnswersB, D

Reduces number of rows.

Why this answer

Aggregating transaction data to a daily level reduces the number of rows in the dataset, which directly decreases the storage footprint and improves refresh performance. Power BI compresses data more efficiently when cardinality is lower, and fewer rows mean smaller column dictionaries and reduced page compression overhead.

Exam trap

Microsoft often tests the misconception that adding calculated columns is a harmless transformation, but in reality, they increase dataset size because they are stored as new columns in the VertiPaq engine.

825
MCQhard

You are designing a star schema for a sales analysis report. The source data includes Order Details, Products, Customers, and Dates. Which table should be the fact table?

A.Dates
B.Customers
C.Order Details
D.Products
AnswerC

Order Details has numeric measures and foreign keys to dimensions, making it the fact table.

Why this answer

Option A is correct because Order Details contains transactional measures (quantity, price) and foreign keys to dimensions. Option B (Products) is a dimension. Option C (Customers) is a dimension.

Option D (Dates) is a dimension.

Page 10

Page 11 of 13

Page 12