Question 540 A cashflow table contains profit and loss measures ranging from -5000 to +6000. The author wants a diverging gradient with zero as neutral. What is important when configuring conditional formatting? Choose a diverging color scale anchored at the meaningful zero midpoint, using the signed numeric measure Use absolute values so losses and gains both appear positive Assign the maximum positive color to all negative values Convert the numeric measure into a date serial before formatting Explanation Correct Answer A:A zero-centered gradient preserves direction and magnitude of losses and gains. Incorrect Answers B:Absolute value destroys the sign and makes losses indistinguishable from profits. C:Using positive colors for negatives misrepresents business meaning. D:Date serial values do not express signed cashflow.
Question 541 A report has Overview, Products, and Finance pages, plus an author-debug page. The author wants only the first three pages listed in the built-in Page navigator, without implying that hiding a page secures confidential data. What should the author do? Delete every source query used by the debug page regardless of shared dependencies. Hide the author-debug report page and verify that the Page navigator lists the intended visible pages. Create a bidirectional data-model relationship using the page title as a foreign key. Replace the Page navigator with a tooltip that still lists the debug page. Explanation Correct Answer B:Page navigators follow the report page visibility settings; actual access to sensitive data must be controlled through permissions or RLS, not page hiding. Incorrect Answers A:Deleting potentially shared queries can break legitimate pages and does not directly control navigator entries. C:Relationships connect data columns, not report page metadata or navigation lists. D:A tooltip is neither the appropriate page-list control nor a security mechanism.
Question 542 Two deployment environments have identical data schemas in different blob container prefixes. The query currently hardcodes the folder prefix in six places. What should be centralized? A folder/container-path parameter referenced in source steps, with environment-specific permitted values A unique Excel workbook for every report page A pie chart that shows the names of environments A DAX color theme variable replacing the file path Explanation Correct Answer A:Centralizing the source path avoids multiple manual edits and environment drift. Incorrect Answers B:Extra workbooks increase maintenance and do not centralize the connector input. C:A pie chart cannot configure query source locations. D:Theme/DAX presentation values do not set a connector’s source path.
Question 543 A stock table has UnitCount values 5, 10, 10, 20, 0. A measure uses COUNTROWS(FILTER(Stock,Stock[UnitCount] > 10)). What is the result? 2 3 20 1 Explanation Correct Answer D:Only the row with 20 is strictly greater than 10. Incorrect Answers A:Two would incorrectly include one of the rows equal to 10. B:Three would include both rows equal to 10. C:Twenty is a value in a row, not the number of qualifying rows.
Question 544 A report computes TotalUnits with SUMX(Fact, Fact[Units]) even though every row simply contributes its Units value, without a per-row expression. Which simpler DAX definition should be evaluated? SUMX(Fact, FORMAT(Fact[Units],"0")) AVERAGEX(Fact,Fact[Units]) regardless of row count COUNTROWS(Fact) as a substitute for total units SUM(Fact[Units]) Explanation Correct Answer D:For a directly additive numeric column, SUM expresses the aggregation without explicit row-by-row expression logic. Incorrect Answers A:FORMAT returns text and is not a valid numeric simplification. B:An average does not equal total units across multiple rows. C:Row count ignores the actual units in each fact row.
Question 545 An analyst moves a PBIX from an en-GB workstation to a US-configured build agent. A source contains day-first text dates such as `25/04/2026`. The existing transformation relied on the workstation defaults. How can the Power Query refresh be made independent of the machine locale? Change the report theme to one with regional date labels Edit the date type-conversion step to specify the source locale explicitly and validate the converted dates Convert all dates to category labels and never load a real Date column Use a visual sort on month names after refresh fails Explanation Correct Answer B:Explicit locale in the transformation makes parsing stable across machines and prevents a US machine misreading or rejecting day-first values. Incorrect Answers A:A theme can format visuals but cannot specify how source text is parsed into dates. C:Text categories lose typed date operations and do not repair the data conversion. D:Sorting is a reporting operation, not a substitute for reliable source parsing.
Question 546 A consumer has Viewer workspace access and Build permission so they can analyze a governed dataset in Excel. They belong to the EastRegion RLS role. Will Build reveal WestRegion rows? Yes; Build always grants full model edit rights No; Viewer access with Build still enforces the configured RLS filters Yes; Analyze in Excel ignores all Power BI model security Only report color themes decide which rows are returned Explanation Correct Answer B:Microsoft explicitly applies RLS to Viewers even when they hold Build permission. Incorrect Answers A:Build enables reuse, not a higher workspace editing role. C:Excel connectivity remains subject to model row restrictions. D:Formatting has no authority over row security.
Question 547 A university has a wide table with EnrollmentID, Jan, Feb, and Mar numeric columns. A newly added SourceFile text column must remain metadata rather than become a bogus month in the Month field. What should the author change? Explicitly preserve the identifier and SourceFile columns when unpivoting remaining month columns Unpivot SourceFile alongside actual month amounts Convert SourceFile values to a date without validating them Drop all monthly value columns Explanation Correct Answer A:Keeping metadata columns fixed prevents non-month values from being loaded as Month attributes. Incorrect Answers B:SourceFile is metadata, not a month, so it pollutes the long fact if unpivoted. C:An arbitrary filename is not a meaningful monthly date. D:Dropping values prevents the required month-by-month analysis.
Question 548 A retailer links each order to several marketing campaigns through a bridge table. Its campaign dashboard sums full order revenue under each campaign and reports more than total company revenue. What must the analyst decide before summing campaign totals? Hide the campaign table and assume the report now allocates revenue Define an explicit attribution or fractional-allocation rule and implement it at the bridge or measure level Turn on both-direction filtering everywhere and assume totals cannot double count Add campaign names directly to the fact and duplicate order revenue on every membership row Explanation Correct Answer B:A single order can belong to multiple campaigns. Only a defined attribution rule makes campaign totals additive across memberships. Incorrect Answers A:Hiding a dimension does not change allocation or underlying fact grain. C:Bidirectional filtering changes propagation, not the economic attribution of a shared sale. D:Duplicating revenue per membership reproduces the overcount instead of resolving it.
Question 549 A hotel analyst wants a computed revenue driver available as a field for the Key Influencers visual. They try creating a visual calculation directly on that visual, but Power BI does not support visual calculations there. What should the author use? Create a visual calculation in some other chart and assume it becomes a model-wide field automatically. Define an appropriate semantic-model measure or source column for the explanatory calculation instead of a visual-local calculation. Increase scheduled refresh frequency so unsupported visuals start accepting visual calculations. Add a visual calculation directly inside Key Influencers despite its unsupported status. Explanation Correct Answer B:A model calculation or column provides the reusable analytic field without relying on an unsupported visual-calculation feature. Incorrect Answers A:Visual calculations are local to their own visuals and cannot automatically act as reusable semantic-model fields. C:Refresh frequency does not change the supported visual types for the visual-calculation editor. D:Key Influencers is explicitly among the visuals without direct visual-calculation support.
Question 550 A ranking table has scores 100, 90, 90, 70. After the two 90 scores tie for second, the business requires the 70 score to take rank 3. What tie behavior is appropriate? Dense ranking with consecutive ranks for distinct scores Skip ranking, which would rank 70 fourth Ascending order with default Skip and 70 first Suppress all rows after the first tie Explanation Correct Answer A:Dense assigns 100→1, both 90→2, and 70→3 without a gap. Incorrect Answers B:Skip counts both tied rows and leaves rank 3 unused. C:Ascending would change rank direction and not meet the stated policy. D:RANKX can rank tied data without discarding later values.
