Question 590 A warehouse wants to shorten a 100-column imported fact table. Six columns are currently hidden in the Fields pane but used in relationship definitions and security expressions. Which action is safe? Delete every hidden column automatically because hidden means unused Review all model dependencies before physically removing columns; hidden fields may still be essential Replace the hidden relationship keys with a visual bookmark Increase source rows to compensate for removed attributes Explanation Correct Answer B:Hidden is only a visibility setting; it does not prove that model columns are unused. Incorrect Answers A:Deleting essential hidden keys can break model joins or RLS. C:Bookmarks cannot substitute for semantic-model fields. D:Adding more rows increases memory and does not repair missing relationships.
Question 591 An energy utility created two report views: an overview and a detail layout with different visual visibility and filter state. The new buttons should switch visual visibility without resetting the consumer’s active slicer selections. What bookmark setting should be controlled? Delete all slicers from the page Remove all report relationships Turn off the bookmark Data option when saving display-only states Reenable Data so every click restores an old slicer choice Explanation Correct Answer C:Excluding Data from a display-state bookmark avoids overriding active filters. Incorrect Answers A:Deleting slicers loses necessary consumer filtering. B:Removing relationships breaks intended filter propagation. D:Capturing Data would restore the stored slicer state.
Question 592 A JSON feed for a government agency returns a list of service applications objects, each with an embedded record for Districts. The expanded JSON amount arrives as text although it must be summarized numerically. Which post-expansion step is required? Disable every query load Set the expanded amount to an appropriate numeric data type, handling invalid values Use text concatenation to summarize currency Convert the amount into a report page bookmark Explanation Correct Answer B:Numeric types allow reliable aggregation once the nested field is available. Incorrect Answers A:Disabling all loads would prevent access to the required parsed data. C:Text concatenation is not arithmetic summation. D:Bookmarks concern visuals and cannot type source fields.
Question 593 A utility invoice field stores two-decimal currency amounts and must be aggregated repeatedly without binary floating-point rounding surprises. Which Power Query data type is generally preferable? True/False, with each positive value treated as one unit Fixed Decimal Number (currency) for four-decimal-place scaled precision Whole Number, discarding all invoice cents Text formatted with a currency symbol before the calculation Explanation Correct Answer B:Fixed Decimal Number stores scaled integer-based decimals and is suited to money calculations where decimal precision should be predictable. Incorrect Answers A:Boolean conversion destroys the amounts needed for sums and averages. C:Whole Number cannot preserve cents. D:Text formatting prevents numeric arithmetic unless the values are parsed back.
Question 594 A partner must view a published logistics report. A technician proposes adding the partner as workspace Contributor because a report link was rejected. What is the better initial check? Automatically give Contributor and data edit rights Review the app/report item audience and semantic-model access needed for consumption, without workspace editing rights Disable the entire organization’s RLS rules Publish source database passwords as a report appendix Explanation Correct Answer B:Consumption should be granted at the narrowest relevant item/audience level. Incorrect Answers A:Contributor authoring rights exceed partner consumption needs. C:Disabling RLS would expose unrelated records. D:Passwords should not be disclosed to consumers.
Question 595 A security team removes a report from the app’s Legal audience. The report remains in the workspace for internal editors. What should be validated after updating the app? Legal audience access to the report and any separate direct/shared item grants Only the color of the Legal audience banner Delete all underlying model tables for every audience Assume removing an app item revokes any independent link or workspace access Explanation Correct Answer A:App membership and independently granted item/workspace access are distinct paths that must be checked. Incorrect Answers B:Colors reveal nothing about effective data entitlement. C:Deleting models harms authorized consumers unnecessarily. D:Direct sharing or workspace rights can survive app audience changes.
Question 596 A support center has two active role-playing date dimensions, Created Date and Resolved Date, each related to the ticket fact. In the Fields pane they both show a field named Year, so new report authors cannot tell which time role they are using. What usability change preserves the model? Deactivate both relationships and replace dates with free-text labels Create another fact table for every calendar year Use clear role-specific field labels such as Created Year and Resolved Year and document both relationships Rename both fields to Date without indicating their event roles Explanation Correct Answer C:Distinguishing the two active date roles in field names avoids mistaken slicer selection while keeping the modeled time relationships intact. Incorrect Answers A:Removing relationships breaks the time filtering needed by both created and resolved analysis. B:Partitioning by year into independent facts is not necessary for field discovery. D:An ambiguous common label still conceals whether a field applies to creation or resolution.
Question 597 A factory leadership team needs a report tile showing current OutputUnits, the quarterly target, and a time-based trend that reveals whether the plant is approaching that target. Which Power BI visual should the analyst consider? A pie chart treating actual and target as mutually exclusive segments A table containing just the page title A KPI visual with indicator, trend axis, and target measure A plain Card visual containing only the current OutputUnits total Explanation Correct Answer C:The KPI visual supports a current indicator, a goal measure, and a trend axis, presenting progress toward the business target. Incorrect Answers A:Actual and target are different measures, not components of one categorical whole. B:A title supplies no analytical status or progress indicator. D:A single-value card omits the target and trend context the executives requested.
Question 598 An invoice fact has rows (Quantity, UnitPrice) = (2,10) and (3,7). There is no stored LineAmount. What does SUMX(Fact, Fact[Quantity]*Fact[UnitPrice]) return? 17, the sum of the unit prices without quantities 35, multiplying all quantities by the average price incorrectly 41, summing 2×10 plus 3×7 6, the total quantity plus one Explanation Correct Answer C:SUMX multiplies each row’s quantity and unit price then adds the two line totals. Incorrect Answers A:10+7 ignores row quantities. B:SUMX uses each row’s own unit price, not an unrelated average. D:Quantity totals do not substitute for extended line revenue.
Question 599 A factory group wants hovering over one Plants category in a chart to display a small, rich contextual page with trend and cost information. The requested detail grows into a full investigative page rather than a quick hover popup. What feature should replace the tooltip? A tooltip whose maximum size remains a small popup A report page tooltip that remains a hover popup with limited exploration A bookmark that returns to a predefined overview without passing the selected Plant Drillthrough navigation filtered to the selected category Explanation Correct Answer D:Drillthrough takes the selected context to a full details page. Incorrect Answers A:A tooltip is transient and not intended as a full analytic page. B:A tooltip can show context but does not provide the requested persistent full investigative page. C:A bookmark restores saved state and does not inherently pass the current source data point as drillthrough context.
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.
