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: From the View tab, select Column distribution.
Step 2: Set Column Profiling based upon entire dataset.
Step 3: Select the Location Name column.
Step 4: Group the value distribution by text length.
Explanation: Column distribution enables value analysis without transforming data. Profiling the entire dataset ensures accuracy beyond the first 1,000 rows. Selecting the column focuses the analysis, and grouping by text length reveals the maximum character length.
Question 33
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: Legends in Power BI stacked bar charts require categorical fields (columns), not measures. To combine information from multiple existing columns into a single legend field, you must create a calculated column that concatenates or derives the combined value. Measures, dynamic format strings, and calculation groups cannot be used directly as legend categories.
Question 34
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 the percentage of valid, error, and empty values per column. Column profile shows detailed column statistics, including minimum and maximum values.
Question 35
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, functions like RUNNINGSUM are designed to compute cumulative totals directly over the visual’s axis. RUNNINGSUM([Sales]) correctly returns the current year’s sales plus all prior years in the visual context. Option C is a classic DAX running total measure, but it is not a visual calculation.
Question 36
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: Enable overlap for every series.
Enable data labels for the Plan series.
Explanation: Reducing the spacing between paired columns in a clustered column chart is done by enabling series overlap. The percent change values are displayed as data labels on the Plan bars, so data labels must be enabled only for the Plan series.
Question 37
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: YOY monthly comparison requires shifting the current date context to the same period in the prior year. SAMEPERIODLASTYEAR returns last year’s corresponding month, and DIVIDE calculates (Current − Prior) / Prior safely, handling divide-by-zero cases.
Question 38
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: Users only analyze by the date portion of TransactionDate, so converting it from DateTime to Date reduces storage without impacting analysis. To further minimize model size, removing PostDate eliminates an entire column that is not required for the stated analysis. Removing TransactionID could affect row-level detail or relationships, and changing PostDate to Date does not reduce size as effectively as removing an unused column.
Question 39
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: The model must follow a star schema and be optimized for monthly reporting with minimal size. One-to-many relationships are required between fact and dimension tables in a star schema (A). To minimize size while meeting the requirement of monthly totals, the Transactions table should be pre-aggregated at the monthly grain by grouping by AccountID and MonthStartDate and summing TransAmt (D). To enable that aggregation and to relate the fact table to the Date dimension at the month level, a MonthStartDate column must first be added to the Transactions query (E). Options B and C are either redundant or unnecessary once the table is aggregated, and many-to-many relationships (F) violate star schema best practices.
Question 40
HOTSPOT
-
You have a Power BI semantic model that contains two tables named Sales and Forecast. Both tables contain a date column.
You need to create a calculated table that will cover the range of dates in both tables.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: CALENDAR
MINX
MAXX
Explanation: CALENDAR creates a contiguous date table between a start and end date. MINX(Sales, [Date]) returns the earliest date in Sales, and MAXX(Forecast, [Date]) returns the latest date in Forecast, covering the full range across both tables.
Question 41
HOTSPOT
-
You have a Power BI semantic model that contains three tables named Products, OrderHistory, and Date.
The Products table is a dimension table that contains the following columns:
• ProductID
• ProductName
The OrderHistory table is a fact table that contains the following columns:
• OrderID
• ProductID
• OrderDate
The Date table is a dimension table that contains the following columns:
• Year
• Date
• Week
• Month
You need to define a relationship from Products to OrderHistory and from OrderHistory to Date.
Which cardinality should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Show Answer
Correct Answer: Between Product and OrderHistory:
One-to-many
Between OrderHistory and Date:
One-to-many
Explanation: Products and Date are dimension tables with unique keys, while OrderHistory is a fact table with repeating foreign keys. One product can appear in many orders, and one date can have many orders, so both relationships are one-to-many (dimension → fact).
$19
Get all 356 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.
