Question 140 A regional sales bar chart cross-filters an organization-wide target KPI, but the KPI must always show the global target while the product table should still respond to region clicks. How can the report author correct only the KPI behavior? Set the bar chart’s interaction with the target KPI to None; retain filtering for the product table Delete the shared Region dimension Disable all visual interactions on every page Change the target KPI measure to text Explanation Correct Answer A:Edit interactions applies per source-target visual pair, so one KPI can stay global without breaking the other filter. Incorrect Answers B:Removing the dimension damages both intended and unintended filter paths. C:Globally disabling interactions breaks the product drilldown requirement. D:A text conversion cannot choose a visual-level interaction.
Question 141 A government agency charts forecast error by month and wants the uncertainty around each monthly estimate to be visible as upper and lower boundaries, rather than just one point estimate. Which visual addition is most suitable? A text-only slicer Disable visual labels and tooltips Error bars configured from valid lower/upper measures A report page navigation button Explanation Correct Answer C:Error bars display the spread or interval for each estimate when appropriate upper/lower values are supplied. Incorrect Answers A:A slicer selects values but does not render estimate intervals. B:Hiding labels removes information and does not create uncertainty ranges. D:Page navigation moves between report pages and does not quantify uncertainty.
Question 142 An invoice feed has InvoiceID I-104 on three rows with LineNumber 1, 2, and 3, each holding a different product. A developer wants to Remove duplicates on InvoiceID before calculating sales. What should be corrected? Discard two lines because each InvoiceID must always represent exactly one fact row Preserve the line-item grain and test uniqueness using InvoiceID plus LineNumber instead of InvoiceID alone Average the three line amounts into one arbitrary transaction Rename InvoiceID to a report title and remove ProductID Explanation Correct Answer B:Multiple valid invoice lines share their header ID; a composite line key prevents legitimate sales from being erased. Incorrect Answers A:Deleting lines understates revenue and units. C:Averaging line amounts changes the defined transaction-grain metric. D:Changing field names cannot resolve fact row identity.
Question 143 A mobile games studio wants its in-app purchases row-level restrictions to stay consistent as staff transfers between regions. The roles are assigned through managed Entra security groups. What should administrators update? Every visual title in the workspace The worker’s membership in the correct managed security groups The theme colors of the affected reports Only the Power Query step names Explanation Correct Answer B:Managed role groups let group membership changes track region reassignment without editing row filters for each user. Incorrect Answers A:Visual titles cannot replace proper group-based RLS management. C:Themes do not update user authorization. D:Applied-step naming affects readability, not security-group assignment.
Question 144 A rail operator stores freight mass in kilograms in a transaction fact. Reports need selected CargoTons in metric tonnes (1000 kg) and the same definition must be reused across pages as users filter by corridor. Where should the calculation be defined? A static report title that displays the word tonnes without converting numeric values A semantic-model measure such as DIVIDE(SUM(Fact[MassKg]),1000), referenced by report visuals A calculated column repeating an all-corridor grand total on every shipment row An unsynchronized Power Query parameter changing at model refresh rather than viewer selection Explanation Correct Answer B:A DAX measure applies the unit conversion to the filtered aggregate consistently for every visual that uses it. Incorrect Answers A:Renaming a label leaves the kilograms numeric scale unchanged. C:Repeating a global total on each row is not a slicer-responsive reusable aggregation. D:A refresh-time parameter does not evaluate separately for each visual filter context.
Question 145 A transport company has numeric Latitude and Longitude columns for depots. Their map visual puts some facilities in the wrong country because the fields are treated as generic numeric measures. What should the author verify? Aggregate coordinates into a total cost measure Assign the geographic coordinates to appropriate Latitude and Longitude fields and set suitable data categories Use a month-only axis to position the depots Create one report bookmark for each latitude degree Explanation Correct Answer B:Correct map field mapping and categories let the visual geolocate each depot accurately. Incorrect Answers A:Summing coordinate values does not form valid point positions. C:Months do not encode spatial coordinates. D:Bookmarks cannot replace geographic field bindings.
Question 146 A charity’s Power BI Desktop file retrieves an updated donations CSV from separate development and production SharePoint folders, with the same schema. The team wants deployment to switch the folder root without editing multiple Power Query steps. Which source configuration helps? Manually duplicate the whole model for each monthly file Configure random row filters that differ on every refresh Define a Power Query parameter for the folder/root path and reference it in the source step, with environment-specific values Convert the organization’s donations amounts from Decimal to text Explanation Correct Answer C:A parameterized source path makes the input environment explicit and avoids editing many M queries during deployment. Incorrect Answers A:Manual model duplication creates ongoing drift and does not centralize an environment-specific path. B:Row filtering changes the dataset rather than selecting the intended source location. D:Numeric-to-text conversion is unrelated to choosing the correct source environment.
Question 147 An ETL analyst needs a temporary Power Query branch to test an alternative deduplication algorithm without later changes to the source query altering the experiment’s step history. Which operation best fits? Create a Reference specifically to inherit every future upstream change Append the source query to itself before deduplicating Duplicate the existing query and conduct the experiment on the independent copy Disable refresh for all queries in the model Explanation Correct Answer C:Duplicate copies the current query logic for an independent branch of transformations. Incorrect Answers A:Reference remains dependent on the upstream query and may change with it. B:Appending doubles records and does not isolate transformation design. D:Global refresh disablement blocks testing rather than isolating the branch.
Question 148 The Region slicer selects East. A measure uses CALCULATE([NetSales], KEEPFILTERS(Region[Region] = "West")). The East and West values are mutually exclusive. What happens? The intersected filter is empty, so the ordinary SUM-based measure returns BLANK West replaces East, because every CALCULATE filter overwrites a slicer All regions become visible East remains selected and West is ignored Explanation Correct Answer A:KEEPFILTERS retains the existing East filter and intersects it with West; there are no matching rows. Incorrect Answers B:KEEPFILTERS changes the default overwrite behavior and preserves the existing filter. C:KEEPFILTERS does not remove the Region filter. D:KEEPFILTERS intersects the conditions; it does not discard the West condition.
Question 149 A finance Import model contains a free-form comment text column with nearly a unique value per row. Reports, relationships, and security never use it. The model occupies excessive memory. What is the lowest-risk first change? Change its data type from text to Date Duplicate the comment column in a calculated column Remove the unused comment column from the loaded model after checking dependencies Add a second relationship from the comments to the Date table Explanation Correct Answer C:A high-cardinality unused text field contributes dictionary storage without an analytic purpose. Incorrect Answers A:Unparseable notes are not calendar dates and changing their type may create errors. B:Duplicating the text increases storage rather than reducing it. D:A meaningless date relationship will not improve column encoding.
Question 150 A software vendor must preserve the ability to reuse a shared license invoices model while publishing a new report, not duplicate its data under a second imported semantic model. What is the appropriate publication approach? Build the report from the existing shared semantic model and publish the report item Export the model to separate CSV tables for each report Force all consumers to use raw SQL directly Duplicate the entire semantic model for each page Explanation Correct Answer A:Connecting to the shared license invoices model preserves central DAX definitions, relationships and governance across multiple reports. Incorrect Answers B:CSV exports create redundant copies and lose the central model lifecycle. C:Raw SQL access bypasses the curated semantic definitions and governance. D:Duplicating the model per page fragments refresh and measure consistency.
