Question 110 A municipal planning report stores AgeYears as a numeric column for 20,000 residents. The report needs a frequency distribution in 10-year age intervals, not one category per exact age. What feature fits? Create numeric bins for the AgeYears column with a 10-year bin size Use a single Card with the average age Create a relationship from AgeYears to an unrelated monetary fact Convert the age column to freeform month names Explanation Correct Answer A:Power BI can group values in a numeric column into fixed-width bins to display a histogram-like frequency distribution. Incorrect Answers B:An average hides the spread and number of observations in each interval. C:Relationship cardinality does not construct age group boundaries. D:Month-name text cannot preserve numeric age intervals or correct counts.
Question 111 A factory must keep operational events in SQL and reports use DirectQuery. After a source index is dropped, most visuals become slow, despite no Power BI model edit. What is the most relevant next diagnostic action? Use Performance Analyzer and SQL query diagnostics to identify slow source statements and address source indexing or statistics Export SQL records to a Word document rather than investigating the model Change the calendar sort to descending without looking at query execution Add a hidden report page and assume existing visuals regain their performance Explanation Correct Answer A:DirectQuery depends on source execution; querying the actual SQL statements and their plans after an index change diagnoses the bottleneck. Incorrect Answers B:A document is not a diagnostic substitute for SQL source performance analysis. C:Presentation sorting will not recover a removed index or fix an expensive execution plan. D:An invisible report page does not speed up the DirectQuery requests of existing visuals.
Question 112 A maintenance table contains SiteID, AssetID, and 24 columns named after months. It must become one row per site/asset/month, retaining both IDs. Which operation is best? Unpivot SiteID and AssetID while preserving monthly fields as separate columns Pivot the month columns into 24 more distinct columns Select SiteID and AssetID and choose Unpivot Other Columns Delete month columns and keep only the identifiers Explanation Correct Answer C:Unpivot Other Columns melts the month values while leaving stable business keys intact. Incorrect Answers A:Unpivoting keys corrupts the intended grain of each asset observation. B:The table is already wide; pivot would not create a month-value fact layout. D:Dropping months discards all time-series measures.
Question 113 An in-app purchases DirectQuery report at a mobile games studio displays an operational dashboard on a wall. Data changes frequently and the page should automatically requery at a configured interval where supported. What report feature is relevant? A bookmark that freezes all model data forever Automatic page refresh configured within the model/capacity limits Change the report theme each hour A one-time export to PDF Explanation Correct Answer B:Automatic page refresh can periodically requery supported DirectQuery report pages within licensing/capacity controls. Incorrect Answers A:Bookmarks preserve display states but do not refresh model values on an interval. C:Themes affect colors and fonts, not source query refresh cadence. D:A PDF is a static snapshot and cannot display frequent source updates.
Question 114 A report filters March 2026. The prior-year same month has no fact rows, and [Units] is SUM(Fact[Units]) without a zero replacement. What result is expected from CALCULATE([Units], SAMEPERIODLASTYEAR(Date[Date]))? BLANK, unless the measure explicitly replaces the missing aggregate with zero March 2026 units, because missing history preserves current context The annual total for all of 2025 The February 2026 amount Explanation Correct Answer A:The shifted March 2025 filter contains no rows, so a plain SUM-based measure has no value for that context. Incorrect Answers B:The date modifier shifts the filter to March 2025 instead of reusing March 2026. C:SAMEPERIODLASTYEAR shifts the selected month, not the entire prior year. D:A one-year shift is different from stepping back one month.
Question 115 A model uses classic DAX time intelligence with a custom Date dimension. Its Date column is valid, unique, continuous and spans full years. What model configuration should the analyst perform? Keep duplicate dates in the Date column to represent busy days Use a transaction ID in place of the Date column Mark the table as the Date table and designate its valid Date column for classic time-intelligence use Convert all dates to month-name text without a true date Explanation Correct Answer C:Classic time intelligence expects a properly designated date table where applicable; validated contiguous unique dates are required. Incorrect Answers A:Duplicate date values would violate marked-date requirements. B:A transaction ID does not represent a continuous calendar. D:Text month labels cannot supply classic time-intelligence date context.
Question 116 A freight company plots monthly weight records, but some months have no deliveries. Its line chart currently treats MonthName as text and visually spaces February and June as adjacent categories. The analyst wants spacing to reflect elapsed time. What should change? Add a Category label for each missed month but keep the x-axis as untyped MonthName text Switch the value measure to a count of all rows to invent shipments for missing months Use a true Date field on a continuous date axis so missing intervals occupy appropriate chronological space Sort MonthName alphabetically so June appears beside January Explanation Correct Answer C:A continuous date axis uses actual positions in time and makes gaps between observations visible. Incorrect Answers A:Extra text labels do not give a categorical axis continuous calendar spacing. B:Changing a measure to row count cannot create valid observations in missing months. D:Alphabetic ordering of month names is not time spacing and worsens chronology.
Question 117 A financial cooperative monitors a dashboard card that displays a numeric Principal total and wants an alert when it crosses a specified threshold. Which service feature should the analyst investigate? A new category color theme Data alert on an eligible dashboard tile A calculated column to send email from each row A Power Query merge command Explanation Correct Answer B:Dashboard data alerts can notify users when supported KPI/card/gauge tile values meet a set condition. Incorrect Answers A:Theme color changes do not monitor the changing metric. C:Calculated columns produce data, not threshold notifications from the dashboard tile. D:Merge performs relational joins and cannot send a monitoring alert.
Question 118 An enrollment Category column contains A, A, B, C, C, D. Power Query Column distribution shows Distinct and Unique counts. What is the meaning of Unique in this profile? 4, because there are four different labels 6, because there are six rows 0, because no label must be treated as unique unless it is a primary key The count is 2, because B and D each occur exactly once Explanation Correct Answer D:Unique counts values whose frequency is exactly one; A and C are distinct but not unique. Incorrect Answers A:Four is the Distinct count A/B/C/D; Unique excludes labels that recur. B:Row count includes duplicates and does not mean unique values. C:Column profiling reports one-occurrence values regardless of whether a column is a declared key.
Question 119 A wholesale distributor must share the deliveries report with an external guest who is already approved through Microsoft Entra B2B. Which control still needs consideration before sending a report link? Give the guest Power BI workspace Admin automatically Place the source database password in the report title Assume guest accounts bypass all RLS Tenant sharing policies, licensing/permissions, and the report/semantic-model access path Explanation Correct Answer D:External sharing depends on tenant policy plus the recipient’s supported access and license; RLS still needs verification. Incorrect Answers A:Admin is excessive for an external reader and bypasses intended least privilege. B:Secrets must never be exposed in report metadata. C:Guest identity does not generally remove the need for model row restrictions.
Question 120 A billing export has columns InvoiceID, ChargeType, Amount. An invoice can contain multiple rows with the same ChargeType. The analyst wants one amount column per charge type. How should the pivot handle duplicates? Pivot without any aggregation and assume all ID/type pairs are unique Unpivot ChargeType into a wider row Use Count when the business requires monetary totals Pivot ChargeType using Sum of Amount for repeated invoice-type combinations Explanation Correct Answer D:Summing repeated charge rows yields one numerical amount per InvoiceID/ChargeType. Incorrect Answers A:Repeated combinations require an explicit aggregation or preprocessing. B:Unpivot moves data to long form rather than the desired columns. C:Count measures occurrences, not the sum of charge amounts.
