Courseiva

CCNA Pl300 Visualize Analyze Questions

75 of 243 questions · Page 1/4 · Pl300 Visualize Analyze topic · Answers revealed

Practice these questionsExam hubAll questions
1
MCQeasy

You are a Power BI report creator for a non-profit organization. You have a semantic model with a 'Donations' fact table (columns: 'DonationID', 'DonorID', 'Date', 'Amount', 'CampaignID') and a 'Donors' dimension table (columns: 'DonorID', 'DonorName', 'City', 'DonorType' (Individual/Corporate)). You need to create a report page that shows a scatter chart with 'Total Donation Amount' on the X-axis and 'Number of Donations' on the Y-axis, with each point representing a donor type. You also want to add a trend line to show the correlation. When you create the scatter chart, only one point appears (for all donors combined), instead of separate points for Individual and Corporate. What is the most likely cause?

A.The relationship between Donations and Donors is inactive.
B.The DonorType field is placed in the 'Values' well instead of the 'Legend' well.
C.The measures are incorrectly defined; they should use SUM and COUNT respectively.
D.The scatter chart does not support multiple categories; you need to use a small multiples chart.
AnswerB

To get separate points for each donor type, DonorType must be in the Legend or Details well.

Why this answer

In a scatter chart, you need to place the category field in the 'Legend' or 'Details' well to get separate points. If you put the field in the 'Values' well, it will be aggregated. Option A is correct.

Option B is incorrect because the measures are fine. Option C is incorrect because relationship is fine. Option D is incorrect because small multiples are for separate charts.

Practice this question →
2
MCQeasy

You have a Power BI report that uses a calculated column to categorize sales as 'High', 'Medium', or 'Low'. You notice the column is not being refreshed when the underlying data changes. What is the most likely reason?

A.The column is defined as a measure instead of a calculated column.
B.Calculated columns are only refreshed when the dataset is refreshed.
C.The DAX syntax for the calculated column is incorrect.
D.The calculated column uses a function that does not support dynamic updates.
AnswerB

Calculated columns are computed during refresh.

Why this answer

Option C is correct because calculated columns are computed during data refresh and are static until the next refresh. Option A is wrong because changes to data do not trigger recalculation of calculated columns. Option B is wrong because the column is not a measure.

Option D is wrong because the column is correctly defined.

Practice this question →
3
Multi-Selecthard

Which TWO of the following are required to use Copilot in Power BI? (Select two.)

Select 2 answers
A.A dataset created from scratch in Power BI Desktop.
B.Power BI Desktop only (service not supported).
C.A report with at least one visual using a custom visual.
D.A Power BI Premium capacity (PPU or Premium Gen2).
E.A Fabric license (F64 or higher).
AnswersD, E

Correct. Premium capacity is required.

Why this answer

Option A is correct because Copilot requires a Premium capacity (Premium Per User or Premium Gen2). Option D is correct because Copilot requires a Fabric license (F64 or higher). Option B is wrong because Copilot is available in service as well.

Option C is wrong because Copilot works with existing datasets. Option E is wrong because Copilot does not require a specific report theme.

Practice this question →
4
MCQhard

You have a Power BI dataset with a fact table and multiple dimension tables. You need to ensure that when a user filters by a dimension, the filter propagates correctly to the fact table. What type of relationship should you use?

A.Many-to-one from fact to dimension.
B.One-to-many from dimension to fact.
C.One-to-one between dimension and fact.
D.Many-to-many between dimension and fact.
AnswerB

This is the standard star schema relationship.

Why this answer

Option A is correct because a one-to-many relationship from dimension to fact is standard for star schemas. Option B is wrong because many-to-many can cause ambiguous filtering. Option C is wrong because one-to-one is rare and not typical.

Option D is wrong because many-to-one from fact to dimension is not correct direction.

Practice this question →
5
MCQmedium

You have the DAX expression shown. It is intended to sum sales for the West region using an inactive relationship. However, the result is incorrect. What is the issue?

A.The USERELATIONSHIP function syntax is incorrect.
B.There may be multiple inactive relationships between Sales and Date, causing ambiguity.
C.The filter on Region should be in a separate CALCULATE.
D.The column names are case-sensitive and don't match.
AnswerB

USERELATIONSHIP needs a single, clear path.

Why this answer

Option B is correct because USERELATIONSHIP activates a relationship, but if there are multiple inactive relationships between the same tables, it might not pick the intended one. Option A is wrong because the syntax is correct. Option C is wrong because the filter is applied correctly.

Option D is wrong because there is no ambiguity in the filter.

Practice this question →
6
MCQeasy

You are building a Power BI report to display sales data. You want to ensure that when users export the report data to Excel, the exported data respects the current filters and slicers applied in the report. What should you do?

A.Apply row-level security (RLS) to the dataset.
B.Set the report to 'Read only' mode.
C.Use the 'Export data' option from the visual's context menu.
D.Use the 'Analyze in Excel' feature.
AnswerC

Export data automatically exports the filtered data as seen in the visual.

Why this answer

Option D is correct because the 'Export data' feature in Power BI respects the current filters and slicers by default. Options A and B are about underlying data permissions, not export filtering. Option C is about preventing export, not filtering behavior.

Practice this question →
7
Multi-Selecteasy

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

Select 2 answers
A.Using the CALENDAR function to generate a date table.
B.Using DAX expressions like SUMMARIZE or ADDCOLUMNS.
C.Using the 'New Table' button under the 'Modeling' tab and writing a Power Query expression.
D.Using M language in Power Query Editor.
E.By right-clicking a table in the Fields pane and selecting 'New calculated table'.
AnswersA, B

Correct. CALENDAR is a DAX function for calculated tables.

Why this answer

Option A is correct because you can use DAX expressions like SUMMARIZE. Option D is correct because you can use CALENDAR to create a date table. Option B is wrong because calculated tables are defined in DAX, not M.

Option C is wrong because Power Query creates tables, but not calculated tables. Option E is wrong because calculated tables are not created in the model view right-click.

Practice this question →
8
MCQeasy

A Power BI report includes a bar chart showing total sales by product category. The report designer wants to add a trend line to the chart to show the overall sales trend over time. Which type of visual should be used instead?

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

A line chart is the standard visual for showing trends over time, and it supports adding a trend line.

Why this answer

A line chart is the correct visual to show a trend over time because it plots data points connected by straight lines, making it easy to see the overall direction and pattern of total sales across a continuous time axis. Bar charts, including stacked variants, are designed for comparing discrete categories, not for displaying continuous trends.

Exam trap

The trap here is that candidates may think a bar chart with a trend line added via the analytics pane is acceptable, but the question asks which visual should be used instead, implying the bar chart is not the optimal choice for showing a trend over time.

How to eliminate wrong answers

Option A is wrong because a stacked bar chart is used to show the composition of a total across categories over time or groups, not to display a single trend line for total sales. Option C is wrong because a scatter chart is used to show the relationship between two numerical variables, not to display a single metric's trend over time. Option D is wrong because a pie chart shows proportions of a whole at a single point in time and cannot represent trends over time.

Practice this question →
9
MCQmedium

You have a Power BI dataset that includes a 'Sales' table and a 'Calendar' table. You need to create a measure that calculates the running total of sales over the last 12 months, ending on the last date in the current filter context. Which DAX function should you use?

A.DATEADD
B.PREVIOUSMONTH
C.DATESBETWEEN
D.DATESINPERIOD
AnswerD

DATESINPERIOD returns a set of dates in a period from the last date going back a specified interval.

Why this answer

Option B is correct because DATESINPERIOD returns a set of dates from the last date in the current context going back 12 months, which is ideal for a rolling 12-month total. Option A is wrong because DATEADD shifts dates but does not automatically give a period. Option C is wrong because DATESBETWEEN requires explicit start and end dates.

Option D is wrong because PREVIOUSMONTH only gives one month.

Practice this question →
10
MCQhard

Refer to the exhibit. The DAX query is executed in DAX Studio. It returns a table with Category and Total Sales. However, the total sales values are incorrect because they include all categories regardless of context. What is the most likely issue?

A.The query does not filter by any specific context, so it returns grand total for each category
B.The SUMMARIZE function syntax is incorrect
C.The relationship between Sales and Product is inactive
D.The GROUP BY column should be from the Sales table
AnswerA

Without additional filters, SUMMARIZE returns all rows with the same grand total.

Why this answer

Option C is correct because SUMMARIZE does not automatically apply filter context from the report; it evaluates in the current filter context of the query. Option A is wrong because the relationship exists. Option B is wrong because the syntax is valid.

Option D is wrong because the grouping is correct.

Practice this question →
11
MCQeasy

You have a Power BI report that uses a DirectQuery connection to a SQL Server database. You need to improve the performance of a visual that shows a large number of data points. What is the best action to take?

A.Increase the number of data points displayed in the visual.
B.Add a slicer to limit the data range.
C.Change the storage mode to Import.
D.Disable the 'cross-filter' interaction between visuals.
AnswerB

Slicers filter the data, reducing the amount retrieved from the source.

Why this answer

Option B is correct because filtering reduces the amount of data queried from the source, improving performance. Option A is wrong because increasing the number of data points worsens performance. Option C is wrong because disabling cross-filtering does not reduce the data volume.

Option D is wrong because changing to Import would require a full data load, which may not be feasible for large data.

Practice this question →
12
MCQhard

You have a Power BI report with a page that contains a matrix visual showing sales by year and quarter. Users want to be able to drill down from year to quarter and then drill up again. The matrix currently shows only year. What should you configure?

A.Add a hierarchy to the matrix columns.
B.Enable the drill-down mode on the matrix visual.
C.Add both Year and Quarter fields to the matrix rows and enable drill-down mode.
D.Add a drillthrough page that filters by year.
AnswerC

Multiple levels in rows with drill-down enabled allows drilling up/down.

Why this answer

Option C is correct because enabling the drill-down mode and adding both Year and Quarter to the matrix rows allows users to drill down and up. Option A is wrong because enabling drill-down without adding Quarter to the rows won't allow drill-down. Option B is wrong because adding a drillthrough page is for navigating to a detail page, not for drilling down in the same visual.

Option D is wrong because adding a hierarchy to the columns would affect column drill-down, not row drill-down.

Practice this question →
13
MCQhard

Refer to the exhibit. You have a DAX measure that calculates customer lifetime value (CLV) as total revenue divided by distinct customer count. When you use this measure in a visual with Product category, you notice that the CLV values are higher than expected. What is the most likely reason?

A.The measure does not filter out returns
B.The measure counts customers per category, but customers who buy multiple categories are counted in each category, reducing the denominator
C.The measure should use COUNTROWS instead of DISTINCTCOUNT
D.The measure is dividing by zero for categories with no customers
AnswerB

This inflates CLV per category.

Why this answer

Option C is correct because DISTINCTCOUNT(Sales[CustomerID]) counts customers who purchased any product in that category, but if a customer bought multiple products in the same category, they are counted once. However, the issue is that the denominator is smaller because customers who bought multiple categories are counted in each category, leading to higher CLV. Option A is wrong because DIVIDE handles zeros.

Option B is wrong because the measure is correct syntactically. Option D is wrong because the measure doesn't consider customer-level profitability.

Practice this question →
14
MCQhard

You are designing a Power BI report for executives. The dataset contains sales data with a many-to-many relationship between 'Sales' and 'Product' tables via a 'ProductSales' bridge table. Users complain that some measures return incorrect totals when using multiple related fields. What is the most likely cause?

A.The many-to-many relationship is causing ambiguity in measure evaluation
B.Data type mismatches between key columns
C.The cross-filter direction is set to single instead of both
D.Row-level security (RLS) is filtering out some rows
AnswerA

Many-to-many relationships can lead to ambiguous filter propagation, causing incorrect totals.

Why this answer

Option D is correct because many-to-many relationships in Power BI can cause ambiguity in measure evaluation, leading to incorrect totals. Option A is wrong because row-level security is not directly related to many-to-many relationships. Option B is wrong because cross-filter direction does not typically cause this issue.

Option C is wrong because data types are not the root cause.

Practice this question →
15
MCQmedium

A data analyst creates a Power BI report that uses a date table with a continuous date range. They want to calculate the running total of sales over the last 12 months, ending on the last date in the current filter context. Which DAX expression should they use?

A.CALCULATE(SUM(Sales[Amount]), DATESBETWEEN('Date'[Date], MAX('Date'[Date]) - 365, MAX('Date'[Date])))
B.CALCULATE(SUM(Sales[Amount]), DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -12, MONTH))
C.TOTALMTD(SUM(Sales[Amount]), 'Date'[Date])
D.CALCULATE(SUM(Sales[Amount]), DATESYTD('Date'[Date]))
AnswerA

DATESBETWEEN with MAX date minus 365 days approximates the last 12 months, but this may not account for leap years; however, among the options, this is the most appropriate for a running 12-month total. A more precise method would use DATESINPERIOD, but that is not listed.

Why this answer

Option A is correct because it uses DATESBETWEEN to define a custom date range from 365 days before the last date in the current filter context (MAX('Date'[Date])) up to that last date, effectively creating a rolling 12-month window. This approach works with a continuous date table and respects the filter context, ensuring the running total is calculated dynamically based on the latest visible date.

Exam trap

The trap here is that candidates often choose DATESINPERIOD (Option B) because it seems intuitive for monthly periods, but they overlook that it can include extra days due to month boundaries, whereas DATESBETWEEN with a 365-day offset provides a precise 12-month window.

How to eliminate wrong answers

Option B is wrong because DATESINPERIOD with -12 and MONTH shifts the window back 12 months from the end date, but it includes the entire month of the start date, which can result in a 13-month window if the last date is not the end of a month, thus not guaranteeing exactly 12 months. Option C is wrong because TOTALMTD calculates a month-to-date total, not a running total over the last 12 months. Option D is wrong because DATESYTD calculates a year-to-date total from the start of the calendar year, not a rolling 12-month window ending on the last date in the filter context.

Practice this question →
16
MCQmedium

A Power BI developer writes the Power Query M code shown in the exhibit. The code runs successfully but returns an error when the user selects a year from a slicer in the report. The error states: 'Expression.Error: The key did not match any rows in the table.' Which is the most likely cause?

A.The table name Sales does not exist in the database
B.The code hardcodes the year 2021, but the slicer passes a different year, causing the M code to fail when the source is queried
C.The ProductID column has duplicate values
D.The data type of the Year column is text instead of number
AnswerB

The M code is static and doesn't respond to slicer changes, leading to an error if the source doesn't have that year.

Why this answer

Option B is correct because the error 'The key did not match any rows in the table' occurs when a Power Query M query uses a hardcoded value (e.g., 2021) in a filter or lookup step, but the slicer passes a different year value to the report. When the slicer changes the parameter, the M code tries to retrieve data for that year, but the hardcoded key does not exist in the source table, causing the key lookup to fail. This is a classic parameterization issue where the M code should use a dynamic reference to the slicer value instead of a literal.

Exam trap

The trap here is that candidates often confuse a key-not-found error with a data type mismatch or missing table error, but the specific phrasing 'key did not match any rows' points to a lookup or filter operation where the key value is not present in the source, not a structural or type issue.

How to eliminate wrong answers

Option A is wrong because if the table name Sales did not exist in the database, the error would be 'DataSource.Error: The table 'Sales' does not exist' or a similar connection error, not a key matching error. Option C is wrong because duplicate values in the ProductID column would cause a different error, such as 'Expression.Error: Duplicate keys' when using Table.Join or Merge operations, not a key-not-found error. Option D is wrong because a data type mismatch between the Year column (text) and the slicer value (number) would cause a type conversion error or filter failure, not a key matching error; the error message specifically mentions 'key did not match any rows', which indicates a lookup operation on a key column.

Practice this question →
17
MCQeasy

You have a Power BI report that shows sales by region. The map visual displays regions with incorrect boundaries. What is the most likely cause?

A.The map visual is not the best choice for the data.
B.The data source is not refreshed.
C.The map labels are overlapping.
D.Bing Maps geocoding inaccuracies.
AnswerD

Map visuals rely on Bing Maps, which can have boundary errors.

Why this answer

Option B is correct because map visuals in Power BI use Bing Maps, which may have inaccurate or outdated geographic data. Option A is wrong because data source refresh does not affect map boundaries. Option C is wrong because the issue is not related to visual type selection.

Option D is wrong because map labels do not affect boundaries.

Practice this question →
18
Multi-Selectmedium

Which THREE actions can you take to improve the performance of a slow Power BI report that uses multiple visuals on a single page?

Select 3 answers
A.Increase the frequency of data refreshes to reduce data latency.
B.Use the Performance Analyzer to identify and optimize the slowest visuals.
C.Add more calculated measures to precompute aggregations.
D.Reduce the number of fields used in each visual to only those necessary.
E.Reduce the number of visual interactions by disabling cross-filtering between unrelated visuals.
AnswersB, D, E

Helps pinpoint bottlenecks.

Why this answer

Options A, C, and E are correct. Reducing query reduction by turning off cross-filtering interactions (A) reduces query load. Reducing the number of fields in a visual (C) reduces data retrieval.

Using performance analyzer to identify slow visuals (E) is a best practice. Option B is wrong because increasing data refresh frequency does not improve report rendering performance. Option D is wrong because adding more measures increases calculation load.

Practice this question →
19
MCQhard

You have a Power BI report with the DAX measure shown in the exhibit. Users report that the measure returns blank for some months even though sales data exists for both current and previous years. What is the most likely cause?

A.The measure uses SUM instead of SUMX.
B.The 'Date' table is not marked as a date table or is missing dates.
C.The DIVIDE function is incorrectly handling division by zero.
D.The relationship between 'Sales' and 'Date' is set to cross-filter direction single.
AnswerB

SAMEPERIODLASTYEAR requires a proper date table with continuous dates.

Why this answer

Option A is correct because SAMEPERIODLASTYEAR requires a contiguous date table marked as a date table; if the date table does not cover all dates, it may return blank. Option B is wrong because DIVIDE handles division by zero gracefully. Option C is wrong because the measure uses SUM which aggregates correctly.

Option D is wrong because relationship direction affects filtering but not SAMEPERIODLASTYEAR's ability to shift dates.

Practice this question →
20
MCQhard

You are a Power BI analyst for a multinational retail company. The company's sales data is stored in an Azure SQL Database with tables: Sales (SalesID, Date, ProductID, Quantity, Amount), Products (ProductID, ProductName, Category), and Calendar (Date, Year, Month, Day). The Sales table contains 500 million rows. You are creating a Power BI report to analyze daily sales trends over the past 5 years. The report must allow users to drill from year to month to day using a hierarchy. The performance of the report is critical; users expect visuals to load within 5 seconds. The current model imports all tables without any optimization, and the date hierarchy visual takes over 30 seconds to render. You need to redesign the data model to meet the performance requirement. What should you do?

A.Create an aggregated table in Power Query that groups sales by date, and create a date hierarchy in the Calendar table.
B.Add calculated columns for Year, Month, and Day in the Sales table to avoid using the Calendar table.
C.Switch the import mode to DirectQuery to avoid loading all data into memory.
D.Implement incremental refresh policy on the Sales table to reduce the amount of data loaded.
AnswerA

Pre-aggregation reduces rows and improves query speed; hierarchy enables drill-down.

Why this answer

Option B is correct because reducing the granularity of the Sales table by pre-aggregating daily sales reduces the number of rows drastically, improving query performance. Creating a date hierarchy in the Calendar table allows drill-down. Option A is wrong because DirectQuery may still be slow over 500 million rows without aggregation.

Option C is wrong because incremental refresh only affects data load time, not query performance. Option D is wrong because calculated columns add to model size and do not help with aggregation.

Practice this question →
21
MCQmedium

Your Power BI report uses a custom visual that is not rendering in the Power BI service. The visual works correctly in Power BI Desktop. What is the most likely cause?

A.The custom visual is not certified by Microsoft
B.The data source is not supported in the service
C.The visual was not imported into the report
D.The browser needs to be refreshed
AnswerA

Admin settings may block non-certified custom visuals.

Why this answer

Custom visuals from AppSource require approval; if not certified, they may be blocked by admin policies. The data source is irrelevant, and all visuals need to be loaded. Refreshing the browser rarely helps.

Practice this question →
22
MCQmedium

You are a Power BI developer for a retail company. You have a semantic model that includes a 'Sales' fact table with columns: 'Date', 'ProductID', 'StoreID', 'Quantity', 'UnitPrice'. The 'Product' dimension table includes 'ProductID', 'ProductName', 'Category', 'SubCategory'. The 'Store' dimension table includes 'StoreID', 'StoreName', 'Region', 'District'. You need to create a report page that allows users to analyze sales performance by product category and store region. The report must include a matrix visual with: - Rows: Product Category - Columns: Store Region - Values: Total Sales Amount (Quantity * UnitPrice) Additionally, users must be able to drill down from category to subcategory in the rows, and from region to district in the columns. You also need to ensure that when a user selects a specific store region, the matrix only shows data for that region and its districts. You have created the measures and the matrix visual. However, when you test the drill down, the hierarchy does not work as expected: clicking the expand icon on a category does not show subcategories. What is the most likely cause?

A.The Total Sales measure is incorrectly defined, causing blank values for subcategories.
B.A slicer for Store Region is interfering with the matrix drill down behavior.
C.The matrix rows do not have a hierarchy defined; Category and SubCategory are separate fields.
D.The relationship between Sales and Product is set to single direction, preventing drill through.
AnswerC

To enable drill down, you need to create a hierarchy (Category > SubCategory) in the Product table.

Why this answer

For drill down to work in a matrix, the fields must be in a hierarchy. The correct approach is to use a hierarchy in the rows and columns. If the fields are simply placed as separate rows/columns, drill down won't work.

Option A is correct because without a hierarchy, the expand button will not drill down. Option B is incorrect because the measure is defined correctly. Option C is incorrect because cross-filter direction doesn't affect drill down.

Option D is incorrect because slicer interaction is not the issue.

Practice this question →
23
Multi-Selecthard

Which THREE features can be used to create custom narratives in Power BI? (Choose three.)

Select 3 answers
A.Calculated columns
B.DAX measures
C.Custom visuals from AppSource
D.Smart Narratives visual
E.Bookmarks
AnswersA, B, C

Columns can provide context for narratives.

Why this answer

Calculated columns are correct because they allow you to create custom text fields by combining or transforming existing data using DAX formulas, which can then be used in visuals or as part of a narrative. For example, you can concatenate product names and sales figures into a single string that serves as a custom narrative in a table or card visual.

Exam trap

The trap here is that candidates often confuse the Smart Narratives visual (which is automated) with a feature for creating custom narratives, or they mistakenly think bookmarks can contain narrative text, when in fact bookmarks only store report state and require separate visuals to display text.

Practice this question →
24
MCQmedium

You are building a Power BI report for the HR department. You have a table 'Employees' with columns: EmployeeID, Name, Department, HireDate, Salary, and ManagerID. You need to create a hierarchy for organizational chart that allows users to drill from CEO down to individual employees. The hierarchy should be dynamic based on the ManagerID. Which approach should you use? A. Create a parent-child hierarchy using DAX PATH and PATHITEM functions. B. Create a calculated column that concatenates all manager levels. C. Use the built-in drill-down feature with a matrix visual. D. Create separate tables for each level and merge them. Which option is the best?

A.Create separate tables for each level and merge them
B.Use the built-in drill-down feature with a matrix visual
C.Create a calculated column that concatenates all manager levels
D.Create a parent-child hierarchy using DAX PATH and PATHITEM functions
AnswerD

This builds a dynamic hierarchy from ManagerID.

Why this answer

Option A is correct because Power BI supports parent-child hierarchies using DAX functions like PATH and PATHITEM to create a hierarchy from a self-referencing table. Option B is wrong because concatenation does not create a hierarchy. Option C is wrong because drill-down in a matrix requires explicit hierarchy levels.

Option D is wrong because creating separate tables is complex and not dynamic.

Practice this question →
25
MCQeasy

You are designing a Power BI report for executive leadership. The report must display key performance indicators (KPIs) with current values and trend arrows. Which visual type should you use?

A.Table visual
B.Card visual
C.KPI visual
D.Gauge visual
AnswerC

KPI visual displays value, trend, and goal.

Why this answer

Option C is correct because the KPI visual is specifically designed to show a current value, a status indicator (like trend arrow), and a goal. Option A is wrong because a card visual only shows a single value without trend. Option B is wrong because a gauge visual shows progress toward a goal but not a trend arrow.

Option D is wrong because a table visual is for detailed data, not KPIs.

Practice this question →
26
MCQhard

You have the DAX measure shown. The measure returns blank for some periods even though there are sales in the current period. What is the most likely cause?

A.The Date table does not contain all dates from the previous year.
B.The measure is not properly filtered by the current context.
C.The variable CurrentSales is not evaluated correctly.
D.The DIVIDE function returns blank when denominator is zero.
AnswerA

SAMEPERIODLASTYEAR requires a full date range.

Why this answer

Option B is correct because SAMEPERIODLASTYEAR requires a contiguous date table to work correctly; if dates are missing, it returns blank. Option A is wrong because the measure does not have filter context issues by default. Option C is wrong because DIVIDE handles division by zero and returns blank, but the issue is that PreviousSales is blank.

Option D is wrong because the measure is not using a variable incorrectly.

Practice this question →
27
Multi-Selecthard

Which THREE of the following are valid considerations for choosing between Import and DirectQuery storage modes? (Select three.)

Select 3 answers
A.Import mode provides faster query performance for aggregated data
B.DirectQuery mode supports all DAX functions without limitations
C.Import mode has a maximum data size limit (e.g., 1 GB per dataset in shared capacity)
D.DirectQuery mode cannot query large data sources
E.DirectQuery mode is suitable when real-time data is required
AnswersA, C, E

Data is preloaded into memory.

Why this answer

Option A is correct: Import mode has size limits. Option C is correct: DirectQuery provides real-time access. Option D is correct: Import mode offers faster performance.

Option B is wrong: DirectQuery can query large data, but Import can also handle large data via incremental refresh. Option E is wrong: DirectQuery does not support all DAX functions, but the statement is too absolute.

Practice this question →
28
Multi-Selecteasy

You are building a Power BI report that uses a DirectQuery source. Which TWO of the following actions can improve report performance?

Select 2 answers
A.Add calculated columns to the model.
B.Disable the 'Reduce queries sent to the source' option.
C.Reduce the number of visuals on each report page.
D.Use complex DAX measures with many nested functions.
E.Create summary tables in the data source to pre-aggregate data.
AnswersC, E

Fewer visuals mean fewer queries.

Why this answer

Options A and D are correct. A: Reducing the number of visuals decreases the number of queries sent to the source. D: Creating aggregations in the source can speed up query responses.

Option B is wrong because using many calculated columns increases query complexity. Option C is wrong because disabling query reduction would increase the number of queries.

Practice this question →
29
MCQmedium

Refer to the exhibit. This JSON defines a row-level security (RLS) role in Power BI. A user assigned to the 'Sales Manager' role runs a report that shows total sales across all regions. The sum displayed is lower than expected. What is the most likely reason?

A.The role name 'Sales Manager' does not match the user's job title
B.The RLS filter restricts data to the West region only
C.The user is not a member of the role
D.The FILTER function syntax is incorrect and causes an error
AnswerB

The filter limits the rows visible to the user, so the sum reflects only West region.

Why this answer

Option B is correct because the RLS role filters the Sales table to only show rows where Region is 'West', so the total sum only includes West region sales. Option A is wrong because the filter is applied regardless of the role's name. Option C is wrong because the sum is not a bug; it's the intended behavior.

Option D is wrong because the user is in the role, so RLS is enforced.

Practice this question →
30
MCQeasy

You have a report that contains a map visual showing sales by city. Several cities are missing from the map because the location data is ambiguous. What should you do to resolve this?

A.Add latitude and longitude fields to the model.
B.Create a calculated column that combines city and country to provide unambiguous location.
C.Replace the map visual with a table.
D.Adjust the bubble size to make missing points visible.
AnswerB

Combining fields resolves ambiguity in location mapping.

Why this answer

Option A is correct because creating a custom location field with city and country or state ensures accurate mapping. Option B is wrong because latitude/longitude would work but is not the simplest fix. Option C is wrong because bubble size is for value, not location accuracy.

Option D is wrong because the map visual relies on location fields.

Practice this question →
31
MCQeasy

You are building a Power BI report that shows sales by region. You want to use a visual that displays hierarchical data, such as region -> country -> city, and allows drilling up and down. Which visual should you use?

A.Scatter plot
B.Stacked bar chart
C.Card
D.Decomposition tree
AnswerD

Correct. It allows hierarchical drill-down.

Why this answer

Option A is correct because the decomposition tree visual is designed for hierarchical drilling and root cause analysis. Option B is wrong because a stacked bar chart does not support hierarchical drill-down natively. Option C is wrong because a scatter plot shows relationships between two numeric variables.

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

Practice this question →
32
MCQhard

You have a Power BI report with a date table and a sales table. The above DAX measure is used in a visual that also shows 'Date[Year]' on the axis. What does this measure return?

A.The sum of sales for all years.
B.The sum of sales for the current year on the axis.
C.The sum of sales for the maximum year present in the Date table, regardless of the visual's year filter.
D.A blank because the measure conflicts with the visual filter.
AnswerC

ALL removes year filter, and MAX(Date[Year]) returns the maximum year in the whole table.

Why this answer

Option C is correct because the FILTER with ALL(Date) removes all filters from the Date table, then keeps only rows where Year equals the maximum year in the current context (which, because of the ALL, is the maximum year in the entire Date table regardless of slicers). Since the visual is filtered to a specific year by the axis, the measure shows the total for the max year overall, not the current year. Option A is wrong because it would require ALLSELECTED or no ALL.

Option B is wrong because it would be a simple SUM. Option D is wrong because the measure returns a sum, not a blank.

Practice this question →
33
MCQeasy

You have a Power BI report that uses a live connection to an Azure Analysis Services (AAS) tabular model. You need to add a new measure to the report. What should you do?

A.Use DAX to create a new calculated column in Power BI Desktop.
B.Modify the AAS model directly from Power BI Desktop.
C.Add the measure to the AAS tabular model using SQL Server Management Studio (SSMS) or Visual Studio.
D.Create a new calculated table in Power BI Desktop.
AnswerC

In a live connection, all measures must originate from the source model.

Why this answer

Option A is correct because with a live connection, you cannot create measures in Power BI Desktop; they must be defined in the source model. Option B is wrong because measures cannot be created in the report layer with live connection. Option C is wrong because calculated columns also cannot be added.

Option D is wrong because the AAS model must be modified externally.

Practice this question →
34
Multi-Selecthard

Which THREE steps are required to set up row-level security (RLS) in Power BI Desktop?

Select 3 answers
A.Use the View as Roles feature to test the security filters.
B.After publishing, assign users or groups to roles in the dataset settings.
C.Install and configure an on-premises data gateway.
D.Create roles and define DAX filter expressions in the Manage Roles dialog.
E.Publish the report to the Power BI service before defining roles.
AnswersA, B, D

Validation step to ensure filters work correctly.

Why this answer

Options A, C, and E are correct. You must create roles and define DAX filters (A), then validate the roles using the 'View as' feature (C), and after publishing, assign users to roles in the Power BI service (E). Option B is wrong because RLS is defined in Desktop, not the service.

Option D is wrong because RLS does not require a gateway for definition.

Practice this question →
35
MCQeasy

You need to create a measure that calculates the year-over-year growth percentage for sales. Which DAX function combination is most appropriate?

A.CALCULATE with DATEADD and SUM
B.CALCULATE with SAMEPERIODLASTYEAR and DIVIDE
C.TOTALYTD and DIVIDE
D.PREVIOUSMONTH and SUM
AnswerB

SAMEPERIODLASTYEAR shifts the date context back one year, and DIVIDE computes the percentage change.

Why this answer

Option C is correct because CALCULATE with SAMEPERIODLASTYEAR calculates the previous year's sales, and the DIVIDE function handles division safely. Option A is wrong because TOTALYTD is for year-to-date, not year-over-year. Option B is wrong because DATEADD is used but not with SAMEPERIODLASTYEAR.

Option D is wrong because PREVIOUSMONTH is for month-over-month.

Practice this question →
36
MCQmedium

You have a report page that shows sales by product category. You want to allow users to click on a category and see a detailed breakdown of products within that category on a separate page. Which Power BI feature should you implement?

A.Add a slicer for product category
B.Drillthrough page with category as a drillthrough field
C.Bookmark that shows the detail page
D.Report page tooltips
AnswerB

Drillthrough passes the selected category to a detail page.

Why this answer

Option B is correct because drillthrough allows passing a filter to another page. Option A is wrong because tooltips show on hover, not click. Option C is wrong because a slicer filters the same page.

Option D is wrong because bookmarks navigate to a state, not filter another page.

Practice this question →
37
MCQhard

You are a Power BI analyst for a retail company. You have a dataset containing a 'Sales' table with columns: SalesDate, StoreID, ProductID, Quantity, UnitPrice, and Discount. You also have a 'Calendar' table marked as a date table with a continuous date range from 2018 to 2023. You need to create a measure that calculates the running total of sales amount (Quantity * (UnitPrice - Discount)) over the last 12 months, but only for products that have been sold in at least 10 different stores in the current month. The measure should be dynamic based on the current filter context (e.g., month, year). The report will be used by regional managers to monitor product performance. You have already created a base measure: TotalSales = SUMX(Sales, Sales[Quantity] * (Sales[UnitPrice] - Sales[Discount])). Which DAX measure should you create?

A.RunningTotal = CALCULATE([TotalSales], DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date]), -12, MONTH), FILTER(ALL(Sales[ProductID]), CALCULATE(DISTINCTCOUNT(Sales[StoreID]), DATESMTD('Calendar'[Date])) >= 10))
B.RunningTotal = CALCULATE([TotalSales], DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date]), -12, MONTH), VALUES(Sales[ProductID]))
C.RunningTotal = CALCULATE([TotalSales], DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date]), -12, MONTH), ALL('Calendar'))
D.RunningTotal = CALCULATE([TotalSales], DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date]), -12, MONTH), FILTER(ALL(Sales[ProductID]), COUNTROWS(SUMMARIZE(Sales, Sales[StoreID])) >= 10))
AnswerA

This correctly filters products with at least 10 stores in the current month (using DATESMTD) and then calculates the running total over the last 12 months.

Why this answer

Option A is correct because it uses CALCULATE with DATESINPERIOD to compute the running total over the last 12 months, and then applies a filter that restricts the calculation to only those products that have been sold in at least 10 distinct stores in the current month (via DATESMTD). The use of ALL(Sales[ProductID]) inside the filter ensures that the product-level filtering is applied over all products, while the inner CALCULATE with DATESMTD evaluates the store count condition within the current month context, making the measure dynamic based on the filter context.

Exam trap

The trap here is that candidates often forget to use ALL() to expand the product context and instead use VALUES(), which restricts the filter to only products already in the current selection, or they fail to nest a separate CALCULATE with DATESMTD to evaluate the store count condition specifically for the current month.

How to eliminate wrong answers

Option B is wrong because it uses VALUES(Sales[ProductID]) which only returns products that are already in the current filter context, not all products; it does not enforce the condition that products must be sold in at least 10 stores in the current month. Option C is wrong because it uses ALL('Calendar') which removes all date filters, making the running total ignore the 12-month window and instead compute over the entire date range, breaking the requirement. Option D is wrong because COUNTROWS(SUMMARIZE(Sales, Sales[StoreID])) counts all stores in the entire dataset for each product, not just the current month, and does not use DISTINCTCOUNT, so it may overcount stores and fails to apply the monthly condition correctly.

Practice this question →
38
MCQeasy

You want to create a report that allows users to select a product category and see the top 5 products by sales within that category. Which approach should you use?

A.Use a waterfall chart with category on the breakdown axis.
B.Add a slicer for category and apply a Top N filter on product to the visual.
C.Use a measure to rank products and filter visual to top 5.
D.Create a calculated column for rank and filter to top 5.
AnswerB

Top N filter combined with slicer provides dynamic ranking.

Why this answer

Option A is correct because using the Top N filter with a slicer for category allows dynamic filtering. Option B is wrong because a static rank would not respond to slicer selection. Option C is wrong because a waterfall chart does not support Top N.

Option D is wrong because calculated columns cannot be dynamic based on slicer selection.

Practice this question →
39
Multi-Selecteasy

You are creating a Power BI report to analyze customer churn. You have a table with Customer ID, Churn Date, and other attributes. You want to create a measure that calculates the number of customers who churned in the last 30 days. Which THREE components do you need?

Select 3 answers
A.A measure using CALCULATE, COUNTROWS, and DATESINPERIOD
B.A calculated column for 30-day flag
C.A relationship between date table and Churn Date
D.A separate date table marked as date table
E.A disconnected table with date range
AnswersA, C, D

Standard approach for dynamic period calculation.

Why this answer

Options A, B, and E are correct: a date table (A) for time intelligence, a relationship (B) between date table and churn date, and a CALCULATE measure (E) with appropriate filter. Option C is incorrect because a calculated column is not required. Option D is incorrect because a disconnected table is not necessary.

Practice this question →
40
MCQhard

Refer to the exhibit. You have a JSON definition of a Power BI dataset. You need to ensure that when a user filters by Product[Category], the filters propagate to Sales table. What is the current cross-filtering behavior?

A.Filter from Product flows to Sales
B.Filter from Sales flows to Product
C.No filter propagation occurs
D.Filter propagation is bidirectional
AnswerA

oneDirection means filter from the one side (Product) to the many side (Sales).

Why this answer

Option A is correct because 'oneDirection' means filter flows from the 'one' side (Product) to the 'many' side (Sales). Option B is wrong because 'bothDirections' is not set. Option C is wrong because the filter does propagate.

Option D is wrong because the behavior is defined.

Practice this question →
41
Drag & Dropmedium

Drag and drop the steps to configure a scheduled refresh for a dataset in the Power BI service 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

Scheduled refresh is configured in the dataset settings, enabling automatic updates at specified intervals.

Practice this question →
42
MCQhard

You see the above XMLA response when querying a Power BI dataset. You want to create a measure that calculates the difference between current sales and previous year sales, but you want to use the calculation group to avoid writing multiple measures. Which measure expression should you use?

A.CALCULATE([Total Sales], 'Time Intelligence'[Name] = "Current") - CALCULATE([Total Sales], 'Time Intelligence'[Name] = "PY")
B.SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]))
C.SELECTEDMEASURE() - CALCULATE(SELECTEDMEASURE(), 'Time Intelligence'[Name] = "PY")
D.SUM(Sales[Amount]) - [Sales YoY]
AnswerC

This uses the calculation group to dynamically compute the difference.

Why this answer

With a calculation group, you can define a measure that references the calculation items. The expression 'SELECTEDMEASURE() - CALCULATE(SELECTEDMEASURE(), 'Time Intelligence'[Name] = "PY")' will compute the difference between the current measure (e.g., Total Sales) and its previous year version.

Practice this question →
43
MCQmedium

You need to design a report that allows users to drill from a yearly sales summary to quarterly details, then to monthly details, while maintaining the ability to go back. Which visual interaction should you enable?

A.Bookmarks
B.Tooltips
C.Drill-down
D.Drillthrough
AnswerC

Drill-down allows users to expand hierarchical levels with a back button.

Why this answer

Option B is correct because drill-down is the built-in Power BI feature that allows users to drill into hierarchical levels and use the back button to navigate up. Option A is wrong because drillthrough navigates to a separate page, not drill within the same visual hierarchy. Option C is wrong because tooltips provide additional detail on hover, not drill-down.

Option D is wrong because bookmarks capture a specific state, not hierarchical drill.

Practice this question →
44
Multi-Selecthard

Which THREE actions can help optimize a Power BI report's performance? (Select THREE.)

Select 3 answers
A.Use calculated columns instead of measures for complex aggregations.
B.Reduce the number of visuals on a single page.
C.Import all columns from source tables to avoid missing data.
D.Use aggregations in the data source (e.g., pre-summarize tables).
E.Disable cross-highlighting and cross-filtering where not needed.
AnswersB, D, E

Fewer visuals reduce rendering load.

Why this answer

Options A, C, and D are correct. Option B is wrong because using many calculated columns can hurt performance. Option E is wrong because importing all columns increases model size and refresh time; only import needed columns.

Practice this question →
45
Multi-Selectmedium

You need to create a Power BI report that allows users to analyze sales data by multiple dimensions including date, product, and region. Which THREE features should you use to provide a good user experience?

Select 3 answers
A.Add slicers for date, product, and region.
B.Create bookmarks to switch between different report views.
C.Set up drill-through pages for detailed analysis.
D.Disable cross-filtering between visuals.
E.Use only default tooltips.
AnswersA, B, C

Slicers provide intuitive filtering.

Why this answer

Options A, C, and E are correct. A: Slicers allow users to filter data interactively. C: Drill-through enables navigation to detail pages.

E: Bookmarks can save and switch between views. Option B is wrong because disabling cross-filtering limits interactivity. Option D is wrong because tooltips are for additional info, not primary navigation.

Practice this question →
46
MCQeasy

You want to create a custom visual that is not available in the default Power BI visuals pane. What should you do?

A.Write the visual in Python and add it to the report.
B.Use the R script visual to create the visual.
C.Download the visual from AppSource and import it.
D.Create a custom visual using Power BI Desktop's built-in editor.
AnswerC

AppSource is the official marketplace for Power BI visuals.

Why this answer

Custom visuals can be imported from AppSource or a file. The option to get from AppSource is standard.

Practice this question →
47
Multi-Selectmedium

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

Select 2 answers
A.DATATABLE(...)
B.CREATE TABLE FROM (SELECT ...)
C.SUMMARIZE(Sales, Product[Color], "Total", SUM(Sales[Amount]))
D.TABLE.COLUMNS()
E.CALENDARAUTO()
AnswersC, E

SUMMARIZE creates a summarized table.

Why this answer

Option C is correct because SUMMARIZE is a DAX function that creates a calculated table by grouping rows from a table (Sales) and adding a new column with an aggregate expression (SUM(Sales[Amount])). Option E is correct because CALENDARAUTO() returns a single-column table of dates, which is a valid calculated table definition in Power BI.

Exam trap

The trap here is that candidates confuse DAX table functions with SQL syntax or non-existent functions, and they may overlook that CALENDARAUTO() is a valid calculated table function, while DATATABLE is for static tables, not dynamic calculated tables.

Practice this question →
48
MCQeasy

You have a Power BI report that shows sales by region. Users report that the map visual is not displaying data for some countries. What is the most likely cause?

A.The geographic data is not categorized correctly in the Data pane.
B.The report page filter is excluding those countries.
C.The map visual is limited to 30 data points.
D.The map visual only supports US addresses.
AnswerA

Correct categorization is required for Bing Maps to recognize locations.

Why this answer

The most likely cause is that the geographic data is not categorized correctly in the Data pane. Power BI map visuals rely on the data category (e.g., Country, State, City) assigned to each field to correctly geocode and plot locations. If a field containing country names is left as 'Text' or 'Uncategorized', Power BI may fail to recognize the values as geographic entities, resulting in missing data points on the map.

Exam trap

The trap here is that candidates often assume a filter or data limit is the cause, but the core issue is the data category metadata, which is a subtle but critical setting in Power BI for map visuals.

How to eliminate wrong answers

Option B is wrong because a report page filter would affect all visuals on the page, not just the map, and users would typically notice missing data across the report, not solely on the map. Option C is wrong because the map visual (Bing Maps) does not have a hard limit of 30 data points; the limit applies to scatter charts and other visuals, not to map visuals. Option D is wrong because Power BI map visuals support addresses globally via Bing Maps geocoding, not just US addresses.

Practice this question →
49
MCQhard

Refer to the exhibit. You run this DAX query but the YoY Growth column returns blank for all rows. What is the most likely cause?

A.Local measures cannot be referenced by other local measures in SUMMARIZECOLUMNS
B.The subtraction operator does not work with measures
C.SAMEPERIODLASTYEAR requires a continuous date range
D.The 'Date' table has no relationship with Sales
AnswerA

This is a known limitation; define measures in the model or use CALCULATE.

Why this answer

The 'Total Sales' measure is defined locally (DEFINE), but SUMMARIZECOLUMNS may not evaluate local measures in the same context. The measure reference [Total Sales] inside SUMMARIZECOLUMNS might not resolve correctly. Moving the measure definition to the model would fix it.

Practice this question →
50
MCQhard

You are a Power BI administrator for a large enterprise. You have a shared dataset that is used by multiple reports. The dataset contains sensitive financial data. You need to implement row-level security (RLS) so that managers can only see data for their own region. The dataset has a table 'Sales' with RegionID, and a table 'Managers' with ManagerID, ManagerName, and RegionID. You need to create an RLS role that filters the Sales table based on the logged-in user's region. You have the following options: A. Create a role with a DAX filter: 'Sales[RegionID] = USERPRINCIPALNAME()'. B. Create a role with a DAX filter: 'Sales[RegionID] = LOOKUPVALUE(Managers[RegionID], Managers[ManagerName], USERPRINCIPALNAME())'. C. Create a role with a DAX filter: 'Sales[RegionID] = USERNAME()'. D. Create a role with a static filter for each region. Which option should you choose?

A.Create a role with a DAX filter: 'Sales[RegionID] = USERNAME()'
B.Create a role with a DAX filter: 'Sales[RegionID] = USERPRINCIPALNAME()'
C.Create a role with a static filter for each region
D.Create a role with a DAX filter: 'Sales[RegionID] = LOOKUPVALUE(Managers[RegionID], Managers[ManagerName], USERPRINCIPALNAME())'
AnswerD

This dynamically maps the user to their region.

Why this answer

Option B is correct because it uses LOOKUPVALUE to find the region for the logged-in user (ManagerName) from the Managers table, and then filters Sales accordingly. Option A is wrong because RegionID is not a user principal name. Option C is wrong because USERNAME() returns the user's login name, not region.

Option D is wrong because static filters would require multiple roles and manual maintenance.

Practice this question →
51
MCQmedium

You have a Power BI report that uses a composite model with a DirectQuery source (SQL Server) and a local imported table. The report includes a measure that calculates sales growth by comparing current year to previous year. Users report that the measure returns blank for months with no data in the current year. How should you modify the measure to show 0% growth instead of blank?

A.Use ISBLANK(CurrentYear) in an IF statement.
B.Add a condition to check if PreviousYear = 0.
C.Use DIVIDE with an alternate result of 0.
D.Use COALESCE(CurrentYear, 0) in the measure.
AnswerD

COALESCE replaces blank with 0, allowing DIVIDE to compute 0% growth.

Why this answer

Option B is correct because COALESCE replaces blank with the next non-blank value, so if CurrentYear is blank but PreviousYear has data, it returns 0. Option A is wrong because ISBLANK would still return blank if CurrentYear is blank. Option C is wrong because it only handles division by zero.

Option D is wrong because it replaces blank with 0 only for the denominator.

Practice this question →
52
MCQmedium

You are designing a Power BI report for a sales team. They need to see their individual performance compared to team averages. You have a table with columns: Salesperson, Region, SalesAmount. Which visual best allows each salesperson to see their own value alongside the average?

A.Clustered bar chart with a measure for average
B.Waterfall chart
C.Table with conditional formatting
D.Combo chart (clustered column and line) with salesperson bars and average line
AnswerD

Allows easy comparison of individual to average.

Why this answer

Option B is correct because a combo chart can show individual bars and a line for average. Option A is wrong because a table with conditional formatting doesn't show average easily. Option C is wrong because a clustered bar chart can show average but not as clearly.

Option D is wrong because a waterfall chart is for cumulative changes.

Practice this question →
53
MCQeasy

You have a Power BI report that uses a map visual to show store locations. Some stores have the same latitude and longitude. You want to distinguish overlapping points. Which visual feature should you use?

A.ArcGIS map
B.Bubble map with bubble size set to a measure
C.Filled map
D.Shape map
AnswerB

Bubble size can differentiate overlapping points.

Why this answer

Option B is correct because the bubble map with size can differentiate overlapping points by a measure. Option A is wrong because a shape map shows regions. Option C is wrong because a filled map shows regions.

Option D is wrong because arcGIS map may have similar issues.

Practice this question →
54
Multi-Selecthard

Which THREE considerations are important when designing a dashboard for executive stakeholders?

Select 3 answers
A.Focus on key performance indicators (KPIs) that align with business goals.
B.Use consistent colors and fonts to maintain a professional look.
C.Provide high-level summaries with the ability to drill down if needed.
D.Include as many interactive slicers as possible for flexibility.
E.Use detailed tables to show all underlying data.
AnswersA, B, C

KPIs provide quick insight into performance.

Why this answer

Options B, D, and E are correct. B: KPIs allow quick performance assessment. D: High-level summaries prevent information overload.

E: Consistent design improves readability. A is wrong because interactivity can distract. C is wrong because dashboards should be concise, not detailed.

Practice this question →
55
MCQhard

You are reviewing a Power BI dataset schema. The Date column is used in time intelligence measures. What is missing from this schema?

A.There is no separate date table marked as a date table.
B.The version should be 2.0.
C.The Amount column should be a decimal.
D.The data type for Date should be date instead of dateTime.
AnswerA

Time intelligence requires a date table.

Why this answer

Option D is correct because a separate date table is needed for time intelligence functions to work properly. Option A is wrong because data types are specified. Option B is wrong because the schema is valid JSON.

Option C is wrong because there is no indication of an issue with columns.

Practice this question →
56
MCQeasy

You have a Power BI report that includes a line chart showing monthly sales. You want to add a trend line to help users identify the overall direction of sales over time. Which feature should you use?

A.Forecast option in the visual
B.Add a DAX measure for linear regression
C.Format pane to change line style
D.Analytics pane in the visual
AnswerD

The Analytics pane contains the Trend line option.

Why this answer

Option A is correct because the Analytics pane in line chart visuals provides the 'Trend line' option. Option B is wrong because a forecast is different from a trend line. Option C is wrong because the format pane deals with visual appearance, not analytics.

Option D is wrong because DAX is not required to add a trend line.

Practice this question →
57
MCQeasy

You need to create a Power BI report that uses data from Microsoft Excel files stored in SharePoint Online. The data should refresh automatically every hour. What is the recommended approach?

A.Use the SharePoint Online folder connector in Power Query and set up a scheduled refresh in the Power BI service.
B.Use the Excel Online connector in Power BI Desktop.
C.Manually upload the Excel files to the Power BI service each time.
D.Import the Excel files into Power Query and then publish.
AnswerA

This allows automatic refresh of Excel files from SharePoint.

Why this answer

Option A is correct because Power BI can connect to Excel files in SharePoint via the SharePoint Folder connector, and then schedule refresh. Option B is wrong because importing to Power Query is not a data source; it's a transformation step. Option C is wrong because manual uploads do not support scheduled refresh.

Option D is wrong because Excel Online is not a direct data source for Power BI refresh.

Practice this question →
58
Matchingmedium

Match each data connectivity mode to its description.

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

Concepts
Matches

Data is copied into Power BI

Queries are sent to the source database

Connects to a published dataset or Analysis Services

Combines Import and DirectQuery sources

Acts as Import or DirectQuery depending on context

Why these pairings

These modes determine how data is accessed in Power BI.

Practice this question →
59
MCQhard

Refer to the exhibit. You have a DAX measure that calculates year-over-year sales growth. When you add this measure to a table visual with Year and Month, some rows show blank values. What is the most likely cause?

A.The measure cannot be used at the month level because SAMEPERIODLASTYEAR only works at year level
B.The measure is trying to divide by zero for months with no sales in the previous year
C.The relationship between Sales and Calendar is inactive
D.The Calendar table does not have a continuous date range, causing SAMEPERIODLASTYEAR to return blank for some months
AnswerD

SAMEPERIODLASTYEAR requires a contiguous set of dates; missing dates cause blank.

Why this answer

Option B is correct because SAMEPERIODLASTYEAR requires a contiguous date range; missing dates in the Calendar table cause blank returns. Option A is wrong because DIVIDE handles division by zero. Option C is wrong because the measure uses SUM, not a relationship issue.

Option D is wrong because the measure works at month granularity.

Practice this question →
60
Multi-Selectmedium

Which TWO actions can you take to improve the performance of a Power BI report that uses a large dataset?

Select 2 answers
A.Use multiple columns in slicers for more granular filtering.
B.Use aggregations to pre-summarize data at higher levels.
C.Create complex calculated measures that use many nested functions.
D.Reduce the number of visuals on a page.
E.Switch from Import mode to DirectQuery mode.
AnswersB, D

Aggregations reduce the data volume queried.

Why this answer

Options A and D are correct. A: Reducing the number of visuals lowers processing load. D: Using aggregations pre-summarizes data.

B is wrong because using multiple columns in slicers increases cardinality. C is wrong because DirectQuery may slow performance. E is wrong because complex measures can be resource-intensive.

Practice this question →
61
MCQmedium

You have a Power BI report that uses a slicer to filter data by year. You want the slicer to show only years that have data, but currently it shows all years from 2000 to 2030. What is the most likely cause?

A.The slicer is using a calculated column.
B.The year field is from a disconnected table.
C.The slicer is set to 'Single select' mode.
D.The data model uses a star schema.
AnswerB

A disconnected table will show all values regardless of data.

Why this answer

If the slicer field is from a disconnected date table or the relationship is not filtering correctly, the slicer shows all values. The solution is to use a date table related to the fact table.

Practice this question →
62
MCQhard

You are a Power BI consultant for a logistics company. The company has a semantic model with a 'Shipments' fact table (containing 'ShipmentID', 'Date', 'OriginCity', 'DestinationCity', 'Weight', 'Cost') and 'City' dimension table (with 'City', 'Region', 'Country'). The company wants a report that displays a map visual with bubbles sized by total shipment weight, and a slicer to select a region. Additionally, they want to be able to click on a bubble (city) and see a table of shipments from that city. You have implemented a map visual using the 'City' field and a table visual. When you click on a bubble, the table does not filter to show only shipments from that city. You have confirmed that cross-filtering is enabled. What is the most likely cause?

A.The map visual does not have a legend field, so clicking does not generate a filter.
B.The table visual has a filter that prevents cross-filtering.
C.The relationship between Shipments and City is based on OriginCity, but the table shows DestinationCity, so the filter does not apply.
D.The region slicer is interfering with the cross-filtering.
AnswerC

The filter from the map applies to the City dimension, but the table uses a different field (DestinationCity) that is not related to the same City table.

Why this answer

The map visual uses the 'City' field from the City dimension table. When you click a bubble, it sends a filter on the City table. However, the table visual likely uses fields from the Shipments table (e.g., ShipmentID, DestinationCity).

If the relationship between Shipments and City is based on OriginCity, and the table is showing DestinationCity, the filter from the map (on City) may not propagate correctly because the relationship is on OriginCity, not DestinationCity. Option D is correct. Option A is incorrect because the slicer is not the issue.

Option B is incorrect because the map should have a legend if needed. Option C is incorrect because the table might have many rows but filtering should work.

Practice this question →
63
MCQeasy

You have a Power BI report that includes a slicer for product category. Users want to select multiple categories and see the combined data. The slicer currently allows only single selection. What should you change?

A.Change the slicer style to dropdown.
B.Use the sync slicer pane to replicate the slicer on other pages.
C.Add a second slicer for product category.
D.Enable multi-select in the slicer formatting options.
AnswerD

Multi-select allows selection of multiple items.

Why this answer

Option B is correct because enabling multi-select on the slicer allows users to select multiple items. Option A is wrong because the sync slicer pane is for syncing slicers across pages. Option C is wrong because changing the slicer to dropdown does not enable multi-select by default.

Option D is wrong because adding a second slicer would not solve the single-select limitation.

Practice this question →
64
MCQmedium

You are building a report for executives to monitor key performance indicators (KPIs) against targets. You have a KPI visual for revenue. The target is stored in a separate table. Which approach should you use to configure the KPI visual correctly?

A.Create a calculated column in the sales table that references the target.
B.Merge the target table into the sales table in Power Query.
C.Use the target column directly from the related table in the KPI visual.
D.Create measures for actual and target, then assign them to the KPI visual.
AnswerD

Measures allow dynamic aggregation and are required for KPI visual.

Why this answer

Option D is correct because the KPI visual requires a single value for actual, a goal, and a trend axis. By creating measures that retrieve the target from the separate table, you can assign them to the KPI visual fields. Option A is wrong because merging tables would denormalize the model unnecessarily.

Option B is wrong because the KPI visual cannot directly use a column from a related table without measures. Option C is wrong because calculated columns are static and not suitable for dynamic targets.

Practice this question →
65
MCQeasy

You have a Power BI report that displays sales data by region. The report includes a map visual showing sales amount by state. You notice that some states are not displayed on the map because the state names in the data do not match the standard names used by Power BI's map visualization. For example, 'California' is correct but 'CA' is not recognized. You need to ensure all states appear correctly. Which action should you take? A. Create a calculated column that maps state abbreviations to full names using a SWITCH statement. B. Change the map visual to a filled map. C. Use the 'Data category' property to set the field to 'State or Province'. D. Add a custom map image. Which option is the best?

A.Use the 'Data category' property to set the field to 'State or Province'
B.Create a calculated column that maps state abbreviations to full names using a SWITCH statement
C.Add a custom map image
D.Change the map visual to a filled map
AnswerB

This corrects the values to be recognized by the map.

Why this answer

Option A is correct because you can create a calculated column that converts abbreviations to full names using a SWITCH or a mapping table. Option B is wrong because a filled map has the same recognition issue. Option C is wrong because setting data category does not change the values.

Option D is wrong because custom map images require additional setup and may not solve the recognition issue.

Practice this question →
66
MCQmedium

You have a Power BI report that displays key performance indicators (KPIs) using a KPI visual. The visual shows a measure 'Current Sales' with a goal of 'Target Sales'. You want to show the status (on track, behind, etc.) based on the difference. You configure the KPI visual with the measure, goal, and trend axis. However, the status indicator does not appear. What should you do? A. Ensure the measure and goal are both numeric and have the same unit. B. Add a trend line to the visual. C. Set the 'Direction' property to 'High is good' or 'Low is good'. D. Use a different visual like a gauge. Which option is the best?

A.Add a trend line to the visual
B.Ensure the measure and goal are both numeric and have the same unit
C.Set the 'Direction' property to 'High is good' or 'Low is good'
D.Use a different visual like a gauge
AnswerC

Direction is required to compute status based on goal.

Why this answer

Option C is correct because the KPI visual requires setting the direction to calculate status. Option A is wrong because units don't need to be same. Option B is wrong because trend line is optional.

Option D is wrong because gauge is an alternative but not a fix for KPI.

Practice this question →
67
MCQmedium

Your Power BI report uses a calculated table to create a date dimension. You need to add a column that shows the fiscal quarter based on a fiscal year starting in July. What DAX expression should you use?

A.Fiscal Quarter = "Q" & FORMAT('Date'[Date], "\QQ")
B.Fiscal Quarter = "Q" & FORMAT('Date'[Date], "Q")
C.Fiscal Quarter = "Q" & FORMAT('Date'[Date], "Q", "en-US", 2025-07-01)
D.Fiscal Quarter = "Q" & QUARTER('Date'[Date])
AnswerC

FORMAT with a fiscal calendar start date returns the fiscal quarter.

Why this answer

Option A is correct because FORMAT with "Q" returns the quarter number, and the shift of 0 accounts for the fiscal year start in July (July=Q1). Option B is wrong because it returns the calendar quarter. Option C is wrong because it uses "\QQ" which is incorrect syntax.

Option D is wrong because it uses QUARTER function which returns calendar quarter.

Practice this question →
68
MCQeasy

You have a Power BI report that uses a date table with a continuous date range. You want to add a slicer that allows users to select a single month and then display data for that month only. You add a slicer visual with the Date field. However, the slicer shows individual dates instead of months. How should you configure the slicer to show months? A. Change the slicer type to 'Between' and then select a month range. B. Create a calculated column for Month and use that in the slicer. C. Use the 'Hierarchy' slicer with Date hierarchy. D. Set the slicer to 'List' and enable 'Show select all'. Which option is best?

A.Set the slicer to 'List' and enable 'Show select all'
B.Create a calculated column for Month and use that in the slicer
C.Use the 'Hierarchy' slicer with Date hierarchy
D.Change the slicer type to 'Between' and then select a month range
AnswerB

A Month column provides distinct month values for selection.

Why this answer

Option B is correct because creating a Month column (e.g., 'Month Year') allows users to select a month. Option A is wrong because 'Between' slicer still shows dates. Option C is wrong because hierarchy slicer shows drill-down, not single selection.

Option D is wrong because 'Select all' does not group by month.

Practice this question →
69
MCQeasy

You need to create a visual that shows the relationship between advertising spend and website traffic. Which type of visual is most appropriate?

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

Scatter charts show correlation between two measures.

Why this answer

Scatter charts are ideal for showing relationships between two numeric variables. A line chart shows trends over time, a bar chart compares categories, and a pie chart shows proportions.

Practice this question →
70
MCQmedium

You have a Power BI dataset that contains a table with sales data and a separate date table. You need to create a measure that calculates the total sales for the previous month relative to the selected date. Which DAX function should you use?

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

PREVIOUSMONTH returns the previous month in the current context.

Why this answer

Option B is correct because PREVIOUSMONTH returns the previous month based on the current filter context. Option A is wrong because DATEADD shifts dates by an interval but requires a number. Option C is wrong because PARALLELPERIOD returns a parallel period, not specifically previous month.

Option D is wrong because SAMEPERIODLASTYEAR returns the same period last year.

Practice this question →
71
MCQeasy

You want to allow users to highlight different product categories in a line chart by selecting from a list. Which feature should you add?

A.Slicer
B.Tooltip
C.Bookmarks
D.Drillthrough
AnswerA

A slicer allows users to filter or highlight categories.

Why this answer

A slicer filters or highlights data based on selection, making it ideal for category selection. Bookmarks save a state, drillthrough navigates to another page, and tooltips show details on hover.

Practice this question →
72
MCQeasy

You have a Power BI report that includes a map visual showing store locations. You want to add a tooltip that displays the store name and total sales when users hover over a location. What do you need to do?

A.Add the store name and sales fields to the tooltips bucket of the map visual.
B.Create a bookmark that shows a table with store details.
C.Add a drill-through page with store details.
D.Set the page tooltip property to show store details.
AnswerA

Tooltips display field values on hover.

Why this answer

Option B is correct because tooltips are configured by adding fields to the tooltips well. Option A is wrong because drill-through is for navigating to another page. Option C is wrong because bookmarks switch states.

Option D is wrong because the tooltip is a visual property, not a page property.

Practice this question →
73
MCQhard

You are a Power BI analyst at a retail company. The company has a SQL Server data warehouse with tables: 'Sales' (SalesID, ProductID, CustomerID, SalesDate, Amount, Quantity), 'Products' (ProductID, ProductName, Category, UnitPrice), 'Customers' (CustomerID, CustomerName, Region, Segment). The data warehouse is refreshed nightly. You need to build a Power BI solution that meets the following requirements: - The report must be published to the Power BI service and support scheduled refresh. - Users must be able to analyze sales by product category and customer region. - The data model should follow a star schema design. - A measure must calculate the running total of sales by date. - The report must include a visual that shows the top 5 products by sales amount for the current year. - Performance is critical; the report should load quickly. You have imported the data into Power BI Desktop. Which of the following actions should you take to meet the requirements?

A.Create a date dimension table. Build a star schema with Sales as fact and Products, Customers, and Date as dimensions. Use TOTALYTD for running total and TOPN for top products.
B.Import all tables. Create a calculated column for running total using FILTER and EARLIER. Use a slicer to filter by current year and sort a bar chart by sales.
C.Use DirectQuery mode to connect to the data warehouse. Write a SQL query for each visual to ensure real-time data. Use a SQL window function for running total.
D.Create a single flat table by merging all tables in Power Query. Use a measure for running total with EARLIER function. Create a Top N filter on a table visual.
AnswerA

This follows star schema best practices and uses efficient DAX functions.

Why this answer

Option B is correct because creating a date dimension, using a star schema, and using DAX measures (including TOTALYTD for running total and TOPN for top products) is the best practice. Option A is wrong because using a single flat table would create a poor model and slow performance. Option C is wrong because DirectQuery would be slower for aggregated measures like running total.

Option D is wrong because using calculated columns for running total is less efficient than measures.

Practice this question →
74
MCQmedium

You have a Power BI report with a matrix visual showing sales by year and quarter. Users want to drill down from year to quarter and expand back up. Which feature should you enable?

A.Set up drill-through pages for each quarter
B.Create bookmarks for each level
C.Enable drill-down mode and add a hierarchy of Year and Quarter
D.Add a tooltip page showing quarterly details
AnswerC

Drill-down mode allows users to expand and collapse hierarchy levels.

Why this answer

Option A is correct because the drill-down mode in a matrix visual allows hierarchical navigation. Option B is wrong because bookmarks do not provide interactive drill-down. Option C is wrong because the drill-through feature navigates to a different page.

Option D is wrong because tooltips do not enable drill-down.

Practice this question →
75
MCQmedium

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

A.Stacked area chart
B.Clustered bar chart
C.Scatter plot
D.Pie chart
AnswerA

Stacked area chart shows how each category contributes to the total over time.

Why this answer

Option B is correct because a stacked area chart shows the contribution of each category to the total over time. Option A is wrong because a clustered bar chart compares individual values, not contributions. Option C is wrong because a pie chart shows proportions at a single point in time.

Option D is wrong because a scatter plot shows correlation, not contribution.

Practice this question →
Page 1 of 4 · 243 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Pl300 Visualize Analyze questions.

Start 20-question session