Question 170 A grid operator considers rolling minute readings into daily totals to shrink its model. Compliance must still identify a 30-minute voltage spike. What constraint should govern the change? Discard the original timestamps because daily totals always identify half-hour peaks Sum the daily values twice to mimic the missing variation Replace the time field with day-of-week text and assume the spike remains recoverable Retain access to an intraday detail grain for spike investigations even if daily aggregate tables serve general dashboards Explanation Correct Answer D:Daily aggregates lose the temporal information needed to identify a short spike unless fine-grain data is kept elsewhere. Incorrect Answers A:Summation removes the within-day shape and cannot locate the specific interval. B:Double-counting aggregates does not reconstruct the true minute observations. C:Day names have less precision than dates/times and cannot identify a 30-minute episode.
Question 171 An order-fulfillment report groups a title, overlay, and bar chart in the Selection pane. After grouping, keyboard users reach a decorative overlay before the first useful chart. What must the author check in addition to visual grouping? Change the source data types of all monetary fields to Text Create a bidirectional Many-to-Many relationship among the grouped visuals Delete keyboard focus support from the report canvas entirely Set an intentional Tab order in the Selection pane and remove decorative items from the navigation sequence when appropriate Explanation Correct Answer D:Grouping and stacking are different from Tab order; the author must set a logical focus sequence and skip noninteractive decoration. Incorrect Answers A:Source field types do not control keyboard focus order of objects in a report. B:Relationships model data rather than the accessibility traversal of visual objects. C:Removing accessibility navigation would make the report unusable for keyboard users.
Question 172 A clinic dimension records multiple historical address versions for the same business ClinicID, each with nonoverlapping effective dates. Appointments must report the address active on the visit date. Why should the fact use a version-specific surrogate clinic key rather than relate directly to repeated ClinicID? Use a distinct ClinicVersionKey on the fact resolving to the correct effective-dated clinic dimension row for each appointment Force a one-to-many relationship on duplicated ClinicID despite multiple historical versions Delete the older address versions and reassign all past visits to the newest address Treat the clinic name string as globally unique even after address changes Explanation Correct Answer A:A type-2 dimension permits several rows for one business ClinicID; a unique version key maps each historical appointment to the appropriate time-valid record. Incorrect Answers B:Duplicated business keys cannot be the unique one-side key in the intended relationship. C:Deleting versions misattributes historical appointments to present-day locations. D:Names are mutable and do not distinguish valid time-specific history rows.
Question 173 A budget started at $120K, increased by $35K in renewals, and decreased by $20K in cancellations. The CFO wants a visual explaining how the opening position became the closing $135K. What is the appropriate layout? Waterfall with starting total, positive and negative contributors, and ending total A scatter plot of customer age against store latitude A single Card showing only 135K and no bridge A pie chart treating the negative cancellation amount as a positive slice Explanation Correct Answer A:A waterfall bridge preserves the signed contributions between opening and closing totals. Incorrect Answers B:Unrelated numeric axes do not explain the financial bridge. C:The ending balance alone conceals the two opposing changes. D:Negative movement should not be represented as an ordinary positive part of a whole.
Question 174 A warehouse author has a Power Query staging table that standardizes Region IDs. Two loaded output tables reference it. The staging table should not consume a separate model table slot. What should be configured? Delete the staging query, breaking dependent references Disable Enable load on the staging query while preserving the references from the loaded outputs Enable load for every temporary transformation Replace the staging data with a report bookmark Explanation Correct Answer B:A nonloaded staging query can still supply transformations for downstream loaded tables. Incorrect Answers A:Deleting the referenced stage breaks dependent queries. C:Loading every intermediate stage adds unnecessary model objects. D:Bookmarks are UI state rather than ETL staging.
Question 175 A catering company has prepared a workspace report and needs a responsible author to publish the official Power BI app to approved audiences. The person may edit the report but must not remove workspace users or delete the workspace. Which role normally provides app publication capability? An external consumer with only an app audience assignment Viewer in the workspace Member in the workspace, without granting unnecessary Admin rights A report subscription recipient with no workspace editing rights Explanation Correct Answer C:Members are permitted to publish and manage workspace apps without the full access-removal and workspace-deletion powers of Admins. Incorrect Answers A:App audience membership allows report consumption; it does not authorize app publication. B:Viewers can interact with content but cannot publish workspace apps. D:Email subscriptions distribute notifications and do not provide the authoring role needed to publish an app.
Question 176 An operations chart has a sudden throughput drop on April 14. Leadership wants to flag unusual observed points with an explanation, not predict future values. Which analysis feature fits? Anomaly detection on a supported line-series visual Forecasting future values with no outlier annotation A page bookmark hiding the date axis A scatter cluster of unrelated warehouse locations Explanation Correct Answer A:Anomaly detection identifies deviations in the observed time series and supports explanation of candidate drivers. Incorrect Answers B:A forecast estimates future observations and does not replace retrospective detection. C:Hiding the date axis removes the event context. D:Spatial clustering is unrelated to anomalies in throughput over time.
Question 177 A company’s financial year ends March 31. For April 2026 its monthly sales are 40, while January–March 2026 totaled 300. A fiscal year-to-date calculation uses year_end_date="3/31". What is the April result? 40, because a new fiscal YTD window began on April 1 340, adding January through April despite the fiscal reset 300, because April is not part of the prior fiscal year BLANK because April cannot be a fiscal month Explanation Correct Answer A:The year-end argument closes the previous fiscal period on March 31; April starts a new accumulation. Incorrect Answers B:The old fiscal period is excluded when the YTD period resets in April. C:April begins the new year and must contribute its 40 units. D:Any valid calendar month can begin a fiscal year with a configured year-end date.
Question 178 A certified organizational semantic model appears in the discovery hub. A contractor can see its description but cannot create a report from it. What should the team check? Assume the Certified badge automatically grants all users edit rights Whether the contractor has Build permission and the necessary licensing/connection rights, independent of certification Change its badge to Promoted to override access control Increase its refresh frequency until Build becomes available Explanation Correct Answer B:An endorsement signals trusted content; it does not substitute for model access and Build rights. Incorrect Answers A:Certification is not an authorization grant. C:Promotion is a discovery signal and does not elevate permissions. D:Refresh freshness and model author permissions are separate concerns.
Question 179 An e-commerce catalog has product labels ` Home Theater ` and `Home Theater`. The two words must remain separated by one internal space, and only padding at the edges is erroneous. Which transformation should be applied? Trim leading and trailing whitespace on the product label without removing internal word separators Remove all spaces, changing Home Theater into HomeTheater Split every label into separate table rows at each space Convert the product name into an integer key by type change Explanation Correct Answer A:Trimming the edges normalizes padding while retaining the meaningful separator between Home and Theater. Incorrect Answers B:Removing all spaces changes the actual product name, which is not the stated defect. C:Expanding words into rows would change the table grain instead of cleaning categorical padding. D:A text label cannot be made into a numeric business key by changing data type.
Question 180 A returns table must join a lookup on CountryCode plus StoreID because StoreID repeats in multiple countries. The Merge dialog currently matches CountryCode to StoreID and vice versa. What should the author correct? Merge on StoreID alone even though it repeats across countries Append the lookup table to the returns table Select both join keys in the same matching order on the two tables, then validate lookup uniqueness Convert both identifiers into dates and join by nearest month Explanation Correct Answer C:Power Query multi-column merge matches selected key positions in order; mismatched pairing yields wrong join results. Incorrect Answers A:StoreID alone can match the wrong country and duplicate facts. B:Appending cannot enrich a transaction with its matched store. D:Date conversion destroys business-key meaning.
