Question 120 A billing export has columns InvoiceID, ChargeType, Amount. An invoice can contain multiple rows with the same ChargeType. The analyst wants one amount column per charge type. How should the pivot handle duplicates? Pivot without any aggregation and assume all ID/type pairs are unique Unpivot ChargeType into a wider row Use Count when the business requires monetary totals Pivot ChargeType using Sum of Amount for repeated invoice-type combinations Explanation Correct Answer D:Summing repeated charge rows yields one numerical amount per InvoiceID/ChargeType. Incorrect Answers A:Repeated combinations require an explicit aggregation or preprocessing. B:Unpivot moves data to long form rather than the desired columns. C:Count measures occurrences, not the sum of charge amounts.
Question 121 A Fabric warehouse model uses Direct Lake on SQL analytics endpoints. SQL endpoint row-level security is enabled on one referenced table, and users report DirectQuery performance. What is the documented behavior? The affected query can fall back to DirectQuery because SQL endpoint RLS is enforced Direct Lake on SQL ignores SQL RLS and always reads Parquet without fallback A user-facing slicer automatically bypasses SQL endpoint security The model automatically converts to an Import snapshot when RLS is enabled Explanation Correct Answer A:SQL endpoint RLS is a documented fallback trigger for Direct Lake on SQL analytics endpoints. Incorrect Answers B:Ignoring SQL security would not enforce the declared endpoint policy. C:A slicer is a presentation filter, not an authority to bypass source security. D:Fallback is to DirectQuery, not arbitrary Import conversion.
Question 122 A ticket table has durations 3, 5, BLANK(), 6, 0 and 5 minutes. How many rows satisfy COUNTROWS(FILTER(Tickets, Tickets[Duration] > 5))? 3; count both rows equal to five as above the threshold 1; only the six-minute row is strictly above five 2; count BLANK as greater than five 6; FILTER returns the unfiltered table Explanation Correct Answer B:The strict predicate excludes both five-minute rows, zero, blank and three; only six remains. Incorrect Answers A:Equality does not satisfy a strict greater-than comparison. C:A blank duration does not qualify as a positive numeric value above five. D:FILTER evaluates the condition per row and removes nonmatching entries.
Question 123 A donations measure uses SUMX(Donations, Donations[Amount]) over a large Import table with no row-level expression beyond the Amount column. The report has become slow. Which first optimization is meaningful? Wrap the SUMX in two more FILTER iterators without a new calculation Compare an equivalent SUM(Donations[Amount]) measure with the original, validating output and timing using Performance Analyzer or a DAX profiling tool Convert DonationAmount to Text so the engine skips numeric calculations Hide the measure from the field list while keeping every slow visual unchanged Explanation Correct Answer B:A direct SUM can avoid unnecessary iterator work; measured comparisons show whether the rewrite actually helps. Incorrect Answers A:Nested iterators typically add work and do not simplify the existing sum. C:Text conversion breaks aggregation semantics and may worsen performance. D:Visibility in the field list does not optimize its evaluation.
Question 124 A billing report has a left navigation panel and a set of detail visuals. The team wants an Overview bookmark to control only the detail visuals, without changing the shared navigation panel or its selected filters. Which bookmark configuration meets this? Save the bookmark with All visuals and Data enabled so every slicer is restored Use a new source data refresh to control report visibility states Select only the detail visuals before updating the bookmark, use Selected visuals and Display, and leave Data capture off Convert each hidden report visual into a separate data-model relationship Explanation Correct Answer C:Selected visuals scopes bookmark effects to the designated objects; Display saves visibility and excluding Data avoids overwriting filter choices. Incorrect Answers A:All visuals plus Data would restore unrelated slicers and navigation states, contrary to the requirement. B:Refresh retrieves underlying records but cannot restrict which report objects a bookmark captures. D:Model relationships are not a mechanism for controlling bookmark object visibility.
Question 125 A factory group wants to find natural groups of store locations based on three numeric performance measures, without previously defined cluster labels. What analytic capability is relevant? A threshold-only gauge for the overall company Clustering comparable data points in a suitable visual Manual calendar month sorting A scatter plot colored by the existing company hierarchy only Explanation Correct Answer B:Clustering groups similar observations using the selected numeric features without predefined category labels. Incorrect Answers A:A gauge compresses performance to one metric and conceals multivariate similarities. C:Calendar sorting organizes dates but discovers no behavioral clusters. D:Coloring points by a predefined business hierarchy does not discover new similarity groups from several numeric metrics.
Question 126 A model has one Date dimension, active Sales[OrderDate] and inactive Sales[ShipDate]. Order revenue defaults to OrderDate. The author wants a shipped-revenue measure by ShipDate without changing default order reporting. Which DAX pattern fits? Activate both Date relationships globally and accept filter ambiguity Remove the Date dimension and group by ShipDate text labels Use FORMAT on OrderDate to change its visible name CALCULATE([Revenue], USERELATIONSHIP(Date[Date], Sales[ShipDate])) Explanation Correct Answer D:USERELATIONSHIP enables the specified inactive path inside the measure evaluation. Incorrect Answers A:Two active paths to the same fact from one date dimension can be ambiguous. B:Text grouping loses consistent calendar filtering. C:Formatting cannot switch relationship propagation.
Question 127 A logistics manager wants a bar chart listing the top ten depots by FreightCost. The chart sorts depot names alphabetically instead. What visual setting directly addresses ranking? Sort by depot name A–Z Use a date forecast without a time axis Replace the cost measure with a static title Sort the bars descending by FreightCost and apply the appropriate Top N filter Explanation Correct Answer D:Measure-based descending order shows largest depots first rather than alphabetic labels. Incorrect Answers A:Alphabetical order does not rank magnitude. B:A forecast estimates future time periods, not category ranking. C:Titles do not order underlying category values.
Question 128 A sports league publishes a new match tickets report and later fixes a chart label in the workspace. Business consumers access the associated app but still see an older app version. What lifecycle step is missing? Rename the source database Refresh an unrelated Power Query parameter Update the published app to distribute the workspace changes Force a new many-to-many relationship Explanation Correct Answer C:Updating the app publishes authorized workspace content changes to app users. Incorrect Answers A:Database renaming does not synchronize app content and risks broken connections. B:Unrelated parameter changes cannot substitute for an app update. D:Relationship cardinality cannot publish new report layouts.
Question 129 A shipping analyst needs one parent row per Depot for a control report, but must also keep all underlying delivery records accessible as a nested table in each depot result so later M steps can calculate complex checks. Which Power Query Group By setting fits? Group by Depot with the All Rows aggregation so each depot row retains a nested table of its delivery records Group by Depot using only Sum(Weight), discarding all original row details Pivot each DeliveryID into a separate field, creating thousands of columns Remove duplicates on Depot, keeping one arbitrary delivery while losing the others Explanation Correct Answer A:All Rows yields a nested table for every group, preserving row-level detail under one depot summary key for subsequent transformations. Incorrect Answers B:A sum collapses details required for record-specific validation. C:A column per delivery produces an unmanageable wide schema. D:First-row deduplication erases legitimate delivery events.
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.
