Question 600 A Fabric warehouse report remains functional but becomes substantially slower after a new access policy is introduced. It uses Direct Lake on SQL with Automatic behavior. The team must determine whether one table switched to DirectQuery. What is the most direct diagnostic? Disable all user audit events and infer mode from report appearance Run EVALUATE TABLETRAITS() and inspect DirectLakeFallbackInfo for the model tables Count bookmarks in the report navigation pane Increase the number of slicers to improve column caching Explanation Correct Answer B:TABLETRAITS returns table-level Direct Lake metadata, including a fallback explanation, rather than asking administrators to guess from latency. Incorrect Answers A:Visual appearance cannot distinguish Direct Lake from DirectQuery, and disabling auditing would remove evidence. C:Bookmarks describe report state and cannot reveal a storage-mode fallback. D:More slicers may increase source queries; their count does not identify DirectQuery fallback.
Question 601 A subscription company wants a star-schema model: renewals events repeat the same Plans attributes on millions of transaction rows. After separating dimensions, the source transaction date is still needed for daily sales analysis. Where should that event-date foreign key remain? Only in a report bookmark Discarded because fact tables never have date keys On the fact row linked to a Date dimension Only inside a descriptive geography dimension Explanation Correct Answer C:A date key on each fact row supports filtering by the related calendar dimension. Incorrect Answers A:Bookmarks store display state, not fact date relationships. B:Date foreign keys are common in facts; removing them loses daily analysis. D:Geography dimensions do not represent individual event dates.
Question 602 A rail operator charts daily fare estimates, with separate `[Lower]` and `[Upper]` measures generated from model uncertainty. A manager asks for a constant threshold line at $50 instead. What is the best interpretation? The constant target line is always equivalent to the two computed bounds A constant reference threshold is a different analytic annotation; use calculated error bars when the goal is to show observation-specific intervals Remove the Date axis because uncertainty cannot vary over time Make the forecast label bold and assume the interval is then visible Explanation Correct Answer B:Reference lines serve comparison to a benchmark, while upper/lower error bounds express uncertainty around each plotted estimate. Incorrect Answers A:A single fixed threshold does not vary with estimate-specific confidence limits. C:Time-varying uncertainty is legitimate and can be charted at the date grain. D:Typography does not encode lower and upper numerical limits.
Question 603 A software vendor wants InvoiceAmount to respond dynamically to report slicers. The new requirement is a stable classification assigned to each transaction based on its own amount, and the result must be usable as a slicer. What object fits the new grain? Only a total SUM measure over all selected transactions A formatting string on the report page A bookmark saved before data refresh A calculated column or Power Query column evaluated per row Explanation Correct Answer D:Row-level columns hold stable attributes to group and slice individual transactions. Incorrect Answers A:A total measure cannot supply a discrete classification for each source row. B:Formatting does not compute category membership. C:Bookmarks cannot create row-grain data attributes.
Question 604 A government agency wants a detailed report of Amount by both Districts and fiscal quarter, with row-group subtotals and expansion into underlying groups. Users instead want each individual record, its identifier, date and amount as separate rows; they do not want grouped subtotals. Which visual is the simpler fit? Matrix with unnecessary grouped columns and subtotals Single-card total Waterfall over the identifier Table visual showing the exact selected detail columns Explanation Correct Answer D:A table is suited to flat row-level detail. Incorrect Answers A:Matrix grouping adds hierarchy and totals that were explicitly rejected. B:A card collapses all rows into one number. C:A waterfall conveys additive changes, not a record list.
Question 605 A report’s [PriorYearRevenue] measure is BLANK for a new product with no prior-year records. The requirement is to display 0 only for this presentation metric. Which DAX expression provides that output? FORMAT([PriorYearRevenue], "0") without a BLANK fallback USERELATIONSHIP without a model relationship REMOVEFILTERS(Product) unconditionally COALESCE([PriorYearRevenue], 0) Explanation Correct Answer D:COALESCE returns the first nonblank expression and uses 0 only when the measure is blank. Incorrect Answers A:A format expression does not provide the same explicit numeric fallback semantics. B:Activating date relationships is unrelated to substituting a presentation value. C:Removing the product filter can display another product’s past sales instead of zero for the new item.
Question 606 A customer-location feed contains city values "N/A", "n/a", and true null. Policy states that all three mean missing. How can the analyst make completeness reporting stable? Treat upper- and lowercase N/A as separate real cities Append the table to itself to increase the nonmissing count Normalize the sentinel case and convert those defined N/A markers to null before profiling Rename the City column to Missing without transforming values Explanation Correct Answer C:A controlled case-insensitive sentinel mapping consolidates equivalent missing representations. Incorrect Answers A:N/A case variants are not distinct cities. B:Appending duplicates distorts quality counts. D:Column renaming does not change values.
Question 607 A planning model has a daily refresh schedule but its dashboards display values four days old. Someone proposes running refresh every five minutes without investigating. What should happen first? Change the report background and assume the data becomes current Inspect refresh history and connection errors to identify why recent scheduled refreshes failed Delete the date table to permit more frequent ingestion Hide the Refresh button from workspace owners Explanation Correct Answer B:Increasing schedule frequency does not fix failed authentication or transformation errors. Incorrect Answers A:Visual color does not affect data staleness. C:Deleting date relationships can break time intelligence. D:Hiding controls obscures the problem instead of finding it.
Question 608 An insurance company applies a Highly Confidential sensitivity label to a Power BI report. Regional viewers must still be limited to their own customers. Which additional control meets the data-level requirement? Set the report background to red to warn unauthorized readers Use only a bookmark showing a region-filtered page as the security boundary Row-level security with tested region filters and authorized role membership Assume the report label automatically filters customer rows by region Explanation Correct Answer C:Sensitivity labels classify/protect content under policy, whereas RLS enforces row-level model filtering for eligible consumers. Incorrect Answers A:Color formatting cannot enforce data access. B:Bookmarks and visual filters can be changed or bypassed by authorized model querying; they are not row security. D:Classification labels do not automatically create user-to-region row filters.
Question 609 A government agency has a geographic map, a bar chart, and a monthly total. A selected bar is currently dimming a compliance KPI that must always display the overall total, while other charts should still be highlighted. How should this be configured? Set that bar-to-KPI interaction to None while keeping other interactions Disable all interactions globally in every page Remove the fact-to-dimension relationship Rename the KPI measure Explanation Correct Answer A:Edit interactions can selectively exclude the KPI from one source visual’s selection effects. Incorrect Answers B:A blanket global stop removes required interactions on other charts. C:Relationship deletion breaks semantic filtering across the report. D:Renaming does not affect selection propagation.
Question 610 A source file contains a text code such as `DE|Hamburg` in one field. Reports need CountryCode and City as separate attributes, and the pipe is a fixed delimiter. Which Power Query transformation is appropriate? Append the same source rows twice Unpivot every source field into a single value column Replace every code with a row number Split the composite column by the `|` delimiter into CountryCode and City columns, then validate the values Explanation Correct Answer D:Split Column by Delimiter separates the two known components without changing the row grain. Incorrect Answers A:Appending duplicates observations and does not separate code components. B:Unpivot changes table shape but does not parse the two portions of one text value. C:Sequential row numbers erase the country and city information needed for analysis.
