Question 430 A delivery matrix needs upward, flat and downward indicators based on the signed month-over-month growth measure. A designer proposes icons based on report row order. What should be configured? Conditional formatting icons with explicit ranges for positive, near-zero, and negative growth Sort the rows randomly and use the row number as performance Replace the growth measure with a string that never changes Apply one icon to the entire column independent of value Explanation Correct Answer A:Numeric rules map the sign and magnitude of growth to a consistent visual cue. Incorrect Answers B:Row position does not determine improvement or decline. C:Text-only values are not the requested signed growth calculation. D:A constant icon conveys no performance variation.
Question 431 An equipment register has PlantName values null, "(blank)", and "Plant 3". The source contract says the literal "(blank)" means missing, not a valid named plant. What should the analyst do? Map the explicit sentinel "(blank)" to null and profile the resulting PlantName completeness Treat the literal and null as unrelated real plants Delete all plants that have a valid name Convert PlantName to integer without a mapping Explanation Correct Answer A:Normalizing the contractual missing marker permits one coherent measure of missing plant names. Incorrect Answers B:Separate missing tokens artificially fragment missingness. C:Valid plant rows must remain. D:Integer conversion cannot resolve categorical sentinel meaning.
Question 432 An author cannot find a Highly Confidential label in the report’s sensitivity menu. Their teammate can apply it. What should the author check? Tenant enablement, licensing, security-group eligibility, and usage rights for the particular label Only whether the report theme has a red palette Whether all model measures are displayed as percentages Whether the report page has more than three bookmarks Explanation Correct Answer A:Purview labels require organization configuration and rights; not all authors can apply every label. Incorrect Answers B:Color themes are not the label permission system. C:Percent formatting does not grant information-protection rights. D:Bookmark count has no relationship to label availability.
Question 433 A university clusters student-course groups by attendance and average assessment score. One cluster has low attendance and low scores, and a dean immediately concludes that attendance interventions will guarantee higher exam results. What is the responsible interpretation? Assign every student to the same cluster and assume the association disappears Rename the cluster to Causal Intervention Proven without further validation Hide the scatter numeric axes to remove evidence of the association Treat clusters as descriptive similarity patterns and test potential causal interventions with suitable additional evidence Explanation Correct Answer D:Clustering identifies groups with similar observed measures but cannot guarantee that changing one dimension changes the other. Incorrect Answers A:Destroying the data grouping does not answer the cause of the observed outcome. B:A cluster name cannot turn descriptive similarity into causal proof. C:Hiding axes makes analysis less transparent and does not validate causality.
Question 434 A department spent 90 in operating costs while earning revenue of 300. Its model measure DIVIDE([Costs], [Revenue]) has General numeric format. Which numeric result is correct? 390, adding the two currency amounts 0.3 30, confusing a fraction with an unformatted percentage number 3.33, inverting revenue and cost Explanation Correct Answer B:90 divided by 300 is 0.3. A Percentage format would display 30%, but General retains 0.3. Incorrect Answers A:Adding cost and sales is unrelated to the cost-to-revenue ratio. C:30 is not the underlying decimal fraction; it is the percent value multiplied by 100. D:300/90 inverts the defined measure.
Question 435 An insurer’s mobile report renders long axis labels too small on portrait phones. The desktop version is already approved and must not change. How can the report author adjust only the phone presentation? Change the semantic model from Import to DirectQuery Increase desktop axis font size and accept that it breaks large-screen layout Open Mobile layout, select the visual, and customize its mobile formatting independently of desktop formatting Hide the entire Date table in the model to shorten labels Explanation Correct Answer C:Mobile visual formatting can diverge from desktop values, allowing a phone-specific legibility fix. Incorrect Answers A:Storage mode determines data querying, not portrait layout typography. B:Changing desktop formatting would violate the approved large-screen design. D:Model field hiding is unrelated to visual label typography and may impair reports.
Question 436 A Power Query model contains a common stage called CleanClaims and a report-ready query named ClaimsSummary that references it. Only ClaimsSummary should appear as a semantic-model table. Which load setting should be changed? Disable load on ClaimsSummary while leaving only the staging table visible Delete CleanClaims before the final query refreshes Duplicate the raw source for every report instead of keeping the reference Disable load for CleanClaims, leaving ClaimsSummary load enabled Explanation Correct Answer D:The cleaned stage remains a query dependency without creating an unnecessary visible table in the model. Incorrect Answers A:The report-ready output would be missing from the model if its load were disabled. B:Deleting the stage breaks a dependent Reference expression. C:Duplicated source logic increases maintenance drift and redundant work.
Question 437 A public weather endpoint is combined with private customer addresses in Power Query. The privacy firewall blocks a query plan that could send private addresses to the public endpoint. What is the correct investigation? Review source privacy levels and the query combination to avoid unsafe private-to-public data movement Apply a green report theme Give all report readers SQL Admin Force all source tables into one public Excel export Explanation Correct Answer A:Power Query privacy isolation guards against transmitting private values to less trusted sources. Incorrect Answers B:Visual styling does not affect the data-combination firewall. C:Reader SQL administration is unrelated and unnecessary. D:A public export of addresses worsens the confidentiality risk.
Question 438 A product dimension contains ProductKey, Category and DisplayName. Business users need search-friendly model fields, while relationships depend on ProductKey. Which presentation change avoids accidental key display? Convert ProductKey into a freeform multiline report description Hide ProductKey from the report field list and document DisplayName as the intended attribute Delete ProductKey and leave the fact without a lookup relationship Duplicate ProductKey into three visible measure fields Explanation Correct Answer B:A hidden key still participates in joins but no longer invites report authors to drag surrogate integers onto visual axes. Incorrect Answers A:A description field is metadata and cannot replace the actual relationship key. C:Removing the key can break the model relationship. D:Duplicating technical keys increases clutter.
Question 439 A water-utility analyst has a visual calculation that ranks treatment sites in one chart. They now want to place that calculated rank field in a slicer across the whole report. What limitation should they recognize? Turning on cross-highlighting converts the local rank into a global semantic field Visual calculations cannot be used as slicer fields; create a proper model field or measure-supported design All visual calculations automatically become columns in the Date dimension The visual rank can be applied as a slicer by changing gateway credentials Explanation Correct Answer B:Visual calculations live only on their chart and cannot serve as reusable slicer fields. The model design must supply the required selection semantics. Incorrect Answers A:Cross-highlighting changes interaction behavior but does not create a slicer-ready model column. C:Visual calculations do not materialize Date-table columns. D:Gateway credentials have no ability to change calculation scope.
Question 440 A report author fixes a chart title in the workspace. The app’s consumers still see the old title even though the semantic model refreshed successfully. What is the missing publication step? Run an unrelated SQL schema migration Grant a consumer database admin Have the authorized app publisher update the app to distribute the report change Change the model’s calendar format only Explanation Correct Answer C:Model refresh updates data, but distributing changed app report content requires an app update. Incorrect Answers A:Schema migration is irrelevant to a report title change. B:Database admin cannot update app content. D:Date formatting does not republish changed report visual titles.
