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.
Question 11 An energy utility must limit report consumers to meter readings records from their assigned region, while maintaining one shared semantic model. Which modeling security feature restricts the visible rows? Changing the report page title Filtering only one visual while leaving other visuals open Row-level security (RLS) roles with the correct region filter Hiding the Region column from the Fields pane Explanation Correct Answer C:RLS enforces region row filters on eligible consumers across the secured model. Incorrect Answers A:Page titles have no security effect. B:A visual-only filter does not enforce row restrictions across every report and model query. D:Hiding a field changes authoring visibility but does not prevent access to its rows.
Question 12 A sales analyst defines RevenuePerUnit = DIVIDE([Revenue], [Units]) without a third argument. In a region with revenue 280 but zero units, what does the measure return? 280 because the numerator is still nonzero 0 because all ratios with a zero denominator automatically equal zero Infinity because the ratio has a positive numerator BLANK(), the default alternate result for a zero denominator Explanation Correct Answer D:DIVIDE returns BLANK for zero denominator unless a constant alternate result is provided; it does not perform ordinary unguarded division. Incorrect Answers A:280 is the undivided revenue, not a per-unit result. B:Zero is not DIVIDE’s implicit alternate result; it must be supplied explicitly if desired. C:DIVIDE handles zero denominator safely rather than returning a numeric infinity.
Question 13 A hotel operator receives January and February bookings extracts with exactly the same columns (BookingID, StayDate, RoomRevenue). It needs one vertically combined fact table for both months. Which Power Query operation should it use? Merge the tables on the transaction ID Pivot the date field Join only rows with matching IDs Append the February rows to the January query Explanation Correct Answer D:Appending stacks rows from the two bookings extracts into a single table with the same schema. Incorrect Answers A:Merging matches keys horizontally, which is wrong when February contains additional BookingID records. B:Pivot reshapes category values into columns instead of extending the monthly row set. C:An inner join would discard unmatched records across the two different monthly extracts.
Question 14 A nonprofit models a clean Chapters dimension related to a donations fact. Filters should travel from the dimension to transactions, but transaction rows must not unexpectedly filter unrelated dimension members. What cross-filter setting is safest? Both directions everywhere in the model Delete the key relationship and use disconnected tables Create a many-to-many bridge without a need Single direction from the one-side dimension to the many-side fact Explanation Correct Answer D:Single-direction filtering from Chapters to donations follows a predictable star-schema filter path. Incorrect Answers A:Bidirectional filters can create ambiguous paths and unnecessary interactions for this simple dimension/fact design. B:Disconnecting breaks the intended Chapters-based filtering of donations. C:A bridge solves different many-to-many situations, not a clean one-to-many dimension key.
Question 15 An insurance provider compares last quarter’s total ClaimValue between five Offices categories. The main objective is clear ranking, not part-to-whole composition. Which visual is preferable? Gauge without individual categories Pie chart with twelve nonpresent categories Line chart using unordered category names as time Sorted bar chart of the five categories Explanation Correct Answer D:Sorted bars make the magnitude and ranking of ClaimValue by Offices easy to compare. Incorrect Answers A:A gauge measures progress against a target, not ranked comparisons among five members. B:A pie requires proportions and would not provide a readable rank-first display. C:A line implies ordered progression and is less appropriate for unrelated Offices names.
Question 16 A manufacturing report displays cost by Plant. When a user hovers over one bar, the author wants a small contextual page showing that plant’s trend and maintenance metrics without leaving the report page. Which feature should be configured? Drillthrough to a separate Plant Details page A regular tooltip containing only the default numeric value A bookmark navigator that switches whole-page layouts Report page tooltip, registered and assigned to the bar chart Explanation Correct Answer D:A report page tooltip receives the hovered plant context and can show multiple supplementary visuals without requiring navigation. Incorrect Answers A:Drillthrough opens another report page on an explicit action; it is not the requested hover panel. B:A standard field tooltip can reveal values but does not deliver the requested richly formatted report page. C:Bookmarks can change saved page states but are not dynamically invoked as item-specific hover content.
Question 17 A hotel operator has a Power BI workspace whose analysts must publish content and manage an associated app but should not delete the workspace or remove users. Which role is generally suitable? Member Viewer Contributor without explicit app-update delegation App consumer only Explanation Correct Answer A:Workspace Members can collaborate on content and publish/update the app without taking Admin-level workspace-control duties. Incorrect Answers B:A Viewer cannot publish workspace app content. C:A Contributor can update the app only when an Admin delegates that permission; the scenario lacks that grant. D:An app consumer can view distributed content but cannot publish changes for the workspace.
Question 18 A coastal logistics operator keeps a governed shipments table in a high-performing SQL database and forbids importing the underlying row data into the Power BI model. Reports must issue supported queries to that database as users filter. Which connectivity mode fits the restriction? DirectQuery to the supported SQL source Direct Lake over an uncreated Fabric lakehouse Duplicate the table into an Excel workbook Import with overnight refresh Explanation Correct Answer A:DirectQuery leaves the shipments rows at the SQL source and delegates visual requests through source queries, subject to source performance. Incorrect Answers B:Direct Lake requires supported Delta-backed Fabric storage; it is not direct access to an ordinary SQL operational database. C:Excel duplication would still move data and introduce another maintained copy of shipments. D:Import would copy the shipments rows into the model and violate the stated non-ingestion requirement.
Question 19 An insurance feed explicitly documents month/day/year dates such as "12/31/2026". A Power Query step created on a day-first configured workstation raises an error during default conversion. What change applies the known source convention reliably? Replace every slash with a dash but continue parsing as day-first Keep the dates as text and depend on alphabetical sorting for time intelligence Convert the date strings to Whole Number and delete records that fail Convert the text to Date using the explicit English (United States) source locale, then validate sample calendar dates Explanation Correct Answer D:Using Locale en-US interprets 12 as the month and 31 as the day independently of the workstation’s default regional setting. Incorrect Answers A:Separator changes do not change the ambiguous regional order. B:Text labels cannot reliably drive typed date joins and chronological grouping. C:Arbitrary numeric conversion destroys calendar meaning and discards valid claims.
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.
