Question 260 An analyst clicks Run now on a report subscription, then assumes the Import model’s data has just been refreshed from SQL. What is the correct interpretation? A subscription automatically executes a full source refresh on every send The email reassigns RLS roles for all recipients Run now sends a subscription email; it does not trigger an underlying semantic-model refresh The send changes a model measure into a calculated column Explanation Correct Answer C:Email subscriptions distribute report snapshots; source refresh is scheduled and managed separately. Incorrect Answers A:An email send is not equivalent to a dataset refresh operation. B:Subscriptions do not administer row-level security. D:DAX schema is not changed by email delivery.
Question 261 A delivery service groups customer ages into 20-year bands. The field currently contains the text strings "18", "35", and "53", and numeric binning is unavailable. What should be checked before creating bins? Keep ages as free text and sort alphabetically Convert and validate the Age field as numeric, then define a 20-year bin size Create a report bookmark for every unique age Change the Age field to Date and treat years as calendar dates Explanation Correct Answer B:Numeric grouping requires valid numeric values to calculate contiguous interval boundaries. Incorrect Answers A:Text categories do not have reliable arithmetic interval distances. C:Bookmarks do not form numeric age bands. D:Calendar dates are not customer ages in years.
Question 262 Power Query in a municipal water authority uses identical transformations for development and production service tickets SQL databases. Only server/database names change between environments. What design makes controlled environment switches easiest? Define Power Query parameters for the server and database and bind the connector to them Copy every applied step manually before each deployment Hard-code the production password in an M formula Create a separate unrelated report for every server Explanation Correct Answer A:Parameters let service tickets queries change designated source settings without duplicating their transformation logic. Incorrect Answers B:Manual replication creates drift and unnecessary deployment errors. C:Secrets should not be embedded in editable query text. D:An unrelated report cannot preserve a single maintainable, parameterized data-ingestion pipeline.
Question 263 Four claims have (Channel, Amount) values (Online,120), (Store,90), (Partner,150), (Online,80). An analyst counts Online claims over 100 OR Partner claims over 100. What is the correct result? 4, counting all channels regardless of amounts 3, including Store 90 1, counting only the Online 120 record 2, covering Online 120 and Partner 150 Explanation Correct Answer D:Each of those two rows satisfies its channel and value condition; the other rows fail one or both requirements. Incorrect Answers A:The threshold and channel criteria exclude two rows. B:Store is not one of the named channels and 90 does not exceed 100. C:The Partner 150 record also satisfies its own OR branch.
Question 264 A developer replaces a numeric Revenue measure with FORMAT([Revenue], "$#,##0") to achieve a currency symbol. A downstream chart stops behaving as a numeric series. Why? FORMAT creates a faster numeric aggregation in the storage engine All visual measures must be text before graphing A dashboard bookmark controls DAX return types FORMAT returns text; apply model/visual numeric formatting while retaining a numeric measure Explanation Correct Answer D:The DAX FORMAT function produces a string, which is not a suitable replacement for numeric measure semantics. Incorrect Answers A:Formatting does not transform text back to a native numeric aggregate. B:Power BI charts support and generally require numeric values for quantitative axes. C:Bookmarks do not alter function return types.
Question 265 A factory group owns two different plants both called North Works; their stable PlantID values are P1 and P9. Import code creates a lookup by removing duplicate PlantName values, and one location disappears. What should the author correct? Merge P1 and P9 into one record because equal PlantName always implies one facility Switch the relationship to Both direction to make duplicate names unique Build and validate the dimension at unique PlantID grain, preserving both plants even when their descriptive names match Keep one arbitrary name and delete facts linked to the other PlantID Explanation Correct Answer C:PlantID is the stable identity while PlantName is a nonunique attribute; using the correct key retains both legitimately different locations. Incorrect Answers A:Names can repeat across distinct physical plants. B:Filter direction changes propagation, not logical identity. D:Dropping a real plant or its facts corrupts operational totals.
Question 266 Executives need a monthly Net Sales indicator showing current value, target, and a trend axis. The existing single-number Card hides whether performance is improving. Which visual should replace it? A Card with only the latest total and no goal A month-name text box with no values A KPI visual with Indicator, Target goal, and Trend axis A Pie chart containing one total slice Explanation Correct Answer C:A KPI combines actual, target and trend context in one supported visual. Incorrect Answers A:A single total cannot reveal gap to target over time. B:Text labels do not compute or visualize the measures. D:A one-slice pie cannot compare movement with a goal.
Question 267 A store inventory feed contains `north`, `NORTH`, and `North` as names of the same zone. The entries already have no extra whitespace. A relationship must use one standardized version of the category text. Which cleaning operation is appropriate? Append a copy of the entire Zone table three times Change zone names to Decimal Number Unpivot one zone-name field into an attribute table without altering its values Normalize the case consistently (for example Text.Upper) on the zone key before deduplication and joining Explanation Correct Answer D:Consistent uppercase normalization produces one comparable key for all three variants, enabling a clean dimension lookup. Incorrect Answers A:Appending duplicate data increases rows and does not reconcile the category variants. B:Changing words to numbers fails conversion and is unrelated to case normalization. C:Unpivoting changes the layout while leaving differently cased labels as separate values.
Question 268 A national bookstore has an Orders-like book sales query with ReceiptID, a Shops key, and NetSales. The analyst must list transaction keys with no matching lookup record before correcting missing dimension data. Which merge join kind directly returns those left-side exceptions? Left anti join from the transaction table to the lookup Left outer join including all transactions and their lookup matches Inner join including only matched transaction rows Append lookup rows underneath transactions Explanation Correct Answer A:Left anti retains the left-side rows for which the lookup has no match, exposing precisely the missing keys. Incorrect Answers B:Left outer also includes matched transactions and is not the requested exceptions-only result. C:Inner discards the unmatched keys that the analyst must investigate. D:Append stacks rows and does not test equality of keys.
Question 269 A report owner cannot sync two independently built slicers because one uses Sales[LocationName] and another uses an unrelated text table with different values. What should be reviewed? Sort both slicer titles alphabetically and assume they now share data semantics Use a compatible shared field/model relationship for synchronized slicer behavior and verify the resulting filters Hide the second slicer without fixing the field mismatch Add unrelated text values to both tables until they have the same number of rows Explanation Correct Answer B:Cross-page sync requires consistent filter semantics, not merely a matching display label. Incorrect Answers A:Page titles do not establish semantic field identity. C:Hiding an incompatible filter preserves the inconsistency. D:Equal row counts cannot guarantee identical location keys or relationships.
Question 270 A regional manager is a Viewer in a Power BI workspace and has Build permission on an RLS-protected semantic model. They use Analyze in Excel with that model and ask whether Build lets them inspect all regions. What is the correct answer? Yes, because Excel bypasses Power BI semantic-model roles whenever a pivot is used Yes, because Build automatically makes the user Contributor in the source workspace No, because Excel can never connect to Power BI semantic models No; the RLS role still restricts rows for a Viewer with Build when analyzing the semantic model through Excel Explanation Correct Answer D:Microsoft explicitly states that RLS remains enforced for Viewer users who also have Build, including Analyze in Excel. Incorrect Answers A:The consuming tool does not by itself override the semantic-model authorization context. B:Build allows derived analysis but does not silently elevate a Viewer to the Contributor workspace role. C:Analyze in Excel is a supported workflow for eligible users with appropriate model access.
