Question 70 A food chain imported a single wide store purchases table with a repeated Locations name, address, and region on every event. The repeated text inflates model size. What model change is most appropriate? Create a calculated table for each distinct transaction amount Create a unique Locations dimension and keep store purchases fact columns at event grain Duplicate the full wide table for each visual Turn on every relationship’s Both direction Explanation Correct Answer B:A compact Locations dimension and numeric-grain fact reduce repeated descriptive attributes and support shared slicers. Incorrect Answers A:One calculated table per NetSpend value fragments the data and is not a star-schema fix. C:Duplicating the wide table multiplies redundant attributes and increases the memory burden. D:Filter-direction settings do not remove repeated text values from model storage.
Question 71 A nonprofit has revenue by month and wants side-by-side small trend panels, one for each of six Chapters categories, using identical visual encodings. Which Power BI feature helps? One arbitrary bookmark per transaction Small multiples on a suitable visual, split by the category field One card containing only the largest category A single tooltip without separate panels Explanation Correct Answer B:Small multiples repeat the time-series visual in comparable panels by Chapters, revealing differences across categories. Incorrect Answers A:Bookmarks capture states; dozens of transaction-level bookmarks are not a panel layout. C:A single card loses all per-category time trends. D:A tooltip adds contextual detail but does not create synchronized comparison panels.
Question 72 A factory group stores its production records data on an on-premises SQL Server that the Power BI cloud cannot reach directly. Multiple semantic-model owners need centrally managed scheduled refresh. What connectivity component should it deploy? A report bookmark that stores SQL credentials Standard on-premises data gateway with configured SQL connection A personal gateway on a single user laptop as the enterprise default An email subscription to every report Explanation Correct Answer B:A standard gateway supports shared managed access from Power BI to on-premises SQL, including scheduled refresh and administration. Incorrect Answers A:Bookmarks do not authenticate or tunnel service requests to on-premises SQL. C:Personal mode is designed for one person and lacks the shared central management requirement. D:Subscriptions distribute report snapshots, not connections to private databases.
Question 73 A customer service report has Overview, Resolution and Aging pages. The team frequently renames and reorders pages and wants the navigation controls to track those changes automatically. What should the author add? A drillthrough button requiring a selected CustomerID before any page opens A built-in Page navigator whose buttons follow the report-page list Independent bookmarks for every page that must be manually maintained A static text-box table of contents with no navigation actions Explanation Correct Answer B:The Page navigator automatically reflects the report’s current pages and supports navigation without maintaining separate bookmarks. Incorrect Answers A:Drillthrough is a data-context detail action, not general report table-of-contents navigation. C:Bookmarks can navigate but require state management and do not automatically match new/renamed report pages in the same way. D:Plain text provides no reliable click behavior for navigating pages.
Question 74 A claim filings report for an insurance provider shows branch-level revenue against complaint counts; one branch is far from the main pattern. What visual and analytic approach makes the unusual branch easy to detect? Month-name slicer without individual branches Turn off tooltips and all data labels Scatter chart of the two measures with branch detail and outlier inspection Card showing only the overall revenue Explanation Correct Answer C:A scatterplot shows each branch in numeric context, revealing a point far from the association between revenue and complaints. Incorrect Answers A:A month slicer changes time context but cannot alone show branch outliers. B:Withholding identifiers makes it harder to investigate the exceptional point. D:Overall revenue hides branch-level deviations.
Question 75 A Power BI analyst wants to use Direct Lake on OneLake for a SQL endpoint view that is not a materialized Delta table. What design constraint applies? The nonmaterialized SQL view cannot be a Direct Lake on OneLake table; materialize a backed Delta table or choose another supported mode The view automatically runs as DirectQuery fallback in Direct Lake on OneLake A report bookmark materializes the SQL view as a Delta table Setting SQL endpoint RLS makes the view natively supported in OneLake-only mode Explanation Correct Answer A:Direct Lake on OneLake works with Delta-backed tables and does not use SQL-endpoint-view fallback. Incorrect Answers B:DirectQuery fallback applies to Direct Lake on SQL endpoints, not OneLake-only mode. C:Bookmarks save report display state and do not create Delta files. D:SQL endpoint RLS does not convert a view into supported Delta table storage.
Question 76 A subscription company wants a star-schema model: renewals events repeat the same Plans attributes on millions of transaction rows. Which modeling preparation should Power Query perform? Duplicate the dimension text into every measure definition Pivot every event into a separate column Keep numeric SubscriptionValue at event grain in a fact query and produce a distinct Plans dimension with a stable key Create a separate fact table for every Plans name Explanation Correct Answer C:Separating Plans attributes from renewals event measures enables a one-to-many dimension/fact relationship and reuse of slicers. Incorrect Answers A:Measure definitions do not replace a properly keyed dimension for filtering and relationships. B:One column per event is unmanageable and loses normal row grain. D:One fact per Plans member creates fragmented tables and harder cross-category analysis.
Question 77 A Region slicer currently selects West. A measure uses CALCULATE([Sales], Region[Region] = "East") with no KEEPFILTERS. Which region does the measure evaluate? West, because slicers always override every DAX expression The intersection of West and East, which must always be empty Every region with its original slicer selection ignored entirely East, because CALCULATE replaces an existing filter on the same column Explanation Correct Answer D:Without KEEPFILTERS, a new Boolean filter on Region[Region] overrides the existing West selection for this measure. Incorrect Answers A:CALCULATE can overwrite same-column filters; slicer context is not unconditionally dominant. B:An intersection would require KEEPFILTERS or a different filter construction. C:The expression specifically applies East rather than removing all region filters.
Question 78 A government agency queries a relational source through Power Query; a complex custom transformation is pushed before a selective row filter and prevents query folding. Data transfer now grows unnecessarily. What transformation change should be evaluated? Remove every filter so the source returns more rows Unpivot columns simply to disable folding permanently Turn every filter into a measure after importing all rows Move foldable selective filters ahead of the nonfolding custom step when semantically safe Explanation Correct Answer D:Foldable filters can be executed by the source, reducing transferred service applications records before later local transformations. Incorrect Answers A:Removing filters forces extra source rows through the pipeline. B:Intentionally breaking folding does not minimize source work or network volume. C:Late measures do not replace source-side row filtering in Power Query.
Question 79 A mobile games studio loads in-app purchases and Countries keys where the dimension has accidentally duplicated keys after a merge. A one-to-many relationship now fails. What should the analyst correct? Use Both cross-filter direction as a uniqueness fix Delete all PurchaseID rows that use duplicate dimension values Make the intended Countries dimension key unique and validate the mapping Force a many-to-many relationship without investigating duplicates Explanation Correct Answer C:One-to-many modeling requires unique keys on the Countries side; deduplication or valid surrogate keys must restore that property. Incorrect Answers A:Bidirectional filtering cannot make a nonunique lookup column unique. B:Deleting fact transactions loses valid in-app purchases events rather than repairing the lookup. D:Many-to-many can conceal incorrect duplicate dimension rows and change filter/total behavior.
Question 80 A financial cooperative must export a multi-page, fixed-layout printable statement with repeating headers and precise row breaks. Which report type should the team evaluate instead of a typical scrolling interactive canvas? Scatter chart for page breaks A bookmark that converts any visual into PDF layout Paginated report designed for print-ready page control Single Power BI card visual Explanation Correct Answer C:Paginated reports support pixel-precise page layout, repeating headers and controlled print/export pagination. Incorrect Answers A:Scatter charts visualize correlations and have no report pagination model. B:Bookmarks restore filter/display states but do not automatically supply fixed-layout report pagination. D:A card cannot contain page-controlled, row-based financial statements.
