Question 1 A regional hospital network receives a patient encounters extract of 160 rows at the end of each shift. Business users need fast interactive filtering, complete Power Query preparation, and can accept data changing only after scheduled refresh. Which storage approach should the analyst prioritize? Choose Direct Lake without a Fabric Delta table in OneLake Live-connect to an unrelated external semantic model Import the source rows into the semantic model and schedule refresh Use DirectQuery against the operational source for every visual request Explanation Correct Answer C:Import caches this patient encounters snapshot in the VertiPaq engine, supporting fast reports and transformations with a known refresh boundary. Incorrect Answers A:Direct Lake reads appropriate OneLake Delta data; this scenario supplies an ordinary extract, not a Fabric Delta source. B:A live connection cannot invent or substitute for an existing governed model of these patient encounters. D:DirectQuery would send interactive requests to the operational source even though a end-of-shift snapshot is already acceptable.
Question 2 A university finds that the category column in course enrollments contains both " EAST " and the same category without surrounding spaces. Which Power Query operation addresses this difference without changing internal letters? Replace nulls with zero Unpivot the category column Trim the category column Change the column to Whole Number Explanation Correct Answer C:Trim removes leading/trailing whitespace from values like ' EAST ' so equal category names group together. Incorrect Answers A:Null replacement does not remove existing leading and trailing whitespace. B:Unpivot changes table shape and does not clean the extra spaces in category labels. D:A category is textual; Whole Number would create conversion errors instead of removing padding.
Question 3 A national bookstore has an Orders-like book sales query with ReceiptID, a Shops key, and NetSales. A separate lookup contains the descriptive Shops name for each key. Analysts must bring the description into each transaction row without stacking more transactions. What operation is correct? Transpose both tables before loading Unpivot the numeric amount column Merge the queries on the matching dimension key and expand the lookup attribute Append the lookup rows underneath the transaction rows Explanation Correct Answer C:A merge joins matching Shops keys to enrich individual book sales records with the lookup description. Incorrect Answers A:Transpose changes rows to columns and cannot perform a key-based lookup. B:Unpivot reorganizes columns into key/value rows; it does not join the Shops lookup. D:Append stacks rows rather than adding the Shops attribute beside matched transaction rows.
Question 4 A published Import model has several fact-date columns. Power BI Auto date/time created separate hidden calendars for each eligible field, increasing model size and making it hard to apply one consistent fiscal calendar. The organization wants a governed calendar and explicit relationships. Which redesign best addresses this? Enable Auto date/time for every additional text and currency field. Remove all date relationships and use month-name strings sorted alphabetically. Develop a proper shared Date table and explicit relationships, turn off Auto date/time for this model after migrating dependent visuals, and validate the fiscal definitions. Duplicate each hidden Auto date/time table into the fact rows as a calculated text column. Explanation Correct Answer C:A modeled Date table supports consistent time filtering and fiscal definitions; retiring the auto-generated hidden tables also requires checking visuals that depend on their hierarchies. Incorrect Answers A:Auto date/time creates hidden calendars for eligible date columns, not arbitrary currency/text fields, and would expand rather than consolidate date structures. B:Disconnected month text loses reliable chronology and does not supply a governed fiscal calendar. D:Copying date labels into facts increases redundancy without providing the shared calendar or maintained relationships.
Question 5 In a shipments semantic model, the East region has 17 and 28 in Freight; West has 41. A DAX measure is CALCULATE(SUM(Fact[Freight]), DimRegion[Region] = "East"). Assuming no other filters, what does it return? 41 17 45 86 Explanation Correct Answer C:The CALCULATE filter restricts the fact to East: 17 + 28 = 45. Incorrect Answers A:41 is the West-only value and fails the specified East filter. B:17 omits the second East record (28). D:86 includes the West value of 41; the measure explicitly filters Region to East.
Question 6 A published Import model at a transit authority contains 27 unused text columns copied from ticket validations. Its memory footprint and refresh time have grown, but analysts need none of those fields. What is a direct optimization? Remove unused columns in Power Query before load Add calculated columns duplicating the same text Use bi-directional relationships for every dimension Increase a report bookmark count Explanation Correct Answer A:Removing unused ticket validations columns before load reduces compressed storage, refresh volume, and model surface. Incorrect Answers B:Duplicated text adds more model columns and memory without aiding queries. C:Cross-filter directions affect relationship behavior, not the bytes of unused source columns. D:Bookmarks control saved report states and do not shrink the semantic model.
Question 7 A report for a university must show how total Tuition changed month by month over two years, keeping time in chronological order. Which visual is most directly suited to showing the continuous trend? Single card showing only the grand total Scatter plot without a meaningful second numeric variable Line chart with month on the X-axis and total measure on Y Pie chart with one slice for each month Explanation Correct Answer C:The line graph joins ordered monthly Tuition values so trends and inflections are visible. Incorrect Answers A:A single card summarizes one total but cannot display how Tuition evolved over months. B:A scatterplot is more appropriate for association between numeric variables, not an ordinary month-by-month line. D:Twenty-four pie slices make sequential changes hard to read and omit the ordered time trajectory.
Question 8 An energy utility created two report views: an overview and a detail layout with different visual visibility and filter state. A button must switch between these saved states without editing the model. What should the author configure? Column quality profiling in Power Query Recreate the semantic model per button Report bookmarks assigned to a button or bookmark navigator A new many-to-many relationship for each layout Explanation Correct Answer C:Bookmarks capture supported report display/filter states; a button can navigate among the overview and detail states. Incorrect Answers A:Column profiling measures source quality, not report layout navigation. B:Switching layouts does not require rebuilding the semantic model. D:Relationship changes affect data filtering but are not the intended stored visual states.
Question 9 A revenue line chart displays one eligible monthly series against a continuous date axis. Leadership needs future monthly estimates together with uncertainty bands, not only a benchmark based on past months. Which analytic option should the author add? Display anomaly markers only for already observed months. Cluster geographic store locations using latitude and longitude. Use Forecast with a suitable future horizon and confidence interval in the Analytics pane. Show a constant reference line at the historical mean and call it a future forecast. Explanation Correct Answer C:Forecast uses the eligible time series to estimate future values and display uncertainty under the chosen settings. Incorrect Answers A:Anomaly markers identify unusual observed points; they do not create a future time horizon. B:Spatial clustering is not time-series forecasting and does not output uncertainty bands for future revenue. D:A static mean line is a baseline and has no time-varying projections or future confidence bounds.
Question 10 An analytics team at a national bookstore needs one person who can remove members from the Power BI workspace, change access roles, and manage the workspace itself. Which workspace role should that person hold? Member Contributor Viewer Admin Explanation Correct Answer D:Workspace Admin can manage roles and workspace-level settings, including removal of users. Incorrect Answers A:Members can create content and add lower-privileged members but cannot generally remove existing workspace users. B:Contributors can create or update content but cannot administrate the workspace membership. C:Viewers browse content and cannot change workspace access.
