Question 450 A sales team adds a monthly-by-region aggregate table, but users frequently slice on individual product SKU. What determines whether visuals can safely use that aggregate instead of the detail fact? A monthly region total always answers any SKU-level question exactly Removing Product from the model will automatically create correct SKU results The report theme selects the fact table needed for each filter The aggregation must contain or correctly relate the dimensions needed by the query; SKU-level filters may require detail access Explanation Correct Answer D:An aggregation missing SKU detail cannot independently resolve product-level filtering without a valid detail path. Incorrect Answers A:An overall region total collapses distinctions among products. B:Removing a dimension worsens the mismatch instead of recovering lost grain. C:Themes affect styling, not source-grain query accuracy.
Question 451 A visual plots monthly watch minutes by subscription tier. An analyst adds upper/lower confidence measures, but those bounds ignore the Tier filter and display identical values for every tier. What must be corrected? Make the bound measures calculate within the same relevant tier and month filter context as the central estimate, then validate against segment data Increase the thickness of every confidence interval so it is easier to see Delete the Tier slicer and stop comparing separate groups Use one report title as the upper and lower confidence interval Explanation Correct Answer A:Error bars are meaningful only when their bounds represent the displayed observation and its current context, not an unrelated global aggregate. Incorrect Answers B:Visual styling does not repair mathematically wrong interval values. C:Removing the requested segment analysis hides rather than fixes the calculation defect. D:Titles cannot substitute for numerical upper/lower bound measures.
Question 452 A company refreshes an Import semantic model every night at 02:00. Users at 16:00 ask why the report ignores transactions loaded at noon. What is the expected explanation? Import visuals always issue live SQL queries at every click The report theme prevents noon transactions from loading Any bookmark forces an updated source snapshot Import visuals reflect the last successful model refresh, not automatic live reads after each source transaction Explanation Correct Answer D:Import stores a refresh-time snapshot; new source records require a later successful refresh. Incorrect Answers A:Live-query behavior is not how ordinary Import works. B:Styling does not control source ingestion. C:Bookmarks restore visual state but cannot ingest new source rows.
Question 453 Two warehouse extracts have the columns ShipmentID and Weight; the newer one also contains Carrier. Both months must become one long table without inventing Carrier values for prior rows. What should Power Query do? Fill every historic Carrier with the first new-month carrier as a default Append by matching column names and retain null Carrier values for the older rows Merge rows on ShipmentID as if the two extracts were dimension attributes Discard old rows lacking Carrier, reducing historic coverage Explanation Correct Answer B:Append combines row sets by column name and introduces null for columns absent from a source table. Incorrect Answers A:Guessing carrier values would manufacture unsupported history. C:Merge joins records horizontally and is not the required month stacking operation. D:Discarding old rows erases valid historical shipments.
Question 454 A drug wholesaler lets report viewers change the x-axis from Supplier to Product category using Personalize visuals. An analyst worries that one person’s experimentation will rewrite the official report page for everyone. What behavior should they understand? A viewer can explore an authorized visual variation without changing the original published report definition for colleagues A personalized visual always edits the central semantic model table relationships Report personalization grants every viewer app-publication capability Any field swap requires all users to be added as workspace Contributor Explanation Correct Answer A:Personalize visuals enables reader-side exploration while the publisher remains responsible for the shared authored report. Incorrect Answers B:Changing a personal field selection does not change model relationships. C:App publication rights are separate permissions, not part of reading-mode personalization. D:Contributors can edit shared content but are unnecessary for consumer-level field choices.
Question 455 A service-desk fact table stores `CreatedAt` values with hours and minutes. Its Date dimension contains exactly one row per midnight calendar date. An analyst creates a relationship on the raw DateTime column and many events fail to match. What should be changed? Change the Date dimension to one row for every minute in the fact table Relate the fact to a random sequence number instead of any date Create a derived Date-only value from CreatedAt and relate it to the daily Date dimension, retaining the original timestamp for detailed reporting Treat any non-midnight fact timestamp as an invalid service ticket Explanation Correct Answer C:The Date-only relationship key matches the dimension’s daily grain while keeping the precise original event time available. Incorrect Answers A:A minute-grain Date table undermines its intended daily uniqueness and needlessly increases its size. B:Arbitrary numeric IDs do not link an event to its calendar date. D:Legitimate events occur throughout the day; they are not invalid because their times are nonzero.
Question 456 A report author hides a confidential column and uses a visual filter to show only West. A test Viewer can query the semantic model directly with Build and access other regions. What should be added? More visual-level filters alone A tooltip called West Only A correct model RLS role limiting the user’s rows, then test with the intended viewer identity A category color gradient that hides regions Explanation Correct Answer C:Visual filters and hidden fields are not a substitute for model-wide row authorization. Incorrect Answers A:Visual filters may be bypassed through other model queries. B:Tooltips do not enforce model row security. D:Colors change appearance and do not block data access.
Question 457 March is selected in a report; sales are Jan 10, Feb 20, Mar 30 for Team A, and 100 each month for Team B. The report also filters to Team A. What does a normal TOTALYTD([Sales], Date[Date]) measure return? 60, the January–March total for Team A 360, adding Team B despite the team filter 30, only March for Team A 300, the Team B contribution Explanation Correct Answer A:The date modifier expands through March but the Team A filter still excludes Team B. Incorrect Answers B:The YTD modifier does not remove the Team filter. C:YTD accumulates from January as well as the selected March. D:The selected Team A filter excludes Team B records.
Question 458 A marketing model joins each campaign to shared support contracts. A contract worth 100 is attached to Campaign A and B, and management wants allocated cost totals summing to exactly 100. What data design is necessary? Count the full 100 in both campaigns, giving 200 total Set bidirectional filters to infer a financial allocation automatically Exclude Campaign B entirely without an approved attribution policy Store an explicit allocation such as 60% to A and 40% to B and calculate attributed cost Explanation Correct Answer D:A governed weighted bridge distributes each contract’s cost among the associated campaigns while preserving total spend. Incorrect Answers A:Full-count membership doubles shared cost across campaigns. B:Filter direction does not determine a money allocation ratio. C:Discarding one campaign arbitrarily violates the requested allocation rule.
Question 459 A pharmaceutical inventory report has 25 warehouses and total StockUnits measures. The existing bar chart sorts warehouse names A–Z, making it hard to find the highest stock locations. Leaders want the largest values at the top. Which action meets this? Replace the bar chart with a single Card showing overall stock Sort the warehouse categories by their label text in reverse alphabetical order Turn warehouse names into continuous Date values Sort the bar chart by the StockUnits value in descending order and verify the top warehouses appear first Explanation Correct Answer D:Sorting by the numeric measure provides the requested ranked magnitude comparison and can change correctly as results change. Incorrect Answers A:An aggregate Card loses comparisons among individual warehouses. B:Reverse alphabetic names still do not rank warehouses by current inventory. C:Warehouse names are categories, not calendar dates.
Question 460 Several departments build thin reports on one approved financial semantic model. The governance team corrects its GrossMargin measure. What is the operational advantage of this architecture? Every dependent report must import independent fact copies for each new measure One corrected model definition can flow to authorized dependent reports, reducing inconsistent local versions Central model changes automatically bypass consumer RLS roles Thin report visuals cannot be edited after initial creation Explanation Correct Answer B:Reuse centralizes calculation definitions and improves cross-report consistency. Incorrect Answers A:Independent copies recreate the very drift the organization is avoiding. C:Shared measures do not remove row entitlements. D:Report authors can change visuals while retaining the shared model connection.
