Question 520 A model has daily handling minutes [10,20,30,40]. The measure AVERAGEX(FILTER(Fact, Fact[Minutes] > 20), Fact[Minutes]) has no other filters. What is its numeric result? 35 25, averaging all four rows regardless of the FILTER predicate 30, taking only the first qualifying row 70, by adding qualifying values without dividing Explanation Correct Answer A:FILTER keeps minutes 30 and 40; the iterator averages those values to (30+40)/2=35. Incorrect Answers B:10 and 20 fail the strict greater-than-20 filter and must be excluded. C:40 is another qualifying row, so 30 alone is incomplete. D:The sum of the qualifying values is 70, but AVERAGEX divides it by two to return 35.
Question 521 A retail model stores five years of transactions, but only the latest 30 days change after settlement. Leadership wants less refresh processing without losing old reports. What policy suits? Delete all historical partitions after every refresh Refresh the entire five-year history every minute Keep a historical storage period and refresh only a recent rolling window using incremental refresh Disable all model refresh indefinitely Explanation Correct Answer C:A retention window plus narrower refresh window reduces work while keeping approved historical facts. Incorrect Answers A:Deleting history breaks trend reports. B:Full repeated refresh defeats the efficiency goal. D:No refresh leaves recent changes invisible.
Question 522 An operations report overlays a close button, a chart, and a legend panel. A keyboard-only tester reaches invisible controls before the active menu. Which authoring setting should be adjusted? Sort an unrelated transaction table by month Increase the number of bookmarks without changing focus order Change the semantic-model sensitivity label Set the supported Tab order and visual visibility deliberately in the Selection pane Explanation Correct Answer D:A deliberate focus order and appropriate visibility keep keyboard traversal logical for interactive report elements. Incorrect Answers A:Fact-table sort order does not control the keyboard focus sequence among visuals. B:More bookmarks preserve display states but do not automatically correct focus order. C:Sensitivity labels classify and protect content rather than manage focusable controls.
Question 523 A transit authority needs the share of validations with Fare above a policy threshold for the month and station currently selected in a Power BI report. Which calculation object stays correct as slicers change? A data-source credential parameter set to the selected station A static image copied from the previous month’s dashboard A DAX measure computing filtered high-fare count divided by filtered total validations A fixed column containing the citywide threshold percentage from the last refresh Explanation Correct Answer C:Both counts can be evaluated in the current date/station filter context, making the percentage responsive to selections. Incorrect Answers A:Credentials do not implement calculation or visual filter context. B:Static imagery is not a DAX calculation and will not change with a slicer. D:A stored citywide percentage cannot reflect arbitrary future station and month selections.
Question 524 A shipping provider needs an official 1,200-page carrier invoice register with fixed page breaks, repeated headers and PDF exports. An interactive dashboard is not an acceptable archival output. What should the team build? A scatter chart relying on hover tooltips for each invoice line A bookmark sequence of 1,200 pages within an interactive report A paginated report with controlled layout and page-based printing/export A single card visual showing the sum of all invoices Explanation Correct Answer C:Paginated reports are designed for detailed multipage print-ready output with specified pagination and export layouts. Incorrect Answers A:Hover tooltips cannot produce a predictable 1,200-page register. B:Bookmark navigation is interactive report state, not a reliable print pagination facility. D:A card omits the required per-invoice records and headers.
Question 525 A Power Query model has StagingOrders, which reads and cleans an expensive source, and two final queries that Reference it. StagingOrders should not appear as a separate model table, but both final queries must continue refreshing. What setting should change? Duplicate the raw connector call for both final tables and delete their common cleaning steps Disable Enable load for StagingOrders while keeping the query and its dependent references Delete StagingOrders and let its final queries refer to a missing query Disable refresh for all dependent final queries Explanation Correct Answer B:Disabling load excludes the staging output from the model while keeping the query as a transformation dependency. Incorrect Answers A:Duplicating source reads wastes resources and risks divergent cleaning logic. C:Deleting a referenced query breaks the downstream expressions. D:Stopping all dependent refreshes leaves the final tables stale.
Question 526 A weekly stock balance is 140 on Monday, BLANK on Tuesday, and 125 on Wednesday. A measure wants the latest available numeric balance through Wednesday. Which logic is suitable? Sum all snapshots as if each were a distinct sale Evaluate the last date whose balance expression is not blank, returning Wednesday’s 125 Return Tuesday’s BLANK because it lies between the other dates Always use the first known balance of 140 Explanation Correct Answer B:LASTNONBLANKVALUE or equivalent logic locates the latest date with a nonblank expression, not the sum of balances. Incorrect Answers A:Balances are point-in-time levels and should not be summed over dates. C:Wednesday is later and has a populated balance. D:The requested logic is latest, not earliest nonblank snapshot.
Question 527 A financial reporting model has passed central data quality tests. An analytics manager wants the Certified badge rather than Promoted. What must be true before that change? The report author can always self-certify regardless of organization policy Enabling bidirectional relationships automatically confers certification A user authorized by tenant certification settings must certify the model Any consumer with Viewer rights can certify models by clicking Follow Explanation Correct Answer C:Power BI certification is a controlled endorsement requiring permission, not simply a label chosen by an ordinary author. Incorrect Answers A:An organization can restrict certification to specific authorized users. B:Relationship topology has no connection to endorsement authority. D:Viewer and Follow capabilities do not grant certification rights.
Question 528 A developer sets the confidential HR source privacy level to Private and concludes that only HR employees can view the final report. What security distinction is missing? Privacy levels govern mashup data movement; report item permissions and semantic-model RLS govern who may see rows Private privacy level automatically assigns every HR user to an RLS role Private source flag is identical to Microsoft Entra group membership A report bookmark named HR Secured enforces authorization Explanation Correct Answer A:The mashup firewall and consumer row-level authorization are different mechanisms. Incorrect Answers B:A source privacy flag does not create user security roles. C:Entra membership is identity authorization, not a Power Query privacy setting. D:Bookmarks are display state, not access policy.
Question 529 A logistics dataset contains delivery status labels " Ready " and "Ready"; another valid label is "Ready for pickup". A cleaning rule must group padded values without merging different internal phrases. Which transformation is appropriate? Apply Text.Trim to the status field, preserving the internal space between words Use Text.Remove with the space character on the entire field Apply Text.Clean and assume it always strips ordinary boundary spaces Replace every status containing "Ready" with the identical value "Ready" Explanation Correct Answer A:Text.Trim removes leading and trailing spaces while leaving the meaningful internal space in "Ready for pickup" unchanged. Incorrect Answers B:Removing all spaces would turn "Ready for pickup" into "Readyforpickup", changing valid text. C:Text.Clean addresses control characters, whereas ordinary leading/trailing spaces are handled by Trim. D:A contains-based replacement collapses a specific status into a broader one, losing business meaning.
Question 530 A national bookstore has an Orders-like book sales query with ReceiptID, a Shops key, and NetSales. The analyst is required to construct a quality-control subset containing only transactions with a matching approved lookup entry; missing keys must be excluded. Which merge join kind does this? Full outer join retaining even unmatched records Append the two differently shaped queries Inner join on the approved lookup key Left anti join of unmatched transaction keys Explanation Correct Answer C:Inner join returns only key matches on both sides, the approved subset requested. Incorrect Answers A:Full outer includes unapproved and orphaned lookup rows as well as matches. B:Appending is a vertical union, not the required key-validation join. D:Left anti returns the opposite set: rows with no matching lookup.
