Question 290 A nonprofit models a clean Chapters dimension related to a donations fact. A designer turns every relation to Both, creating multiple ambiguous filter paths from categories to fact data. What is the preferred repair? Use FORMAT in every DAX measure Restore explicit single-direction dimension-to-fact paths where possible Turn on Both for even more unrelated tables Delete all dimensions and use only fact text Explanation Correct Answer B:Simple single-direction paths prevent unwanted propagation while keeping intended category filters. Incorrect Answers A:FORMAT changes displayed text, not relationship path ambiguity. C:More bidirectional relationships compound ambiguous propagation. D:Removing dimensions sacrifices reusable filters and star-schema clarity.
Question 291 A financial line chart uses small multiples to compare revenue trends by territory. An analyst cannot find Forecast in its Analytics pane. Which interpretation is supported? Forecasting must work on every small-multiples panel without restrictions Forecasting is not currently supported for small-multiples visuals; evaluate it in a compatible single-series line chart Adding a region legend will unlock forecasting regardless of visual type Changing the x-axis to text automatically adds forecasting Explanation Correct Answer B:Microsoft lists forecasting as unavailable in small-multiples visual analytics limitations. Incorrect Answers A:Forecast is explicitly an unsupported small-multiples analytic feature. C:A legend does not override the visual feature restrictions. D:A categorical text axis is not the documented workaround.
Question 292 A media service has a Campaign column with `Fall`, `FALL`, and `fall` values. The business expects a single category and wants to inspect the distinct frequency patterns before cleaning. Which Power Query profiling tool helps? Column quality alone interpreted as a list of distinct category frequencies Column distribution, followed by a deliberate case-normalization rule A model Date table marking operation A report bookmark saved for each spelling Explanation Correct Answer B:Distribution exposes distinct labels and their frequencies; a controlled case transform can reconcile equivalent campaign names. Incorrect Answers A:Column quality focuses on valid/error/empty values, not category occurrence counts. C:Date-table metadata cannot reveal case variants in a text category. D:Bookmarks do not assess or normalize source values.
Question 293 A partner joins a Power BI app through Microsoft Entra B2B. Their report opens, but dynamic RLS returns no rows; the mapping table expects the partner’s ordinary email. What should admins verify? Grant guest workspace Admin to avoid checking identity The actual guest USERPRINCIPALNAME value, role membership, and tenant external-sharing permission path Delete the RLS mapping table and expose all regions Sort branch names alphabetically Explanation Correct Answer B:Guest identity representation may differ from a naive email mapping; RLS must match the authenticated principal. Incorrect Answers A:Admin would overgrant and bypass the intended Viewer security. C:Removing row controls would disclose unauthorized data. D:Sorting has no role in guest authentication.
Question 294 A product has two sales lines: 80 revenue for 2 units and 120 revenue for 6 units. A model measure is DIVIDE(SUM(Sales[Revenue]), SUM(Sales[Units])). What average price per unit does it return? 30, the unweighted average of the row prices 40 and 20 8, the total unit count without considering revenue 200, the combined revenue without dividing 25 per unit Explanation Correct Answer D:Total revenue 80+120=200 and total quantity 2+6=8, yielding 25. The measure weights by unit volume. Incorrect Answers A:Averaging 40 and 20 equally ignores that six units sold on the cheaper line. B:Eight is the denominator, not a monetary price per unit. C:200 is the numerator and does not describe unit economics.
Question 295 A claim filings source at an insurance provider has one row for each ClaimID, MetricType and MetricValue. Some identifier and MetricType combinations occur twice as legitimate components, and the output should sum those components per metric. What pivot aggregation is needed? Pivot using First without considering duplicate components Remove duplicates on identifier alone Use Unpivot Columns instead of Pivot Pivot MetricType using Sum of MetricValue for repeated pairs Explanation Correct Answer D:Sum combines multiple legitimate values for each identifier/metric combination into the requested total. Incorrect Answers A:First discards other valid components and understates totals. B:Removing by identifier alone loses different metrics and valid components. C:Unpivot goes from wide columns to long rows, the reverse of this request.
Question 296 An Import dataset over on-premises SQL does not refresh overnight after a gateway computer was retired. The model is still intact. Which dependency should the owner restore? A new report tooltip page A supported online gateway connection and correctly configured credentials for scheduled refresh An unrelated RANKX measure A different report theme Explanation Correct Answer B:Import refresh requires network reachability and valid authentication to its configured on-premises source. Incorrect Answers A:Tooltips do not connect Power BI service to SQL. C:Ranking DAX does not restore the gateway. D:Themes only style visual elements.
Question 297 A sales report provides a monthly forecast measure of 180 units, plus an independently computed lower limit of 150 and upper limit of 230. The interval is asymmetric. The analyst needs the chart to show the actual two bounds rather than equal-sized generic error. What should be configured? A single Card using only the 180-unit point estimate A fixed symmetric error margin of ±10 units regardless of bound values A map layer with all forecasts plotted at the head office address Error bars driven by the explicit lower and upper bound measures on the supported chart Explanation Correct Answer D:Field-driven upper and lower bounds allow the chart to depict the unequal interval accurately. Incorrect Answers A:A Card cannot display per-period uncertainty spans around the estimate. B:Symmetric error would show 170–190, which misrepresents the 150–230 asymmetric interval. C:A geographic layer does not encode quantitative error bounds for monthly point estimates.
Question 298 A meal delivery platform connects to an HTTPS source that serves confidential fulfilled orders data. A developer suggests placing a long-lived API token in a visible query parameter in the published M code. Which approach is safer and more maintainable? Use the connector’s supported credential handling and configure access in data-source settings Put the permanent token in the report title Publish all token values in documentation Disable source authentication after the first refresh Explanation Correct Answer A:Supported credential storage separates the fulfilled orders access secret from visible transformation code and allows controlled rotation. Incorrect Answers B:Report titles are visible metadata and must not contain access tokens. C:Documenting active secrets in public artifacts compromises the source. D:Subsequent refresh requests still need valid authentication.
Question 299 A hospital drillthrough from Physician to Patient Visits always passes the physician, but must also retain the report’s Department and Month slicers. Which option should the report author assess? Enable the appropriate Keep all filters behavior on the destination drillthrough page Delete Department and Month slicers from the summary page Create unrelated Date tables with no relationships Replace the physician ID with an aggregate total measure Explanation Correct Answer A:Keeping all filters preserves additional valid source context beyond the explicit drillthrough key. Incorrect Answers B:Removing slicers drops required analytic restrictions. C:Unrelated date tables cannot carry intended filter semantics. D:A total measure is not a stable physician drillthrough identity.
Question 300 A financial cooperative has DisbursementDate transactions and wants Year-to-Date DAX measures and an unbroken month axis, including months with no transactions. A separate date dimension has one row per day and covers the full analysis period, but model authors need consistent date semantics. What additional date-table configuration should they consider? Use a sparse text MonthName column as the date key Remove missing dates from the calendar to reduce it Mark the appropriate contiguous date column as a date table where required Mark the transaction ID column as the date table Explanation Correct Answer C:A proper date table has a unique contiguous Date column that supports conventional time analysis. Incorrect Answers A:Month text repeats across years and is not a unique contiguous daily key. B:Omitting days prevents complete-period date filtering. D:Transaction IDs are not calendar dates.
