Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You normalize casing in the source query or Power Query Editor.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: A
Explanation: In DirectQuery mode, Power BI's engine is case-insensitive. If the underlying data source is case-sensitive, values that differ only by letter case can be treated as duplicates by Power BI, leading to undefined results and related errors. Microsoft recommends normalizing casing in the source query or in Power Query Editor to avoid this issue. Therefore, the proposed solution meets the goal.
Question 93
You have a Power BI report that contains the table shown in the following exhibit.
The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns.
You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.
What should you do?
A. Move the conditional formatting icons to a tooltip report.
B. Add alt text that lists the values in the table.
C. Change the icons to use a different shape for each color.
D. Remove the icons and use red, yellow, and green background colors instead.
Show Answer
Correct Answer: C
Explanation: For users with color vision deficiency, information should not rely on color alone. Using distinct icon shapes in addition to color makes the status distinguishable regardless of color perception. Alt text addresses screen reader accessibility rather than color vision deficiency, moving icons to tooltips reduces visibility, and replacing icons with colored backgrounds still relies primarily on color.
Question 94
You have a Power BI report that contains a table visual. The visual contains a column.
The column contains whole numbers ranging from of 1 to 20.
You need to use conditional formatting to meet the following requirements:
• Visually compare the values without having to read the text containing the number.
• Show a different format for each distinct value.
• Hide the numeric value of ColumnA.
• Minimize development effort.
Which formatting should you use?
A. font color
B. icons
C. data bars
D. background color
Show Answer
Correct Answer: C
Explanation: Data bars provide an immediate visual comparison of magnitudes, can be configured with the 'Show bar only' option to hide the numeric values, and require minimal configuration. Icons would require many rules to distinguish 20 distinct values, while font or background color are less effective for comparing numeric magnitude across 20 unique values.
Question 95
You have a Power BI report that contains one visual.
You need to provide users with the ability to change the visual type without affecting the view for other users.
What should you do?
A. From the Bookmarks pane, select Focus mode, and then select Add.
B. From Report settings, select Personalize visuals.
C. From Visual options in Report settings, select Use the modern visual header with updated styling options.
D. From Tabular Editor, create a new perspective.
Show Answer
Correct Answer: B
Explanation: Enabling 'Personalize visuals' in Report settings allows each user to change a visual's type and other supported properties for their own view without affecting the report for other users. Bookmarks are report-defined states, the modern visual header only changes UI styling, and perspectives in Tabular Editor control model metadata visibility rather than per-user visual customization.
Question 96
HOTSPOT -
You have a Power BI workspace.
You need to create two reports that meet the following requirements:
• Report1: Optimized for printing and can be delivered to users via a scheduled email subscription
• Report2: Optimized for dynamic user interactivity
Which format should you use for each report? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Report1: Power BI paginated (.rdl)
Report2: Power BI (.pbix)
Explanation: Paginated (.rdl) reports are designed for pixel-perfect printing and scheduled email subscriptions in Power BI workspaces. Power BI (.pbix) reports are optimized for interactive exploration with slicers, drill-down, and cross-filtering.
Question 97
HOTSPOT
-
You have a Power BI report that contains the table visual shown in the following exhibit.
You need to modify the visual to display as shown in the following exhibit.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Type: Matrix
Format: Set Switch values to rows to On.
Explanation: The target layout is a Matrix with measures displayed as rows and dates as columns (move OrderDate to Columns). Enabling 'Switch values to rows' places Total Cost and Total Sales as row headers, matching the desired view with column totals.
Question 98
HOTSPOT
-
You have a semantic model that has the permissions shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: use Analyze in Excel with
grant the Build permission for
Explanation: The finance group has Read + Build, which allows Analyze in Excel. The corp group has Read + Reshare + Build, and Reshare together with Build allows granting Build permission to others.
Question 99
You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:
• Date
• Product
• SalesAmount
You need to create a DAX measure for a rolling 31-day sales total that will return the total sales amount for a selected date and the previous 30 days.
Which DAX expression should you use?
A. CALCULATE(SUM(Sales[SalesAmount]), DATEADD(Date[Date], -30, DAY))
B. CALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date], Max('Date'[Date])-30, Max('Date'[Date])))
C. CALCULATE(SUM(Sales[SalesAmount]), DATESMTD(Date[Date]))
D. CALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)
Show Answer
Correct Answer: B
Explanation: A rolling 31-day total requires filtering the date table to the range from the current selected date back 30 days. DATESBETWEEN defines that continuous date interval, and CALCULATE evaluates the sales sum over it. DATEADD shifts the current date context by 30 days rather than creating a 31-day window. DATESMTD returns month-to-date, and DISTINCTCOUNT is not a valid way to define the rolling date filter.
Question 100
You need to use Power BI to create a visual that will allow users to compare the sales performance of five sales regions for the current month.
Which visual should you use?
A. a line chart
B. a stacked bar chart
C. a 100% stacked bar chart
D. a waterfall chart
Show Answer
Correct Answer: B
Explanation: To compare sales performance across five categorical regions for a single time period (the current month), a bar chart is the appropriate choice. Although a clustered bar chart would typically be preferred, it is not an option here. A stacked bar chart best fits the available choices for comparing absolute sales values by region. A 100% stacked bar chart emphasizes proportions rather than actual sales amounts, a line chart is better for trends over time, and a waterfall chart is intended to show sequential increases and decreases contributing to a total.
Question 101
You create a Power BI report named Summary1.
You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1.
Which two metrics display the execution duration in Performance analyzer? Each correct answer present part of the solution.
NOTE: Each correct answer is worth one point.
A. Top Operations
B. DAX query
C. Server requests
D. Dependencies
E. Visual display
Show Answer
Correct Answer: B, E
Explanation: Performance Analyzer reports execution duration for categories such as DAX query (time spent executing the DAX query) and Visual display (time spent rendering the visual). Top Operations, Server requests, and Dependencies are not Performance Analyzer duration metrics.
$19
Get all 369 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
