Question 620 A school publishes an RLS-protected model to regional administrators via an app. One administrator is also granted Member on the underlying workspace for unrelated editing. The RLS role is assigned correctly, but the administrator sees all model rows. What is the underlying cause? The app’s background color is suppressing the regional filter Granting Build to a Viewer always removes RLS RLS role membership always overrides elevated workspace editing permissions and restores the Viewer-level filter Workspace Member has edit rights and is not restricted by RLS in the same way as a Viewer Explanation Correct Answer D:RLS does not restrict workspace users with elevated editing roles; users meant to consume regionally filtered reports need an access pattern that preserves Viewer-level permissions. Incorrect Answers A:Visual formatting cannot change model authorization. B:Build permission alone does not bypass the assigned RLS role for Viewer users. C:A model RLS role does not reimpose Viewer-style filtering on a user who has elevated Member workspace permissions.
Question 621 A report shows sales rank by category. Each row must be compared against every product within its current department, but not against unrelated departments. Which population should the author supply to RANKX? Every product across the entire enterprise, discarding the department filter The products in the current department, removing only the product-row filter but preserving the department filter Only the current product, which always ranks itself first Only the fact transaction rows instead of product entities Explanation Correct Answer B:Keeping department context and removing the current product restriction ranks peers inside the relevant partition. Incorrect Answers A:A global ranking answers a different question and can compare incompatible departments. C:A one-item population yields a trivial rank of one for every product. D:Transaction rows repeat products and do not define one comparison candidate per product.
Question 622 A utility attempts to enable forecasting on a line chart of consumption. The Analytics pane option is unavailable because the visual has a legend splitting data into several series and the date axis is categorical. What change should be evaluated? Replace the date axis with alphabetically sorted month names Turn on RLS for every branch to unlock forecasting Use a suitable single-series line chart with a continuous date X-axis Add more legend categories to improve model training Explanation Correct Answer C:Power BI forecasting is available for eligible time-series visuals, notably a continuous axis and a single series. Incorrect Answers A:Text month categories do not provide the required continuous time axis. B:Security-role configuration is unrelated to Analytics-pane forecast eligibility. D:Additional series can disqualify the forecasting capability.
Question 623 A food chain imported a single wide store purchases table with a repeated Locations name, address, and region on every event. A small dimension-to-subdimension snowflake makes field discovery difficult for report authors; the relationship is stable and the descriptive lookup is small. What simplification could be evaluated? Make every cross-filter path bidirectional Flatten the small descriptive attribute into the dimension where appropriate Copy the entire fact table into every dimension Delete the fact grain and aggregate arbitrary rows Explanation Correct Answer B:Flattening a limited descriptive snowflake can improve a Power BI star schema without repeating large fact measures. Incorrect Answers A:Bidirectional filtering does not simplify descriptive lookup structure. C:Fact duplication dramatically increases model size and confuses grain. D:Arbitrary aggregation destroys required row-level measures.
Question 624 A nonprofit has revenue by month and wants side-by-side small trend panels, one for each of six Chapters categories, using identical visual encodings. The comparison has only two categories and users prefer a single shared time axis rather than separate panels. What is a clean alternative? One pie per day One line chart with a two-category legend Small multiples split across dozens of empty categories Two unrelated dashboard cards Explanation Correct Answer B:A two-series line chart keeps comparisons on one synchronized axis. Incorrect Answers A:Daily pies obscure ordered time and meaningful comparisons. C:Unneeded panels add visual overhead in a two-category case. D:Separate cards hide trajectories and relative positions.
Question 625 An analyst combines a personal CSV of survey responses and a governed organizational SQL lookup. A blanket Public designation risks data sharing. What should the author evaluate? Classify each data source with its appropriate privacy level and test the query combination within organizational policy Set both sources Public solely to improve query folding Remove all personally identifying column headers but retain full records Replace source permissions with visual conditional formatting Explanation Correct Answer A:Source classification and evaluation prevent accidentally transmitting sensitive values between incompatible privacy boundaries. Incorrect Answers B:Performance goals do not justify downgrading source confidentiality. C:Renaming fields does not anonymize the underlying data. D:Conditional colors cannot limit query data exposure.
Question 626 Two monthly Power Query extracts have a Charge column; one is numeric and the other stores values like "1,250.50" as text. Analysts need a reliable appended numeric column. What should happen before stacking the rows? Convert both months to text and let Power BI add strings Parse the text charges using the correct culture and align both columns to a compatible numeric type Append without checking types and assume every resulting value is summable Replace every comma with null and drop the affected rows Explanation Correct Answer B:Compatible numeric types prevent mixed-type values and incorrect aggregation after append; culture-aware parsing interprets separators correctly. Incorrect Answers A:Text values cannot be relied on for arithmetic totals. C:A mixed-type column may contain errors or text that cannot be summed. D:Discarding commas and values changes legitimate currency amounts.
Question 627 An aircraft-maintenance inventory feed has daily ending balances through June 29, but June 30 is missing due to a closed warehouse. The quarter-end dashboard’s policy is to use the most recent valid observation on or before quarter end. What should the measure do? Return a fictitious zero on June 30 because the record is absent Sum all historical daily balances within the quarter Use the last nonblank balance by date within the allowed quarter-end window and disclose the observation date Assume the final day’s stock equals the highest balance ever recorded Explanation Correct Answer C:As-of stock reporting can use the latest valid observation, with freshness disclosed rather than invented. Incorrect Answers A:Missing is not equivalent to a measured zero. B:Summing daily stocks repeats the same inventory over time. D:The historical maximum is not an as-of stock value.
Question 628 A nonprofit shows fiscal month names "Apr", "Aug", "Dec", and "Feb" in alphabetic order. The company’s fiscal year begins in April, so month-name labels must show Apr through Mar rather than Jan through Dec. What should control their order? A bookmark per month The gateway’s refresh schedule A fiscal month ordinal column used as Sort by column An alphabetical ascending sort of month names Explanation Correct Answer C:Fiscal ordinal 1..12 starting in April supplies the correct custom order. Incorrect Answers A:Bookmarks do not provide an underlying stable sort key. B:Refresh schedules do not specify category ordering. D:Alphabetic sorting is unrelated to fiscal sequence.
Question 629 A workspace currently contains ten external contractors and the project owner must remove all their workspace roles today. Which permission must the owner use? Workspace Member, which can add some users but cannot remove existing workspace roles Workspace Contributor, which can modify report artifacts but not membership Workspace Viewer, which can view only authorized content Workspace Admin Explanation Correct Answer D:Removing workspace role assignments is an administrative capability available to workspace Admins. Incorrect Answers A:Members can add lower-privileged users but cannot remove existing ones. B:Contributor is a content-editing role, not a role-membership administrator. C:Viewers cannot administer workspace access.
Question 630 A UK logistics file contains FulfilledDate values "03/04/2026" and "11/12/2026". Source documentation specifies day/month/year. A model using a US locale has wrong dates but no conversion errors. What must be corrected? Convert to Date using the source locale, such as English (United Kingdom), before deriving month and year Sort the original text alphabetically to infer chronology Replace slashes with hyphens while keeping the default US locale Cast the field to Whole Number and interpret it as a date index Explanation Correct Answer A:The conversion locale disambiguates day and month and yields real Date values for valid time-intelligence filters. Incorrect Answers B:Text order does not resolve the day/month interpretation. C:Changing punctuation without setting culture preserves the same ambiguous meaning. D:Whole Number conversion cannot directly represent the documented day/month/year fields.
