Question 360 An auditor assigned Member on a Power BI workspace also belongs to a narrowly filtered RLS role. Their report shows all cases, not just their assigned district. What explains this? The district slicer must be hidden before RLS works Every semantic-model RLS definition applies equally to workspace Admins Workspace Member has edit permission and is not restricted by RLS like a Viewer; use a true consumption access pattern Report theme settings are overriding security roles Explanation Correct Answer C:Power BI RLS applies to Viewers; Admin, Member, and Contributor workspace roles bypass that model row filter. Incorrect Answers A:Slicer visibility is independent of model authorization. B:Elevated workspace roles are explicitly exempt from the Viewer RLS path. D:Colors cannot alter security roles.
Question 361 A procurement team modifies a report in the workspace, but the app’s consumers continue to see the earlier published version. What must an authorized app publisher do? Rebuild all underlying SQL tables as CSV files Reset every reader’s browser zoom level Unpublish the semantic model and revoke all Build permissions Update the published app after verifying the new workspace content Explanation Correct Answer D:Published app content must be updated for changes in the workspace to be distributed to its audience. Incorrect Answers A:Source replacement is unrelated to the app version being distributed. B:Zoom settings cannot publish new report content. C:Revoking model permissions would break consumption instead of distributing the revision.
Question 362 An equipment-rental dashboard calculates LossRate = DIVIDE([LostBookings], [Bookings]). For a venue with zero lost bookings and eight bookings, what is the result? 0, because 0 divided by a nonzero denominator is zero BLANK because any zero numerator forces DIVIDE to return blank 8 because that is the booking count An error because DIVIDE cannot accept zero in either argument Explanation Correct Answer A:DIVIDE(0,8)=0; the zero-denominator fallback is irrelevant because the denominator is eight. Incorrect Answers B:BLANK is the default handling of a zero denominator, not a zero numerator. C:Eight is the denominator and not the fraction of bookings lost. D:A zero numerator is a valid arithmetic input for DIVIDE.
Question 363 A fashion retailer uses Key Influencers to analyze whether a return occurs. One candidate predictor has a large relative association but covers only 12 records; another has a smaller association but covers 8,000. What should analysts consider before recommending changes to return policy? Assume the twelve-record segment represents all product lines. Discard sample sizes because the largest relative association is automatically the best policy. Rank the explanatory groups by color rather than by data evidence. Evaluate effect size, group coverage, sample quality, and possible confounding before choosing a business action. Explanation Correct Answer D:Interpreting the visual responsibly requires comparing magnitude and coverage and treating the patterns as associations, not causal prescriptions. Incorrect Answers A:A small observed group may be unstable or unrepresentative and must not be generalized automatically. B:Relative association alone cannot establish reliability or business impact without denominator context. C:Colors encode presentation and cannot substitute for sample-size or model interpretation.
Question 364 The January and February inventory extracts have Product and Count. March also adds a Reason field. Analysts want one fact table and must still tell which month each row came from. What should be done before appending? Merge all month tables by Product even though repeat transactions are valid Append without any month identifier and infer month from row order Replace missing historic Reason with the March reason for every product Add a SourceMonth field to each monthly query, then append by column name Explanation Correct Answer D:SourceMonth preserves provenance while append retains all monthly records and nulls for Reason on earlier rows. Incorrect Answers A:Merging by Product combines records horizontally and can multiply same-product monthly rows. B:Append order is not a reliable business attribute for the origin month. C:March reasons cannot be assumed true of January and February.
Question 365 A telecom provider needs users to filter monthly charges by a single group membership in Areas, but a record can belong to multiple groups and each group contains many records. The same fact amount is associated with two groups in the bridge. Summing group totals without attribution duplicates that fact across groups. What is the design concern? Use a report title to suppress duplicate values Use a documented membership/allocation rule and validate totals against fact grain Assume group totals can always be added without adjustment Delete all group memberships Explanation Correct Answer B:Explicit attribution or distinct-grain measures are needed when one event contributes to multiple groups. Incorrect Answers A:A title does not alter data aggregation. C:Simple sum of overlapping membership groups can double count the same fact. D:Deleting memberships erases required categorization.
Question 366 A retail team maps each branch and needs bigger bubbles for higher transaction volume, not for larger geographic longitude. Which map configuration is relevant? Bind Longitude to Size and discard transaction counts Use a valid location field and bind TransactionCount to the bubble size channel Set every location to the same radius regardless of metric Rename each branch after its sales value and ignore geocoding Explanation Correct Answer B:A thematic map can vary marker size by a chosen numeric business measure. Incorrect Answers A:Longitude is a coordinate, not the quantity to encode in symbol size. C:A constant radius cannot represent transaction volume. D:Changing labels does not supply valid spatial positions or numeric sizes.
Question 367 Managers want to inspect a machine’s detailed failure history and select filters after navigating. The designer proposes putting interactive slicers on a hover tooltip instead. What limitation must the team account for? Tooltip pages can always host active slicers and scrolling controls A tooltip automatically grants access to restricted machine records A dashboard tile report tooltip supports exactly the same interactions as a drillthrough page A report tooltip is not interactive; use a drillthrough page for continued filtered exploration Explanation Correct Answer D:Hover tooltips display contextual information but do not support interactive slicers or scrolling. Incorrect Answers A:Users cannot operate a tooltip page as a persistent filterable report. B:Permissions/RLS still govern data regardless of tooltip placement. C:Dashboard tooltips and report drillthrough have distinct support and interaction boundaries.
Question 368 A finance analyst sees a shared certified model in the catalog but cannot select it as the source of a new report. A teammate can. Before rebuilding all tables, what should the owner verify? Every certified model automatically grants its discovery users Build The analyst has Build permission and supported license/capacity to author over that model The report page theme matches the catalog color Changing the model name to Finance makes it universally reusable Explanation Correct Answer B:Model discoverability and authoring rights are distinct; Build is the relevant model permission. Incorrect Answers A:Certification provides an endorsement, not unrestricted authoring access. C:Colors cannot grant permissions. D:Renaming content does not override access controls.
Question 369 An international shipping API returns `2026-11-01T23:30:00Z` as a timestamp. A local operations report in UTC+05:00 must show the event on the next calendar day. Which Power Query approach correctly handles the zone before deriving a local Date? Truncate the first ten characters and label them local date Treat the Z timestamp as already local and change the column header Replace Z with an empty string, then discard any timezone evidence Parse as DateTimeZone, convert to the required local offset, and only then extract the Date Explanation Correct Answer D:Timezone-aware conversion preserves the instant and shifts its local date correctly before date grouping. Incorrect Answers A:The first ten UTC characters refer to the UTC day and would show 1 November rather than local 2 November. B:A label change cannot shift the instant from UTC to a local reporting zone. C:Deleting the zone marker loses the offset required to interpret the source instant.
Question 370 A company assigns RLS to regional auditors through Microsoft Entra security groups. One auditor moves from East to West. What change updates the person’s row entitlement? Change the color of the East map markers Hide the Region slicer on the landing page Convert all report measures into text Update the relevant role/group memberships and validate effective role access Explanation Correct Answer D:Role and group membership determines which row predicate the viewer receives. Incorrect Answers A:Map colors do not authorize source rows. B:Slicer visibility is not a security boundary. C:Measure type cannot move a user between security roles.
