Question 380 A university receives course Fee values between 0 and 12,000, but one row is 9,999,999. Before removing it, analysts must confirm whether it is a valid exceptional contract. Which profiling action supports that decision? Inspect Column profile statistics and anomalous values, then validate the outlier against source rules Delete every large numeric value without source investigation Change the amount to Text so the maximum cannot be calculated Replace every other fee with the largest value Explanation Correct Answer A:Minimum, maximum and distribution inspection exposes the exceptional amount; business validation determines whether it is erroneous. Incorrect Answers B:A large observation might be legitimate and should not automatically be discarded. C:Text conversion hides the anomaly rather than verifying its meaning. D:Imputation to an outlier destroys the original distribution.
Question 381 A procurement analyst has been assigned a regional RLS role, but a colleague has also granted them Contributor in the report workspace. In the Power BI service the user can view all regions. Which fact explains the behavior? RLS does not apply to users with Contributor or higher workspace edit roles; a consumer who must be filtered needs an appropriate Viewer/app access path RLS is disabled automatically when the report is presented with a blue theme RLS applies to every workspace Admin even when the Admin owns and edits the semantic model A Date-table relationship can override Contributor privileges and force RLS on any editor Explanation Correct Answer A:The high workspace role provides edit-level model access, which is outside the Viewer RLS enforcement boundary. Incorrect Answers B:Themes are presentation configuration and cannot change security roles. C:RLS does not apply to elevated workspace roles merely because the person is assigned to a model RLS role. D:Relationships propagate filters but do not supersede workspace privilege rules.
Question 382 An operations team sees one unusual depot in a plot of maintenance cost versus downtime. A proposed fix aggregates all depots by country, causing the unusual point to disappear. Why is this problematic? Aggregation removes depot-level variation; retain depot points when investigating individual outliers Country averages guarantee every depot is typical A hidden outlier proves the source incident was fixed Converting downtime to a tooltip name restores numeric coordinates Explanation Correct Answer A:Point granularity must match the business entity under investigation. Incorrect Answers B:An average can conceal extreme depot values. C:Removing visual evidence does not repair an operational event. D:Tooltip names do not replace a numeric axis.
Question 383 A manufacturing QC table records MachineID, Date, Metric and Reading. Some machines report the same daily peak-temperature metric more than once, and management wants the highest reading per machine per date. Which pivot aggregation meets the requirement? Choose Do not aggregate despite duplicate MachineID-Date-Metric rows Pivot Metric and aggregate Reading using Max at MachineID-Date grain Use Sum, which would add repeated peak temperatures together Use Count, which returns how many readings occurred Explanation Correct Answer B:Max retains the highest observed value at the specified grain, unlike summing measurements that are intended as peaks. Incorrect Answers A:Nonaggregate pivot requires a unique value for each output cell. C:Adding temperature peaks yields a meaningless total for this requirement. D:A count measures observations, not their maximum magnitude.
Question 384 A Power BI model links Employee, AssignmentBridge and Project. Users should see projects only when authorized, but enabling Both across every relationship creates ambiguous paths. What should the author prioritize? Set Both on every relationship and assume security propagates safely Remove all role filters once the bridge exists Add a new bidirectional relationship from every fact to every dimension Model an explicit authorized filter path through the bridge and test the security predicate with supported relationship directions Explanation Correct Answer D:Security requires a deliberate path and role filter; relationship direction and bridge security must be reviewed together to prevent ambiguous propagation. Incorrect Answers A:More Both-direction relationships introduce ambiguity and do not guarantee security correctness. B:A bridge table is not a substitute for permission enforcement. C:Extra cross-filters increase competing paths and make validation harder.
Question 385 A financial matrix currently indents BusinessUnit, Department, and Team into one compact row-header column. Users want a separate named column for each level while keeping the same hierarchy. Which matrix setting fits? Enable an unrelated map layer Convert all department labels into measures Delete the Team hierarchy level entirely Switch Matrix layout to Tabular for separate row-header hierarchy columns Explanation Correct Answer D:Tabular matrix layout displays hierarchy levels in separate columns without destroying the levels. Incorrect Answers A:A map cannot change hierarchical row-header formatting. B:Names are grouping dimensions, not values to sum. C:Deleting a hierarchy level removes requested reporting detail.
Question 386 Power BI reports rely on one standard on-premises gateway server. Reboots make refresh unavailable. The company wants a supported failover design for its shared SQL connections. What should be evaluated? Replace gateway with a report tooltip Add supported gateway cluster members and configure shared connection failover Move SQL credentials to a dashboard title Delete the semantic model’s Date dimension Explanation Correct Answer B:A standard gateway cluster can support availability across managed members. Incorrect Answers A:A tooltip is visual UI and cannot provide an on-premises network tunnel. C:Public credentials would be a security incident, not HA. D:Model date tables do not control gateway node availability.
Question 387 A procurement report syncs Department selection across Overview and Detail. Users clear the Department slicer on Detail, and Overview unexpectedly resets. What explains this? The semantic model was deleted when the slicer was cleared The pages share synchronized slicer selection state, so clearing it on one page changes the other Synced slicers only work in one direction from Overview to Detail Changing selection on one synced page cannot affect another Explanation Correct Answer B:Synchronized slicers are one shared selection state across the configured pages. Incorrect Answers A:Clearing a filter does not remove the underlying model. C:Sync is not a one-way broadcast with immutable first-page selection. D:A shared selection must update when an authorized user changes it.
Question 388 Monthly totals are December 2025=100 and January 2026=25. A calendar-year TOTALYTD measure is evaluated for January 2026. What result is expected? 125, carrying the previous December into the new year 100, only the December amount BLANK because YTD cannot span a new year 25, because the YTD calculation restarts on January 1 Explanation Correct Answer D:Calendar-year YTD excludes December 2025 from the January 2026 window. Incorrect Answers A:A calendar-year boundary resets the accumulator instead of carrying December. B:December belongs to the previous year and is not the current January result. C:The function supports a valid new-year period beginning January 1.
Question 389 A team intends to store its SQL connection password in a report text box so owners can fix refresh faster. What is the appropriate alternative? Manage the authentication securely in the service/gateway connection and restrict who can administer it Display the password as a tooltip instead of text Store the password in a DAX calculated column Give all report consumers the password as a subscription attachment Explanation Correct Answer A:Managed connection credentials avoid exposing secrets in report content and separate refresh administration. Incorrect Answers B:A tooltip still discloses the secret to viewers. C:DAX model columns are not a credential vault. D:Emailing passwords to consumers expands the exposure.
Question 390 A freight distributor has individual delivery rows with Depot, DeliveryID, and optional ShipmentWeight. A supervisor requests the average non-null ShipmentWeight for each depot. Which Power Query aggregation should be used? Count distinct DeliveryID and assume the result is a weight Append the Depot dimension to the fact table and leave the measures ungrouped Group by Depot and aggregate ShipmentWeight using Average Use Sum of ShipmentWeight and report it as an average Explanation Correct Answer C:Average calculates a mean weight from valid numeric measurements within each depot group. Incorrect Answers A:A distinct ID count describes number of deliveries, not their mean weight. B:Append stacks dimension records and does not produce a depot-level statistic. D:Sum adds all kilograms and is not a per-delivery average.
