Question 480 An operations source contains valid 0 downtime values plus empty strings meaning the sensor did not report. Reports need to distinguish operational zero from missing measurements. What transform is appropriate? Map the empty markers to null, retain real zeros, and type the measured field numerically Replace missing markers with 0 without tracking missingness Replace every real zero with null and mark production offline Convert the downtime column to month-name text Explanation Correct Answer A:Null distinguishes unobserved values from a genuine recorded zero and permits correct completeness calculations. Incorrect Answers B:Zero imputation can hide device reporting failures. C:A true zero downtime is valid business evidence and should remain. D:Month names do not represent downtime magnitude.
Question 481 A contractor leaves, and their account is disabled in Microsoft Entra ID. The reporting team assumes all Power BI sharing records were immediately erased and needs a clean entitlement inventory. What is correct? Disabled identities may retain stored access records; audit and remove no-longer-required Power BI/group grants under policy The Entra disable action always deletes every workspace permission record instantly A report title change revokes dormant grants The person can regain access merely by editing a slicer Explanation Correct Answer A:Microsoft distinguishes account sign-in disablement from removal of persisted workspace/item access records. Incorrect Answers B:Access records can remain for restoration purposes. C:Report titles do not revoke stored entitlements. D:Slicers do not reenable a disabled account.
Question 482 A commission chart uses an aggregated TotalSales field, but its report tooltip was assigned to the unsummarized transaction column; the custom tooltip fails to appear. What should the analyst review? Remove all semantic-model measures used by the chart Rename the workspace so Power BI regenerates report pages Turn off the chart’s report-page tooltip toggle permanently Match the registered tooltip field and summarization level to those used by the source visual Explanation Correct Answer D:Power BI matches tooltip fields including summarization; mismatches can prevent the selected page from appearing. Incorrect Answers A:Removing the measure breaks the chart rather than registering the tooltip field. B:Workspace names do not resolve tooltip-field matching. C:Disabling the tooltip defeats the requirement instead of diagnosing its field association.
Question 483 A software company has 800 read-only report consumers. They must view only the published product-performance reports, with governed RLS, but should not browse the entire authoring workspace. What access pattern should the administrator use? Assign every consumer Admin in the authoring workspace Distribute the original PBIX and database passwords to consumers Publish an app with the relevant audience and report permissions, leaving authoring workspace roles limited Give consumers Contributor so they can investigate the model if the report is unclear Explanation Correct Answer C:App audiences deliver selected content without granting organization-wide workspace editing; RLS can still govern their data. Incorrect Answers A:Admin rights expose workspace settings and content far beyond reader requirements. B:Distributing source files and credentials creates needless copies and security exposure. D:Contributor includes editing rights and can bypass semantic model RLS for workspace users.
Question 484 A service desk is testing anomaly detection on daily incident counts. Raising sensitivity produces many extra flagged days, including routine fluctuations. What should an analyst do? Assume every flagged day is a proven underlying source error Turn off the time axis while keeping anomaly detection Tune sensitivity against business-defined meaningful events and investigate flagged observations Increase sensitivity until every day is classified as anomalous Explanation Correct Answer C:Sensitivity changes the detection threshold; flags warrant validation rather than automatic conclusions. Incorrect Answers A:A statistical deviation is not automatically data corruption. B:Time context is essential for the detection feature. D:Flagging everything destroys the distinction between normal and unusual events.
Question 485 A corporate SQL service account is rotated on Sunday, but two shared semantic models use a single managed gateway connection. One starts failing on Monday. Which administrative action addresses the shared dependency? Update/test the credential on the affected shared gateway connection and verify both models’ refresh histories Rebuild every report visual using a different color theme Revoke RLS for all users Change the workspace name to match the SQL login Explanation Correct Answer A:A shared gateway connection may be used by multiple models and should be rotated and validated consistently. Incorrect Answers B:Visual themes cannot authenticate source access. C:Disabling RLS weakens data access without correcting SQL login. D:Workspace names are not source credentials.
Question 486 A sales model builds a Date table from fact timestamps. The first version has duplicate calendar dates and skips nontransaction days. Analysts need standard year-to-date calculations. What must be fixed before marking this as a date table? Remove weekends and holidays because they have no transactions Store month names as the designated date column Build one unique contiguous row for each calendar date and select that true Date column Keep the timestamps with multiple rows per day as a unique date key Explanation Correct Answer C:A proper date dimension contains a unique, contiguous date key that can support consistent time-intelligence periods. Incorrect Answers A:Missing calendar days break contiguous-period expectations. B:Text month names are neither unique daily dates nor chronological keys. D:Repeated dates cannot serve as the unique daily date column.
Question 487 A manager wants to identify the five departments driving excessive handling time. A single Card currently shows only 84,000 total minutes. What report change actually exposes the breakdown? Change the Card title to Department Comparison Set the Card font size higher Use a categorical bar chart of HandlingMinutes by department, retaining the Card only as a summary Apply an RLS role that hides department values from every consumer Explanation Correct Answer C:A per-department chart lets readers compare contributors while the Card remains an optional aggregate. Incorrect Answers A:Renaming a single total does not reveal per-department variation. B:Larger text cannot add a missing categorical breakdown. D:RLS would restrict data rather than build an analytic distribution.
Question 488 A data steward centralizes consent filtering in a Power Query query named CleanCases. Two report-ready queries must incorporate any later updates to that same cleaning step. Which method maintains that dependency? Append two references into a single field to make the filters global Use Reference to create dependent queries from CleanCases Use Duplicate to create disconnected copies that never receive upstream revisions Copy the displayed table into a screenshot for each model Explanation Correct Answer B:Reference creates queries that use the result of CleanCases, allowing updates to central cleaning logic to flow into dependent queries. Incorrect Answers A:Append stacks table rows and does not create a reusable transformation dependency. C:Duplicate copies the expression steps at that time; future edits to CleanCases do not automatically update them. D:A screenshot has no query evaluation or source lineage.
Question 489 A bookstore stores month-end quantities for two titles. On March 31, Title A has 12 copies and Title B has 8. Earlier months also contain balances for both. What is March 31 total on-hand stock? 20 copies by summing the two SKU balances for the same closing date Sum all balances across January, February, and March for both titles 12 copies because only one SKU has a positive number An average of all daily transaction line quantities without using snapshot dates Explanation Correct Answer A:Inventory can be additive across SKU at one point in time while nonadditive across successive dates. Incorrect Answers B:Adding time snapshots repeats the same stock across periods. C:Ignoring Title B understates the total stock. D:Transaction-line means are not the March closing inventory state.
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.
