Question 80 A financial cooperative must export a multi-page, fixed-layout printable statement with repeating headers and precise row breaks. Which report type should the team evaluate instead of a typical scrolling interactive canvas? Scatter chart for page breaks A bookmark that converts any visual into PDF layout Paginated report designed for print-ready page control Single Power BI card visual Explanation Correct Answer C:Paginated reports support pixel-precise page layout, repeating headers and controlled print/export pagination. Incorrect Answers A:Scatter charts visualize correlations and have no report pagination model. B:Bookmarks restore filter/display states but do not automatically supply fixed-layout report pagination. D:A card cannot contain page-controlled, row-based financial statements.
Question 81 A subscription company has inconsistent missing-category tokens: some Plans entries are true nulls and others contain the literal text "(blank)". Before producing a reliable missingness profile, what should the analyst do? Standardize the literal "(blank)" missing-value token to null Convert all valid Plans values to integer keys without a lookup Delete every row belonging to any category Aggregate categories before reconciling missing values Explanation Correct Answer A:Converting the '(blank)' marker to null makes profile counts distinguish missing values from real Plans labels. Incorrect Answers B:Changing legitimate categories to numeric identifiers does not standardize the missing marker. C:Deleting all categorical rows destroys useful data and is unnecessary for missingness assessment. D:Aggregation hides individual missing tokens instead of correcting them in source rows.
Question 82 A sports league has confidential match tickets records and must have a classification label follow the Power BI report in supported environments. Which feature applies data classification and protection metadata? Microsoft Purview sensitivity label applied to the Power BI item A chart theme named Confidential Changing the file extension of a report A bookmark called Private Explanation Correct Answer A:Sensitivity labels express classification/protection policy for supported Power BI assets and their permitted downstream uses. Incorrect Answers B:A theme label is only a visual design string, not an enforceable information-protection classification. C:Renaming file types is not governance classification. D:Bookmarks only store report states and do not impose security labels.
Question 83 A service dashboard calculates EscalationRate = DIVIDE([Escalations], [Cases], 0). The selected month has six escalations and no recorded cases. What value appears? 0, because the third argument provides the zero-denominator result BLANK(), because DIVIDE always ignores a third argument 6, because the numerator is six A divide-by-zero error that stops the report Explanation Correct Answer A:For denominator zero, DIVIDE uses the provided constant alternate result of 0 rather than its default BLANK. Incorrect Answers B:BLANK is the default only when no alternate result is specified. C:The six escalations are a numerator, not a quotient when the denominator is zero. D:DIVIDE is intended to avoid a divide-by-zero runtime error.
Question 84 A field team at a software vendor views the report primarily on narrow phones, and the desktop canvas requires excessive horizontal scrolling. What report authoring step most directly improves the mobile experience? Put more columns into every table visual Add all source fields to a hidden detail page Design and test the report’s phone layout with the intended visuals Increase desktop canvas width Explanation Correct Answer C:A dedicated phone layout can reorder and resize license invoices visuals for a narrow screen. Incorrect Answers A:Extra table columns increase horizontal scrolling rather than removing it. B:Hidden detail fields do not rearrange the primary mobile canvas. D:A wider desktop canvas makes the mobile overflow worse.
Question 85 After a government agency rotates its cloud database password, refresh of an Import service applications semantic model fails with an authentication error. The gateway is online. What should the analyst check first? Create a new dashboard tile Change the visual theme to the default Update and test the relevant data source credentials in semantic-model or connection settings Disable row-level security roles Explanation Correct Answer C:Authentication errors immediately after password rotation point to stored connection credentials. Incorrect Answers A:Dashboard tiles cannot repair an underlying source login failure. B:The report theme has no influence on database credentials. D:RLS filters viewing users; disabling it would not repair source authentication.
Question 86 A nonprofit has finished staging a lookup query for Chapters but should not expose that staging-only table in the semantic model; a separate final dimension query references it. What load-setting choice is appropriate? Delete the staging query despite dependent references Convert every staging field to text Duplicate and load all staging/intermediate queries Disable Enable load on the staging query while keeping the final dimension query loaded Explanation Correct Answer D:Disabling load keeps the staging logic available for downstream references without adding its intermediate Chapters table to the model. Incorrect Answers A:Deleting the stage can break the final Chapters query that depends on it. B:Type changes are independent of whether a staging table should be loaded. C:Loading intermediates clutters the semantic model and increases needless model surface.
Question 87 A department has an approved central Power BI semantic model. An analyst can view a report but cannot create a new thin report based on that model. Which model permission should the owner verify? Workspace Admin over every upstream source database Build permission on the shared semantic model, along with suitable report-authoring access Only a saved personal bookmark A report page tooltip assigned to the home page Explanation Correct Answer B:Build authorizes model reuse for new reports; report viewing alone does not guarantee Build. Incorrect Answers A:Database administration is far broader than model reuse and not inherently required. C:Bookmarks store a view but cannot create a model-connected report. D:Tooltips change presentation, not semantic-model authoring rights.
Question 88 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. Which model object addresses the genuine many-to-many association? Make the fact amount column the relationship key Duplicate the complete transaction table once per group Assume the group key is unique in the fact without checking A bridge table containing unique pairs of record and group keys Explanation Correct Answer D:A bridge table represents the valid pairs and separates many-to-many membership from the monthly charges fact grain. Incorrect Answers A:Charge is a measure, not a stable identifier for membership in Areas. B:Duplicating the full fact for every group risks overcounting and maintenance problems. C:Groups explicitly repeat in membership records, so treating the field as a unique key is incorrect.
Question 89 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. What can the author use while still validating all generated content? A manual Q&A visual with keyword matches but no report page authoring A Smart narrative visual summarizing an existing chart without building the requested page Manual credential changes as a replacement for visual design Copilot report-page creation or content suggestions, followed by review Explanation Correct Answer D:Enabled Copilot report functionality can draft a page or suggest visuals, but the author must validate field choices and TicketRevenue claims. Incorrect Answers A:A Q&A visual accepts natural-language queries but does not satisfy the requested Copilot-generated report layout. B:Narrative summaries describe existing visuals; they are not equivalent to composing the new report page and selecting visuals. C:Credential settings control authentication and cannot produce visual compositions.
Question 90 A passenger-transit report compares weekly fare recovery with a target that varies by route and contract year. Finance supplies an approved [TargetRecovery] measure that changes when users select the route. A single hardcoded horizontal line is misleading. Which design meets the requirement? Hardcode last year's corporate-wide target as a constant line for every route Sort the weeks by their recovery values and call the order a target Use the historical overall mean as the target even though contracts specify distinct route targets Plot the context-sensitive target measure alongside the observed fare recovery and validate both against route/year selections Explanation Correct Answer D:A measure-bound target series evaluates in the selected route and year context; it can be compared to actual results rather than pretending one value applies everywhere. Incorrect Answers A:A single constant ignores the contractual differences across selected routes. B:Value-sorting changes chronological order without calculating a target. C:An average of observed values is not the approved contractual threshold.
