Question 180 A returns table must join a lookup on CountryCode plus StoreID because StoreID repeats in multiple countries. The Merge dialog currently matches CountryCode to StoreID and vice versa. What should the author correct? Merge on StoreID alone even though it repeats across countries Append the lookup table to the returns table Select both join keys in the same matching order on the two tables, then validate lookup uniqueness Convert both identifiers into dates and join by nearest month Explanation Correct Answer C:Power Query multi-column merge matches selected key positions in order; mismatched pairing yields wrong join results. Incorrect Answers A:StoreID alone can match the wrong country and duplicate facts. B:Appending cannot enrich a transaction with its matched store. D:Date conversion destroys business-key meaning.
Question 181 A bank has joint accounts; one customer can hold many accounts and an account can have multiple customers. How should the semantic model capture those memberships? Duplicate every customer into all Account dimension rows and declare customer key unique Use unique Customer and Account dimensions connected through a customer-account association bridge Use an unrestricted many-to-many fact relationship with no association table or key validation Convert account balances to text so multiple owners are not counted Explanation Correct Answer B:A bridge with unique association pairs models the relationship without forcing duplicated dimension primary keys. Incorrect Answers A:Duplicated dimension keys violate one-side uniqueness. C:Uncontrolled direct many-to-many paths can produce ambiguous filtering and accounting. D:Changing numeric types does not define ownership memberships.
Question 182 A line chart currently shows all regional call volumes together. The author wants identical mini time-trend panels for each Region using one visual definition. Where should Region be placed? In the source credential form In the Small multiples field well of a supported line chart As a separate SQL column containing visual color codes As an unrelated report bookmark name Explanation Correct Answer B:The Small multiples field divides one supported chart into per-region panels with shared visual structure. Incorrect Answers A:Source credentials authorize queries and do not partition charts. C:Static color codes alone do not create multiple panels. D:A bookmark name does not drive the small-multiple category grid.
Question 183 From a revenue summary, an analyst right-clicks an individual Terminal and navigates to a Terminal Detail report page. What must be configured to show only that selected terminal? Include the Terminal key in the destination page’s Drillthrough fields and invoke drillthrough from the selected point Use a static hyperlink to a home page without any filter context Change the terminal name to a visual theme Create a report-tooltip page and assume it supports full interactive investigation Explanation Correct Answer A:The Drillthrough filter carries the source selection into the destination detail page. Incorrect Answers B:A static home URL has no selected terminal context. C:Theme changes do not route data-point filters. D:Report tooltips are hover summaries and not equivalent to a persistent drillthrough page.
Question 184 A regional health report hides North region rows using a visual filter only. Consumers can build new visuals using the same model. What enforces North-only rows for the authorized North viewers regardless of visual? Define and assign North RLS filtering in the semantic model and test it for the intended viewer accounts Hide South in a slicer dropdown on the original page Set the report theme to a North-specific color Restrict access only by changing the dashboard tile title Explanation Correct Answer A:RLS evaluates on model queries, so a new report or export remains governed by the role. Incorrect Answers B:A visual filter does not restrict independent model queries. C:Themes do not authorize facts. D:A title provides no enforcement of row predicates.
Question 185 A newly appointed operations analyst must replace measures and republish a report in a shared workspace, but must not invite users or manage membership. Which workspace role fits? Member with the ability to add users Admin with permission to remove users Viewer with read-only consumption Contributor Explanation Correct Answer D:Contributor can create and edit workspace items while lacking user-access administration. Incorrect Answers A:Member can grant lower-level workspace access, which the analyst must not do. B:Admin can manage membership and the workspace, exceeding the stated scope. C:Viewer cannot replace the shared report and measures.
Question 186 This month’s service cost is 350 and the same month last year was 280. A YoY change measure is [CurrentCost] - CALCULATE([CurrentCost], SAMEPERIODLASTYEAR(Date[Date])). What value does it show? 280, the prior-year value without subtracting 70, the increase over the comparable prior-year month 350, the current month without comparison 630, the sum of two periods Explanation Correct Answer B:The date-shifted component is 280, and the measure subtracts it from current 350. Incorrect Answers A:280 is the comparison base, not the requested difference. C:350 is only the current total and omits the subtraction. D:Year-over-year change subtracts comparable values instead of adding them.
Question 187 Two sales files contain different months with the same columns. Management needs one long fact table with both periods, not extra attributes from a lookup. Which transformation is appropriate? Merge the files on CustomerID and multiply rows with repeated customer keys Pivot all invoice identifiers into one column per invoice Use a relationship that deletes rows not shared by the months Append the monthly records into a single table with aligned column names and types Explanation Correct Answer D:Append stacks records at compatible grain and preserves each month as additional rows. Incorrect Answers A:Merge joins attributes and may create spurious many-to-many matches across months. B:Pivoting invoices produces an oversized wide structure, not combined transaction records. C:Relationships do not concatenate source data rows.
Question 188 A shipping model has one row per CarrierID in the Carrier lookup and thousands of parcel rows with repeated CarrierID. The author accidentally sets a many-to-many relationship and sees unpredictable filter results. What structure should be restored? Make every carrier appear once in the transaction table Add duplicated carrier rows until both tables have matching row counts A one-to-many Carrier-to-Parcel relationship with a unique Carrier key on the lookup side Use an unrelated report bookmark instead of a relationship Explanation Correct Answer C:The one-side key is unique and facts legitimately repeat it; correct cardinality supports predictable star filtering. Incorrect Answers A:Collapsing transactions would erase legitimate parcel events. B:Duplicate lookups violate one-side uniqueness and can multiply filter paths. D:Bookmarks do not propagate carrier filters to the parcel fact.
Question 189 A delivery company already uses a Power BI paginated report for customer invoices. Its report spans multiple PDF pages, and auditors need “Page X of Y” in each page footer. What should the report author configure? Place a single Power BI Card on the dashboard and print the first page Add a report bookmark that sorts the customer list alphabetically Use Report Builder page footer expressions with built-in PageNumber and TotalPages fields Turn all invoicing amounts into Text so the PDF creates page numbers Explanation Correct Answer C:Paginated Report Builder exposes built-in page-number fields for repeating footer text across printed pages. Incorrect Answers A:A dashboard card cannot establish repeating page numbers on a multipage invoice. B:A bookmark does not produce the paginated report footer metadata. D:Data type changes are unrelated to page numbering and may break financial calculations.
Question 190 A training-provider report has a single page with two layouts, Monthly and Quarterly, saved as bookmarks. The audience must switch layouts by clicking tabs without leaving the page. Which control fits? A drillthrough action that requires a selected transaction row A Bookmark navigator associated with the saved Monthly and Quarterly bookmarks A Page navigator targeting separate report pages An ordinary slicer whose categories have no model relationship Explanation Correct Answer B:Bookmark navigators select saved report states, including visibility, on the current page without needing new physical pages. Incorrect Answers A:Drillthrough is for context-filtered navigation to detail pages, not saved-layout tabs. C:A Page navigator switches actual report pages rather than states on one page. D:A disconnected slicer alone cannot toggle saved visual visibility states.
