Question 310 A call-center model contains per-agent daily handling minutes and a service-level percentage. Analysts propose summing both measures into one daily table. Which aggregation decision is defensible? Sum daily percentages across agents as though they were additive hours Sum additive minutes, but recompute the service-level rate from aggregated numerator and denominator counts Take a simple average of all percentages regardless of case volumes Convert both values to text to prevent numeric aggregation Explanation Correct Answer B:Ratios require appropriate weighting or recomputation; additive duration can be summed. Incorrect Answers A:Percentage sums can exceed 100% and misrepresent service-level performance. C:Unweighted means bias the result if agents handled different case counts. D:Text conversion prevents correct numeric analytics and does not define the right grain.
Question 311 A sports league has OrderDate and ShipDate in its match tickets fact and one Date dimension. Most visuals use order date, but a single shipping KPI must follow delivery date. Which design retains the default relationship while supporting the exception? Permanently switch the active date relationship for all pages Remove the shared Date table Convert ShipDate into text to avoid the relationship Keep OrderDate active and use CALCULATE with USERELATIONSHIP for ShipDate KPI Explanation Correct Answer D:USERELATIONSHIP scopes the alternative relationship to the shipping measure while preserving default order-date behavior. Incorrect Answers A:Changing the global active relationship would unintentionally change other reports. B:Without the Date table reliable shared dates disappear. C:Date text does not support the needed date relationship.
Question 312 A consumer without Build permission asks Copilot to create a new report from a restricted model and assumes a prompt can bypass access controls. What must be established? Write "ignore permissions" in the Copilot request Change the report background to a privileged color Use a bookmark to impersonate the model owner The user needs the required model/report authoring entitlement and supported Copilot prerequisites; prompts cannot grant access Explanation Correct Answer D:Copilot operates within user/capacity permission boundaries rather than elevating model rights. Incorrect Answers A:Prompt wording cannot overrule authorization. B:Colors have no identity effect. C:Bookmarks do not impersonate other accounts.
Question 313 A data engineering team has one vetted M cleaning sequence but must apply it to 20 tables whose schemas match and whose source tables are passed dynamically to a dataflow. Creating 20 separately maintained copies is error-prone. Which reusable Power Query design is appropriate? Paste the transformation steps into 20 unrelated queries and maintain them independently Package the transformations as an M function accepting the input table and invoke that function separately on each source table Append all tables into one before applying schema-specific business logic even where source separation is required Use report bookmarks to choose which query transformations execute at refresh Explanation Correct Answer B:A custom M function parameterizes an input table so the same transformation definition can be invoked repeatedly without copy-pasted query logic. Incorrect Answers A:Copied steps diverge over time when a shared cleansing rule changes. C:An unqualified append changes source provenance and may violate required independent processing. D:Bookmarks control report view state, not Power Query M execution at refresh.
Question 314 A call-volume report uses a bar chart of text month labels with two legend series. The author cannot enable the built-in Forecast tool. Which design change should be considered? Use a supported line time series with a suitable date axis and eligible single-series configuration for forecasting Rename MonthName to Forecast without changing its text type Add a geographic slicer to the current chart Apply a color rule that guesses future data Explanation Correct Answer A:Power BI Forecast support depends on visual/series eligibility and valid time-series structure. Incorrect Answers B:A field label cannot create a continuous timeline. C:Spatial filtering does not unlock time-series forecasting. D:Color formatting does not compute future estimates.
Question 315 Monthly sales are Jan 80, Feb 95, Mar 110. With a calendar-year YTD measure and a visual filtered to February, what does TOTALYTD([Sales], Date[Date]) return? 95, only February 285, including March 175, the January-plus-February total 80, only January Explanation Correct Answer C:A February YTD window spans January 1 through February; 80+95=175. Incorrect Answers A:The measure accumulates prior months in the same year. B:March is later than the February context and lies outside the YTD window. D:The February amount must also be included in the accumulated total.
Question 316 A field-services report has twelve visuals on a desktop page. For phones, workers need only an urgent-ticket KPI, a short list, and a filter. The report owner must keep all twelve visuals on the regular desktop page. Which action best meets this? Delete all nonessential visuals from the desktop report page and republish Change the data-source schema to remove records unrelated to mobile users Design the mobile page canvas with the three key visuals, leaving the other desktop visuals off that mobile layout Grant every mobile worker Contributor so they can reposition visuals themselves Explanation Correct Answer C:Mobile layout authoring chooses which existing report visuals appear on the phone canvas without deleting them from the main desktop page. Incorrect Answers A:Deleting desktop content violates the requirement to retain the full authored desktop view. B:Source schema changes affect both mobile and desktop data unnecessarily. D:Consumers need a usable design, not editing privileges, to view reports on a phone.
Question 317 A reader still has Contributor editing rights after a direct Viewer assignment was applied. The user also belongs to a Microsoft Entra group assigned Contributor in the workspace. What does the administrator need to investigate? Delete the report visuals because a Viewer should never see a chart Add the user to another Viewer group and assume the lower role wins Change the numeric model measures into text to prevent edits Review all direct and group role grants: the effective workspace role follows the highest assigned permission level Explanation Correct Answer D:Power BI resolves overlapping assigned roles by the highest permission, so the Contributor group membership must be addressed. Incorrect Answers A:Chart content is unrelated to how the workspace resolves overlapping role assignments. B:Adding more Viewer grants does not override an inherited higher Contributor grant. C:Data types do not determine workspace authorization.
Question 318 A clinical source treats EncounterID ab12 and AB12 as the same encounter, but Power Query Keep duplicates does not flag the pair. What should the analyst account for? Assume case-insensitive matching is Power Query default and do nothing Unpivot the encounter ID into a value column Create an independent encounter for each casing variant Normalize the case of the business key before evaluating duplicates, respecting the source identity rules Explanation Correct Answer D:Power Query text comparisons for duplicate values are case-sensitive unless the key is normalized. Incorrect Answers A:The unnormalized pair can appear distinct to the duplicate operation. B:Unpivot changes table shape, not key equality. C:Splitting one encounter into two inflates clinical event counts.
Question 319 A Viewer also belongs to an Entra group with Contributor workspace permission. They unexpectedly can edit reports. What should the admin correct? Add another Viewer assignment and assume it overrides Contributor Change the font color of all editable reports Hide the Edit button in a screenshot Review both group grants and remove the unintended Contributor membership to achieve effective Viewer rights Explanation Correct Answer D:Effective role takes the highest granted privilege across direct and group memberships. Incorrect Answers A:A lower additional grant does not negate an inherited higher role. B:Fonts do not change workspace permission. C:Screenshots do not enforce authorization.
Question 320 A support-case model uses CreatedDate as the active Date relationship. Only the [Closed Cases] metric needs to follow CompletionDate, while all existing CreatedDate reports must remain unchanged. The report does not require separate simultaneous Date slicers. Which approach fits? Use CALCULATE with USERELATIONSHIP for the [Closed Cases] metric and retain the active CreatedDate relationship Activate both Date relationships from the same Date table globally Duplicate one Date dimension for every support case row Convert CompletionDate to text to stop unwanted filters Explanation Correct Answer A:USERELATIONSHIP applies the alternate date role within the specified measure without altering the default date filtering used by existing reports. Incorrect Answers B:Two simultaneous active paths from one Date table to the fact lead to ambiguous filters. C:Role-playing dimensions, when needed, are shared dimensions rather than per-fact-row copies. D:Text type prevents normal date filtering and does not implement the alternate relationship.
