Question 560 A report for a university must show how total Tuition changed month by month over two years, keeping time in chronological order. The analyst now must overlay current and previous year monthly results to see whether the seasonal shape differs. Which arrangement is appropriate? Pie with twenty-four unlabeled segments Scatter without ordered month labels Line chart with separate year series and month axis Single grand-total card Explanation Correct Answer C:Separate year series make month-aligned trends directly comparable. Incorrect Answers A:Pie slices are poor for comparing two chronological trajectories. B:An unordered scatter omits the aligned month sequence. D:A single total hides seasonality across years.
Question 561 A consumer using a screen reader needs to inspect the numbers behind a dense line chart. Which supported report feature provides a more tabular representation of visual data? Export a screenshot and ask users to read pixels Disable keyboard navigation for the chart Change the chart background but keep numbers hidden Use Show as a table or the accessible visual data-table interaction where supported Explanation Correct Answer D:The tabular data view offers values in a structure better suited to assistive technologies. Incorrect Answers A:Images lack the structured table data and text navigation. B:Disabling keyboard access prevents the intended interaction. C:Background changes do not expose numeric values semantically.
Question 562 A dashboard owner edits a report page, but a pinned tile displays an older visual configuration. What should be verified before assuming model data is broken? Delete all underlying SQL history Whether the pinned tile needs to be refreshed or repinned for changes to its visual configuration Grant every viewer workspace Administrator Change the source column to text Explanation Correct Answer B:Pinned tiles and report visual layout are distinct surfaces and may need an update to reflect changed visual composition. Incorrect Answers A:Deleting history cannot update a pinned visual. C:Access elevation does not refresh visual configuration. D:Text conversion is irrelevant to tile versioning.
Question 563 One branch adds DiscountAmount to its new monthly CSV, while older files lack the column. The combined model must preserve every old row and represent missing discounts accurately. What should the author verify? Delete all old rows until every file has the new field Fill every missing discount with 100% without a business rule The combine transformation handles optional columns explicitly and yields null for unavailable historical discounts Treat the new column as a filename and remove it from data Explanation Correct Answer C:A controlled schema-variation step retains historical records without inventing discount values. Incorrect Answers A:Discarding history is unnecessary and damages trend reporting. B:An invented 100% discount would corrupt revenue. D:The new field has business meaning and should not be dropped automatically.
Question 564 A transit authority must produce one Stations-level record with total Fare and a count of distinct TicketID values. The business requests one total per category per fiscal quarter, rather than one annual total per category. How should the grouping keys be configured? Group by the event ID only Transpose before aggregating without any keys Group by both category and fiscal quarter and sum the amount Group by category alone and discard quarter Explanation Correct Answer C:A two-column grouping key preserves the category/quarter reporting grain. Incorrect Answers A:Event-ID grouping usually leaves one row per transaction, not the requested summary. B:Transpose does not supply the required business grouping keys. D:Grouping only category loses differences among quarters.
Question 565 A report is filtered to 2026, showing [Sales]=80. Past years add another 120. A comparison measure uses CALCULATE([Sales], REMOVEFILTERS(Date)) and no other filters. What does it show? 80, because a date slicer always overrides CALCULATE 120, past years only 200, including current and prior years BLANK, because removing Date filters removes all fact records Explanation Correct Answer C:REMOVEFILTERS(Date) clears the current year filter so the measure sums all 200 across years. Incorrect Answers A:The modifier deliberately removes filters from Date. B:Clearing all Date filters includes 2026 along with the earlier years. D:Removing a filter does not erase valid rows from the model.
Question 566 A production model receives 12 million sensor readings per day. Operations approved only daily aggregate reporting, but another report still needs per-minute exceptions. Before replacing raw sensor data with daily rollups, what must the analyst verify? Preserve a supported detail path for exception analysis and aggregate only the facts not needed at finer grain Discard all timestamps immediately because daily totals always preserve every exception Split each sensor row into separate columns for every minute Use calculated text columns to store daily averages in every raw row Explanation Correct Answer A:Aggregation can improve performance but irreversibly loses minute-level exceptions if no detail source remains. Incorrect Answers B:A daily sum cannot reproduce when a transient exception occurred. C:Expanding fields by minute increases model width and does not preserve a scalable fact grain. D:A repeated text average increases storage and cannot answer fine-grained incidents.
Question 567 A nonprofit models a clean Chapters dimension related to a donations fact. A valid membership bridge connects a distinct list of employees and a distinct list of teams. A report requires filtering teams by currently selected employees through this bridge. What should be evaluated carefully? Enable Both for every relationship in the semantic model Delete membership records that create the many-to-many association Replace security evaluation with visual title text A controlled bidirectional path through the bridge with ambiguity and security reviewed Explanation Correct Answer D:Some bridge scenarios need managed bidirectional propagation; check paths and RLS implications explicitly. Incorrect Answers A:Global Both direction can create ambiguous paths and surprising results. B:Deleting membership facts loses actual group affiliations. C:Title labels are not substitutes for relationship and security design.
Question 568 An insurance provider compares last quarter’s total ClaimValue between five Offices categories. The request changes: business users need to see each department’s contribution to each month’s total instead of only a department rank. What visual fits? Sorted horizontal bars of all-time department totals KPI card for one department only Scatterplot without time categories Stacked columns by month with department legend Explanation Correct Answer D:Stacked columns show how component values combine into each monthly total. Incorrect Answers A:All-time ranked bars hide the changing monthly contribution. B:One card omits both parts and month totals. C:Scatter lacks the intended categorical composition.
Question 569 A clinic calculates average procedure cost. Some cases have the placeholder "Pending" because claims are not finalized. What preparation avoids biased averages? Convert Pending to zero and average it with real approved costs Discard all procedures whose approved cost is exactly zero Treat the entire cost column as a date Convert Pending to null with a documented quality flag, then type actual costs as decimal numbers Explanation Correct Answer D:Missing costs should not be silently counted as measured zero values in averages. Incorrect Answers A:Pending is not a verified zero and would reduce average cost artificially. B:Real zero may be valid and does not imply missingness. C:Dates do not represent monetary cost values.
Question 570 A multi-tenant customer model uses USERPRINCIPALNAME() in a DAX role filter. One staff member’s UPN changed after a domain migration and now sees no assigned accounts. What is the safest correction? Hardcode the employee’s previous UPN into every fact row Grant the employee workspace Member so the role filter stops applying Use a public report link rather than fix identity mapping Update the authorized identity-to-account mapping for the actual signed-in UPN and test the role as the user Explanation Correct Answer D:Dynamic RLS resolves the current authenticated UPN and joins it to the allowed account mapping. The mapping must match that identity. Incorrect Answers A:Old hardcoded identities become stale and risk incorrect authorization. B:Member bypasses Viewer RLS and adds editing rights instead of repairing authorization data. C:Public access would remove the intended user-specific control.
