Question 320 A support-case model uses CreatedDate as the active Date relationship. Only the [Closed Cases] metric needs to follow CompletionDate, while all existing CreatedDate reports must remain unchanged. The report does not require separate simultaneous Date slicers. Which approach fits? Use CALCULATE with USERELATIONSHIP for the [Closed Cases] metric and retain the active CreatedDate relationship Activate both Date relationships from the same Date table globally Duplicate one Date dimension for every support case row Convert CompletionDate to text to stop unwanted filters Explanation Correct Answer A:USERELATIONSHIP applies the alternate date role within the specified measure without altering the default date filtering used by existing reports. Incorrect Answers B:Two simultaneous active paths from one Date table to the fact lead to ambiguous filters. C:Role-playing dimensions, when needed, are shared dimensions rather than per-fact-row copies. D:Text type prevents normal date filtering and does not implement the alternate relationship.
Question 321 An author already has a DAX measure returning valid hex colors for each product risk group. The table must use exactly those result colors for background fill. Which formatting mode fits? Format by Field value using the color-returning measure Rules comparing month names alphabetically A static theme applied equally to every item Convert the risk measure to an unrelated date field Explanation Correct Answer A:Field value formatting accepts an appropriate color field/measure to determine each cell’s fill. Incorrect Answers B:Month-label ordering cannot reproduce a specified hex color mapping. C:A static theme ignores per-product values. D:Date conversion does not supply the color codes.
Question 322 A Fabric warehouse exposes a sales result only as a SQL view. A semantic model using Direct Lake on the SQL analytics endpoint begins answering queries through DirectQuery. The capacity team wants Direct Lake scans rather than fallback. Which change directly addresses the view limitation? Add a Power Query text-index column to the report page Materialize the SQL view result as a supported Delta table and use that table in the Direct Lake model Set DirectLakeBehavior to Automatic and leave the view unchanged Enable row-level security on the SQL view to force in-memory scans Explanation Correct Answer B:Direct Lake reads physical Delta-backed tables. A SQL view has no materialized Delta data to page, so materializing the result removes this fallback trigger. Incorrect Answers A:A calculated report field does not alter the physical storage underlying a SQL view. C:Automatic is the fallback policy; it preserves DirectQuery execution instead of making the view eligible for Direct Lake. D:SQL-endpoint RLS is another reason a Direct Lake-on-SQL query can fall back, not a cure.
Question 323 A factory group has a finished production records transformation to reuse as a frozen starting point for an experiment. A temporary validation copy must be changed without affecting production, and production changes should not flow into this branch. What action preserves independence? Append the query to itself Change the production query in place Duplicate the query and edit the copied applied steps Reference the production query and expect permanent independence Explanation Correct Answer C:Duplicate makes a separate set of steps that can evolve independently. Incorrect Answers A:Append duplicates data rather than creating a new independent transformation history. B:Changing production directly contradicts the isolated validation requirement. D:Reference remains linked to production results and can inherit later changes.
Question 324 A retail store sold 250 units this September and 200 units in September last year. What YoY growth percentage should a measure calculate using the prior-year value as denominator? 20% growth, dividing 50 by current-year sales 125% growth, dividing current total by prior total without subtracting one 50% growth, reporting the absolute increase as a percent without scaling 25% growth Explanation Correct Answer D:The increase of 50 divided by the prior-year 200 gives 25 percent. Incorrect Answers A:Current-year denominator answers a different ratio, not standard YoY growth. B:250/200 is the index ratio; growth is the ratio minus one. C:The raw increase of 50 units must be divided by the 200-unit prior base.
Question 325 A dashboard’s keyboard focus jumps from the footer to the last slicer and back to the header. Keyboard-only users cannot follow the report logically. Which authoring change helps? Make every visual title transparent Replace all slicers with static pictures Sort the raw fact table by timestamp in Power Query Set the intended Tab order for visuals and interactive controls in the Selection pane Explanation Correct Answer D:The report’s visual tab-order settings govern how keyboard focus proceeds among supported elements. Incorrect Answers A:Transparent headings remove visual cues without changing focus sequence. B:Static images remove filtering interaction and may worsen accessibility. C:Fact-table sorting does not determine focus navigation.
Question 326 A retail workspace has a Contributor who maintains several reports. The workspace Admin wants this Contributor to update the existing app after content changes without giving full Member permissions. What supported governance setting enables this? Have the workspace Admin explicitly allow Contributors to update the workspace app, then verify app audience settings Grant all report readers Editor rights so app updates occur automatically Hide the semantic model ID to bypass app publishing permissions Change the report’s storage mode from Import to DirectQuery Explanation Correct Answer A:Power BI allows a workspace Admin to delegate the ability to update the app to Contributors; it is not an automatic Contributor entitlement. Incorrect Answers B:End-user edit permission is unnecessary for app updates and is contrary to least privilege. C:Hiding metadata affects usability but cannot grant app-management capabilities. D:Storage mode is unrelated to the app update authorization path.
Question 327 A software vendor wants InvoiceAmount to respond dynamically to report slicers. The report needs a percentage of selected totals that changes whenever customers filter categories. Which calculation location supports this behavior? A data-source password setting A measure using filter-context-aware DAX such as DIVIDE and CALCULATE A calculated column storing one constant percent from refresh A static report tooltip image Explanation Correct Answer B:Measures recalculate numerator and denominator under slicer context and can adapt the selected total. Incorrect Answers A:Credentials do not implement DAX filter context. C:Refresh-time columns do not generally recompute percent-of-total from arbitrary report selections. D:A screenshot is not a dynamic calculation.
Question 328 A cost report has a working visual-only running total. Another team now needs the exact calculation as a field in an external DAX query and across several report pages. Which redesign meets that requirement? Rely on the visual calculation as a global model measure without any change Define a suitable reusable DAX measure in the semantic model and validate its filter context Copy a visual calculation into a report title and treat it as a model field Pin the visual calculation to a dashboard and assume the underlying DAX is exported Explanation Correct Answer B:Visual calculations are stored on individual visuals. A model-level measure is the reusable calculation object needed by other reports and external queries. Incorrect Answers A:Visual-local calculations do not automatically become semantic-model calculations. C:Titles do not expose evaluated DAX fields. D:Visual calculations cannot be pinned as independent reusable measures.
Question 329 A JSON feed for a government agency returns a list of service applications objects, each with an embedded record for Districts. The inner Details field is itself a list of records, one record per line item. What sequence reveals one row per line item? Keep each entire JSON array as a single text cell Pivot the list without expanding nested structure Group the document before parsing its records Expand the Details list into rows, then expand each record to columns Explanation Correct Answer D:Expanding list to rows and then records to columns exposes each line-item attribute. Incorrect Answers A:Text preservation hides the line-item structure that reports need. B:Pivot cannot directly flatten nested arrays without first extracting tabular rows. C:Grouping before parse removes necessary line-item detail.
Question 330 A team attempts anomaly detection on a categorical chart of StoreName, with no time series. What must change to evaluate unusually high weekly demand over time? Rename the StoreName category to Date without changing its values Use a supported line chart with a valid time axis and numeric demand series Create a bookmark containing a high demand value Convert demand to text and use a pie chart Explanation Correct Answer B:The feature analyzes a numeric time series rather than an arbitrary category ordering. Incorrect Answers A:Renaming a category does not create chronological values. C:Bookmarks capture view states and do not detect deviations. D:Text and pies discard the temporal numeric series.
