Question 500 A university’s cost reporting uses Department and ResearchProgram dimensions. Reviewers want to inspect expenditure in one department and then subdivide only that branch by program. What is suitable? Replace every department with the global cost Card Create a new CSV from the entire fact table for each click Use only an unconditional chart background fill Expand the selected branch in a Decomposition Tree using ResearchProgram as the next explanatory dimension Explanation Correct Answer D:Tree branching retains the selected department context while comparing its program subcategories. Incorrect Answers A:An overall Card removes the needed branch-specific breakdown. B:Repeated exports are not necessary for interactive dimension splits. C:Background styling has no data decomposition mechanism.
Question 501 A sales executive assumes hiding a synchronized Region slicer on certain report pages prevents readers from seeing other regions’ data. Which correction is necessary? Mark a slicer hidden on every page and treat all rows as secured Use semantic-model RLS or appropriate data permissions for authorization; slicer visibility is not a security boundary Rename Region to Confidential in the model Add a tooltip explaining the hidden slicer instead of restricting rows Explanation Correct Answer B:A hidden/synced slicer is a report filtering convenience and cannot enforce user-specific entitlement. Incorrect Answers A:Readers can access other permitted paths; hiding UI does not enforce row restrictions. C:A column label cannot replace access-control rules. D:A tooltip does not limit data access to authorized regions.
Question 502 An order model has an active Date-to-OrderDate relationship and an inactive Date-to-ShipDate relationship. Only [Shipped Sales] must respond to ShipDate; all standard sales visuals should continue using OrderDate. Which DAX pattern fits? CALCULATE([Sales], USERELATIONSHIP(Date[Date], Orders[ShipDate])) for the shipping measure Activate both competing Date relationships globally for every visual Change [Sales] to a calculated column of ShipDate text Delete the active Date-to-OrderDate relationship and hope unaffected measures remain the same Explanation Correct Answer A:USERELATIONSHIP activates the alternate relationship for that calculation without replacing the default OrderDate path. Incorrect Answers B:Two simultaneously active paths from one Date table would be ambiguous in the ordinary model. C:A text column is not a measure-scoped date filter. D:Removing the default link changes normal sales date semantics for existing reports.
Question 503 A factory’s output change visual lists only absolute values for each cause. Overtime adds output, but breakdown losses reduce it. What data should the waterfall bind to represent the net movement accurately? A signed delta measure for each cause, with gains positive and losses negative An absolute-value-only measure that makes every cause positive The plant name converted into an integer An unrelated page-filter bookmark with no quantitative measure Explanation Correct Answer A:Waterfall movement bars require change values with correct direction to reconcile to the ending total. Incorrect Answers B:Absolute values erase decreases and inflate the resulting total. C:A plant identifier is not an additive production change. D:Bookmarks cannot substitute for the numeric movement measure.
Question 504 A store metric is DIVIDE([Revenue], [Units]). With the North slicer selected, North records have 240 revenue and 8 units; all regions together have 640 revenue and 20 units. What value should the context-sensitive measure show? 8, the unit count for North 240, North revenue without dividing by units 30 for North 32, the unsliced all-region revenue per unit Explanation Correct Answer C:The selected North context filters both measures, producing 240/8=30 instead of the all-region ratio. Incorrect Answers A:Eight is only the North denominator. B:240 is only North revenue and not a per-unit value. D:640/20=32 ignores the currently selected region.
Question 505 A service telemetry JSON payload has a Tickets list; each Tickets element is a record with a TicketID and Priority. An analyst imported it as one row containing a List cell. What sequence yields one row per ticket with both fields? Expand directly to record columns without expanding the outer list Pivot TicketID into category headings before extracting records Join the JSON text to a date dimension and expect list items to materialize Expand the list to new rows and then expand each record into TicketID and Priority columns Explanation Correct Answer D:The outer list determines the repeated row grain. Once each element occupies a row, record expansion exposes its named properties. Incorrect Answers A:Record expansion is not the first step for a cell whose value is a List. B:Pivot requires scalar values and cannot interpret the nested list directly. C:A relationship join cannot unpack JSON list and record structures.
Question 506 A fulfillment dataset measures handling time to tenths of a minute: 1.8, 2.2 and 2.7. A report computes mean handling time. Which transformation retains the measurement resolution? Convert the field to Date/Time despite storing durations as numeric minutes Replace every noninteger value with null and average only exact minutes Keep HandlingMinutes as a decimal-capable numeric type before aggregation Convert to whole numbers and assume the fractional part has no effect Explanation Correct Answer C:Decimal numeric storage preserves fractional durations; the mean can then be computed from all recorded measurements. Incorrect Answers A:A timestamp describes a point in time, not a duration measured as numeric minutes. B:Dropping fractional observations creates a nonrepresentative sample. D:Whole-number conversion changes 1.8 and 2.7 and biases the average.
Question 507 A bookings report must be distributed to 300 frontline workers. None should be able to browse or edit all assets in its collaboration workspace. What is the better distribution model? Publish a Power BI app with a tailored audience and only the required report content Grant all 300 staff workspace Contributor Grant all 300 staff workspace Member Grant all 300 staff workspace Admin Explanation Correct Answer A:An app can distribute selected workspace content to a consumer audience without giving everyone authoring access to the underlying workspace. Incorrect Answers B:Contributor grants item-editing privileges and unnecessary workspace visibility. C:Member includes publishing and content update rights inappropriate for end users. D:Admin permits role and workspace management, a severe overprivilege.
Question 508 A dataset contains customer transactions and a medical-condition column. Readers may see authorized customer rows but not the sensitive medical column. Which security distinction is relevant? Use RLS alone to assume all columns are inaccessible Hide the medical column in the Fields pane and call it encrypted Use row-level controls for permitted records and object-level security for the prohibited column, with appropriate model-role design Use only a report bookmark named Private Explanation Correct Answer C:Row filtering and object/column hiding are separate enforced security capabilities. Incorrect Answers A:RLS operates on rows, not selectively excluding one column from authorized rows. B:Field visibility is not an OLS guarantee. D:Bookmarks preserve view state and are not security controls.
Question 509 A retailer added a new column to a Fabric lakehouse Delta table used by a Direct Lake model. The new field is missing from model queries although it exists in OneLake. Which operation should the developer perform before treating the model as broken? Recreate the lakehouse as an Excel workbook Refresh the Direct Lake semantic model to frame the updated Delta table metadata Change all report visuals to DirectQuery permanently Disable storage security for the lakehouse workspace Explanation Correct Answer B:Direct Lake framing captures the current Delta table and schema state; refreshing or reframing the semantic model makes supported table changes available to the model. Incorrect Answers A:An Excel export abandons the Delta source instead of updating its model representation. C:DirectQuery can change the architecture and does not by itself frame the existing Direct Lake model. D:Turning off security neither updates model table metadata nor satisfies governance requirements.
Question 510 A course model has 50 unique learners overall. Selecting the Math department narrows them to 12, and a year slicer further narrows to 7. What should a DISTINCTCOUNT(LearnerID) measure return with both filters active? 50 12 19 7 Explanation Correct Answer D:Distinct learners are evaluated within the intersection of current Department and Year filter context. Incorrect Answers A:Fifty is the unfiltered population. B:Twelve ignores the additional year restriction. C:Adding the filtered counts double-counts rather than evaluates the intersection.
