Question 490 An analyst uses Edit interactions on a slicer and configures two target charts. Clicking a different bar chart still modifies them unexpectedly. What should the author understand? Interactions are configured for each source visual separately; select the bar chart and set its target interactions too One setting on the slicer globally controls all other source visuals Changing the report theme permanently disables all cross-filtering Every relationship must be bidirectional to stop this Explanation Correct Answer A:A configuration made while the slicer is selected does not define how a separate bar chart affects targets. Incorrect Answers B:Each source has its own interaction configuration, not a universal page-only switch. C:Themes cannot override selection propagation logic. D:Bidirectional relationships can increase filtering paths and do not disable the visual interaction.
Question 491 A sports venue has EventID E9 on 15,000 admission records, each with a unique TicketID. Analysts propose removing duplicates on EventID because all rows share the same event. What is wrong? Remove 14,999 legitimate tickets to ensure EventID is unique Each admission is distinct at TicketID grain; EventID is a grouping attribute, not a per-ticket deduplication key Use the event title as a measure to identify tickets Count one paid admission per event regardless of tickets scanned Explanation Correct Answer B:The fact grain is one ticket/admission, so repeated EventID values are expected. Incorrect Answers A:Removing valid tickets catastrophically understates attendance. C:A title is not a unique ticket identifier. D:One event can legitimately have many admitted participants.
Question 492 A school district uses Entra groups to assign report viewers to campus-based RLS roles. A staff member transfers campuses and remains in both old and new groups. What governance action is necessary? Give the staff member global workspace Admin to remove restrictions Update group memberships to match the authorized campus and test effective RLS under that identity Rename the slicer to New Campus and assume rows follow Disable RLS for the entire tenant after every staff transfer Explanation Correct Answer B:Group membership drives effective row roles; outdated grants can expand the viewer’s permitted campus rows. Incorrect Answers A:Admin bypass would exacerbate unauthorized data access. C:Slicer labels do not change security groups. D:Turning off RLS exposes all rows to consumers.
Question 493 Operations adds a monthly chart of shipping throughput to an existing sales model. A visual currently responds to OrderDate because that is the active relationship; the team insists ordinary sales reports must remain unchanged. What should be tested before declaring the shipping chart correct? Assume the shipping chart uses ShipDate because the axis is titled Shipped Switch the active relationship globally without comparing existing sales results Use row-level security to redirect the date relationship Check that the shipping-specific measure activates the ShipDate relationship and validate results with orders whose dates differ Explanation Correct Answer D:A targeted measure and an order crossing month-end prove the intended event date controls the shipping metric. Incorrect Answers A:Renaming a chart label does not change which relationship filters the fact. B:A global relationship change would alter ordinary sales reports. C:RLS filters accessible rows and does not choose which date role a measure uses.
Question 494 A report matrix includes many quarterly columns. Users scrolling right lose sight of the department names and sometimes misread totals. Which setting addresses this usability issue? Sort the measure values by random order Remove the Department field from Rows Disable all horizontal scrolling by turning numeric measures into text Use the matrix row-header Freeze option where appropriate for the desktop layout Explanation Correct Answer D:Frozen row headers keep the grouping labels visible while wide matrix columns scroll. Incorrect Answers A:Random sorting does not preserve row identification. B:Removing Department eliminates the needed grouping. C:Changing measures to text does not fix column width and corrupts numeric analysis.
Question 495 A workspace Contributor has been allowed by the Admin to update an existing Power BI app. The team now wants that Contributor to publish an app for the first time. Which statement is accurate? Delegation allows Contributors to create and unpublish any app Every Viewer automatically gets first-publication rights A report-level Build grant alone lets anyone create a workspace app Contributors cannot publish a new app under that delegation; use an authorized Member or Admin Explanation Correct Answer D:Microsoft distinguishes updating an existing app from publishing a new app, which remains a Member/Admin capability. Incorrect Answers A:Update delegation does not expand to first publication or full app governance. B:Viewer role has no app publication authority. C:Build is semantic-model reuse permission, not workspace app management.
Question 496 A DirectQuery model is used by 300 analysts whose dashboards trigger many interactive queries simultaneously. The underlying OLTP server becomes saturated. What should architecture review consider? Source capacity/query performance and workload isolation, plus caching or aggregation options where business latency allows Turn every numerical measure into text Delete all workspace roles Increase report-title length to delay requests Explanation Correct Answer A:DirectQuery shifts interactive workload toward the source, so source concurrency and aggregation strategy matter. Incorrect Answers B:Text conversion does not solve source demand. C:Removing roles weakens access and does not tune queries. D:Long titles have no meaningful effect on SQL execution concurrency.
Question 497 An analyst needs to test a risky currency-conversion transformation on a copy of an existing Power Query pipeline. Changes made in the experiment must not affect the approved production transformations. Which operation best isolates the experiment? Edit the production query directly while report consumers are active Remove load from production and expect the experiment to inherit approvals Duplicate the approved query into an independent branch before testing Use Reference and edit the shared upstream production steps Explanation Correct Answer C:Duplicate copies the current query steps into a separately editable query; later experimental edits need not change the approved source branch. Incorrect Answers A:Direct production edits expose consumers to unreviewed transformation behavior. B:Disable load controls model output and is not an isolation or approval mechanism. D:A reference still depends on the original upstream query, so changing upstream steps would affect production.
Question 498 A report page filters ProductCategory to Bikes and Accessories. A table displays one category per row. For percent-of-selected-categories, which denominator respects the page slicer but removes the current table-row category? CALCULATE([Sales], REMOVEFILTERS(Product[Category])) CALCULATE([Sales], ALLSELECTED(Product[Category])) [Sales] without any modifier FORMAT([Sales], "0.0%") Explanation Correct Answer B:ALLSELECTED keeps outer explicit selections and removes the row-level category filter for the visual total. Incorrect Answers A:REMOVEFILTERS on Category would include categories excluded by the outer page slicer. C:Each row retains its own category filter, making a row/row division uninformative. D:Formatting converts a value to text and does not define the comparison population.
Question 499 A SQL-backed sales query folds source filtering and column selection, but a final custom M calculation executes locally. A colleague says the entire query now does no source-side work because its final step does not fold. What is correct? Any local M step forces all preceding source filters to run locally too The query may still have partial folding: SQL processes the supported earlier steps while the Power Query engine evaluates the remaining operation Adding a report bookmark converts all custom functions to source SQL Partial folding can occur only with Excel text files that have no query engine Explanation Correct Answer B:Partial query folding leaves some transformations at the SQL source and others in Power Query; plan inspection reveals the actual split. Incorrect Answers A:The folding mechanism can delegate a subset of supported operations even when later work runs locally. C:Report bookmarks have no relationship to M query evaluation. D:Structured SQL sources commonly support partial folding; flat files usually have no comparable native query processor.
Question 500 A university’s cost reporting uses Department and ResearchProgram dimensions. Reviewers want to inspect expenditure in one department and then subdivide only that branch by program. What is suitable? Replace every department with the global cost Card Create a new CSV from the entire fact table for each click Use only an unconditional chart background fill Expand the selected branch in a Decomposition Tree using ResearchProgram as the next explanatory dimension Explanation Correct Answer D:Tree branching retains the selected department context while comparing its program subcategories. Incorrect Answers A:An overall Card removes the needed branch-specific breakdown. B:Repeated exports are not necessary for interactive dimension splits. C:Background styling has no data decomposition mechanism.
