Question 640 A retailer’s workspace already has a widely distributed Power BI app. Analysts added a new inventory report and need existing audiences to receive the updated app after the report is included. Which controlled action should the authorized publisher take? Update the existing workspace app, include the report for the appropriate audience, and publish the changes Create a new workspace Admin account for each consumer Change a report bookmark and assume it republishes the app package automatically Delete and recreate the semantic model to force all app readers to receive new pages Explanation Correct Answer A:App updates explicitly publish revised content and audience configuration; report edits alone may not update an existing distributed app. Incorrect Answers B:App consumers do not need administrative identities. C:Bookmarks change report state, not app publication or audience inclusion. D:Deleting a shared semantic model risks breaking dependencies and is unnecessary for distributing a report.
Question 641 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 membership table itself contains duplicated pairs of entity ID and group ID due to an import retry. What is the correct cleaning strategy? Sum repeated membership rows as new facts Make the metric value the relationship key Replace every group name with the same constant Deduplicate identical entity/group pairs before modeling the bridge Explanation Correct Answer D:The bridge should record each valid membership pair once so retry copies do not distort path counts. Incorrect Answers A:Repeated pairs are not additional memberships or measurable fact events. B:Metrics are not stable identifiers for entity/group association. C:Collapsing group names destroys the real memberships.
Question 642 A licensed Power BI author at a sports league, with Copilot enabled for the supported workspace, wants a first draft of report page visuals from a description of TicketRevenue trends. Management asks for an executive narrative based on the current governed model. Copilot is supported and enabled. What is the responsible workflow? Treat every generated sentence as automatically audited Delete the semantic model after narrative generation Give Copilot unrestricted source database credentials Generate a draft narrative with Copilot and verify all figures and claims against model visuals Explanation Correct Answer D:The model can support a summary, but the analyst remains accountable for checking numbers and context. Incorrect Answers A:Generative summaries can contain unsupported descriptions or incorrect numeric interpretations. B:The model is still needed for source-grounded verification and updates. C:Unrestricted database secrets are not necessary for a supported report narrative.
Question 643 A freight sensor feed records CargoTons=0 for an actual empty wagon, BLANK for a failed sensor, and positive numbers for loaded wagons. What data-cleaning rule preserves these distinct meanings? Replace all zero readings with null Keep valid zero measurements as zero and represent unavailable readings as null with a documented missingness flag Replace all nulls with zero Delete all positive readings so remaining categories are uniform Explanation Correct Answer B:A genuine zero is an observed physical state; null records a missing observation and must not be conflated. Incorrect Answers A:This would misclassify legitimate empty-wagon events as sensor failures. C:This would fabricate empty-wagon measurements when no observation exists. D:Removing real loads destroys the measured distribution.
Question 644 An external B2B auditor can open a Power BI report but sees no matching data. Dynamic RLS compares USERPRINCIPALNAME() with an authorization table populated from email aliases. How should the team diagnose the identity mismatch? Turn off all RLS filters for every guest to ensure nonempty visuals Have the actual guest sign in, inspect their resolved UPN, and align the authorization mapping with that value Assume the Test as role simulator always reproduces the guest authentication identity Grant the guest Contributor to bypass RLS temporarily Explanation Correct Answer B:External guest UPN resolution may differ from mail aliases. Testing with the real guest reveals the value the model evaluates. Incorrect Answers A:Disabling all row filters would expose unauthorized data. C:Test as role uses the tester’s identity and cannot reliably simulate a distinct B2B guest UPN. D:Contributor bypasses Viewer RLS and grants editing rights, an unsafe diagnostic shortcut.
Question 645 Two branches process 5 and 15 completed jobs, costing 100 and 180 respectively. A model measure computes DIVIDE(SUM(Cost), SUM(CompletedJobs)). What is the combined cost per job? 14 16, the average of branch unit costs 20 and 12 20, using only the first branch cost per job 280, summing costs without dividing by jobs Explanation Correct Answer A:The combined rate is (100+180)/(5+15)=280/20=14, weighting branches by completed jobs. Incorrect Answers B:The unweighted average of 20 and 12 gives each branch equal weight despite unequal throughput. C:The first branch rate omits the second branch’s records. D:280 is total cost, not cost per completed job.
Question 646 A daily product file includes ProductID, Day, Channel and Units. Several product-day-channel records are valid separate sales, and the pivoted Channel columns must show units sold rather than number of transactions. Which aggregation is required? Count rows, which answers transactions instead of units sold Do Not Aggregate despite repeated ProductID-Day-Channel combinations Minimum Units, which discards all but the smallest sale Sum Units when pivoting Channel at ProductID-Day grain Explanation Correct Answer D:Sum preserves total unit volume from all legitimate records in each output product/day/channel cell. Incorrect Answers A:Count treats every sale as one regardless of units. B:A duplicate pivot intersection cannot be reduced without an aggregation. C:Minimum loses units from all other valid sales.
Question 647 A subsidiary has a certified semantic model. A thin report accidentally binds Revenue Forecast to a chart titled Actual Revenue. How should the certification badge affect review? Publish automatically because certification proves the chart binding Still validate the report’s actual field bindings; model endorsement does not certify every downstream visual Remove all model data security rules because the model is certified Replace the chart with a database-password text box Explanation Correct Answer B:Certification is an endorsement of the model, not a guarantee that each report author selects the right measure. Incorrect Answers A:The display title can remain misleading despite an endorsed model. C:Endorsement does not change row-level authorization. D:Exposing credentials is irrelevant and unsafe.
Question 648 A stadium-operations report has one line chart showing revenue by Year. Managers want to expand a selected Year to Quarter and then Month **in the same chart**, without opening a separate report page. Which navigation feature should be configured? A Year–Quarter–Month date hierarchy with the visual’s drill-down controls Drillthrough to a separate report page, with Year as its navigation field A report page tooltip showing only the yearly total A bookmark fixed to the author’s initial Year selection Explanation Correct Answer A:Drill-down changes the displayed hierarchy level in the same visual; drillthrough would instead navigate to another report page. Incorrect Answers B:Drillthrough opens a destination page and does not satisfy the same-chart hierarchy requirement. C:A hover tooltip does not expand an axis into successive date levels. D:A static bookmark cannot dynamically navigate an arbitrary selected hierarchy level.
Question 649 A licensed contractor will create a new report in an existing workspace and change its layout, but another owner will manage app publication and access. Which role avoids excessive privileges? Workspace Admin Contributor, assuming all required licensing and model access are present Workspace Member with app publication authority Viewer because it can change shared visual definitions Explanation Correct Answer B:Contributor allows editing workspace artifacts without broader app and membership management. Incorrect Answers A:Admin adds workspace controls outside the contractor’s job. C:Member gives app publication and lower-role invitation rights not requested. D:Viewer can consume content but not author changes to shared workspace reports.
Question 650 A Sales fact contains five lines belonging to three invoices. It is correctly related many-to-one to Customer. A report asks how many invoices were issued, not how many line items exist. Which measure matches the business grain? DISTINCTCOUNT(Sales[InvoiceID]) rather than counting Sales rows COUNTROWS(Sales), which returns five lines SUM(Sales[InvoiceID]), treating invoice identifiers as amounts Count Customer rows, which counts customers rather than issued invoices Explanation Correct Answer A:InvoiceID identifies one business invoice across its lines; DISTINCTCOUNT returns three invoice entities. Incorrect Answers B:The fact line count is five, not the requested three invoices. C:Invoice identifiers are categorical keys and must not be summed. D:The customer dimension grain differs from invoice grain.
