Question 250 A sales director wants a single Power BI canvas summarizing pinned visuals from several reports. An analyst assumes the dashboard creates a new independent semantic model. What is accurate? Every pinned tile requires copying all source tables into a new dashboard model A dashboard can contain tiles pinned from reports backed by their existing models A dashboard is merely a Power Query staging table The dashboard is a report bookmark saved as a dataset Explanation Correct Answer B:Pinned tiles surface visuals from existing report artifacts without making a separate data model by default. Incorrect Answers A:Model duplication is not inherent in tile pinning. C:Power Query staging is data transformation, not a dashboard canvas. D:Bookmarks and dashboards are distinct features.
Question 251 An analyst at an aviation services group combines restricted internal maintenance tasks data with a public exchange-rate feed in Power Query. Enterprise policy prohibits leaking private row values to a public source during query folding. Which connection setting needs particular scrutiny? Set and honor suitable data-source privacy levels for both sources Make the internal source Public so folding always succeeds Turn off query privacy protections for convenience Publish the restricted rows as an open CSV for testing Explanation Correct Answer A:Correct privacy levels govern how Power Query combines the internal maintenance tasks and public feed without unintended cross-source data disclosure. Incorrect Answers B:Classifying confidential internal rows as Public defeats the stated data protection rule. C:Disabling privacy isolation can expose private values to a less-trusted source. D:An open CSV export leaks the very records the restriction is intended to protect.
Question 252 A logistics fact table records one row per ShipmentID, with OriginHubID and Freight. HubName is repeated, and two unrelated hubs now share the same display name following an acquisition. How should Power Query prepare a reliable hub dimension join? Join on HubName even though multiple different HubID values share it Aggregate all shipments for same-named hubs before preserving their distinct identities Keep ShipmentID-grain facts and a stable HubID foreign key, and build a HubID-unique hub dimension rather than joining on ambiguous HubName Create a separate fact table for every HubName string instead of a shared keyed dimension Explanation Correct Answer C:Stable HubID relationships disambiguate equal display names while preserving all shipment events and the distinct hub identities. Incorrect Answers A:Identical display labels do not establish identical locations or keys. B:Premature aggregation can combine independent hubs and lose required shipment detail. D:Fragmented fact tables impede shared reporting and do not fix ambiguous labels.
Question 253 An energy utility identifies zones with codes 01, 02, and 03 at every facility. The fact table records FacilityID and ZoneCode; a ZoneCode-only dimension incorrectly merges unrelated areas from different facilities. What key design addresses this? Group all ZoneCode 01 records across facilities as one physical zone without checking FacilityID Define a unique facility-plus-zone lookup key or surrogate identifier and relate each fact to the matching facility-specific zone Use the latest zone description as the universal name for every matching code Create a bidirectional many-to-many relationship to conceal the duplicate ZoneCode values Explanation Correct Answer B:ZoneCode is only unique within a facility. A composite business key or correctly mapped surrogate prevents distinct zones from being conflated. Incorrect Answers A:Local numbering schemes can reuse 01 in unrelated facilities. C:One label cannot describe several physically distinct location keys. D:Relationship direction cannot repair a nonunique lookup identity.
Question 254 A web retailer has validated coordinates for every store and a [NetRevenue] measure. A basic pin map already plots all stores but does not communicate which store sells more. Which enhancement best supports magnitude comparison? Treat the latitude number as revenue and drop the actual measure Use an Azure Maps bubble layer with verified coordinates and a suitable size encoding for [NetRevenue], checking legend and scale Set every store’s bubble to exactly the same radius regardless of values Replace every store with the head-office latitude and longitude Explanation Correct Answer B:Bubble size can represent a numeric measure at each coordinate while preserving store geography; scale and tooltip choices should remain interpretable. Incorrect Answers A:Coordinate values describe location, not financial magnitude. C:Equal bubble sizes cannot convey the required relative revenue differences. D:One fabricated location merges distinct stores and destroys spatial accuracy.
Question 255 A report displays August 2026 sales and needs the amount from July 2026 for month-over-month comparison, using a contiguous classic Date column. Which expression supplies the desired date filter? SAMEPERIODLASTYEAR(Date[Date]) DATESYTD(Date[Date]) DATEADD(Date[Date], -1, MONTH) NEXTMONTH(Date[Date]) Explanation Correct Answer C:DATEADD with a one-month backward shift targets July 2026 for an August 2026 selection. Incorrect Answers A:This moves the context to August 2025, not July 2026. B:YTD returns a cumulative window rather than just the prior month. D:NEXTMONTH shifts forward to September, not backward to July.
Question 256 Two vendors each send a Market field containing "N/A". Vendor A documents N/A as missing, whereas Vendor B uses it as a legitimate category for digital-only subscriptions that have no geographic market. The feeds will be combined. What cleaning design preserves meaning? Globally replace every N/A with null before identifying its vendor Globally replace every null with N/A and claim all products have valid market classifications Apply source-specific normalization: map Vendor A's missing sentinel to null but preserve Vendor B's valid N/A category with source provenance Delete the vendor identifier so no source-specific mapping can be applied Explanation Correct Answer C:The same text can represent absence in one contract and a real not-applicable category in another; conditional conversion preserves business truth. Incorrect Answers A:Global replacement erases Vendor B's real no-geographic-market category. B:Converting nulls to a business label obscures source gaps and invents meaning. D:Dropping provenance prevents deciding which source contract defines each N/A value.
Question 257 A confidential finance report carries a configured Microsoft Purview sensitivity label. An authorized user exports data to a supported file format. What should the governance team expect from compatible sensitivity-label protection? The label automatically turns off all viewer RLS roles The label permanently prevents every authorized user from exporting anything The applicable label and protection settings can be retained or propagated on supported exports, subject to policy and format Renaming the report cancels data-classification requirements Explanation Correct Answer C:Supported export paths can preserve classification/protection, whereas row entitlement remains separately governed. Incorrect Answers A:Labels and RLS have different access-control scope. B:Not all labeled reports impose an unconditional export ban. D:Classification does not disappear by changing a file title.
Question 258 A product bar chart selects one category, and executives want the category’s contribution highlighted within the full total of another supported bar chart rather than filtering all other categories away. Which interaction mode matches? Cross-highlight the target supported bar visual Cross-filter the target so other categories vanish entirely Set None so the target cannot indicate the selection Delete the target’s axis and show only its total Explanation Correct Answer A:Highlight shows the selected portion while retaining reference to the complete visual composition. Incorrect Answers B:Filtering removes unselected categories and loses total comparison context. C:None leaves no visual indication of the chosen product. D:Deleting the axis destroys the category comparison.
Question 259 A Power Query staging query is needed by two output queries. Someone disables its refresh and expects this to remove only its separate table from the model while still updating dependents. What should be clarified? Disable refresh always guarantees all dependent results are current Convert the staging query to a visual-level filter Delete every reference and rely on a static screenshot Use Enable load control to exclude the stage from model output; refresh/evaluation dependencies are a separate concern Explanation Correct Answer D:Enable load governs model materialization, whereas dependency evaluation and refresh have separate behavior. Incorrect Answers A:Disabling refresh can leave data stale or affect dependent evaluation. B:Report filters do not determine model-load configuration. C:Screenshots cannot replace live prepared data.
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.
