Question 400 A shipping model contains both OrderDate and ShipDate. Most pages analyze orders placed; a shipping-only KPI must count orders by ship month. How should the report author preserve the default while meeting the exception? Create a bidirectional relationship between the two Date columns themselves Keep OrderDate active and use an alternate ShipDate relationship within the shipping-specific measure Permanently activate the ShipDate path for all measures Change ShipDate to text and sort by month name Explanation Correct Answer B:The measure can activate its inactive ShipDate relationship through USERELATIONSHIP without changing default order KPIs. Incorrect Answers A:Joining two Date columns directly is not the fact-to-date role pattern. C:Changing the global relationship would alter the meaning of other order reports. D:Text dates lose reliable time-based relationship filtering.
Question 401 A dashboard author needs a comparison of 45 store regions, but the Small multiples grid settings allow at most six rows and six columns in one visible grid. What should the author plan? Increase row and column settings to 30 each without limit Use up to a 6×6 grid with additional panels loading through scrolling, or narrow the selection Make all 45 regions a single numeric average and call them separate panels Create a distinct semantic model for every region just to display it Explanation Correct Answer B:Small multiples supports a bounded grid, with additional panels rendered as consumers scroll. Incorrect Answers A:The grid layout settings have documented maximums. C:One aggregate loses the per-region comparison. D:Model duplication is unnecessary for faceting by Region.
Question 402 A DirectQuery sales report responds slowly only when filtering a large SQL table by CustomerID. The query plan shows a full table scan because CustomerID has no suitable index. Where is the best first optimization? Evaluate a supported source-side index/query plan improvement for the selective predicate Change all chart colors Add more report bookmarks Convert CustomerID to a free-text visual title Explanation Correct Answer A:DirectQuery depends on source query execution; indexing a selective lookup can reduce scanned rows. Incorrect Answers B:Themes do not affect SQL access paths. C:Bookmark quantity does not create an index. D:Report titles are not indexed source predicates.
Question 403 A sensor fact table contains four rows, two with blank Weight readings. A measure counts rows of the table after a filter that keeps all four records. How many rows does COUNTROWS return? 2 4 0 BLANK() Explanation Correct Answer B:COUNTROWS counts table rows regardless of whether one column contains BLANK values. Incorrect Answers A:Two would count only nonblank Weight values. C:The filter leaves all four rows. D:BLANK is returned only if no rows remain.
Question 404 A business margin measure recalculates the same complex filtered revenue expression three times in branches of an IF statement. What DAX refactoring can reduce repeated work and improve clarity? Add three nested FILTER iterators to each branch Compute the shared expression once in a VAR and reuse it in the RETURN expression Convert the measure to a calculated text column for every fact row Remove all model relationships and replace them with visual captions Explanation Correct Answer B:A variable stores a reusable intermediate expression result in its evaluation context. Incorrect Answers A:More redundant iterators may add cost rather than remove it. C:Text columns do not preserve dynamic measure semantics. D:Captions cannot replace the underlying filter context or relationships.
Question 405 A game publisher has grouped a logo, shape border, and explanatory text in the Selection pane. For an executive presentation mode, all three decorative objects must hide together while charts and model data remain visible. What should the author use? Delete the underlying purchase fact table to hide the decoration Remove model RLS to simplify the page Change the Date table sort order and hope the visuals move off screen Toggle the visibility of the object group in the Selection pane or capture its display state in a bookmark Explanation Correct Answer D:Grouped report objects can be controlled together for a display layout without modifying semantic-model data. Incorrect Answers A:Deleting fact data affects analysis and does not target decorative objects. B:RLS is a data-security control and cannot hide a decorative report group. C:Calendar sorting does not govern the visibility of annotation objects.
Question 406 A ticket-validation API sends several versions of one TicketID; status and LastUpdated differ. Only the latest approved version per ticket should feed the current-state dashboard. Why is bare Remove duplicates on TicketID inadequate? Assume Remove duplicates always keeps the latest timestamp automatically Retain every revision as if it were a separate active ticket Determine the latest valid LastUpdated row per TicketID through a deterministic grouping/selection rule Replace each timestamp with a constant date before deduplication Explanation Correct Answer C:Power Query does not guarantee which duplicate survives; current-state selection must explicitly use version/time rules. Incorrect Answers A:Default duplicate removal does not promise latest-value retention. B:Counting all revisions multiplies a single current ticket. D:Overwriting timestamps destroys the ordering evidence.
Question 407 A project manager asks for a multi-page dashboard with monthly report pages and drillthrough navigation. What Power BI distinction should the author explain? Dashboards always have unlimited built-in pages A report cannot contain multiple pages A model relationship creates dashboard pages automatically Dashboards are single-page canvases; use a report for multi-page interactive navigation Explanation Correct Answer D:Dashboards summarize tiles on one page, whereas reports provide multiple pages and richer interactions. Incorrect Answers A:Multi-page content belongs to reports rather than dashboard page structure. B:Reports can have multiple designed pages. C:Relationships filter model data, not dashboard page count.
Question 408 A semantic model owner removes a contractor from the published app audience. The contractor can still create thin reports on the model. What permission must the owner additionally inspect? Only whether the app title changed Only the report background image The contractor’s remaining direct or inherited Build grants on the semantic model Only the number of pinned dashboard tiles Explanation Correct Answer C:Model Build rights may persist outside an app audience assignment and must be revoked through the proper access path. Incorrect Answers A:A title change does not revoke permissions. B:Background images do not control model reuse. D:Pinned tile count is unrelated to model Build entitlements.
Question 409 An analyst is experimenting with aggressive outlier removal on one copy of an approved claim-processing Power Query. The official query must continue unchanged while outcomes are compared. What action isolates the trial? Duplicate the approved query and modify only the duplicate Edit the approved query directly so every dependent report changes at once Reference the approved query and then alter upstream shared steps for the trial Disable load on the original and treat the experiment as production Explanation Correct Answer A:Duplicate copies the existing transformation definitions so experiment-specific changes can be managed separately. Incorrect Answers B:Direct production changes violate the requirement to retain the approved baseline. C:Changing shared upstream steps affects references and does not isolate the experiment. D:Disable load only controls whether a query becomes a model table.
Question 410 Three branches have profitability measures 12, BLANK(), and -4. A numeric RANKX over those three branches uses descending order. Under the documented BLANK comparison behavior, what rank does the blank branch take? 1 3 2 BLANK() Explanation Correct Answer C:For numeric ranking, BLANK is treated as zero, which falls between 12 and -4. Incorrect Answers A:The positive 12 takes first place, exceeding the blank-treated-as-zero value. B:Negative four is below zero and ranks third in descending order. D:A blank measure does not necessarily yield a blank ranking; RANKX treats numeric BLANK as zero.
