Question 20 A manufacturer defines and tests a PlantRegion RLS role in Power BI Desktop. After publishing, a new Viewer is granted report access but has not been assigned to any RLS role. The Viewer needs only the rows for her authorized plants. What is the missing step? Give the Viewer Build permission instead of role membership Give the Viewer workspace Contributor access Add a visual-level PlantRegion filter to one report chart Assign the Viewer or her security group to the published PlantRegion role in the service and test effective access Explanation Correct Answer D:Desktop role definitions must be mapped to intended users or groups after publication so their row filters apply to eligible report consumers. Incorrect Answers A:Build permits derivative report creation but does not put an unassigned viewer into the defined RLS role. B:Contributor is an editing role that bypasses RLS, the opposite of the desired restricted consumer experience. C:A visual filter is not an enforceable model-wide security rule across other reports based on the semantic model.
Question 21 A national bookstore has 5 book sales rows with ReceiptID identifiers T-13, T-14, T-13, T-14, T-13. What value does DISTINCTCOUNT(Fact[ReceiptID]) produce? 2 5 1 6 Explanation Correct Answer A:The unique identifiers are T-13, T-14, so DISTINCTCOUNT is 2. Incorrect Answers B:5 counts every row, including repetitions, instead of distinct transaction identifiers. C:1 omits one legitimately different ReceiptID value. D:6 overcounts repeated identifiers as additional unique values.
Question 22 A national bookstore charts daily NetSales and wants automatic attention drawn to unusual spikes and dips relative to historical behavior. Which supported line-chart analytics feature is relevant? Sync slicers between reports Sorting by a text label Hiding the date field from all visuals Anomaly detection on a suitable time-series line visual Explanation Correct Answer D:Anomaly detection can flag unusually high or low NetSales observations in a qualified time series. Incorrect Answers A:Slicer synchronization preserves filter choices but cannot identify outlier observations. B:Label sorting does not compute statistical unusualness. C:Removing the date axis eliminates the time-series context required by this scenario.
Question 23 A university has a wide table with EnrollmentID, Jan, Feb, and Mar numeric columns. It needs Month and Tuition columns so the month can be used as a slicer. Which transformation creates this tall format? Unpivot Jan, Feb, and Mar while retaining the identifier Pivot Jan, Feb, and Mar into more columns Merge the table with itself on the identifier Remove Jan and Feb and keep only Mar Explanation Correct Answer A:Unpivoting turns the monthly headers into Month attribute values and their numbers into Tuition values, one row per EnrollmentID/month. Incorrect Answers B:Pivot goes from categories in rows to columns, the reverse of the requested wide-to-long operation. C:A self-merge can duplicate rows and will not create a Month attribute from headers. D:Deleting months destroys February and January history instead of normalizing it.
Question 24 A financial cooperative has DisbursementDate transactions and wants Year-to-Date DAX measures and an unbroken month axis, including months with no transactions. What date-modeling step should come first? Create a continuous calendar date dimension and relate it to the fact date Use only the dates that happen to appear in the fact table Convert dates to month-name text and sort alphabetically Use the transaction ID as a surrogate date Explanation Correct Answer A:A continuous Date table supports unbroken reporting periods and reliable time-intelligence filters over DisbursementDate. Incorrect Answers B:A sparse fact-date column omits dates without loan disbursements records and complicates time-intelligence interpretation. C:Month-name text lacks chronological order and cannot supply a continuous date column. D:LoanID is an event identifier, not a calendar date.
Question 25 A transit authority has 80 station records, each with passenger footfall and ticket revenue. Leadership wants to see whether the two numeric measures are associated and identify unusual stations. Which chart is suitable? Scatter chart with footfall and ticket revenue on numeric axes and StationID identifying each point A single card of total ticket revenue An area chart that treats unordered station codes as a time series A matrix of row counts with neither footfall nor revenue Explanation Correct Answer A:A scatter plot places every station at the two-measure coordinate; the station identifier prevents one aggregated point. Incorrect Answers B:A card hides station-to-station variation and cannot show association. C:Station identifiers are not a temporal sequence and the chart cannot reveal the bivariate pattern well. D:Row counts omit the two numeric variables that need comparison.
Question 26 A government agency has a geographic map, a bar chart, and a monthly total. Selecting one Districts bar should highlight other visuals but should not filter the monthly total card. Which report setting controls this? Edit interactions between the source bar chart and each target visual Set the global page theme only Change numeric type to percentage Delete the relationship between every pair of tables Explanation Correct Answer A:Edit interactions sets per-target highlighting, filtering, or no effect when a Districts bar is selected. Incorrect Answers B:A theme changes design tokens but not cross-visual interaction behavior. C:Number formatting cannot change which visuals respond to a selection. D:Removing relationships destroys meaningful model filters instead of selectively disabling one visual interaction.
Question 27 A university wants analysts to create and edit course enrollments reports in one workspace but neither manage access nor publish the associated app. Which least-privileged workspace role fits? Only an app audience member Contributor Admin Viewer Explanation Correct Answer B:Contributor can edit and create allowed workspace content without role-management privileges. Incorrect Answers A:App audience access is for consumption, not workspace content authoring. C:Admin is unnecessarily broad and can control workspace membership and settings. D:Viewer cannot edit the course enrollments reports.
Question 28 A digital retailer maintains curated orders as supported Delta tables in OneLake under a Fabric capacity. Analysts want model-like DAX interactivity without copying all Delta rows into a separately refreshed Import model. What storage mode is the primary candidate? Direct Lake on the supported Fabric tables DirectQuery to an arbitrary SQL database outside Fabric Manual CSV imports to Power BI Desktop A live connection to an unrelated published model Explanation Correct Answer A:Direct Lake can access compatible OneLake Delta tables for orders without a separate large Import reload; check its fallback and eligibility requirements. Incorrect Answers B:DirectQuery to an unrelated SQL endpoint ignores the expressly supplied OneLake Delta source and may add query latency. C:CSV import creates another data copy and requires refresh management, contrary to the requested lake-native approach. D:A live connection can reuse an existing model but does not by itself create a model over these orders Delta tables.
Question 29 Two bookings transactions have revenue/cost pairs (152,76) and (218,163). What does AVERAGEX(Fact, DIVIDE(Fact[Revenue] - Fact[Cost], Fact[Revenue])) return, formatted as a percentage? 25.23% 37.61% 35.41% 50.00% Explanation Correct Answer B:AVERAGEX evaluates each row margin, 50.00% and 25.23%, then averages them to 37.61%. Incorrect Answers A:25.23% is only the second row’s percentage. C:35.41% is (total profit)/(total revenue), which weights rows and differs from AVERAGEX of row percentages. D:50.00% is only the first row’s percentage.
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.
