Question 420 A manager shares a finance report to a broad app audience but hides its Payroll page. The app still uses a model containing sensitive payroll rows. What access policy must be evaluated? Consider the Payroll page hidden and therefore all associated rows secured Change the page title to Confidential Turn all financial values into a display-only color Enforce model permissions/RLS or appropriate data restrictions rather than relying on hidden-page UI Explanation Correct Answer D:Page navigation visibility is not an authorization barrier for model rows. Incorrect Answers A:Hidden report pages are a UI setting, not a row-level access rule. B:Titles do not change model permissions. C:Colors do not prevent data queries.
Question 421 A report is filtered to Region East and Product A. Its sales measure needs Product A as a share of all East product sales while keeping the Region filter. Which DAX denominator pattern is suitable? REMOVEFILTERS() on every table in the model, which also removes Region A hardcoded denominator based on last month’s grand total A calculated column repeating Product A share on every sale CALCULATE([Sales], REMOVEFILTERS(Product)) in the denominator while retaining Region context Explanation Correct Answer D:Removing only Product context retains East while counting the product total needed for the selected-region percentage. Incorrect Answers A:Clearing all filters would include other regions and misstate the regional share. B:A fixed past total ignores active slicers and new transactions. C:A refresh-time column is not a dynamic percent of selected total.
Question 422 An analyst asks Power BI Copilot to build a new page using a third-party custom visual that is not supported by Copilot. Which response best reflects the product limitation? Assume every custom visual is created by Copilot whenever capacity is licensed Disable all semantic-model roles to unlock third-party visual generation Replace the visual with an arbitrary chart and declare feature parity Use Copilot for supported report generation, then add and validate the unsupported custom visual manually Explanation Correct Answer D:Current Copilot report authoring does not support custom visuals. The author can handle that part separately while verifying visual behavior. Incorrect Answers A:Capacity entitlement does not make unsupported custom visual types compatible. B:Removing row security is unrelated to Copilot feature support and risks disclosure. C:An arbitrary replacement can change interpretation and does not meet the stated visual requirement.
Question 423 An aviation services group wants a persistent button-based table of contents taking report consumers to the Overview, Exceptions, and History pages. Which feature is designed to create page navigation controls? Power Query Merge as new Page navigator or buttons with page navigation actions A slicer disconnected from the model A drillthrough page that requires a selected data point rather than a general table of contents Explanation Correct Answer B:Page navigation buttons or a page navigator provide intentional links among the three report pages. Incorrect Answers A:Merge as new combines tables, not report pages. C:A disconnected slicer filters nothing and cannot replace a navigation control. D:Drillthrough needs source context and is meant for a filtered detail investigation, not a persistent whole-report page navigator.
Question 424 A Power BI semantic model accesses an on-premises SQL Server through a standard gateway. A service account password is rotated and refresh now fails. Where should the administrator examine the affected identity? The report page tooltip settings The model’s RANKX ranking formula The gateway connection/data-source credentials used by the semantic model The audience display name in the published app Explanation Correct Answer C:Gateway connections hold the source authentication required for on-premises refresh. Incorrect Answers A:Tooltips control hover content, not gateway authentication. B:Ranking DAX cannot log in to SQL Server. D:App display labels are independent of the source credential.
Question 425 An invoice line table joins to InvoiceHeader by InvoiceID. Source profiling discovers repeated InvoiceID values in the header extract due to duplicate file loads, and the merge doubles line amounts. What correction restores the expected join? Enable both-direction model filtering on every table Aggregate the doubled output without documenting why it doubled Deduplicate the header source at the legitimate InvoiceID grain before the merge Remove repeated invoice lines, which can be genuine separate products Explanation Correct Answer C:A header lookup should have one row per invoice; the duplicate lookup matches each line multiple times, so source deduplication fixes the multiplication. Incorrect Answers A:Filter direction does not correct Power Query join cardinality. B:Aggregating multiplied data hides rather than repairs false duplication. D:Invoice lines can legitimately repeat InvoiceID for different line numbers.
Question 426 A measure uses CALCULATE(SUM(Fact[Amount]), Region[Name]="North"). Region is completely disconnected from Fact. Which issue should the analyst identify? The North filter will not restrict Fact rows until the intended relationship or an explicit virtual filter exists The measure always returns zero because North exists CALCULATE creates a new physical relationship at run time Changing the font of Region names will activate filtering Explanation Correct Answer A:A filter on an unrelated dimension does not propagate to the fact table automatically. Incorrect Answers B:A disconnected filter does not automatically remove all fact rows. C:CALCULATE modifies context; it does not materialize model relationships. D:Visual formatting does not define model filter propagation.
Question 427 A call-center Import dataset contains thirteen years of raw events, but every approved report uses only the last 24 months; historical records remain archived in the source for compliance. What data-reduction step is reasonable? Create one calculated copy of each old row in the model Convert the event timestamp to an unrelated color category Apply a source/Power Query date filter to load only the approved reporting period, without deleting archived source rows Increase the number of report pages to distribute the events Explanation Correct Answer C:Filtering unused historical rows reduces imported cardinality while preserving the source archive. Incorrect Answers A:Copied rows increase memory usage and duplicate totals. B:Changing a timestamp to color does not reduce the rowset or retain time semantics. D:Page count does not change how many records the model imports.
Question 428 A Power BI user configures a threshold alert on a dashboard tile and expects it to change every other user’s notification rules automatically. What should they understand? One user alert silently creates identical policies for every tenant member Data alerts are managed per user on supported dashboard tile values; other users need their own configuration or an authorized workflow A report theme propagates personal alert thresholds Every dataset numeric row can send an alert without dashboard configuration Explanation Correct Answer B:Power BI’s built-in data alert is a user’s notification rule for an eligible tile. Incorrect Answers A:Personal alert settings are not automatically tenant-wide notification policies. C:Themes affect visual presentation, not per-user alert subscriptions. D:Not all source numeric rows are evaluated as individual dashboard alerts.
Question 429 An e-learning provider wants the share of course purchases above $100 for only the selected campus and reporting month. The denominator must change with every slicer selection. Which calculation location meets that requirement? A DAX measure that counts selected high-value purchases and divides by all selected purchases One stored refresh-time percentage repeated in a column on every purchase A calculated-column sort order for purchase bands only A bookmark displaying a fixed percentage captured last week Explanation Correct Answer A:Measures evaluate against the active report filters, so both high-value count and total count reflect selected campus and month. Incorrect Answers B:A repeated column value cannot represent all future combinations of campus and month. C:Band sort order only orders categorical labels and does not calculate a rate. D:Bookmarks save visual state but not a general recalculating DAX business measure.
Question 430 A delivery matrix needs upward, flat and downward indicators based on the signed month-over-month growth measure. A designer proposes icons based on report row order. What should be configured? Conditional formatting icons with explicit ranges for positive, near-zero, and negative growth Sort the rows randomly and use the row number as performance Replace the growth measure with a string that never changes Apply one icon to the entire column independent of value Explanation Correct Answer A:Numeric rules map the sign and magnitude of growth to a consistent visual cue. Incorrect Answers B:Row position does not determine improvement or decline. C:Text-only values are not the requested signed growth calculation. D:A constant icon conveys no performance variation.
