Question 670 A report compares sales in January 2026 with December 2025 and labels the change YoY. What correction is required for a true year-over-year January comparison? Compare against December 2025 and rename the title Subtract the lifetime company total from January Compare January 2026 against January 2025 using a proper calendar relationship or equivalent prior-year filter Use a Card containing only January 2026 without a comparison Explanation Correct Answer C:Year over year compares equivalent periods one year apart, not the previous adjacent month. Incorrect Answers A:December is month-over-month rather than year-over-year for January. B:Lifetime totals answer a different aggregation question. D:One value cannot compute a comparison difference.
Question 671 A model owner confirms the connector successfully authenticates to SQL, but a report consumer receives a Power BI access-denied message. What separate configuration must be inspected? The user’s report/app/model access and licensing, separate from refresh connection authentication Only the SQL credential because it proves every viewer has report rights Add a random sample of SQL rows to the report Change source collation to make the report public Explanation Correct Answer A:Power BI item entitlement is a distinct permission boundary from the backend data-source credential. Incorrect Answers B:Successful backend login does not grant the consumer rights to the report artifact. C:Additional source rows cannot resolve authorization. D:Collation controls text comparisons, not app access grants.
Question 672 A financial analyst has two reporting queries that must both adopt corrections to a shared validation table. A previously duplicated query did not receive the upstream update. What should replace that duplicate? A screenshot of the approved query values An RLS rule that rewrites Power Query transformation steps A Reference to the approved validation query rather than an independent Duplicate Another Duplicate with the same copied steps Explanation Correct Answer C:Reference keeps a dependency on the validated upstream query, so subsequent fixes propagate to downstream expressions. Incorrect Answers A:A screenshot is not an executable query dependency. B:RLS is model row security and cannot implement Power Query reference updates. D:Another Duplicate creates another independent snapshot of the expression steps.
Question 673 An insurer’s Key Influencers visual shows customers with ten missed payments are more likely to cancel. A product manager claims the visual proves missed payments directly caused churn. What should the analyst explain? The relationship cannot be examined because Power BI only supports time series The visual identifies statistical associations; causal claims need an appropriate causal study or experiment The factor is necessarily causal because the visual ranked it first All other correlated features can be ignored after Key Influencers runs Explanation Correct Answer B:Key Influencers helps reveal relationships in modeled data but observational correlations can reflect confounding and selection effects. Incorrect Answers A:The visual can analyze categorical outcomes; it is not limited to forecasting. C:A rank or association score does not establish cause and effect. D:Other related factors and possible confounders still matter to the interpretation.
Question 674 A company publishes an app from a workspace in shared capacity. The recipient can receive a link but lacks a Power BI Pro/PPU entitlement. What should be checked before assuming the link alone enables access? Increase the number of report bookmarks Give the recipient the SQL Server administrator password Change report colors to the organization theme Recipient licensing or supported capacity, plus the app and model permissions Explanation Correct Answer D:Content access depends on the appropriate Power BI license/capacity and permission path, not just a URL. Incorrect Answers A:Bookmarks store report view state and cannot supply a license. B:Database credentials are inappropriate and do not grant Power BI app consumption rights. C:Colors do not change tenant entitlement or app authorization.
Question 675 A support ticket opened at 10:00 and closed at 12:30 on the same day. A DAX measure uses DATEDIFF(OpenTime, CloseTime, MINUTE). What does it return? 150, the number of minute boundaries between the two timestamps 2, the number of whole hours 30, only the minutes after the last full hour A date/time string rather than a number Explanation Correct Answer A:The interval spans 2 hours and 30 minutes, or 150 elapsed minute boundaries. Incorrect Answers B:The interval argument is MINUTE, not HOUR. C:DATEDIFF counts the full 150-minute span, not just the remainder. D:DATEDIFF returns an integer number of specified interval boundaries.
Question 676 A wholesale distributor needs its deliveries report to support screen readers, keyboard use, readable labels, and alternatives to color-only status cues. A blind user hears an unlabeled chart in a screen reader. What authoring remediation supplies a useful nonvisual description? Change a bar chart into an unlabeled colored image Disable keyboard focus Put all values in hover-only tooltips Add meaningful alternative text describing the chart and its purpose Explanation Correct Answer D:Alt text conveys the chart’s function and important context to screen readers. Incorrect Answers A:Color-only images remain inaccessible without descriptions. B:Keyboard suppression harms assistive navigation. C:Hover-only content may be inaccessible to keyboard/screen-reader users.
Question 677 A subscription model tracks OrderDate and DeliveryDate on each row. Analysts need two independent date slicers on the same page and cannot accept one filter changing the meaning of the other. What modeling pattern fits? One Date table with two simultaneously active competing fact relationships One inactive delivery relationship used only by a measure, with no active delivery slicer path Two text fields in report titles rather than relationships Two role-playing Date dimensions with their own active relationships to the fact Explanation Correct Answer D:Independent date dimensions enable both slicers to filter separate date roles at once. Incorrect Answers A:Two paths from the same Date table to one fact are normally ambiguous. B:A single measure with USERELATIONSHIP is not the general solution for two simultaneously active date slicers. C:Titles cannot filter the model.
Question 678 A report shows quarterly sales split among Retail, Wholesale, and Online, but Online orders are already included within Retail in the source taxonomy. A stacked column shows shares exceeding the intended total. What is the model issue? Treat every overlapping bucket as an independent share and accept overcounting Hide the grand total so the double counting is not visible Change the category colors while keeping duplicated sales Make stacked categories mutually exclusive or implement documented allocation so the same sales cannot be counted in overlapping parts Explanation Correct Answer D:Part-to-whole stacking requires nonoverlapping contributions or a defensible allocation to avoid inflated totals. Incorrect Answers A:Overlapping memberships duplicate the same fact in the visual breakdown. B:Hiding the total obscures rather than fixes arithmetic. C:Colors cannot correct duplicated category attribution.
Question 679 An API returns `Amount` as a nested JSON text field, with values such as "1.234,50" from a European region. The model needs totals in decimal amounts after record expansion. What conversion is essential? Parse using US culture and assume "1.234,50" is 1.23450 Treat Amount as Text and concatenate rows to calculate totals Delete commas and periods and multiply the result by 100 Parse Amount as a decimal using the source culture, treating dot as thousands and comma as decimal Explanation Correct Answer D:Culture-aware conversion maps the source string to 1234.50 while preserving numeric meaning. Incorrect Answers A:US parsing can reject or misinterpret European separator conventions. B:Text concatenation is not arithmetic addition. C:Removing separators without preserving their roles can change magnitude by orders of ten.
Question 680 A clinical analytics source records visit costs such as 86.75, 91.20, and -12.50 for refunded charges. The amount must support averages and sums, including cents. Which Power Query type fits without discarding fractional portions? Decimal Number or an appropriate fixed-decimal monetary type Whole Number to truncate cents at the source Date because the source column contains periods True/False based on whether each charge is positive Explanation Correct Answer A:A decimal-capable numeric type preserves fractional charges and refunds for arithmetic; fixed decimal may be appropriate when currency precision is required. Incorrect Answers B:Whole Number removes cents and can bias financial aggregates. C:Dates represent calendar values rather than prices. D:A Boolean sign flag loses the magnitude of charges and refunds.
