Question 240 A retailer uses Summary and Detail bookmarks to show or hide different visuals on one Power BI report page. Each bookmark currently restores the Region slicer value saved by the author, overriding the reader’s latest selection. The visuals must change, but selected Region must persist. What should the author change? Rebuild the Sales fact table separately for each bookmark. Grant every reader workspace Admin rights to preserve their personal slicers. Update the bookmarks to capture Display state but not Data state, and test switching with an active slicer selection. Remove relationships between Date and Sales so no slicer can affect the visuals. Explanation Correct Answer C:Display governs visibility, while Data restores filters and slicers; disabling Data preserves the reader’s current slicer choices when switching layouts. Incorrect Answers A:Duplicating fact tables does not control what report filter state a bookmark records. B:Role elevation is unrelated to bookmark data capture and violates least privilege. D:Breaking model relationships destroys analytical filtering rather than repairing bookmark behavior.
Question 241 A shared dataset refreshes under a service principal; its OAuth credential was revoked after a security review. What action should the authorized owner perform? Re-establish an approved connection identity/consent and test the semantic-model refresh Disable report RLS for all viewers Edit every visual title to include the token Delete all model relationships Explanation Correct Answer A:Revocation affects source authentication; an approved connection must be reauthorized. Incorrect Answers B:RLS is independent and should not be weakened. C:Displaying tokens creates a credential leak. D:Relationship deletion cannot restore OAuth identity.
Question 242 A dataset includes a column Address containing JSON records with City, CountryCode, and Postcode for each customer. There is one record per customer, not an array. What is appropriate? Expand it as if every character were an array item Expand the Address record column into its named fields without increasing customer row count Unpivot CustomerID into attribute rows and discard Address Change the entire Address record to Decimal Number Explanation Correct Answer B:A record expansion exposes named fields on the same parent row. Incorrect Answers A:Character-by-character expansion is not how JSON records are structured. C:Unpivoting keys would damage the customer grain. D:A nested record is not a scalar decimal value.
Question 243 An inventory system counts whole sealed boxes and never partial boxes. Reports sum units by warehouse, and 2.5 boxes is invalid. Which typed column best reflects this source contract? Decimal Number with arbitrary fractional box counts Whole Number Text containing a numeric label Date type whose serial value happens to be integer Explanation Correct Answer B:Whole Number encodes valid integral counts and avoids admitting unsupported fractions. Incorrect Answers A:Allowing fractional counts violates the described business unit. C:Text prevents native numeric summaries. D:A Date serial does not represent a count of boxes.
Question 244 A regulated team needs to give a reviewer read-only access to one compliance report but not unrelated workspace items. What access pattern best follows least privilege? Make the reviewer a workspace Admin Share the specific report or give a scoped app audience assignment with necessary underlying model permissions Grant Contributor to every semantic model in the department Provide a common SQL administrator account Explanation Correct Answer B:Item/app sharing can limit consumption to approved content without granting workspace editing rights. Incorrect Answers A:Admin exposes unrelated workspace governance controls. C:Contributor permits editing far beyond review. D:Database admin grants unnecessary source permissions.
Question 245 A weekly revenue chart needs a target line that changes when the selected business unit changes, rather than an unconditional fixed value. What analytics approach fits? Use a supported dynamic reference line tied to the applicable target measure Hardcode a single constant across all business units Sort weeks alphabetically to imitate target changes Use a screenshot line that does not recalculate Explanation Correct Answer A:A measure-driven reference can follow selected context where the visual supports dynamic lines. Incorrect Answers B:A fixed constant cannot represent different division targets. C:Week sorting does not compute a target. D:Static artwork ignores filter context.
Question 246 A financial report needs MarginRate to change when users select different departments and periods. A developer proposes materializing one column containing the enterprise margin rate at last refresh. What should be used? A DAX measure computing the ratio from filtered numerator and denominator totals One stored enterprise-wide ratio copied to every fact row A report title containing last quarter’s rate A static color rule with no value expression Explanation Correct Answer A:A measure evaluates under current report filter context, unlike a fixed per-row copy. Incorrect Answers B:A refresh-time value cannot reflect later slicer combinations. C:A title is not a numeric calculation. D:Formatting alone cannot compute a dynamic ratio.
Question 247 A warehouse report already uses x-axis DelayHours and y-axis DeliveryCost for each depot. Leadership wants larger bubbles to represent more outbound orders, while keeping the axes unchanged. What should the author configure? Put OrderCount in the Size field of the scatter/bubble chart Place OrderCount in a Page navigator Change the x-axis to Date and drop DelayHours Apply one flat bubble size to all points Explanation Correct Answer A:A bubble plot uses the Size channel to encode the third numeric measure per depot. Incorrect Answers B:Page navigation does not encode a quantitative metric in chart symbols. C:Changing the x-axis loses the stated two-variable relationship. D:A uniform size cannot distinguish depots by order volume.
Question 248 A YTD measure uses TOTALYTD([Revenue], Date[Date]). A report is filtered to Product A, while Product B also has sales in the same months. Which rows contribute to the YTD result? Every product in the company regardless of slicers Only Product A rows in the YTD date window, unless the measure removes the product filter Only the currently selected day rather than the accumulated year Only Product B because its data exists in the model Explanation Correct Answer B:TOTALYTD changes the date window; it does not automatically remove unrelated Product filters. Incorrect Answers A:The time-intelligence modifier alone does not clear the product dimension. C:YTD includes dates from the beginning of its year through the current date. D:There is no instruction switching product selection to B.
Question 249 A shop analyst built a small page containing margin and discount visuals, but hovering a Product bar never shows it as a contextual tooltip. The page has not been flagged as a tooltip. What configuration is missing? Schedule a SQL refresh every five seconds Make the tooltip page a Power Query calculated table Change every visual to a static image Enable tooltip on the page and register relevant matching Product fields, then bind it to a supporting visual Explanation Correct Answer D:Power BI report tooltips must be marked as tooltip pages and associated with the relevant fields or manually assigned. Incorrect Answers A:Refresh does not register a report page as a tooltip. B:Query tables are model objects, not report tooltip page configurations. C:Static images remove the desired context-sensitive metric values.
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.
