Question 90 A passenger-transit report compares weekly fare recovery with a target that varies by route and contract year. Finance supplies an approved [TargetRecovery] measure that changes when users select the route. A single hardcoded horizontal line is misleading. Which design meets the requirement? Hardcode last year's corporate-wide target as a constant line for every route Sort the weeks by their recovery values and call the order a target Use the historical overall mean as the target even though contracts specify distinct route targets Plot the context-sensitive target measure alongside the observed fare recovery and validate both against route/year selections Explanation Correct Answer D:A measure-bound target series evaluates in the selected route and year context; it can be compared to actual results rather than pretending one value applies everywhere. Incorrect Answers A:A single constant ignores the contractual differences across selected routes. B:Value-sorting changes chronological order without calculating a target. C:An average of observed values is not the approved contractual threshold.
Question 91 A visitor table has four rows: (East,A), (East,B), (East,A) and (West,C). A page filter selects East. What is DISTINCTCOUNT(Visitors[VisitorID]) for the filtered page? 3, counting visitor C despite the East filter 2, the distinct East visitors A and B 4, counting duplicate East visits separately 1, because repeated A suppresses distinct B Explanation Correct Answer B:The East filter excludes West visitor C, and repeated East visitor A counts once. Incorrect Answers A:C occurs only in West, outside the selected context. C:DISTINCTCOUNT counts distinct IDs rather than all event rows. D:B is a separate visitor and remains visible in the filtered rows.
Question 92 A fundraising data column contains `North` in most rows and `North` followed by a nonprinting tab in a subset. The spaces have already been trimmed, but the values still form separate groups. Which Power Query text operation specifically addresses this defect? Use a DAX YEAR extraction on the category text Use Text.Clean to remove control characters, then confirm the grouped values match Change the fundraising category to Whole Number Unpivot the category into attribute and value rows Explanation Correct Answer B:Text.Clean targets nonprinting control characters, including tab characters, that basic whitespace trimming might leave behind. Incorrect Answers A:YEAR extracts calendar components and has no role in removing control characters from region labels. C:Text labels are categories and do not become valid numbers by changing their type. D:Unpivot reshapes columns; it does not remove the hidden control characters that fragment groups.
Question 93 A lender merges a loan fact with a Branch lookup. Some loans reference retired branch IDs; the auditor requires those transactions preserved, showing blank branch names pending cleanup. Which join kind should be used? Left outer join with loans as the left table, followed by expansion of the Branch attribute Inner join that discards unmatched loan rows Right anti join returning only unmatched lookup branches Append the Branch table underneath the loan facts Explanation Correct Answer A:Left outer keeps every loan even without a matching lookup row, making data quality gaps visible. Incorrect Answers B:Inner join would silently remove unmatched loans and understate balances. C:Right anti returns unmatched lookup entries, not all loan facts. D:Appending tables stacks rows rather than matching attributes by key.
Question 94 A wholesale distributor needs its deliveries report to support screen readers, keyboard use, readable labels, and alternatives to color-only status cues. What should the analyst prioritize? Color-only red/green indicators with no text Hide every visual title and disable keyboard interactions Use small images of numbers instead of accessible text Accessible alt text, tab order, legible contrast, and meaningful labels Explanation Correct Answer D:Alt text, tab order, labels and contrast help consumers of deliveries reports using different assistive technologies. Incorrect Answers A:Color alone excludes users who cannot reliably distinguish the chosen colors. B:Hidden labels and disabled keyboard navigation reduce usability. C:Rasterized numbers are less accessible than semantically labeled native values.
Question 95 A call center gives a user an app that uses a model with RLS. That user also has Viewer workspace access and Build permission. Will the viewer’s permitted row set still be constrained by RLS? Only the report theme determines the rows Yes; Viewer plus Build does not bypass the assigned RLS filter No; any Build permission automatically disables RLS No; all app consumers get unrestricted access Explanation Correct Answer B:Microsoft documents that RLS still applies to Viewers given Build permission; permitted support cases rows remain filtered. Incorrect Answers A:Visual themes control presentation, not row entitlements. C:Build enables creating derived content but does not itself elevate a Viewer to an RLS-exempt workspace editor. D:App access does not grant a universal exemption from semantic-model row security.
Question 96 Operations leaders need one Power BI service landing canvas with a pinned customer-renewal KPI from one report and a production-availability tile from another. The underlying reports must remain separate. What item supports this cross-report overview? A new ordinary report page that can only use one existing report’s canvas A Power BI app audience definition by itself A paginated report designed for fixed-page printing A Power BI dashboard with pinned tiles from the supported source reports Explanation Correct Answer D:Power BI dashboards collect pinned visuals from one or more reports into a single overview canvas without merging their underlying report pages. Incorrect Answers A:A report page does not automatically aggregate previously pinned tiles from separate reports as a service dashboard does. B:An app controls packaged content distribution but does not itself create the requested combined pinned-tile canvas. C:Paginated reports serve repeatable printable layouts rather than a dashboard of independently pinned service tiles.
Question 97 An aviation services group has one unique row per Airports member and thousands of maintenance tasks rows referring to each member by its key. To make a slicer on Airports filter the transactions, what is the appropriate relationship cardinality? One-to-many from the Airports dimension to the maintenance tasks fact Many-to-many because maintenance tasks has many rows One-to-one from Airports to maintenance tasks Many-to-one in which maintenance tasks is the unique side Explanation Correct Answer A:The Airports key is unique in the dimension and repeated in maintenance tasks, making the dimension the one-side and transactions the many-side. Incorrect Answers B:Many-to-many would require repeated keys on both sides; the Airports lookup is explicitly unique. C:One-to-one incorrectly assumes every Airports has exactly one maintenance tasks row. D:The transaction key is not the unique Airports value; reversed one-side cardinality would misdescribe the data.
Question 98 A call center needs the value of HandlingMinutes to appear as a red label when a row falls below the accepted target and as green otherwise. Which report formatting feature is appropriate? Conditional formatting driven by a target rule or measure Create a duplicate import query for each color Change all number fields to text Disable the semantic model refresh Explanation Correct Answer A:Conditional formatting maps the actual HandlingMinutes-to-target condition to a visual color and updates with filters. Incorrect Answers B:Import duplicates cannot dynamically encode a below-target rule in the report. C:Text data types undermine numeric comparison rather than supplying a color rule. D:Refresh configuration does not apply a cell- or visual-level display condition.
Question 99 A water utility receives a daily meter-reading CSV at midnight. Report users ask why a reading uploaded at 10:00 remains absent from the Import dashboard at noon. The model last refreshed at 01:00. What explains this? Import automatically runs one SQL query per report click Changing a slicer causes an on-demand data-source ingestion Import visual queries use the last successful cached refresh; schedule a later refresh after source arrival The dashboard title forces data to remain one day old Explanation Correct Answer C:Import stores data in the model until a later refresh loads new source records. Incorrect Answers A:Ordinary Import does not send a source query on every interaction. B:Filtering cached rows does not ingest new files. D:Titles have no freshness mechanism.
Question 100 A fact table has three rows with Revenue, Profit: (100,20), (0,0), and (200,100). The expression AVERAGEX(Fact, DIVIDE(Fact[Profit], Fact[Revenue])) uses DIVIDE without an alternate result. What percentage is returned? 23.33%, by treating the blank ratio as numeric zero and dividing by three 50%, by using only the last row and discarding the first 35% 70%, by adding the valid percentages without averaging Explanation Correct Answer C:The ratios are 20%, BLANK (zero denominator), and 50%. AVERAGEX averages the two valid numeric results: (20% + 50%)/2 = 35%. Incorrect Answers A:The zero-denominator result is BLANK, which does not contribute a numeric zero to the average. B:The 20% first-row ratio is also valid and must be included. D:Adding percentages without dividing by the count of valid entries is not an average.
