Question 130 A sponsor ranking contains values 90, 80, 80, and 50. A descending RANKX with Dense ties ranks the two 80 scores as second. Which rank should 50 receive? Rank 4 because the physical fourth row determines the displayed rank Rank 1 because the smallest value wins descending ranking Rank 3 because Dense gives consecutive positions to distinct scores No rank can be computed when values tie Explanation Correct Answer C:Dense ranks 90 as first, 80 as second, and 50 as third without a gap. Incorrect Answers A:The fourth row position is not the Dense rank of the third distinct score. B:Descending ranks the largest score first. D:RANKX explicitly supports ties.
Question 131 An overseas service provider delivers HandlingMinutes as text `1,5`, `2,0`, and `3,25`, using a comma decimal separator. On a US workstation default conversion raises errors or misreads the values. What is the correct Power Query preparation? Convert the duration field to Decimal Number using the documented source locale, then validate a few interpreted values Remove every comma and read 1,5 as 15 minutes Convert the values to Date instead of a numeric type Replace every non-US number with zero Explanation Correct Answer A:A source-specific locale identifies the comma as the decimal separator and preserves quantities such as one-and-a-half minutes. Incorrect Answers B:Deleting separators changes the quantities by a factor of ten or more. C:Durations measured in minutes are quantities, not calendar dates. D:Zero would fabricate measurements and erase the actual source values.
Question 132 A food chain receives a request to ensure one store purchases report is unavailable to a departed contractor, without removing all other employees’ workspace membership. What is a targeted access-control response? Remove or revoke the contractor’s applicable item, app, or group access paths Publish the report under a different title Change only the report bookmark selection Hide a report page while retaining the contractor’s access Explanation Correct Answer A:Revoking direct and inherited access closes the contractor’s effective report path while retaining other users. Incorrect Answers B:Renaming does not revoke existing permissions. C:Bookmark state is not a security boundary. D:Hidden pages are discoverability features and do not remove report permissions.
Question 133 A Power BI scatter chart includes both Customer and Product. Two report-tooltip pages are registered for those fields, but the automatic selection picks the wrong page. What should the report author change? Hide the scatter visual’s numeric axes Turn every tooltip into a drillthrough detail report Change the source model to DirectQuery Set the scatter visual’s Tooltip type to Report page and explicitly select the intended tooltip page Explanation Correct Answer D:A manual report-tooltip page assignment overrides an ambiguous automatic match for that visual. Incorrect Answers A:Removing axes does not choose the desired contextual tooltip. B:Drillthrough requires navigation and is not the same hover experience. C:Storage mode has no bearing on which tooltip page is selected.
Question 134 A reporting team reuses one certified semantic model from three thin reports. The model owner corrects the definition of NetMargin. What maintenance benefit should be expected? Every thin report must replace the semantic model with an unrelated CSV Reports bound to that shared measure can reflect the corrected definition without duplicating model logic Correcting the measure automatically removes all viewer RLS restrictions A shared model permanently prevents authors from making any report-specific visual changes Explanation Correct Answer B:Central model measures provide one governed definition for consumers with compatible access. Incorrect Answers A:CSV rebuilds would defeat the reuse and governance design. C:A measure correction does not bypass user security entitlements. D:Thin report authors can still change visuals while reusing shared measures.
Question 135 A shipments report has OrderDate and DeliveryDate; the user must simultaneously filter orders placed in July and deliveries made in August. A single Date table has only one active path to the fact. What model design is appropriate? Use separate Order Date and Delivery Date dimensions with active relationships to their respective fact date keys Use one Date table with both relationships globally active and expect independent slicers Delete all date relationships and rely on text matching Create one page bookmark per date value Explanation Correct Answer A:Role-playing date dimensions allow independent filter selections for different date meanings. Incorrect Answers B:One date table cannot independently filter two roles through conflicting active paths. C:Disconnected text labels cannot enforce both date predicates. D:Bookmarks store view states, not independent model role relationships.
Question 136 A clinic plots WaitMinutes against SatisfactionScore but sees one circle representing averages across every clinic. It needs one point per facility. What should be supplied in the scatter visual? Add FacilityID as the detail/category grain and retain both numeric axes Remove FacilityID and use only an overall Card Convert both numeric measures to text labels Use a single waterfall measure without a second axis Explanation Correct Answer A:Adding facility detail creates distinct points rather than an aggregate over all facilities. Incorrect Answers B:A Card reduces the plot to one value rather than showing facility variation. C:Text values cannot act as the two quantitative axes. D:A waterfall explains change rather than a two-variable scatter relationship.
Question 137 A shared staging query applies data-quality fixes. Two downstream marts should reflect any new cleaning rule automatically, rather than diverging independent copies. Which Power Query action supports this? Duplicate the staging query and maintain separate independent transformation histories Create Reference queries from the staging query and add branch-specific transformations Export the staging query as an image for every branch Append the staging query to itself repeatedly Explanation Correct Answer B:References use the upstream query as a source, so downstream branches incorporate updates to the shared stage. Incorrect Answers A:Independent copies risk drift when central rules change. C:Images are not query dependencies. D:Repeated appends duplicate records instead of sharing a transformation stage.
Question 138 A food distributor stores bank operating balances of $100K, $125K, and $90K on the last day of three months. The CFO asks for the quarter-end balance, not quarterly cashflows. Which result is correct? $315K, the sum of three balances measured at different dates $105K, their simple arithmetic average $100K, the opening month snapshot $90K, the closing snapshot for the final month Explanation Correct Answer D:Quarter-end closing balance is the final available balance, not the sum of temporally repeated stocks. Incorrect Answers A:Adding balances across months double-counts money already represented in later balances. B:An average balance answers a distinct metric. C:The first month is not the quarter-ending date.
Question 139 A Power BI support cases report at a call center uses an Import semantic model over a source that updates nightly. The report shows yesterday’s numbers because refresh never ran. Which configuration should be checked first? Bookmark display-state options Visual mobile layout A calculated-column format string Semantic-model scheduled refresh frequency, credentials, and history Explanation Correct Answer D:Import models show loaded data until a successful refresh; its schedule and history explain the stale support cases snapshot. Incorrect Answers A:Bookmarks store report state, not source-ingestion schedules. B:Mobile layout does not update the underlying Import model. C:Formatting a column changes presentation and cannot load new records.
Question 140 A regional sales bar chart cross-filters an organization-wide target KPI, but the KPI must always show the global target while the product table should still respond to region clicks. How can the report author correct only the KPI behavior? Set the bar chart’s interaction with the target KPI to None; retain filtering for the product table Delete the shared Region dimension Disable all visual interactions on every page Change the target KPI measure to text Explanation Correct Answer A:Edit interactions applies per source-target visual pair, so one KPI can stay global without breaking the other filter. Incorrect Answers B:Removing the dimension damages both intended and unintended filter paths. C:Globally disabling interactions breaks the product drilldown requirement. D:A text conversion cannot choose a visual-level interaction.
