Question 210 A report must color defects per batch: green below 2%, amber from 2% through 5%, and red above 5%. What formatting mechanism implements this clearly? Conditional-format rules with explicit numeric range boundaries for the measure A single unconditional background color for every row Changing every defect percentage to text labels and sorting by name A random fill color determined by visual rendering order Explanation Correct Answer A:Threshold rules map each rate into the declared bands without changing the measure itself. Incorrect Answers B:A uniform fill cannot show three performance categories. C:Text conversion is unnecessary and can break numeric boundary comparisons. D:Random formatting is not aligned with approved defect criteria.
Question 211 A report contains a complex waterfall chart of net margin drivers. A screen reader announces only its default title, but not the message of the graphic. What can the author add? Only a decorative gradient background A smaller font to fit more labels A hidden SQL password field Meaningful visual alt text describing the chart’s purpose and key interpretation Explanation Correct Answer D:Alt text supplements visual names with context screen-reader users need to interpret the chart. Incorrect Answers A:Background styling does not communicate substantive findings. B:Tiny text worsens readability and adds no assistive description. C:Credentials are unrelated and should not be embedded in reports.
Question 212 A sports ticketing analyst uses the Key Influencers visual to see that returning attendees are associated with season-ticket renewals. A manager wants to treat the association as proof that offering additional games will cause renewals. Which conclusion is justified? The visual automatically ran a randomized controlled trial across spectators. The visual changes each spectator record to match its top explanatory factor. The visual identifies associations in observed data; causal impact needs an appropriate experimental or causal design. Any correlated factor proves that raising ticket prices increases renewal rates. Explanation Correct Answer C:The strength of an observed association can guide investigation, but it cannot establish a causal intervention effect by itself. Incorrect Answers A:Key Influencers operates on observational model fields; it does not randomly assign spectators to interventions. B:The visual analyzes rows; it does not change attendance or renewal records. D:An association with attendance contains no evidence that a ticket price rise will cause more renewals.
Question 213 A finance team has a mixed-performance Direct Lake on SQL semantic model. One table may be falling back to DirectQuery; they need a table-level reason before remediation. What DAX diagnostic should they run? Evaluate TABLETRAITS() and inspect DirectLakeFallbackInfo for the affected table Query only total revenue and infer every table’s fallback from the final number Switch every report page into Focus mode Disable refresh and assume fallback is resolved Explanation Correct Answer A:TABLETRAITS exposes per-table Direct Lake fallback information, including the reported cause. Incorrect Answers B:An aggregate result provides no per-table fallback diagnostic. C:Focus mode changes page display, not the storage execution path. D:Disabling refresh can leave tables unframed and does not diagnose fallback.
Question 214 An education provider has Subject, OrderID and NetFee fields. Several OrderIDs repeat across multiple line items for one Subject. The business needs one row per Subject containing the sum of fees and a count of distinct orders, not a count of order lines. Which Group By logic fits? Count all subject lines as separate orders even when OrderID repeats Group only on OrderID and omit the required subject grouping Group by Subject, sum the NetFee amounts, and count distinct OrderID values within each subject group Remove every repeated OrderID line before summing, even if each line contains a legitimate different charge Explanation Correct Answer C:Distinct OrderID within Subject avoids double-counting multi-line orders while Sum(NetFee) preserves the monetary contributions of all valid lines. Incorrect Answers A:Line count can exceed order count when multiple charges share one OrderID. B:Grouping only by order does not produce one requested Subject summary record. D:Dropping valid charge lines would understate subject revenue totals.
Question 215 A report slicer selects East, whose sales total 40; West totals 60. A measure is CALCULATE([Sales], REMOVEFILTERS(Region[Region])). Assuming no other filters, what amount does it return? 40, the current East amount 100, the combined sales across East and West 60, West only BLANK because REMOVEFILTERS removes fact rows Explanation Correct Answer B:REMOVEFILTERS on the Region column clears the East slicer for this measure, including both regions. Incorrect Answers A:The Region filter is explicitly cleared for the measure. C:Clearing the Region filter does not impose a new West filter. D:The modifier clears filter context on the column; it does not delete underlying data.
Question 216 A payment report’s Power Query against SQL Server applies a custom text transformation that cannot fold, followed by a filter limiting transactions to the last week. The team wants the server to reduce rows before local processing, with unchanged final results. What order should be evaluated? Keep the expensive nonfoldable transform before the date predicate to force every historical row across the network Move the foldable date filter before the nonfoldable custom step, after verifying the two steps are semantically safe to reorder Delete the date predicate and use a slicer after importing all rows Convert the SQL connection into an unrelated published report bookmark Explanation Correct Answer B:A foldable selective filter can execute at SQL, reducing records sent through the later local transform, provided the transformation sequence remains equivalent. Incorrect Answers A:A nonfolding operation early in a query may force broad local evaluation and unnecessary transfer. C:A report slicer does not replace source-level row reduction and may leave unnecessary import work. D:Bookmarks store report state and do not optimize Power Query delegation.
Question 217 A water authority has hundreds of semantic models. Its analysts must find a reusable model that content owners explicitly marked as suitable for reuse but did not centrally certify. How should consumers narrow the discovery list? Assign an RLS role to each candidate without inspecting it Require every model to carry Certified endorsement even when the authority uses promotion for preliminary reuse Filter the catalog/data hub by Promoted endorsement and review the model’s description and lineage Filter only by report file size, since larger models are more trustworthy Explanation Correct Answer C:Promoted is a discoverable content endorsement; reviewing lineage and model details is still necessary before relying on it. Incorrect Answers A:RLS controls who can see rows, not whether a model has been marked reusable. B:Certification is a higher approval tier and is not required to discover Promoted items. D:File size says nothing about data stewardship, semantic definitions or suitability for reuse.
Question 218 An order model has a valid inactive ShipDate relationship. A developer uses USERELATIONSHIP in one shipped-units measure, then assumes every other measure automatically uses ShipDate too. What is correct? The DAX function permanently changes the model relationship to active The relationship override applies only to calculations that invoke it, not universally to unrelated measures Every report visual starts using ShipDate even without the expression The function creates a new physical Date table on each query Explanation Correct Answer B:USERELATIONSHIP specifies a filter path in its calling calculation, leaving the model’s default active path unchanged. Incorrect Answers A:It does not mutate relationship properties in the model. C:Other measures still use their own filter paths. D:The function uses existing relationships, not table creation.
Question 219 A streaming-media report displays six weekly watch-time totals. The author needs a moving average across the last three displayed weekly values only for this one chart, without adding a reusable model measure. What fits? A fixed overall average measure repeated on each week regardless of neighbors A visual calculation using a moving-average window over the displayed weekly axis A Power Query grouping that permanently collapses the weekly source facts A bookmark toggling the legend without recalculating values Explanation Correct Answer B:A visual calculation operates on the chart’s current weekly shape and can calculate a rolling window tailored to that view. Incorrect Answers A:A constant overall average does not compute a three-week rolling statistic. C:Grouping early loses underlying week-level detail and does not respond to the chart’s displayed window. D:Bookmarks change visibility or filter state, not a rolling arithmetic window.
Question 220 A maintenance table mixes WorkCost values `12.50`, `unknown`, and `18.00`. The numeric rows must remain Decimal and the unresolved value must not become zero. Which preparation is justified? Cast the entire column to text and SUM it as a currency value Convert all rows, including `unknown`, to zero before loading Delete every row with a valid numeric amount Replace the known `unknown` token with null, then validate and convert legitimate amounts to Decimal Explanation Correct Answer D:Targeted missing-token handling retains both valid amounts and a missing marker without inventing cost. Incorrect Answers A:Text aggregation is not a reliable monetary total. B:This fabricates a cost for an unresolved source value. C:That discards the actual observations and keeps the malformed record.
