Question 280 A company merges annual contracts from two systems. One produces “2026-07-31” and the other “31/07/2026”. Both represent 31 July, but a single unqualified text-to-date conversion creates errors in one subset. What preparation is safest? Identify the source format for each feed, convert each to an actual Date using explicit parsing rules, and append typed rows only after validation Convert both sets to Whole Number and drop the delimiter characters Treat every month/day/year string as a day/month/year date regardless of its originating source Concatenate the two raw text fields and let report consumers interpret the joined string Explanation Correct Answer A:Source-aware parsing handles both representations without changing their underlying calendar day and yields one consistent Date type in the combined table. Incorrect Answers B:Removing separators does not resolve which components are day and month or create Date semantics. C:Assuming a universal format risks silently reversing dates for ambiguous source entries. D:Text concatenation preserves neither typed date filtering nor a comparable date dimension.
Question 281 A semantic model has dynamic RLS using USERPRINCIPALNAME. The author tests the role using their own administrator account and sees unrestricted data. What is the appropriate validation? Test as role using the intended viewer identity and verify its region mapping and group membership Assume a workspace Admin sees the same rows as every Viewer Hide the Region column to simulate access filtering Use only report coloring as evidence of the security rule Explanation Correct Answer A:Effective RLS depends on the actual consumer identity; elevated workspace roles do not simulate Viewer enforcement. Incorrect Answers B:Admins can bypass the RLS behavior intended for Viewers. C:Hidden columns do not filter confidential rows. D:Colors are not security test evidence.
Question 282 A subscription company has one unique row per Plans member and thousands of renewals rows referring to each member by its key. Power BI reports that the supposed one-side lookup has duplicate keys. What is the necessary correction before enforcing one-to-many cardinality? Resolve duplicate keys in the dimension so one member has one lookup key Switch to many-to-many without examining duplicate rows Hide the key column in report view Turn on both-direction filters for all tables Explanation Correct Answer A:A one-side dimension must have a unique key; resolving duplicate member records restores the intended grain. Incorrect Answers B:Many-to-many can hide poor lookup quality and change aggregate semantics. C:Hiding a field does not make its values unique. D:Cross-filter direction cannot repair duplicated relationship keys.
Question 283 A school finance team wants to show how tuition discounts (-$12K) and new enrollments (+$27K) affect net tuition. A pie chart converts both to positive parts of a whole. Why is the waterfall alternative preferable? It depicts positive and negative components as signed changes to a running total It automatically guarantees every tuition transaction is error free It replaces all DAX measures with static labels It hides negative discounts because they are visually inconvenient Explanation Correct Answer A:Signed steps preserve whether each factor increases or decreases the result. Incorrect Answers B:Visual choice cannot validate source transaction correctness. C:A waterfall still uses valid quantitative measures. D:Hiding negative contributions misstates what changed net tuition.
Question 284 An editor changes reports in a workspace and republishes the app, but an external audience should not receive a newly added Finance report. What should be verified before Update app? The app audience-to-content assignments and sharing permissions for the new report Remove all app audiences to let everyone see the whole workspace Grant all external users workspace Admin Turn off model RLS because the app is updating Explanation Correct Answer A:An app update is a governance opportunity to confirm which items appear for each audience. Incorrect Answers B:Removing audiences can overexpose information. C:Admin rights are disproportionate and not required for consumption. D:Model row security remains necessary.
Question 285 Every shift a pharmaceutical wholesaler places a CSV file of inventory movements in a controlled network folder, with identical headers and encoding. The analyst wants one reusable ingestion query that includes future files placed in the folder. Which connector workflow is appropriate? Use an image-recognition visual to parse the filenames Set up a new disconnected semantic model for each shift Folder connector with Combine files and a validated sample transform Manually paste each new file into Power BI every day Explanation Correct Answer C:The Folder connector can enumerate compatible inventory movements files and apply one common transform to all of them. Incorrect Answers A:File names and images do not substitute for CSV parsing. B:One model per file fragments the time-series dataset and its measures. D:Manual pasting does not automatically include new daily files.
Question 286 A university has a wide table with EnrollmentID, Jan, Feb, and Mar numeric columns. The feed might add Apr and May columns next month. The identifier column should remain fixed while every other month becomes attribute/value rows without editing a month selection each time. Which command is most resilient? Pivot the identifier to form a column per record Delete every future month after March Select the identifier and choose Unpivot Other Columns Select only Jan and Feb and unpivot those two forever Explanation Correct Answer C:Unpivot Other Columns preserves the selected key and dynamically includes new month columns in the tall result. Incorrect Answers A:Pivoting the identifier creates many columns and does not normalize months. B:Discarding future months violates the data coverage requirement. D:A fixed Jan/Feb selection would silently omit new months.
Question 287 Orders relate to the Date table through active OrderDate and inactive ShipDate. A [Shipped Sales] measure must use the ShipDate relationship without changing default measures. What should it do? Set both conflicting relationships to active globally Rename the ShipDate column to OrderDate Use CALCULATE([Sales], USERELATIONSHIP(Orders[ShipDate], Date[Date])) Change report formatting to show a shipping label Explanation Correct Answer C:USERELATIONSHIP activates the existing inactive path while the measure evaluates; other measures retain the active OrderDate path. Incorrect Answers A:A model with one Date dimension cannot use both paths as simultaneously active general defaults. B:Renaming a column does not change which relationship DAX uses. D:Display formatting cannot change the date path for an aggregate.
Question 288 A shipment fact table has 45 columns. Analysts propose dropping every numeric-looking ID to save memory, but ShipmentDateKey and CustomerKey are relationship columns. What should happen? Remove only verified unneeded columns; retain relationship keys and fields used by reports, calculations, or RLS Delete all keys and rely on matching table names Retain all unused tracking columns to avoid any chance of refactoring Replace relationship keys with report bookmarks Explanation Correct Answer A:Column pruning should honor model dependencies, including relationship and security fields. Incorrect Answers B:Dropping necessary foreign keys can break table filtering and measure correctness. C:Keeping all useless high-cardinality columns preserves the memory problem. D:Bookmarks capture view state and cannot substitute for relational keys.
Question 289 A transport analyst has a semi-transparent annotation rectangle laid over a chart. The shape keeps covering tooltip targets when it should sit behind the chart. The object positions are correct. What should the author change? Use Power Query Group By to reorder events in the source dataset Switch the semantic-model Date relationship from Single to Both Rebuild the report as a paginated form without the interactive chart Move the annotation behind the chart by adjusting object order in the Selection pane Explanation Correct Answer D:The Selection pane controls relative layer order, allowing a decorative overlay to remain visible without blocking chart interactions. Incorrect Answers A:Data grouping changes rows, not the display stacking of two report objects. B:Relationship filter direction has no connection to visual z-order. C:Replacing the report type would be unnecessary and lose useful interactions.
Question 290 A nonprofit models a clean Chapters dimension related to a donations fact. A designer turns every relation to Both, creating multiple ambiguous filter paths from categories to fact data. What is the preferred repair? Use FORMAT in every DAX measure Restore explicit single-direction dimension-to-fact paths where possible Turn on Both for even more unrelated tables Delete all dimensions and use only fact text Explanation Correct Answer B:Simple single-direction paths prevent unwanted propagation while keeping intended category filters. Incorrect Answers A:FORMAT changes displayed text, not relationship path ambiguity. C:More bidirectional relationships compound ambiguous propagation. D:Removing dimensions sacrifices reusable filters and star-schema clarity.
