Question 390 A freight distributor has individual delivery rows with Depot, DeliveryID, and optional ShipmentWeight. A supervisor requests the average non-null ShipmentWeight for each depot. Which Power Query aggregation should be used? Count distinct DeliveryID and assume the result is a weight Append the Depot dimension to the fact table and leave the measures ungrouped Group by Depot and aggregate ShipmentWeight using Average Use Sum of ShipmentWeight and report it as an average Explanation Correct Answer C:Average calculates a mean weight from valid numeric measurements within each depot group. Incorrect Answers A:A distinct ID count describes number of deliveries, not their mean weight. B:Append stacks dimension records and does not produce a depot-level statistic. D:Sum adds all kilograms and is not a per-delivery average.
Question 391 A raw DateDim is generated from purchase timestamps and contains two times on January 8 but no row on January 9. Analysts try to mark its DateTime column as the canonical date table. What fix is required? Generate a contiguous date-only column with exactly one row per calendar date Keep duplicate days because the timestamps differ Exclude zero-transaction dates to make the table smaller Use a month-name text field as the unique date key Explanation Correct Answer A:A proper marked date dimension needs one unique continuous daily Date value, not multiple transaction timestamps. Incorrect Answers B:Different times on one day do not create distinct daily calendar members. C:Missing days break continuous date coverage. D:Month names are nonunique and cannot represent a daily key.
Question 392 An inventory waterfall starts with 500 units and shows +80 receipts and -30 shipments. A developer also includes the opening 500 as an ordinary positive movement after the start total. What should be fixed? Treat opening and ending balances as totals and only receipts/shipments as intervening deltas Add another opening movement to make the chart taller Convert the -30 shipment to a positive +30 receipt Replace the entire inventory calculation with a report title Explanation Correct Answer A:Counting the opening stock both as baseline and increase doubles the reported end balance. Incorrect Answers B:Adding the opening again compounds double counting. C:Reversing the shipment sign incorrectly increases stock. D:A title does not reconcile inventory movement arithmetic.
Question 393 A cost export has CostValue entries 15.25, 9.75, and the literal "N/A" for an unreported transaction. A developer proposes replacing N/A with 0 before summing. Which cleanup is safer without an approved zero interpretation? Replace every N/A with zero and report all rows as measured costs Treat N/A as missing/null and flag for investigation before numeric type conversion Delete all valid numeric rows instead Convert CostValue into a page title Explanation Correct Answer B:A missing cost is not an observed zero; retaining null distinguishes absent input from a legitimate zero. Incorrect Answers A:Zero substitution would understate uncertain costs. C:Deleting valid values destroys measurement coverage. D:Titles cannot represent a usable numeric fact.
Question 394 A dynamic RLS mapping table contains usernames in lowercase email form. A guest user signs in under an external B2B identity and sees no rows. What should the author validate? Rename the report page to the guest email Compare the actual USERPRINCIPALNAME result for the guest with mapping keys and approved role membership Convert all numeric measures to string values Turn off RLS globally for all guests Explanation Correct Answer B:Guest identity formats can differ from assumed email strings; the mapping must match effective sign-in identity. Incorrect Answers A:Report page names cannot fix security identity mappings. C:Measure formatting does not establish row entitlements. D:Disabling RLS exposes unrelated data instead of fixing the mapping.
Question 395 A report selects June 10 through June 12, 2026. An analyst needs the values for June 7 through June 9. Which classic date-column filter expression matches? DATEADD(Date[Date], -3, DAY) SAMEPERIODLASTYEAR(Date[Date]) DATESYTD(Date[Date]) PARALLELPERIOD(Date[Date], -1, MONTH) Explanation Correct Answer A:A three-day backward shift moves each selected date to its corresponding date three days earlier. Incorrect Answers B:This shifts the selected dates by a year, not three days. C:YTD expands the selected dates to a cumulative year window. D:A prior full month is not the three specifically shifted days.
Question 396 A store manager wants one report chart with a slicer that chooses whether the y-axis displays SalesAmount, GrossProfit, or ItemsSold. All three are existing measures; the same category axis must remain. What should the analyst implement? Duplicate the fact table three times and build bidirectional joins Create a disconnected selector table but no DAX or parameter connection to the displayed value Create a field parameter containing the three measures and place the parameter in the visual values and a slicer Sort the MonthName column by MonthNumber Explanation Correct Answer C:A field parameter lets a permitted reader switch the measure included in a visual without maintaining three separate report pages. Incorrect Answers A:Duplicated fact tables and bidirectional relationships introduce model ambiguity without providing a field selection user interface. B:A disconnected selector by itself does not change a measure; without a SWITCH expression or field parameter binding the visual still uses its original field. D:Month sorting affects category order but cannot switch which quantitative measure a visual uses.
Question 397 A dataset’s refresh fails with a 401 Unauthorized after a secret rotation; a colleague insists the solution is renaming a missing column. What evidence should govern the first fix? Randomly rename source columns until login works Use a bookmark to store the new secret The explicit HTTP authentication error and credential change point to connection authentication, not a schema rename Make the report public to bypass the SQL login Explanation Correct Answer C:A 401 response occurs at access authorization; schema validation comes after successful connection. Incorrect Answers A:Column names cannot authenticate a denied request. B:Bookmarks are not secure connection credential stores. D:Publication permissions cannot safely bypass an upstream login.
Question 398 A meal delivery platform displays weekly OrderTotal and has a fixed compliance threshold of 275 units. A horizontal reference should make weeks above the limit obvious. Which analytics feature is appropriate? Hide the value axis Add a constant reference line at 275 on the numeric axis Sort the x-axis alphabetically Join a date dimension to itself Explanation Correct Answer B:A constant reference line at 275 marks the approved threshold against which weekly OrderTotal values can be compared. Incorrect Answers A:Hiding the value axis makes the threshold harder to interpret. C:Alphabetic sorting of week labels does not display the numeric threshold. D:Date self-joins do not add a visual target line.
Question 399 A Power Query pipeline has a validated StagingOrders query with expensive source-side filters. Two report-ready queries need different final aggregations, and future corrections in the staged data must flow into both. What design is appropriate? Duplicate all source steps into both queries and edit them independently Remove StagingOrders so neither downstream query has a dependency Append the two downstream queries together before applying their different aggregations Reference StagingOrders from each downstream report-ready query Explanation Correct Answer D:References share the upstream cleaning and filters while allowing the downstream queries to apply their own transformations. Incorrect Answers A:Duplicated upstream steps can drift independently and repeat source-processing work. B:Deleting the referenced query breaks the dependency. C:Appending transformations with different target grains does not preserve separate outputs.
Question 400 A shipping model contains both OrderDate and ShipDate. Most pages analyze orders placed; a shipping-only KPI must count orders by ship month. How should the report author preserve the default while meeting the exception? Create a bidirectional relationship between the two Date columns themselves Keep OrderDate active and use an alternate ShipDate relationship within the shipping-specific measure Permanently activate the ShipDate path for all measures Change ShipDate to text and sort by month name Explanation Correct Answer B:The measure can activate its inactive ShipDate relationship through USERELATIONSHIP without changing default order KPIs. Incorrect Answers A:Joining two Date columns directly is not the fact-to-date role pattern. C:Changing the global relationship would alter the meaning of other order reports. D:Text dates lose reliable time-based relationship filtering.
