Question 410 Three branches have profitability measures 12, BLANK(), and -4. A numeric RANKX over those three branches uses descending order. Under the documented BLANK comparison behavior, what rank does the blank branch take? 1 3 2 BLANK() Explanation Correct Answer C:For numeric ranking, BLANK is treated as zero, which falls between 12 and -4. Incorrect Answers A:The positive 12 takes first place, exceeding the blank-treated-as-zero value. B:Negative four is below zero and ranks third in descending order. D:A blank measure does not necessarily yield a blank ranking; RANKX treats numeric BLANK as zero.
Question 411 A meal-delivery model has OrderDate and CompletionDate in each order. Management needs a separate order-month slicer and completion-month slicer on the same page, both active and independent. What should be modeled? One inactive CompletionDate relationship activated only in a single measure, leaving the second slicer disconnected A text page-title filter pretending to represent CompletionDate Two role-playing Date dimensions, each with an active relationship to the appropriate fact date One Date dimension with two competing active relationships to the same fact Explanation Correct Answer C:Independent Order Date and Completion Date dimensions allow the two separate slicers to propagate their own active filters at the same time. Incorrect Answers A:A measure-scoped inactive relationship can solve alternate metrics but does not provide a general independent active completion-date slicer. B:A report title cannot function as an active model relationship. D:A single Date dimension normally cannot offer two independent active paths to the same fact without ambiguity.
Question 412 A billing office exports a standardized monthly PDF invoice statement. The month is supplied as a report parameter at execution, and the exported pages must repeat a legal footer. What is the appropriate format? A chart with a month slicer exported as the sole legal statement A semantic-model calculated table with no report layout A paginated report with a Month parameter and configured repeating footer A phone report layout whose viewport width determines printed page breaks Explanation Correct Answer C:Paginated reports support parameterized, precise print layouts and repeated page components needed for a legal statement. Incorrect Answers A:A slicer can filter an interactive report but does not ensure fixed per-page legal footer behavior. B:A calculated table has no page layout or document rendering. D:Phone layout targets mobile interaction, not official repeated PDF pagination.
Question 413 A university uses Direct Lake on OneLake rather than Direct Lake on SQL. Its semantic-model table exceeds an applicable Direct Lake guardrail. An architect proposes depending on automatic fallback to DirectQuery. What is the accurate response? Schedule hourly Import refresh to make the existing OneLake Direct Lake query fall back Direct Lake on OneLake has no DirectQuery fallback; optimize the Delta table or capacity so the Direct Lake guardrail is met Turn on DirectLakeBehavior Automatic to activate SQL fallback for OneLake mode Create a SQL view with row-level security as a fallback path Explanation Correct Answer B:OneLake Direct Lake is DirectLakeOnly. The model must satisfy its guardrails rather than silently switching the affected table to SQL-endpoint DirectQuery. Incorrect Answers A:An Import refresh schedule neither changes Direct Lake mode nor resolves Direct Lake capacity/Delta guardrails. C:Automatic fallback applies to Direct Lake on SQL analytics endpoints, not Direct Lake on OneLake. D:Adding a SQL view changes the data-access design and cannot enable a fallback that OneLake mode does not implement.
Question 414 A user drills through from a sales chart to a filtered Product Detail page. The detail page lacks an obvious return control. Which native report action can the author add? A Back button configured for drillthrough navigation A Delete model relationship button A data-source refresh operation named Back A new CSV export required for each visit Explanation Correct Answer A:A drillthrough Back action returns readers toward the originating report context. Incorrect Answers B:Deleting relationships can break all product filtering. C:Refresh is unrelated to navigation history. D:Data export is not a navigation control.
Question 415 An analyst builds a histogram of 5-year employee-age bins. One bin contains ages 25, 26, 27 and 29. What should its frequency bar represent? 107 by summing the age values A single value because the interval itself is one category Four employees observed in that age interval The maximum age 29 without the number of observations Explanation Correct Answer C:Histogram frequency counts records falling into a numeric interval rather than aggregating the bin’s numeric measurements. Incorrect Answers A:Summing ages answers a different and usually unhelpful question. B:One bin may contain multiple observations. D:A maximum does not describe frequency.
Question 416 A company wants an email subscription sent to a partner outside its tenant. The report sits in a PPU workspace. What limitation should the administrator evaluate? External email subscription recipients require an eligible paid non-PPU Premium capacity and applicable permissions PPU always supports unrestricted external email subscription lists A report page bookmark authorizes all external recipients Changing the recipient email domain automatically upgrades capacity Explanation Correct Answer A:Microsoft documents restrictions for external recipients in PPU and trial-capacity workspaces. Incorrect Answers B:PPU subscription support does not imply support for external delivery. C:Bookmarks cannot grant tenant external email subscription capability. D:An address string cannot change workspace capacity eligibility.
Question 417 A source JSON table already has one row per inspection. Its Details column contains a Record with fields Severity and Inspector, not a List of inspections. What Power Query expansion applies? Join Details to the Date table and expect automatic JSON field extraction Expand the Record column to Severity and Inspector fields in the same inspection rows Expand it to new rows as if each cell contained a List of multiple inspections Pivot the Record cell itself into several numeric months Explanation Correct Answer B:A Record contains named fields of one parent row; record expansion exposes those fields as columns without multiplying the inspection grain. Incorrect Answers A:A model relationship does not parse the nested record. C:Expanding to new rows is a List-oriented operation and could change the row grain incorrectly. D:Pivot requires scalar attribute/value data rather than unexpanded record values.
Question 418 A wholesaler records monthly ending inventory balances of 266, 221, and 204. Its monthly-average-stock measure uses AVERAGEX over the three monthly closing balances (not the quarter-end snapshot). What is the average, to two decimal places? 691 units, the sum of all three monthly closing stocks 204 units, the final month-end balance 266 units, the first month-end balance 230.33 units Explanation Correct Answer D:The arithmetic mean over three monthly balances is (266 + 221 + 204) / 3 = 230.333…, rounded to 230.33. Incorrect Answers A:Summation of stocks over months is not an average and generally is not meaningful as closing stock. B:The final snapshot answers quarter-end stock, not the average of three observations. C:The January observation alone ignores February and March values.
Question 419 A dataset stores defect rate as 0.035, meaning 3.5%. An analyst wants reports to display 3.5% while keeping calculations correct. What is the appropriate change? Multiply by 100 and then also format as Percentage, displaying 350% Convert the decimal to a text label for all calculations Make the number a Date type so it shows a percent Retain a numeric decimal measure and apply Percentage formatting Explanation Correct Answer D:Percent formatting renders 0.035 as 3.5% without changing its underlying numerical ratio. Incorrect Answers A:Multiplying before percentage format scales the display again, giving an incorrect 350%. B:Text breaks expected ratio arithmetic. C:Date is not a ratio type.
Question 420 A manager shares a finance report to a broad app audience but hides its Payroll page. The app still uses a model containing sensitive payroll rows. What access policy must be evaluated? Consider the Payroll page hidden and therefore all associated rows secured Change the page title to Confidential Turn all financial values into a display-only color Enforce model permissions/RLS or appropriate data restrictions rather than relying on hidden-page UI Explanation Correct Answer D:Page navigation visibility is not an authorization barrier for model rows. Incorrect Answers A:Hidden report pages are a UI setting, not a row-level access rule. B:Titles do not change model permissions. C:Colors do not prevent data queries.
