Question 30 An energy utility loads one meter readings record per sensor reading, but reports only require daily summaries by Zones. Most visuals are slow because of extreme event granularity. What model change should be tested? Add a slicer on a high-cardinality event ID Aggregate the source to the required daily reporting grain where detail is unnecessary Keep every subsecond row and add a disconnected duplicate Convert the daily count to a formatted text string Explanation Correct Answer B:A daily Zones-level summary reduces fact row count while preserving the grain needed for stated reports. Incorrect Answers A:A high-cardinality ReadingID slicer can make performance and usability worse. C:Duplicating the raw fact increases storage and does not address over-detailed meter readings. D:Formatting a count changes display, not the number of rows evaluated.
Question 31 A Power Query table has 40,000 rows. The first 1,000 sampled rows show no missing Fare values, but operations staff report missing fares later in the source. What profiling setting should be checked before declaring the column complete? Switch profiling from the default top-1,000-row sample to the entire data set and examine Column quality Assume zero missing values because the first sample has none Replace all Fare values with the sample mean before examining them Disable query profiling because the sample is already representative by definition Explanation Correct Answer A:Whole-dataset profiling can reveal missing/error values absent from the first 1,000-row preview. Incorrect Answers B:A sample cannot prove that later rows contain no missing values. C:Unexamined imputation destroys observed fares and masks the possible defect. D:A preview sample is not guaranteed to represent a large population.
Question 32 A government agency has configured an RLS role but a tester assigned the workspace Contributor role still sees every service applications row. What is the most likely explanation? RLS does not restrict workspace Admin, Member, or Contributor permissions; test as Viewer/consumer RLS is guaranteed to block every workspace Editor The table needs a new visual title All DAX measures must be copied into Power Query Explanation Correct Answer A:Workspace editing roles are not subject to RLS; a Viewer or eligible app consumer is needed for a realistic restricted-user test. Incorrect Answers B:Editors retain broad access, making the claim that RLS always limits them false. C:Page text does not change effective row security. D:Calculation location has no connection to the workspace-role security bypass.
Question 33 A claim filings source at an insurance provider has one row for each ClaimID, MetricType and MetricValue. MetricType contains Revenue, Cost, and Units; the reporting team wants one row per ID with a distinct column for each MetricType. Which transform applies? Split the identifier into separate characters Pivot the MetricType values into columns, aggregating any repeated ID/type pairs appropriately Unpivot the metric type into longer rows Append the MetricType column to another table Explanation Correct Answer B:Pivot creates a column for each MetricType value, turning the type/value rows into one wider ClaimID record. Incorrect Answers A:Splitting a ClaimID identifier does not transform the MetricType/value structure. C:Unpivot would produce even longer name/value data rather than new metric columns. D:Append combines whole row sets and does not create the desired metric columns.
Question 34 A sports league has OrderDate and ShipDate in its match tickets fact and one Date dimension. The OrderDate relationship is active; a measure must calculate TicketRevenue using ShipDate without changing the default report behavior. Which DAX technique fits? Use the FORMAT function to change date display Use CALCULATE with USERELATIONSHIP on the ShipDate relationship Activate both same-table relationships globally Remove the Date table and use ShipDate text fields Explanation Correct Answer B:USERELATIONSHIP enables the existing inactive ShipDate relationship only inside the relevant CALCULATE measure. Incorrect Answers A:FORMAT changes presentation but does not change relationship filter propagation. C:Only one relationship between the same pair of tables can normally be active without ambiguous filtering paths. D:Removing the Date dimension discards the common calendar needed for the report.
Question 35 An energy utility needs to view Consumption by country and city in a geographic report. The records contain valid latitude/longitude and data-category metadata. Which visual family should be evaluated? A constant-line-only chart without a map layer An Azure Maps geographic visual with appropriate coordinates A decomposition tree with no location hierarchy A donut chart showing latitude as a proportion Explanation Correct Answer B:A geographic visual locates Consumption observations on a spatial map using valid coordinate fields. Incorrect Answers A:A constant reference line does not position cities or countries geographically. C:Decomposition trees explain hierarchical contributions but do not display physical locations. D:Latitude is a coordinate, not a meaningful share of a whole.
Question 36 A subscription company has three report pages with a Plans slicer. Users expect a category selected on the summary page to remain selected on the detailed and forecast pages. What is the intended report feature? Set the slicer field to summarize as count Sync slicers across the three report pages Use column quality to merge category spellings Create disconnected, unrelated slicer tables on each page Explanation Correct Answer B:Sync slicers coordinates compatible slicer selection across chosen pages so Plans filtering persists. Incorrect Answers A:Changing summarization cannot synchronize a slicer selection. C:Column quality does not preserve user selections across report pages. D:Disconnected unrelated slicers would not coordinate selection state or fact filtering.
Question 37 A marked contiguous calendar is related to Fact[EnrollmentDate]. Monthly Tuition totals are Jan 29, Feb 36, Mar 42, Apr 52 in the same year. Under a March filter, what does TOTALYTD([Total Tuition], DimDate[Date]) return? 65 159 107 42 Explanation Correct Answer C:At March, year-to-date includes January through March: 29+36+42=107. Incorrect Answers A:65 excludes March from the year-to-date range. B:159 improperly includes April, which is later than the March filter. D:42 is the March-only total, not the accumulated year-to-date result.
Question 38 A claims officer must interact with a Power BI report but never edit it. The published semantic model has regional RLS, and the officer must remain subject to that role. Which workspace role is appropriate? Member with report edit and app publication abilities Contributor with semantic-model edit ability Viewer Admin with access to all workspace settings Explanation Correct Answer C:Viewer is the consumption role under which semantic-model RLS applies. Incorrect Answers A:Member adds authoring capabilities and bypasses RLS enforcement on workspace models. B:Contributor is an editing role to which workspace RLS does not apply. D:Admin is far beyond consumption and is not constrained as a Viewer.
Question 39 A regional manager at a hotel operator sees RoomRevenue decline and wants to interactively break the measure down by Properties, quarter, channel, and product category to locate major contributors. Which AI-assisted breakdown visual is relevant? Decomposition tree with explanatory dimensions One KPI card with no categories A gauge comparing total with target only An unconnected freeform text box Explanation Correct Answer A:A decomposition tree lets the manager drill through multiple dimensions to explain RoomRevenue breakdowns. Incorrect Answers B:A card supplies one total, not a hierarchy of contributing dimensions. C:A gauge shows goal progress and cannot expose the multilevel explanation path. D:Plain text cannot explore the dimensional groups behind the decline.
Question 40 A national bookstore already has a certified shared Power BI semantic model containing governed measures and relationships for book sales. A new report author must reuse its calculations and security rather than create another model. What is the appropriate starting connection? Rebuild all metrics in disconnected report-level tables Connect the report to the existing published semantic model Create a new Import model from its upstream database Export every table into CSV before report creation Explanation Correct Answer B:A live connection to the certified book sales model reuses its existing DAX definitions, relationships and governed access. Incorrect Answers A:Disconnected duplicated tables defeat the shared measures and filters the report author must preserve. C:A separate imported copy risks diverging metric definitions and is explicitly unnecessary when the certified book sales model exists. D:CSV extraction loses the reused semantic layer and creates a new data-maintenance dependency.
