Question 330 A team attempts anomaly detection on a categorical chart of StoreName, with no time series. What must change to evaluate unusually high weekly demand over time? Rename the StoreName category to Date without changing its values Use a supported line chart with a valid time axis and numeric demand series Create a bookmark containing a high demand value Convert demand to text and use a pie chart Explanation Correct Answer B:The feature analyzes a numeric time series rather than an arbitrary category ordering. Incorrect Answers A:Renaming a category does not create chronological values. C:Bookmarks capture view states and do not detect deviations. D:Text and pies discard the temporal numeric series.
Question 331 A shipping feed records parcel weights 0.75, 1.25, and 2.5 kilograms. The author converts the field to Whole Number and loses fractional mass. What type correction is appropriate? Use Decimal Number or an appropriate fixed-decimal type that retains the required precision Keep Whole Number and round every parcel to the nearest kilogram Convert kilograms to True/False Discard every row with a fractional measurement Explanation Correct Answer A:A decimal type preserves legitimate fractional physical quantities for aggregation. Incorrect Answers B:Rounding every parcel changes actual weights and total freight estimates. C:Boolean values cannot represent the measured magnitude. D:Fractional weights are valid, not data errors to exclude.
Question 332 A payroll semantic model contains an EmployeeSSN column. The column is hidden in Fields, but authorized Build users can still discover its values. What can enforce column-level access restrictions for viewers? Apply appropriate object-level security (OLS) to the sensitive column through model roles, combined with proper permissions Hide the field name a second time Turn the report background gray Rename EmployeeSSN to InternalCode and leave values accessible Explanation Correct Answer A:OLS restricts access to secured columns/tables, whereas hiding a field is only a discoverability setting. Incorrect Answers B:Hidden columns may still be queried by entitled model users. C:Theme appearance cannot protect model data. D:Renaming metadata leaves sensitive values exposed.
Question 333 After an administrator revokes a Power BI connector’s OAuth consent, scheduled refresh fails even though the source tables still exist. What should the dataset owner verify? Disable the Date table relationships Reformat all measures as percentages Reauthorize the connector using supported OAuth credentials and confirm the required scopes and policy approvals Delete all RLS roles so OAuth can bypass source authentication Explanation Correct Answer C:Expired or revoked OAuth authorization must be restored through the supported credential/consent workflow. Incorrect Answers A:Relationships do not grant a source authentication token. B:Number formatting cannot renew OAuth scopes. D:RLS changes would weaken security without fixing the external auth failure.
Question 334 A DAX measure evaluates COUNTROWS(FILTER(Tasks, Tasks[Status] = "Escalated")) in a context where no tasks are escalated. What is its documented result? BLANK() 1 because the filter table expression exists -1 because no rows meet the condition All task rows despite the filter Explanation Correct Answer A:COUNTROWS returns BLANK when the supplied table expression contains no rows. Incorrect Answers B:An empty table has no row to count. C:Negative counts are not returned for empty sets. D:The FILTER predicate restricts, rather than includes, all other statuses.
Question 335 A maintenance dashboard has six charts; only one map consistently stalls when a filter changes. The author needs per-visual diagnostics before replacing the semantic model. What should they capture? The number of model relationships without measuring any queries A screenshot of the report without execution timings Performance Analyzer timings for each visual after clearing the current performance recording Only the overall page-loading time without visual breakdown Explanation Correct Answer C:Per-visual DAX query, display and other times can isolate which visual owns the latency and where the delay occurs. Incorrect Answers A:Relationship count alone is not evidence that a particular visual is slow. B:A screenshot cannot reveal DAX or rendering duration. D:A page-level duration cannot distinguish the slow map from the five responsive charts.
Question 336 A donor-relations analyst repeatedly opens the same published report to inspect one fund, one region, and a particular date range. The owner must not change the report’s default view for everyone. What should the analyst save for personal reuse? Create a personal bookmark capturing the desired supported report state Ask for workspace Admin so their filters become organization-wide Rebuild the semantic model with the region hardcoded Disable report bookmarks globally and republish a different default for all readers Explanation Correct Answer A:Personal bookmarks preserve a permitted reader’s chosen report view without changing the published report default for colleagues. Incorrect Answers B:Workspace administration is unnecessary for saving a reader-specific view. C:Hardcoding a slicer choice in the shared model changes data semantics for everyone. D:Disabling bookmarks prevents the personal persistence that the user requested.
Question 337 A wholesale distributor has an OrderValue column and a HighValue flag. A report must show the percent of high-value orders among whichever Month and Region the viewer selects. Which DAX artifact should the analyst create? A source-credential parameter holding the global rate A static report image of last quarter’s percentage A measure such as DIVIDE([HighValue Order Count], [Selected Order Count]) evaluated in the current filter context A calculated column with one precomputed percentage repeated for all source rows Explanation Correct Answer C:A measure recomputes numerator and denominator under the selected month and region so the ratio changes with slicers. Incorrect Answers A:Authentication parameters cannot compute the selected transaction ratio. B:A screenshot cannot recalculate when filters change. D:A refresh-time column does not calculate a new fraction for each future slicer combination.
Question 338 A report plots shipment totals from November 2025 through February 2026. The x-axis displays the text labels “Nov”, “Dec”, “Jan”, “Feb” and sorts them alphabetically. The date model already has daily date keys. How should the analyst retain a meaningful month-by-month trend? Use the monthly totals as a sort key, making large months appear first Convert the line chart into a four-slice pie Build the trend axis from a real MonthStartDate or YearMonth sort key spanning years, then display friendly month-year labels Sort only by MonthNumber and ignore the year boundary Explanation Correct Answer C:A year-aware date position correctly orders November, December, January and February while retaining readable labels. Incorrect Answers A:Sorting by amount changes the sequence when results change and is not chronological. B:Pie slices do not preserve the temporal progression of a cross-year trend. D:MonthNumber alone repeats every year and cannot order multiple January values correctly.
Question 339 A subscription company wants a star-schema model: renewals events repeat the same Plans attributes on millions of transaction rows. The fact should retain one row per transaction, not gain duplicates when a dimension is joined. Which check is critical? Confirm the dimension join key is unique and transaction count remains at intended grain Join to every matching duplicate dimension row Aggregate the fact amount across all transactions first Discard the transaction identifier after the join Explanation Correct Answer A:Unique dimension matches prevent multiplying fact rows and overstating totals. Incorrect Answers B:Duplicate dimension matches inflate fact rows through many matches. C:Premature aggregation erases event detail needed by the fact table. D:Dropping transaction IDs prevents later grain validation.
Question 340 A workspace Contributor can edit its reports. The existing app must also be updated, but the Admin has not delegated Contributor app updates. What must happen first to avoid giving Member rights? Give the Contributor a report bookmark named Publish The workspace Admin must enable Contributor app-update permission for that workspace Assign Viewer directly and expect app editing to appear Disable source data refresh until publishing works Explanation Correct Answer B:Contributors can update a preexisting app only when the workspace Admin explicitly delegates that ability. Incorrect Answers A:Bookmarks capture report state and do not grant publishing permissions. C:Viewer is less privileged and cannot update shared apps. D:Refresh scheduling is independent of workspace app-update authorization.
