Courseiva

CCNA Visualize and analyze the data Questions

75 of 243 questions · Page 2/4 · Visualize and analyze the data · Answers revealed

Practice these questionsDomain overviewAll questions
76
MCQeasy

You want to allow users to filter a report by a specific date range (e.g., last 30 days) without requiring manual selection. Which approach should you take?

A.Use bookmarks to switch between fixed date ranges.
B.Add a relative date slicer to the report page.
C.Create a calculated column that flags rows within the last 30 days.
D.Apply a filter on the date field in the Filters pane.
AnswerB

Relative date slicer provides easy selection of common date ranges.

Why this answer

Option A is correct because a relative date slicer allows users to choose predefined periods like last 30 days. Option B is wrong because a filter pane applies to all pages but is not interactive. Option C is wrong because a calculated column would require maintenance.

Option D is wrong because bookmarks capture a specific view, not dynamic range.

Practice this question →
77
MCQmedium

You have a Power BI report that uses Import mode. The dataset is refreshed daily. Users are complaining that the report shows data from yesterday morning even though the refresh completed successfully at 2:00 AM today. What should you check first?

A.Check row-level security (RLS) role assignments
B.Check the refresh history for errors
C.Verify the on-premises data gateway is running
D.Examine the incremental refresh policy's rangeStart and rangeEnd parameters
AnswerD

Incremental refresh may filter out recent data.

Why this answer

The dataset might be using incremental refresh with a filter that excludes recent data, or the source data hasn't updated. Option C is correct. Option A is wrong because refresh history shows success.

Option B is wrong because gateway is not the issue. Option D is wrong because role permissions don't affect data freshness.

Practice this question →
78
MCQhard

Refer to the exhibit. You are configuring a Power BI dataset for a real-time dashboard that must show data with no more than 5 minutes of latency. What is the impact of the current query caching setting?

A.It will disable caching for real-time queries
B.It will improve performance but may show data up to 60 minutes old
C.It will cause the dataset to switch to DirectQuery mode
D.It will have no effect because caching is off
AnswerB

Caching improves performance at the cost of freshness.

Why this answer

Query caching stores results for up to 60 minutes, causing data to be up to an hour old. This violates the 5-minute latency requirement. The mode is On, not off, and caching applies to all queries.

DirectQuery mode does not eliminate caching.

Practice this question →
79
MCQmedium

You need to design a Power BI report that displays sales trend over time. The data includes dates with missing values for weekends and holidays. Which visualization type and approach should you use to ensure accurate trend representation?

A.Line chart with a categorical date axis
B.Bar chart with a categorical date axis
C.Line chart with a continuous date axis
D.Bar chart with a continuous date axis
AnswerC

Line chart with continuous axis handles date gaps correctly.

Why this answer

Option A is correct because a line chart with a continuous date axis properly handles gaps in dates by not connecting across missing points. Option B is wrong because a bar chart with a categorical axis treats dates as discrete labels, potentially skewing the trend. Option C is wrong because a line chart with a categorical axis would still connect points across missing dates.

Option D is wrong because forcing a continuous axis on a bar chart may create misleading gaps.

Practice this question →
80
Matchingmedium

Match each DAX function category to an example function.

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

Concepts
Matches

SUM

CALCULATE

TOTALYTD

IF

SUMMARIZE

Why these pairings

DAX functions are grouped by their purpose.

Practice this question →
81
MCQeasy

You need to design a report that allows users to see sales data at the year, quarter, and month levels, with the ability to expand and collapse hierarchies. Which visual type should you use?

A.Table visual with hierarchy
B.Stacked bar chart with drill-down
C.Matrix visual
D.Card visual with hierarchy
AnswerC

Matrix supports hierarchical drill-down with expand/collapse.

Why this answer

Option A is correct because matrix visual supports expand/collapse hierarchies. Option B is wrong because a bar chart does not have hierarchy expansion built-in. Option C is wrong because a table is flat.

Option D is wrong because a card visual shows a single value.

Practice this question →
82
MCQeasy

You create a Power BI report that includes a page with a matrix visual showing sales by region and product category. You want users to be able to drill down from region to salesperson level. What is the best way to enable this?

A.Set up drill-through from the region to a salesperson detail page.
B.Use bookmarks to switch between region and salesperson views.
C.Add the Salesperson field to the matrix rows hierarchy below Region.
D.Enable tooltips that show salesperson details on hover.
AnswerC

This creates a hierarchy that enables drill-down within the matrix.

Why this answer

Option B is correct because adding the Salesperson field below the Region field in the matrix rows creates a hierarchy that supports drill-down. Option A is wrong because drill-through navigates to a different page. Option C is wrong because bookmarks do not enable drill-down.

Option D is wrong because tooltips provide additional information but do not support drill-down.

Practice this question →
83
MCQeasy

You have a Power BI report that uses a custom visual from AppSource. The visual is not rendering correctly. What should you check first?

A.The network connection is blocked from reaching AppSource.
B.The visual is not compatible with the report theme.
C.The dataset has row-level security applied.
D.The visual is not certified by Microsoft.
AnswerA

Custom visuals need to fetch resources from AppSource.

Why this answer

Option C is correct because custom visuals require an internet connection to load from the marketplace. Option A is wrong because the visual type is not the issue. Option B is wrong because the visual is certified by the developer.

Option D is wrong because security roles in the dataset do not affect visual rendering.

Practice this question →
84
MCQhard

A Power BI report contains a page with many visuals that use a large DirectQuery dataset. The report is slow to load. Which design change would most improve the initial page load time?

A.Reduce the number of visuals on the page
B.Increase the default page-level filter to limit data
C.Use a slicer to let users choose what to see
D.Create aggregations on the dataset
AnswerA

Fewer visuals mean fewer queries, improving load time.

Why this answer

Reducing the number of visuals on the page directly decreases the number of queries sent to the DirectQuery source during initial page load. Each visual in a DirectQuery model typically generates at least one separate query against the source database, so fewer visuals means fewer concurrent queries and less data transferred, which significantly improves load time.

Exam trap

The trap here is that candidates often confuse performance improvements that reduce query volume (fewer visuals) with those that optimize query execution (aggregations, filters), but for initial page load time, reducing the number of queries is the most direct and effective change.

How to eliminate wrong answers

Option B is wrong because increasing the default page-level filter does not reduce the number of queries; it only limits the rows returned per query, but the overhead of executing many queries for each visual remains. Option C is wrong because using a slicer does not affect initial page load; slicers are interactive controls that apply filters after the page has already loaded, so they do not reduce the initial query volume. Option D is wrong because creating aggregations on the dataset is a design change that improves query performance for large datasets, but it does not directly reduce the number of visuals or queries on the page; it addresses query speed rather than the number of queries executed.

Practice this question →
85
MCQmedium

You are designing a Power BI report for executives. They need to quickly see the top 10 products by revenue and the trend of revenue over the last 12 months. Which combination of visuals should you include on a single page?

A.Stacked bar chart for top products and a line chart for monthly revenue trend
B.Clustered bar chart for top products and a stacked bar chart for monthly revenue
C.Funnel chart for top products and a line chart for monthly revenue
D.Table of products and a pie chart for monthly revenue
AnswerA

Bar chart shows ranking; line chart shows trend over time.

Why this answer

Option C is correct because a stacked bar chart shows top products and a line chart shows trend. Option A is wrong because two bar charts are redundant. Option B is wrong because a table and pie chart are not ideal for trends.

Option D is wrong because a funnel chart is for stages.

Practice this question →
86
MCQhard

Refer to the exhibit. The DAX measure is intended to return the previous purchase amount for the same customer. However, it returns the current row's amount for most rows. What is the most likely reason?

A.The data type of OrderDate is text, causing comparison issues
B.ALLEXCEPT removes all filters except CustomerID, so the measure cannot find the previous date
C.The variable PreviousDate is evaluated within the current filter context, which may be the same as LastDate for single rows
D.The CALCULATE function does not support the 'Sales'[OrderDate] = PreviousDate syntax
AnswerC

Without an explicit filter to get the previous date, PreviousDate may equal LastDate.

Why this answer

Option B is correct because the variable PreviousDate is evaluated in the filter context of the current row, causing it to return the same date as LastDate when there is only one row per customer per date. Option A is wrong because ALLEXCEPT retains the CustomerID filter, which is correct. Option C is wrong because the measure uses CALCULATE correctly.

Option D is wrong because the data type is not the issue.

Practice this question →
87
MCQhard

You are building a Power BI report from a large dataset (10 GB) stored in Azure Synapse Analytics. The dataset includes a fact table with 500 million rows. You need to minimize the amount of data imported into Power BI while still allowing users to filter by year and product category. Which approach should you use?

A.Use DirectQuery to avoid importing data
B.Import only the necessary columns from the fact table
C.Create an aggregation table on year and product category
D.Configure Incremental Refresh with a filter on year
AnswerD

Incremental Refresh imports only new/changed data, reducing load.

Why this answer

Option D is correct because Incremental Refresh with Filtering allows you to import only relevant data (e.g., current year) and filter further by other dimensions. Option A is wrong because DirectQuery may be slow for large fact tables. Option B is wrong because aggregations are not suitable for filtering at granular level.

Option C is wrong because reducing columns does not reduce rows sufficiently.

Practice this question →
88
MCQmedium

You need to create a measure that calculates the year-over-year growth of sales. Which DAX function should you use?

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

Returns the exact same period last year, ideal for YoY.

Why this answer

Option C is correct because SAMEPERIODLASTYEAR returns the same period last year, which is used in YoY calculations. Option A is wrong because PARALLELPERIOD shifts by a full period, not necessarily the same days. Option B is wrong because DATEADD can shift by any interval.

Option D is wrong because PREVIOUSYEAR returns the full previous year, not the same period.

Practice this question →
89
MCQeasy

You need to create a report that calculates running total of sales over time. Which Power BI feature should you use?

A.Use the Quick Measure for 'Running total'
B.Write a measure using SUM and FILTER
C.Create a calculated table with running total
D.Add a calculated column using EARLIER function
AnswerA

Quick Measure generates correct DAX for running total.

Why this answer

Option C is correct because the Quick Measure for running total generates the appropriate DAX. Option A is wrong because a calculated column is static. Option B is wrong because a measure is needed but the quick measure provides correct formula.

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

Practice this question →
90
Multi-Selecthard

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

Select 3 answers
A.Create a dedicated mobile layout view
B.Use large font sizes and high-contrast colors
C.Use custom visuals for advanced analytics
D.Limit the number of visuals per page to 3-5
E.Include multiple slicers for flexible filtering
AnswersA, B, D

Mobile layout view optimizes visuals for small screens.

Why this answer

Option A is correct because Power BI provides a dedicated mobile layout view that allows you to optimize report pages specifically for mobile devices. By using this view, you can rearrange, resize, and hide visuals to ensure they display properly on smaller screens, which is a best practice for mobile report design.

Exam trap

The trap here is that candidates may confuse general report design best practices (like using custom visuals or multiple slicers) with mobile-specific best practices, failing to recognize that mobile constraints require simplification and dedicated layout optimization.

Practice this question →
91
MCQhard

You run the above DAX query in DAX Studio. The result shows profit margin values for each year, but all values are the same for every year despite sales amounts varying. What is the most likely cause?

A.The Sales table contains a calculated column that overrides the year filter.
B.The DIVIDE function is not handling division by zero correctly.
C.The SUMMARIZECOLUMNS function is not compatible with measures that use SUMX.
D.The measures use row context instead of filter context, causing them to evaluate over the entire table.
AnswerD

SUMMARIZECOLUMNS provides filter context, but the SUMX iterates over the Sales table without considering the current year filter because the measures are not using CALCULATE to transform row context.

Why this answer

The issue is that the measures [Total Sales] and [Total Cost] are defined using SUMX over the entire Sales table without any filter context propagation from SUMMARIZECOLUMNS. The SUMMARIZECOLUMNS function only provides row context for the columns in the group by, but measures that use SUMX with a row iterator (Sales table) are not automatically filtered by the year. To get year-level profit margin, the measures should be written using CALCULATE with appropriate filters, or the SUMX should be replaced with SUM after filtering.

Option C is correct because the measures are not respecting the filter context. Option A is incorrect because there is no calculated column. Option B is incorrect because row context is not an issue; it's filter context.

Option D is incorrect because error handling is not the cause.

Practice this question →
92
MCQeasy

You need to allow users to ask questions about their data using natural language. Which Power BI feature should you enable?

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

Q&A lets users type questions in natural language.

Why this answer

The Q&A visual in Power BI allows users to ask questions about their data using natural language, automatically generating visualizations based on the query. This feature is specifically designed for natural language querying, making it the correct choice for enabling users to interact with data conversationally.

Exam trap

The trap here is that candidates may confuse Copilot's generative AI capabilities with the Q&A visual's dedicated natural language querying, but Copilot is for report creation assistance, not for ad-hoc natural language questions about data.

How to eliminate wrong answers

Option A is wrong because the Key Influencers visual is an AI-driven visual that analyzes and displays factors influencing a metric, not a natural language query interface. Option B is wrong because Quick Insights automatically generates pre-defined insights and visualizations from data, but it does not accept user-typed natural language questions. Option D is wrong because Copilot is a generative AI assistant that helps create reports and summaries, but it is not the dedicated natural language query feature for asking ad-hoc questions about data; that role belongs to the Q&A visual.

Practice this question →
93
MCQmedium

You are building a Power BI report that uses a live connection to an Azure Analysis Services (AAS) tabular model. Users need to be able to filter data using a slicer that shows only products that have been sold in the current year. What should you do?

A.Add a calculated column to the Product table in the AAS model that marks products sold this year
B.Use a filter on the slicer visual to show only products where sales year equals current year
C.Create a calculated table in the AAS model that returns only products sold in the current year
D.Create a calculated table in Power BI Desktop using DAX to filter products
AnswerC

Calculated table in AAS is dynamic and available via live connection.

Why this answer

Option C is correct because a calculated table in the AAS model can filter products dynamically, and it will be available in the live connection. Option A is wrong because live connections do not allow new calculated tables in Power BI Desktop. Option B is wrong because a calculated column in the view filters the entire table, not just the slicer.

Option D is wrong because the filter pane applies to all visuals, not just the slicer.

Practice this question →
94
MCQeasy

You have a Power BI report with a matrix that shows sales by region and product category. Users complain that the matrix is too cluttered and hard to read. Which best practice should you apply to improve readability?

A.Remove all subtotals and grand totals.
B.Add more hierarchy levels to the rows to provide granularity.
C.Change the matrix to a table with all detail rows.
D.Apply conditional formatting using data bars or color scales.
AnswerD

Conditional formatting highlights patterns without clutter.

Why this answer

Option C is correct because applying conditional formatting with data bars or color scales helps users quickly identify patterns without adding clutter. Option A is wrong because adding more hierarchy levels increases complexity. Option B is wrong because removing totals reduces context.

Option D is wrong because changing to a table with all details would not reduce clutter.

Practice this question →
95
Multi-Selectmedium

Which THREE of the following are valid methods to enhance the accessibility of a Power BI report? (Choose three.)

Select 3 answers
A.Add animations to visuals to draw attention.
B.Provide keyboard navigation support by setting tab order.
C.Use a high contrast theme.
D.Use a color-blind friendly palette.
E.Add alt text to all visuals.
AnswersB, D, E

Tab order allows keyboard users to navigate logically.

Why this answer

Option B is correct because setting tab order in Power BI allows keyboard-only users to navigate through report visuals in a logical sequence, which is a core requirement of WCAG 2.1 success criterion 2.4.3 (Focus Order). This ensures that interactive elements receive focus in a meaningful order, directly improving accessibility for users with motor disabilities or those relying on screen readers.

Exam trap

The trap here is that candidates often confuse 'visual appeal' enhancements (like animations or high contrast themes) with genuine accessibility features, but Microsoft's PL-300 exam specifically tests knowledge of WCAG-based accessibility methods such as alt text, keyboard navigation, and color-blind friendly palettes, not subjective visual effects.

Practice this question →
96
MCQmedium

You have a Power BI dataset that includes a table 'Orders' with columns: OrderDate, CustomerID, ProductID, Quantity, and Revenue. You need to create a measure that calculates the running total of Revenue over the last 12 months, but only for products that have been sold in the current month. The measure should be used in a line chart showing monthly revenue. You have the following options: A. Use the TOTALQTD function with a filter for last 12 months. B. Use CALCULATE with DATESINPERIOD and a filter on products with sales in the current month. C. Create a calculated column for running total and then sum it. D. Use the WINDOW function (Preview). Which option should you choose?

A.Use the WINDOW function (Preview)
B.Use CALCULATE with DATESINPERIOD and a filter on products with sales in the current month
C.Use TOTALQTD with a filter for last 12 months
D.Create a calculated column for running total and then sum it
AnswerB

This dynamically computes the rolling 12-month total for relevant products.

Why this answer

Option B is correct because you can use CALCULATE with DATESINPERIOD to compute the running total over 12 months, and add a filter to restrict to products that have sales in the current month. Option A is wrong because TOTALQTD is for quarter-to-date, not rolling 12 months. Option C is wrong because calculated columns are static and not dynamic for each month.

Option D is wrong because WINDOW function is still in preview and not recommended for production.

Practice this question →
97
MCQhard

You are designing a report for executives. They need to see both high-level KPIs and the ability to drill down into details. Which approach should you recommend?

A.Place all data in a single table visual with drill-down capability.
B.Use drillthrough pages to navigate from summary visuals to detail pages.
C.Use bookmarks to switch between summary and detail views.
D.Use report page tooltips to show details on hover.
AnswerB

Drillthrough provides contextual detail navigation.

Why this answer

Option A is correct because drillthrough pages allow users to click on a high-level visual and see detailed data for that context. Option B is wrong because tooltips show only summary information, not detailed drilldown. Option C is wrong because bookmarks navigate to different states but not a dedicated detail page.

Option D is wrong because a single table visual does not provide high-level KPI overview.

Practice this question →
98
MCQeasy

You have a Power BI report that uses a bar chart to show sales by region. Users report that the chart is difficult to read because many regions have similar sales values. You need to improve the readability without changing the data. Which visual should you use?

A.Line chart
B.Treemap
C.Donut chart
D.Small multiples (bar chart)
AnswerD

Small multiples split the chart into panels for each category, improving readability.

Why this answer

Option B is correct because a small multiples chart allows breaking down the bar chart into separate panels per region, making it easier to compare values. Option A is wrong because treemaps are not ideal for comparing similar values. Option C is wrong because line charts are for trends.

Option D is wrong because donut charts show proportions.

Practice this question →
99
MCQhard

You are reviewing a Power BI report with the JSON configuration shown in the exhibit. The visual is supposed to display the top 5 product categories by total sales, with all remaining categories grouped into 'Other'. However, the visual shows only the top 5 categories and no 'Other' bar. What is the most likely reason?

A.The JSON version is incorrect; must be 3.0.
B.The 'otherGroup' section lacks a 'showOther' property set to true.
C.The 'sortOrder' should be 'ascending' for 'Other' to appear.
D.The JSON is malformed; missing closing bracket.
AnswerB

The 'otherGroup' requires 'showOther' to display the aggregated 'Other' bar.

Why this answer

Option B is correct because the 'otherGroup' is defined but the aggregation of 'Other' must be enabled in the visual formatting; missing 'showOther' flag. Option A is wrong because JSON version 2.0 is valid. Option C is wrong because sorting does not affect grouping.

Option D is wrong because the format is correct JSON.

Practice this question →
100
MCQeasy

You need to create a KPI visual that shows whether current sales are above or below target. Which fields are required for a KPI visual?

A.Value, Trend axis, and Category
B.Value, Trend axis, and Target
C.Value and Trend axis only
D.Value and Target only
AnswerB

These three fields are essential for a KPI visual.

Why this answer

A KPI visual requires a Value (measure for current sales), a Trend axis (usually date), and a Target (goal).

Practice this question →
101
MCQmedium

You have a Power BI report that uses a DirectQuery connection to a large SQL Server data warehouse. Users report that slicers and filters are slow to respond. What should you recommend to improve performance?

A.Optimize the SQL queries and add appropriate indexes in the data warehouse.
B.Change the connection to a live connection to the data warehouse.
C.Increase the memory allocated to the Power BI service capacity.
D.Switch the report to Import mode and schedule refreshes.
AnswerA

Optimizing the source query improves performance for DirectQuery.

Why this answer

Option A is correct because optimizing the source query with indexes, aggregations, and reducing data volume improves DirectQuery performance. Option B is wrong because Import mode would require moving large data and may not be feasible. Option C is wrong because increasing RAM does not affect DirectQuery performance.

Option D is wrong because changing to live connection doesn't improve query performance.

Practice this question →
102
MCQmedium

You are creating a Power BI report to visualize customer feedback scores. The data contains a column 'FeedbackDate' with dates and a column 'Score' with values from 1 to 10. You want to show a trend line of average score over time. Which visual type is most appropriate?

A.Pie chart
B.Card
C.Table
D.Line chart
AnswerD

Line charts are best for time series trends.

Why this answer

Option C is correct because a line chart is ideal for showing trends over time. Option A is wrong because a pie chart shows proportions. Option B is wrong because a table shows raw data.

Option D is wrong because a card shows a single value.

Practice this question →
103
Multi-Selectmedium

You are designing a Power BI dashboard for executive management. Which TWO practices should you follow to ensure the dashboard is effective?

Select 2 answers
A.Configure real-time data refresh for all data sources.
B.Include as many visuals as possible on a single dashboard page.
C.Use a dark background to make visuals stand out.
D.Use consistent color coding across visuals.
E.Limit the dashboard to the most important KPIs.
AnswersD, E

Consistent colors improve readability.

Why this answer

Options A and D are correct. A: Using consistent color coding helps users quickly interpret data. D: Including key KPIs focuses on what matters.

Option B is wrong because too many visuals clutter the dashboard. Option C is wrong because real-time refresh may not be necessary and can impact performance.

Practice this question →
104
MCQhard

You have a Power BI report that uses a DirectQuery dataset from Azure Synapse Analytics. Users complain that applying a filter on a date slicer takes over 30 seconds. The underlying table contains 500 million rows. You need to improve slicer responsiveness. What should you do?

A.Disable cross-filtering between the slicer and other visuals.
B.Add more visuals to the page so the slicer filter is reused across visuals.
C.Create a date dimension table in the source and use it for the slicer.
D.Import the date column into Power BI and use it for the slicer.
AnswerC

A date dimension reduces cardinality and improves DirectQuery slicer performance.

Why this answer

Option B is correct because creating a date dimension table and using it for the slicer reduces the cardinality of the filter column, improving DirectQuery performance. Option A is wrong because increasing the page's visual count would add more queries. Option C is wrong because importing the date table would create a hybrid model, but the slicer on the imported table would still need to filter the DirectQuery table, which may cause performance issues.

Option D is wrong because disabling cross-filtering doesn't address the root cause.

Practice this question →
105
MCQmedium

You have a report with a line chart showing monthly sales. Users need to see the exact sales value when they hover over a data point. What should you configure?

A.Enable data labels on the chart.
B.Configure the visual's tooltip to display the value.
C.Add a report page tooltip.
D.Set the category label to show the value.
AnswerB

The default tooltip already shows the value; if it's not showing, ensure the tooltip is enabled.

Why this answer

Option B is correct because tooltips in Power BI are designed to show detailed information about a data point when the user hovers over it. By default, the visual's tooltip already includes the value, but if it has been customized or removed, you need to ensure the tooltip is configured to display the sales value. This provides an interactive way to see exact numbers without cluttering the chart with permanent labels.

Exam trap

The trap here is that candidates often confuse data labels (which show values permanently on the chart) with tooltips (which show values on hover), leading them to select option A instead of understanding that tooltips are the correct interactive mechanism for this requirement.

How to eliminate wrong answers

Option A is wrong because enabling data labels permanently displays the sales value on the chart for every data point, which can clutter the visual and is not the hover-based behavior requested. Option C is wrong because a report page tooltip is a custom tooltip that can show additional context from other visuals or pages, but it is not required for simply showing the exact sales value; the default visual tooltip already serves that purpose. Option D is wrong because the category label shows the category name (e.g., month), not the sales value, and setting it to show the value would misrepresent the axis.

Practice this question →
106
MCQeasy

You need to create a measure that calculates year-over-year growth percentage. Which DAX function should you use?

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

This function returns the same period in the prior year, ideal for YoY.

Why this answer

The SAMEPERIODLASTYEAR function returns a set of dates shifted one year back in time, which is exactly what you need to compare current period values with the prior year for year-over-year growth calculations. By using SAMEPERIODLASTYEAR in a measure like `DIVIDE(SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date])), CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date])))`, you get the percentage change. This function is specifically designed for year-over-year comparisons and works correctly with contiguous date ranges.

Exam trap

The trap here is that candidates often choose DATEADD or PARALLELPERIOD because they seem more flexible, but SAMEPERIODLASTYEAR is the only function that guarantees a direct, contiguous year-over-year comparison without requiring manual interval specification or risking misaligned periods.

How to eliminate wrong answers

Option A is wrong because DATEADD shifts dates by a specified interval (e.g., -1 year) but returns a single column of dates, not a contiguous period, and can produce unexpected results when used with non-standard calendars or incomplete date ranges. Option B is wrong because DATESYTD returns a set of dates from the start of the year to the latest date in the current context, which is used for year-to-date calculations, not for comparing against the prior year. Option D is wrong because PARALLELPERIOD shifts an entire period (e.g., the whole previous year) but does not align to the same relative period as SAMEPERIODLASTYEAR; it can include partial periods or incorrect boundaries when the date range is not full.

Practice this question →
107
MCQeasy

You need to create a Power BI report that allows users to select a single measure from a list to display on a card visual. Which feature should you use?

A.Bookmarks
B.Tooltips
C.Field parameters
D.Drill-through
AnswerC

Correct. Field parameters enable dynamic measure selection.

Why this answer

Option A is correct because field parameters allow users to dynamically switch between measures. Option B is wrong because bookmarks capture a snapshot, not dynamic selection. Option C is wrong because drill-through filters to a detail page.

Option D is wrong because tooltips show additional information on hover.

Practice this question →
108
MCQhard

You have a Power BI dataset with a fact table containing sales transactions and a dimension table for customers. The customer dimension includes a calculated column that uses the LOOKUPVALUE function to retrieve a customer's region from another table. The report performance is slow. What should you do to improve performance?

A.Disable the 'Reduce queries sent to the source' option.
B.Enable incremental refresh on the fact table.
C.Remove the LOOKUPVALUE column and instead create a relationship between the tables.
D.Increase the amount of RAM on the Power BI service capacity.
AnswerC

Relationships are more efficient than LOOKUPVALUE for retrieving related values.

Why this answer

Option D is correct because replacing LOOKUPVALUE with a relationship-based approach (e.g., using RELATED) or merging tables in Power Query is more efficient. Option A is wrong because increasing RAM does not address the inefficiency of LOOKUPVALUE. Option B is wrong because disabling the query reduction setting would degrade performance.

Option C is wrong because incremental refresh applies to the fact table, not to calculated columns.

Practice this question →
109
MCQmedium

You are reviewing a DAX query that returns total sales by year and quarter. However, the result includes rows for quarters with no sales. Which modification should you make to exclude empty rows?

A.Add a filter: 'FILTER(ALL('Date'), NOT ISBLANK([Total Sales]))' inside SUMMARIZECOLUMNS
B.No modification is needed; SUMMARIZECOLUMNS already excludes blank rows
C.Replace SUMMARIZECOLUMNS with ADDCOLUMNS(SUMMARIZE(...))
D.Wrap the SUMMARIZECOLUMNS in a NATURALINNERJOIN with Sales table
AnswerA

This explicitly removes rows where Total Sales is blank.

Why this answer

Option C is correct because KEEPFILTERS is not needed; SUMMARIZECOLUMNS by default only returns rows where at least one non-empty measure exists. However, if the measure is defined as a sum, it may return zero for empty combinations. To truly exclude rows where the measure is blank, you can add a filter.

But the exhibit shows an implicit measure that returns blank for empty groups. SUMMARIZECOLUMNS automatically excludes rows where all measure values are blank. Since the measure is a simple SUM, it returns blank for quarters with no sales, so SUMMARIZECOLUMNS will exclude them.

Option A is wrong because NATURALINNERJOIN is not needed. Option B is wrong because ADDCOLUMNS is unnecessary. Option D is wrong because the query already returns correct results.

Practice this question →
110
MCQmedium

You have a report with a map visual showing store locations. You want to display a tooltip with additional store information (e.g., manager name, phone number) when a user hovers over a point. How should you achieve this?

A.Create a card visual next to the map and sync it with the map selection.
B.Add a slicer that displays the details when selected.
C.Set up a drillthrough page for each store.
D.Create a report page tooltip and assign it to the map visual.
AnswerD

Report page tooltips appear on hover and can show multiple fields.

Why this answer

Option D is correct because a report page tooltip allows custom tooltip pages. Option A is wrong because a slicer does not provide tooltips. Option B is wrong because a card visual is separate.

Option C is wrong because drillthrough navigates to another page.

Practice this question →
111
MCQhard

You are building a Power BI report that uses a composite model with a DirectQuery source and an imported local table. You want to create a measure that aggregates data from both sources. What must you ensure?

A.The relationships between tables must be defined correctly.
B.You cannot create measures that use columns from both sources.
C.Both tables must be set to the same storage mode (DirectQuery or Import).
D.The local table must be converted to DirectQuery.
AnswerA

Relationships enable cross-source aggregations.

Why this answer

Option B is correct because in composite models, measures can aggregate data from multiple sources if the relationships are correct. Option A is wrong because storage mode does not need to be the same. Option C is wrong because relationships can be between different storage modes.

Option D is wrong because both tables can be used in a measure.

Practice this question →
112
Multi-Selectmedium

Which TWO of the following are valid ways to share a Power BI report with external users who do not have a Power BI license?

Select 2 answers
A.Export to PDF and email
B.Embed in a secure portal using Power BI Embedded
C.Share via Power BI service with a direct link
D.Create a Power BI app and grant access
E.Publish to web (public)
AnswersB, E

Embedded allows embedding in custom apps; users don't need individual licenses.

Why this answer

Publish to web makes the report public (no license needed). Embed in a secure portal (using Power BI Embedded) also allows external access without licenses if capacity is used.

Practice this question →
113
Multi-Selecthard

You have a Power BI report that uses a composite model with a DirectQuery source and an imported table. Users report that some visuals show incorrect totals when using measures that reference both sources. Which THREE conditions must be met to ensure correct results?

Select 3 answers
A.Ensure relationships are defined with appropriate cardinality and cross-filter direction
B.Set both sources to Dual storage mode
C.Use measures that aggregate data at the appropriate granularity
D.Enable 'Reduce queries' in report settings
E.Set 'Assume Referential Integrity' on relationships between sources
AnswersA, C, E

Proper relationships are essential for composite model accuracy.

Why this answer

Options A, D, and E are correct. Setting 'Assume Referential Integrity' (A) allows Power BI to optimize queries. Ensuring compatible relationships (D) is crucial for composite models.

Using measures that aggregate correctly across storage modes (E) is necessary. Option B is incorrect because dual storage mode is not required. Option C is incorrect because query reduction does not fix incorrect totals.

Practice this question →
114
MCQmedium

You are designing a Power BI report to analyze sales performance across multiple regions. The data includes a Date table with a Many-to-One relationship to Sales. You need to ensure that users can drill down from Year to Quarter to Month in a matrix visual. What must you configure on the Date table?

A.Use the built-in date hierarchy without marking the table
B.Create a relationship between Date and Sales on the Date column
C.Add calculated columns for Year, Quarter, and Month
D.Mark the Date table as a date table
AnswerD

Marking as Date Table enables built-in date hierarchy and drill-down.

Why this answer

Option B is correct because enabling 'Mark as Date Table' in Power BI automatically creates hierarchies and enables drill-down capabilities. Option A is wrong because relationships do not create hierarchies. Option C is wrong because calculated columns are not required for drill-down.

Option D is wrong because the built-in date hierarchy is automatically created when the table is marked as a date table.

Practice this question →
115
MCQmedium

You have a Power BI report that uses a live connection to an Azure Analysis Services tabular model. Users report that the report is slow to load. You need to improve performance without changing the data model. What should you do?

A.Implement report-level measures to pre-calculate complex aggregations.
B.Enable 'Load to report' on the dataset to import data into Power BI.
C.Reduce the number of relationships in the data model.
D.Increase the number of visuals on each report page to reduce the number of pages.
AnswerA

Report-level measures reduce server queries and improve performance.

Why this answer

Option A is correct because implementing report-level measures can reduce the number of queries sent to the server, improving performance. Option B is wrong because enabling 'Load to report' would import data, breaking the live connection requirement. Option C is wrong because increasing the page's visual count could degrade performance.

Option D is wrong because reducing the number of relationships would alter the data model, which is not allowed.

Practice this question →
116
MCQmedium

You are building a report for a logistics company. The dataset includes a 'Shipments' table with columns: ShipmentID, ShipDate, OriginCity, DestinationCity, Weight, Revenue, and Carrier. The company wants to analyze revenue trends by carrier over time. They have a date table marked as a date table. You create a line chart with ShipDate on the axis and Revenue as the value, with Carrier as the legend. However, the line chart shows a single line for each carrier, but the revenue values are aggregated across all dates, showing a constant line. What is the most likely cause?

A.There are missing relationships between Shipments and the date table.
B.The ShipDate column is of type 'Text' instead of 'Date'.
C.The Revenue column is a measure that is not summing correctly.
D.The date table is marked as a date table but not related to Shipments.
AnswerB

If ShipDate is text, Power BI will treat each unique date as a separate category, but if the values are dates, it may still aggregate incorrectly if not recognized.

Why this answer

Option B is correct because if the ShipDate column is stored as text, Power BI cannot treat it as a continuous date hierarchy. Even though a separate date table is marked as a date table, the line chart uses the ShipDate column from the Shipments table. When ShipDate is text, Power BI treats each unique text value as a separate category, and since there is no time intelligence, the revenue is aggregated across all rows for each carrier, resulting in a flat line showing the total revenue for that carrier.

The chart does not break down revenue by actual dates, so it appears constant.

Exam trap

The trap here is that candidates often assume a separate date table automatically resolves date-related issues, but the root cause is the data type of the column used on the axis, not the presence or absence of a date table relationship.

How to eliminate wrong answers

Option A is wrong because missing relationships between Shipments and the date table would typically cause the chart to show no data or an error, not a constant line; the line chart is using ShipDate directly from the Shipments table, not the date table. Option C is wrong because if the Revenue column were a measure that is not summing correctly, the values would likely be blank or show an error, not a constant aggregated value across all dates. Option D is wrong because the date table being marked as a date table but not related to Shipments would not affect the line chart if the chart uses ShipDate from the Shipments table; the chart would still plot dates from Shipments, but if ShipDate is text, the issue remains the same.

Practice this question →
117
MCQeasy

You have a Power BI report that includes a pie chart. Users complain that it is difficult to compare the sizes of slices. Which visual should you recommend instead to improve comparison?

A.A treemap.
B.A donut chart.
C.A bar chart.
D.A scatter plot.
AnswerC

Bar charts allow easy comparison.

Why this answer

Option A is correct because bar charts allow easy comparison of lengths. Option B is wrong because tree maps are also hard to compare. Option C is wrong because scatter plots are for correlation.

Option D is wrong because donut charts are similar to pie charts.

Practice this question →
118
MCQhard

Refer to the exhibit. You run this DAX query and receive an error. What is the most likely reason?

A.The column 'Category' does not exist
B.SUMMARIZECOLUMNS is deprecated
C.SUMMARIZECOLUMNS requires a measure, not an aggregation expression
D.EVALUATE cannot be used in DAX queries
AnswerC

SUMMARIZECOLUMNS expects a measure or a table expression.

Why this answer

SUMMARIZECOLUMNS cannot use SUM directly; it requires an explicit filter context or a measure. A measure should be defined first or use CALCULATE. The syntax is correct but the expression is invalid.

Practice this question →
119
MCQeasy

You need to create a visual that displays the sales trend over the last 12 complete months. Which approach should you use?

A.Create a calculated column that flags last 12 months.
B.Add a slicer for the last 12 months.
C.Write a measure that calculates sales for last 12 months and use it in a visual.
D.Use a relative date filter on the date field set to 'Last 12 months'.
AnswerD

Relative date filter automatically updates to the last 12 complete months.

Why this answer

Option C is correct because a relative date filter on a date hierarchy shows the last N periods. Option A is wrong because a slicer requires manual selection. Option B is wrong because a calculated column is static.

Option D is wrong because a measure alone does not filter visuals.

Practice this question →
120
Multi-Selectmedium

Which TWO actions can you perform using Power BI Desktop's Query Editor? (Choose two.)

Select 2 answers
A.Define row-level security (RLS) roles.
B.Merge two tables based on a common column.
C.Create a relationship between two tables.
D.Remove duplicate rows from a table.
E.Create a new measure using DAX.
AnswersB, D

Query Editor can merge tables (like SQL joins).

Why this answer

Option B is correct because the Power BI Query Editor (Power Query) includes a 'Merge Queries' feature that allows you to join two tables based on matching values in a common column. This is a fundamental data transformation operation used to combine data from different sources or tables before loading into the data model.

Exam trap

The trap here is that candidates often confuse the Query Editor's data transformation capabilities with data modeling tasks (like creating relationships or measures) or security configurations, leading them to select options that belong to other Power BI Desktop views.

Practice this question →
121
MCQmedium

Your Power BI report includes a map visual showing store locations. However, some locations are not appearing correctly because of ambiguous place names. What should you do to ensure accurate geocoding?

A.Aggregate the data by country
B.Switch to a bubble chart
C.Use latitude and longitude fields instead of location names
D.Change the map visual to a filled map
AnswerC

Exact coordinates prevent geocoding errors.

Why this answer

Using latitude and longitude fields bypasses Bing's geocoding, ensuring accuracy. Changing the map style does not fix geocoding, using a filled map is for regions, and a bubble chart is not geographic.

Practice this question →
122
MCQhard

Refer to the exhibit. A user created this measure to calculate sales for the same period last year. However, the measure returns incorrect values when used in a matrix with month granularity. What is the most likely cause?

A.The DATE function is incorrectly specified
B.The 'Date' table is not marked as a date table
C.The VAR CurrentDate is not needed
D.CALCULATE should not be used with SAMEPERIODLASTYEAR
AnswerB

Time intelligence functions require a marked date table with continuous dates.

Why this answer

SAMEPERIODLASTYEAR relies on a contiguous date table; if the date table is not marked or has gaps, it may shift incorrectly. The DATE function is not the issue, and CALCULATE is used correctly. The time intelligence functions require a proper date table.

Practice this question →
123
Multi-Selecthard

Which THREE features are available in Power BI to support natural language queries?

Select 3 answers
A.Key Influencers visual
B.Suggested Questions
C.Q&A visual
D.Synonyms for tables and columns
E.Quick Measures
AnswersB, C, D

Provides prebuilt questions for users.

Why this answer

Options A, B, and C are correct. Q&A visual allows typing questions; Suggested Questions appear in the Q&A visual; Synonyms help Q&A understand business terms. Option D is wrong because Quick Measures create DAX, not natural language.

Option E is wrong because Key Influencers is an AI visual but not natural language.

Practice this question →
124
MCQmedium

You are building a report to analyze sales performance by region. You need to allow users to dynamically switch between viewing data as a bar chart and a line chart without modifying the report page. Which feature should you use?

A.Use bookmarks with buttons to toggle between charts.
B.Add a slicer that changes the chart type.
C.Use a custom visual with built-in toggle.
D.Create a drillthrough page for each chart type.
AnswerA

Bookmarks capture the state of visuals and can be toggled via buttons.

Why this answer

Option A is correct because bookmarks with buttons allow users to switch between visual states dynamically. Option B is wrong because a slicer filters data, not switches chart types. Option C is wrong because a drillthrough page navigates to a different page.

Option D is wrong because a custom visual would require additional development.

Practice this question →
125
Drag & Dropmedium

Drag and drop the steps to import data from a SQL Server database into 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

Importing from SQL Server involves selecting the source, connecting to the server and database, choosing tables or queries, and loading or transforming data.

Practice this question →
126
MCQeasy

You are creating a Power BI report and need to visualize the relationship between two numerical variables, such as sales amount and profit. Which visual type is most appropriate?

A.Line chart
B.Stacked bar chart
C.Pie chart
D.Scatter chart
AnswerD

Scatter chart shows correlation between two numerical variables.

Why this answer

Option A is correct because a scatter chart is designed to show the relationship between two numerical variables. Option B is wrong because a pie chart shows proportions of a whole. Option C is wrong because a stacked bar chart compares parts of a whole across categories.

Option D is wrong because a line chart shows trends over time.

Practice this question →
127
Multi-Selecthard

Which THREE of the following are best practices for designing Power BI reports for mobile devices?

Select 3 answers
A.Use a single column of visuals
B.Include many small text tables
C.Place visuals side by side to maximize space
D.Use large, easy-to-tap slicers
E.Group related measures into a single visual
AnswersA, D, E

Single column works best on mobile screens.

Why this answer

Option A is correct because mobile screens have limited width, so a single-column layout ensures visuals scale properly without horizontal scrolling, which is a core recommendation in Microsoft's mobile report design guidelines. This approach maintains readability and touch interaction by stacking visuals vertically, avoiding the need for users to pinch or zoom.

Exam trap

The trap here is that candidates confuse maximizing screen space (side-by-side visuals) with mobile optimization, but Microsoft's guidance explicitly prioritizes touch-friendly, single-column layouts over density.

Practice this question →
128
MCQmedium

You have a Power BI dataset that contains a table with sales data and a separate date table. You create a measure that uses CALCULATE and DATESYTD to show year-to-date sales. The measure returns incorrect values for the first month of the year. What is the most likely cause?

A.The relationship between tables is single-directional.
B.The date table does not contain a continuous range of dates for the entire year.
C.The date table uses month granularity instead of day.
D.The date table is not marked as a date table.
AnswerB

Correct. DATESYTD needs continuous dates.

Why this answer

Option D is correct because DATESYTD requires a continuous date range; if the date table does not include all dates, the YTD calculation may be incomplete. Option A is wrong because DATESYTD does not require marking as date table. Option B is wrong because relationship direction is not the issue.

Option C is wrong because month granularity is not the problem.

Practice this question →
129
Multi-Selectmedium

Which TWO features can be used to implement row-level security (RLS) in Power BI? (Select TWO.)

Select 2 answers
A.Bookmarks that hide rows
B.Report-level filters
C.Slicer with user principal name
D.Static row-level security in Power BI Desktop
E.DAX filter expressions in roles
AnswersD, E

RLS is configured in Power BI Desktop using roles and DAX.

Why this answer

Options B and D are correct. Option A is wrong because report page filters apply to all users. Option C is wrong because a slicer does not enforce security.

Option E is wrong because a bookmark does not enforce security.

Practice this question →
130
MCQhard

You are troubleshooting a Power BI DirectQuery model that connects to a SQL Server database. A slicer on 'Region' is slow to respond. The region column has 50 distinct values. What is the best optimization?

A.Create an index on the Region column in the source database
B.Increase the cache size in Power BI Desktop
C.Switch the model to Import mode
D.Reduce the number of distinct values in Region
AnswerA

Indexing the column used in slicers improves query performance in DirectQuery.

Why this answer

Option D is correct because in DirectQuery mode, queries are sent to the source; creating an index on the region column will speed up filtering. Option A is wrong because Import mode is not always feasible or desired. Option B is wrong because increasing cache size does not help DirectQuery.

Option C is wrong because reducing cardinality would lose information.

Practice this question →
131
MCQhard

A Power BI report contains a table visual that displays employee names and their total sales. The data model includes an Employee table with columns: EmployeeID, Name, Department, and HireDate. The Sales table has columns: SaleID, EmployeeID, Amount, and SaleDate. The relationship between Employee and Sales is one-to-many. The user wants to see only employees who have made at least one sale. However, the table shows all employees, including those with no sales (blank Amount). What is the most likely reason?

A.The EmployeeID column in the Employee table is hidden.
B.The relationship is many-to-one, not one-to-many.
C.The relationship direction is set to Single from Employee to Sales.
D.There is no visual-level filter to exclude blank values.
AnswerD

To show only employees with sales, a visual-level filter should be applied on the Amount field to exclude blanks.

Why this answer

Option D is correct because the table visual is showing all employees due to the absence of a visual-level filter to exclude blank or zero sales amounts. In Power BI, a one-to-many relationship between Employee and Sales means that employees without sales will still appear in the visual unless explicitly filtered out, as the relationship does not automatically suppress rows from the 'one' side when there are no matching rows on the 'many' side.

Exam trap

The trap here is that candidates assume a one-to-many relationship will automatically hide employees without related sales, but Power BI does not apply implicit row-level security or auto-filtering for missing related records; you must explicitly filter out blank values.

How to eliminate wrong answers

Option A is wrong because hiding the EmployeeID column does not affect the visibility of employees in the table; it only prevents that column from being displayed. Option B is wrong because the relationship is correctly described as one-to-many (one employee can have many sales), and changing it to many-to-one would be incorrect for this data model. Option C is wrong because setting the relationship direction to Single from Employee to Sales is the default and correct direction for a one-to-many relationship; it does not cause all employees to appear regardless of sales.

Practice this question →
132
Multi-Selecthard

Which THREE factors should you consider when designing a Power BI data model for a star schema? (Select three.)

Select 3 answers
A.Use many-to-many relationships between dimensions
B.Fact tables should contain numeric measures and foreign keys
C.Dimension tables should be normalized to reduce redundancy
D.Dimension tables should contain descriptive attributes
E.Relationships should be one-to-many from dimension to fact
AnswersB, D, E

Fact tables store quantitative data and relationships to dimensions.

Why this answer

Option B is correct because fact tables in a star schema store numeric, aggregatable measures (e.g., sales amount, quantity) and foreign keys that reference dimension tables. This structure enables efficient summarization and slicing by dimensions, which is a core requirement for Power BI performance and DAX calculations.

Exam trap

Microsoft often tests the misconception that normalization (Option C) is beneficial for star schemas, when in fact denormalization is preferred to avoid performance penalties from extra join hops in Power BI's query engine.

Practice this question →
133
Multi-Selectmedium

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

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

Correct. Helps keyboard-only users.

Why this answer

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

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

Practice this question →
134
MCQhard

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

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

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

Why this answer

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

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

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

Practice this question →
135
MCQeasy

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

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

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

Why this answer

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

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

Practice this question →
136
Multi-Selectmedium

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

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

Aggregations can pre-summarize data, reducing query volume.

Why this answer

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

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

Practice this question →
137
MCQhard

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

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

CALCULATE applies a filter to the sum.

Why this answer

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

Option D is wrong because it uses RELATED incorrectly.

Practice this question →
138
MCQmedium

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

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

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

Why this answer

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

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

Practice this question →
139
Multi-Selecthard

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

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

RLS restricts access to rows based on filters.

Why this answer

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

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

Practice this question →
140
MCQmedium

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

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

Vertical layout with key metrics at top optimizes mobile reading.

Why this answer

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

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

Practice this question →
141
MCQmedium

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

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

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

Why this answer

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

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

Practice this question →
142
Multi-Selectmedium

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

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

Required for time intelligence functions.

Why this answer

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

Exam trap

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

Practice this question →
143
MCQhard

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

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

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

Why this answer

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

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

Practice this question →
144
MCQeasy

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

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

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

Why this answer

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

Option D is wrong because Key Influencers identifies influencers.

Practice this question →
145
Multi-Selectmedium

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

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

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

Why this answer

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

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

Practice this question →
146
Multi-Selectmedium

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

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

Scheduled refresh ensures data updates automatically.

Why this answer

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

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

Practice this question →
147
Multi-Selecthard

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

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

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

Why this answer

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

Practice this question →
148
MCQeasy

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

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

Correct. Q&A allows natural language queries.

Why this answer

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

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

Practice this question →
149
MCQhard

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

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

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

Why this answer

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

Option D is wrong because ALLNOBLANKROW is similar to ALL.

Practice this question →
150
Multi-Selectmedium

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

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

Reduces load on Power BI.

Why this answer

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

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

Practice this question →
← PreviousPage 2 of 4 · 243 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Visualize and analyze the data questions.

Start 20-question session