You have a Power BI report. The report contains a single report page that uses the default theme.
You need to configure the report page to match the formatting shown in the following exhibit.
What should you change on the report page?
A. the wallpaper color only
B. the canvas background color only
C. the wallpaper color and the canvas background color only
D. the canvas background image only
Show Answer
Correct Answer: C
Explanation: The canvas background controls the report page area behind the visuals, while the wallpaper controls the area outside the canvas. If the exhibit shows different formatting for both the report canvas and the surrounding margins, both settings must be changed. No background image is required.
Question 42
You plan to generate a line chart to visualize and compare the last six months of sales data for two departments.
You need to increase the accessibility of the visual.
What should you do?
A. Configure a unique marker for each series.
B. Configure a distinct color for each series.
C. Replace long text with abbreviations and acronyms.
D. Move important information to a tooltip.
Show Answer
Correct Answer: A
Explanation: Use a unique marker for each line series so users can distinguish the series without relying solely on color. This improves accessibility for people with color vision deficiencies. Using distinct colors alone is insufficient, abbreviations can reduce clarity, and moving important information to tooltips can make it less accessible.
Question 43
DRAG DROP
-
You use Microsoft Power BI Desktop to preview a query in Power Query Editor. The query contains a column named Location Name.
You need to identify the maximum length of each value in the Location Name column without changing the data.
Which actions should you perform in sequence? To answer, drag the appropriate actions to the correct order. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Step 1: Select the Location Name column.
Step 2: Set Column Profiling based upon entire dataset.
Step 3: From the View tab, select Column profile.
Step 4: Group the value distribution by text length.
Explanation: Column Profile provides detailed profiling without modifying the query. After enabling profiling for the entire dataset, group the value distribution by text length to see the maximum text length.
Question 44
You have a Power BI report that contains a stacked bar chart.
You need to add a new field to the legend. The field must combine information from separate columns.
What should you create?
A. a calculated column
B. a dynamic format string
C. a measure
D. a calculation group
Show Answer
Correct Answer: A
Explanation: A stacked bar chart legend requires a categorical field (a column). If you need the legend values to combine information from multiple columns, create a calculated column that concatenates or otherwise combines those column values. Measures cannot be used as legend categories, dynamic format strings only affect formatting, and calculation groups modify calculation behavior rather than create categorical legend fields.
Question 45
DRAG DROP
-
You are using Power BI Desktop to profile data in Power Query Editor.
You need to review the percentage of errors and the maximum value of each column.
Which options should you use in Power Query Editor? To answer, drag the appropriate options to the correct requirements. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Review the percentage of errors: Column quality
Review the maximum value: Column profile
Explanation: Column quality displays percentages of valid, error, and empty values. Column profile provides detailed column statistics such as minimum and maximum values.
Question 46
You have a Power BI report that contains a clustered bar chart. The chart has an X-axis named Sales and a Y-axis named Year. The chart displays sales data for the years 2020 through 2024.
You need to create a visual calculation to show a cumulative total of sales that is equal to the sum of the current year's sales plus all the sales from the previous year.
Which DAX expression should you use?
A. MOVINGAVERAGE([Sales], 4)
B. RUNNINGSUM([Year])
C. CALCULATE ( [Sales], 'Date' [Year] <= MAX ( 'Date'[Year] ) )
D. RUNNINGSUM([Sales])
Show Answer
Correct Answer: D
Explanation: The question explicitly asks for a visual calculation. In Power BI visual calculations, RUNNINGSUM is the built-in function that returns a cumulative total across the visual axis. Using RUNNINGSUM([Sales]) accumulates the current year's sales with all prior years' sales. CALCULATE with a running-total filter is the classic measure pattern, but it is not the intended visual calculation syntax. MOVINGAVERAGE computes an average, not a cumulative sum, and RUNNINGSUM should be applied to the Sales values rather than the Year field.
Question 47
HOTSPOT
-
You have a Power BI report that contains the visual shown in the following exhibit.
You plan to modify the visual by changing the column spacing and adding percent change labels as shown in the following exhibit.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: To change the column spacing: Enable overlap for every series.
To add the percent change labels: Enable data labels for the Plan series.
Explanation: The modified chart shows the clustered columns overlapping more closely, which is controlled by series overlap. The percentage values appear only once per category, aligned with the Plan bars, so enabling data labels for the Plan series displays the percent change labels.
Question 48
HOTSPOT
-
You have a Power BI semantic model.
You need to create a column that will contain year-over-year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year's monthly revenue.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: SAMEPERIODLASTYEAR
DIVIDE
Explanation: Use SAMEPERIODLASTYEAR('Date'[Date]) to retrieve the corresponding period (same month) in the prior year. Compute YOY percentage as (Current Revenue - Prior Year Revenue) / Prior Year Revenue using DIVIDE to safely handle division by zero.
Question 49
You have a Power BI query named Expenses that imports the following data.
Users only use the date portion of the TransactionDate value when performing data analysis.
You need to minimize the model size without affecting the analysis.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Change the data type of the TransactionDate column to Date.
B. Change the data type of the PostDate column to Date.
C. Remove the PostDate column.
D. Remove the TransactionID column.
Show Answer
Correct Answer: A, C
Explanation: Changing TransactionDate from DateTime to Date reduces cardinality and model size because only the date portion is used in analysis. Removing the PostDate column further reduces model size by eliminating an unused column from the model. Changing PostDate's type alone does not help if the column is unnecessary, and removing TransactionID cannot be justified from the information provided because it may still be needed as an identifier.
Question 50
You have a Power BI semantic model that contains the following data.
You need to create a solution that meets the following requirements:
• Presents transaction amount totals for each month for the current and prior year
• Follows the star schema modeling approach
• Minimizes the data model size
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Create one-to-many relationships between the tables.
B. In the Transactions query, delete the TransactionID column.
C. In the Date query, group by MonthNumber.
D. In the Transactions query, group by AccountID and MonthStartDate for TransactionDate. Aggregate by summing the TransAmt column.
E. In the Transactions query, add a column that contains the MonthStartDate value for TransactionDate.
F. Create many-to-many relationships between the tables.
Show Answer
Correct Answer: A, D, E
Explanation: Use a star schema with one-to-many relationships. To minimize model size while meeting a monthly reporting requirement, pre-aggregate the Transactions table by AccountID and MonthStartDate, summing TransAmt. Creating the MonthStartDate column in Transactions provides the grouping key for monthly aggregation and relationship at the required grain.
$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.
