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.
Question 631 A viewer belongs to both East and West security groups, each mapped to a different RLS role. The owner expected only East rows but the person can see both. What should be investigated? Combined role memberships and their effective allowed rows; resolve overlapping grants to match intended entitlement Rename the West report page Change the Date column to text Disable every relationship so the report shows no data Explanation Correct Answer A:Multiple effective roles can broaden the viewer’s union of authorized records and require explicit role membership governance. Incorrect Answers B:Page names do not change effective model role memberships. C:Text conversion cannot reduce group authorization. D:Deleting relationships is not a controlled repair of membership policy.
Question 632 A mobile games studio loads in-app purchases and Countries keys where the dimension has accidentally duplicated keys after a merge. The relationship still fails even after duplicates are removed because one side stores the key as integer and the other as differently formatted text. What needs alignment? Make all dimensions inactive Add bookmarks for every missing key Normalize key formats and use compatible data types on both columns Turn off every numeric format Explanation Correct Answer C:Compatible normalized keys are necessary for correct value matching across relationship columns. Incorrect Answers A:Inactive relationships would not address key-type mismatch. B:Bookmarks do not modify relational keys. D:Display format cannot fix inconsistent stored key representations.
Question 633 A financial cooperative must export a multi-page, fixed-layout printable statement with repeating headers and precise row breaks. The users change the requirement to slicer-driven analysis and drillthrough rather than fixed printable pages. Which deliverable should be used? Static PDF without interactions Unconnected spreadsheet image Interactive Power BI report with slicers and drillthrough Paginated report optimized only for exact printed page breaks Explanation Correct Answer C:Interactive reports provide dynamic exploration and context-aware drillthrough. Incorrect Answers A:PDF snapshots do not support live model filters. B:Images cannot query the semantic model. D:Paginated layouts prioritize print control over the requested exploratory workflow.
Question 634 The author wants a dataset parameter to choose which SQL database to connect to at refresh time. A manager expects a report slicer to update that connection independently for each viewer. What is the accurate distinction? A Power Query source parameter sets query configuration and refresh behavior; a report slicer filters already available semantic data Every slicer changes the shared query credential and database server for its viewer A data-source parameter is identical to a page bookmark Changing a visual color automatically updates a query parameter Explanation Correct Answer A:Source parameters and viewer report filtering operate at different stages and with different scope. Incorrect Answers B:Slicers normally affect report filter context, not shared credentials and remote database selection. C:Bookmarks restore report state and are not connector settings. D:Visual colors do not alter M parameter values.
Question 635 A reporting table has EmployeeID, LastUpdatedBy, JanHours, FebHours and MarHours. The audit field LastUpdatedBy must remain attached to each employee, while month columns become Month/Hours rows. Which Power Query selection is correct? Unpivot EmployeeID and LastUpdatedBy while retaining months as columns Pivot JanHours and FebHours into employee identifiers Select EmployeeID and LastUpdatedBy, then Unpivot Other Columns Select EmployeeID only and unpivot LastUpdatedBy into hour values Explanation Correct Answer C:Preserving both key and audit metadata prevents string auditor names from being mixed with numerical month values. Incorrect Answers A:Unpivoting stable identifiers destroys required row context. B:Pivot moves in the wrong shape direction. D:Unpivoting LastUpdatedBy would insert people names into the Hours value field.
Question 636 An executive selects two product categories in a slicer. A card uses SELECTEDVALUE(Product[Category], "Multiple/None"). What text should the card display? The alphabetically first selected category A concatenation of both names automatically BLANK in every case because two values are visible Multiple/None, because the selection does not contain exactly one distinct category Explanation Correct Answer D:SELECTEDVALUE uses its alternate result when there are zero or multiple distinct values in context. Incorrect Answers A:SELECTEDVALUE does not choose a first category from multiple selections. B:Concatenation requires a separate expression such as CONCATENATEX. C:An explicit alternate string is supplied for the multi-value situation.
Question 637 An author is using Power Query Online on a SQL Server booking dataset. A new custom M transform caused the query to evaluate more data locally. Before reordering steps, the author needs evidence of the first transformation that stops folding to SQL. Which action identifies it? Stop the scheduled refresh and infer the failing step from the absence of results Change the colors of the report visuals to lower their rendering cost Move all filters after the custom transform without examining the native query Review step-level folding indicators and the query plan, including native-query nodes, around the custom transform Explanation Correct Answer D:Power Query Online exposes folding indicators and a query plan to distinguish delegated SQL work from locally evaluated M operations. Incorrect Answers A:Disabling refresh prevents collecting diagnostic evidence about the folding boundary. B:Report visual styling does not determine which M operations execute on the SQL source. C:Moving filters after a nonfoldable step can increase client-side processing and does not establish the first failing step.
Question 638 A manufacturer has daily output measurements and wants to flag historical days that depart unexpectedly from normal activity, together with relevant explanations. They do not need future output predictions. Which Power BI analytical feature should be tested? A future forecast instead of detecting abnormalities in observed periods A horizontal category bar chart with no time axis A report-page bookmark saved at the most recent date Anomaly detection on a supported time-series line chart Explanation Correct Answer D:Anomaly detection evaluates observed time-series deviations; it addresses surprising historical points rather than extrapolating future periods. Incorrect Answers A:Forecasting is designed for future trends and uncertainty bands, not primarily flagging past anomalous observations. B:A categorical bar view does not provide the required ordered time-series anomaly feature. C:Bookmarks save display state and do not calculate statistical departures.
Question 639 A loan disbursements report author must make an annotation overlay, two descriptive charts, and a menu appear or disappear together in one report state. The author’s layered visual overlay is keyboard-navigable in a confusing order. Which report design setting should be fixed? Change the transaction table data type Only change the grouping of objects in the Selection pane while leaving their Tab order unchanged Turn every numeric measure into text Adjust the supported tab order and visibility of the layered visuals Explanation Correct Answer D:An explicit logical tab order improves keyboard navigation of report elements. Incorrect Answers A:Source type changes do not fix the order of focusable chart objects. B:Grouping visual objects helps authoring but does not automatically correct the order in which keyboard users focus them. C:Text conversions do not establish accessible focus sequence.
Question 640 A retailer’s workspace already has a widely distributed Power BI app. Analysts added a new inventory report and need existing audiences to receive the updated app after the report is included. Which controlled action should the authorized publisher take? Update the existing workspace app, include the report for the appropriate audience, and publish the changes Create a new workspace Admin account for each consumer Change a report bookmark and assume it republishes the app package automatically Delete and recreate the semantic model to force all app readers to receive new pages Explanation Correct Answer A:App updates explicitly publish revised content and audience configuration; report edits alone may not update an existing distributed app. Incorrect Answers B:App consumers do not need administrative identities. C:Bookmarks change report state, not app publication or audience inclusion. D:Deleting a shared semantic model risks breaking dependencies and is unnecessary for distributing a report.
