Question 350 A support center has 75 open tickets at Monday close, then opens 20 and closes 30 on Tuesday. What should Tuesday’s ending backlog be? 125 from adding both day-end and event counts 75 because a prior day-end snapshot never changes 65 open tickets 30 because the last flow is a close count Explanation Correct Answer C:Backlog updates as 75 + 20 new - 30 resolved = 65. Incorrect Answers A:Summing stock with events without accounting for sign double-counts. B:A prior day-end balance changes when tickets open or close. D:A close event count is not the remaining backlog.
Question 351 A hotel analytics QA employee must adjust a report visual and republish that report in the team workspace, but must not publish the official Power BI app or change other users’ access. Which role should an administrator assign? Admin role in the workspace Member role with app publication capabilities Contributor role in the workspace Viewer role in the workspace Explanation Correct Answer C:Contributor permits editing workspace items while withholding the unnecessary app-publishing and workspace-administration privileges. Incorrect Answers A:Admin permits managing users and settings beyond the QA employee’s assignment. B:Member permits broader app management than this limited editing job needs. D:Viewer can consume but cannot edit the hosted report.
Question 352 A Power Query analyst uses parameters for DevServer and ProdServer but proposes a shared plain-text Password parameter committed to a source repository. What should the team do? Parameterize nonsecret endpoint identifiers, but configure secrets through supported secured connection credentials Embed the password in every Applied Step Put the password in the report title for easy updates Make the whole model public to avoid future authentication Explanation Correct Answer A:Query parameters suit configurable server names; source credentials should remain in managed connection authentication. Incorrect Answers B:Embedded secrets can leak through files and change history. C:Report titles make secrets visible to consumers. D:Public access is not a safe substitute for credential management.
Question 353 A data import displays `West` and `West ` as visually identical categories, but the second value ends with the nonbreaking-space character U+00A0 from a webpage. The analyst has confirmed the exact code point. Which remediation most explicitly removes this known character without touching internal normal spaces? Replace valid category labels with sequential row numbers before matching Change the column to Date type using the US locale Replace U+00A0 with an ordinary space and trim the outer padding; then recheck distinct categories Append an extra copy of each region to make the frequency count more consistent Explanation Correct Answer C:Replacing the identified nonbreaking character and trimming the edge prevents visually equivalent labels from fragmenting groupings. Incorrect Answers A:New row numbers cannot identify equal business region labels and introduce unrelated keys. B:The source values are textual categories, not calendar dates. D:Appending duplicates increases the number of rows but leaves the invalid trailing character unresolved.
Question 354 A sales manager wants to identify Products cataloged for sale but absent from all order lines this quarter. Products is the left query; OrderLines is the right query. Which Power Query merge join directly yields those catalog rows? Inner join that keeps only products appearing in order lines Right anti join that returns order lines lacking a catalog product Left anti join from Products to the quarter-filtered OrderLines query Left outer join with all matching fact rows expanded, including active products Explanation Correct Answer C:Left anti returns left-side product rows with no match in the filtered order lines, exactly the unused catalog set. Incorrect Answers A:Inner join returns precisely the products that DO have transactions. B:Right anti detects orphan order rows, which is the inverse business question. D:Left outer preserves all products but retains matches; it would need extra filtering to isolate the unused set.
Question 355 A customer-support model records an event for each case status change. Some cases move between teams. Management needs reports by the team responsible at the moment of each event, even after the case is later reassigned. What model design preserves historical assignment? Store a team-version surrogate key on each event and relate it to the matching effective-dated historical team dimension row. Relate every event only to the case’s current team so historical events are automatically reclassified. Put all team name changes into a free-text report title without a dimension key. Create bidirectional many-to-many joins from each event to every team version with the same display name. Explanation Correct Answer A:The event fact references the applicable team/version identity at the time of activity, preserving point-in-time attribution when teams change. Incorrect Answers B:A current-state join would rewrite history under the latest team assignment and misstate historical service workload. C:A visual title has no referential model relationship and cannot provide event-time grouping. D:Uncontrolled many-to-many paths can multiply facts and do not select the correct effective-dated version for an event.
Question 356 An executive uses a disconnected CategorySelection table. A measure must apply its selected category values to FactSales[Category] without creating a physical relationship. What DAX filter expression is suitable inside CALCULATE? USERELATIONSHIP on two columns without any defined relationship FORMAT(FactSales[Amount], "0") REMOVEFILTERS(FactSales[Category]) TREATAS(VALUES(CategorySelection[Category]), FactSales[Category]) Explanation Correct Answer D:TREATAS can project a set of values from an unrelated table onto a target column filter. Incorrect Answers A:USERELATIONSHIP requires a relationship already present in the model. B:FORMAT produces text and does not transfer slicer filter values. C:REMOVEFILTERS clears category filtering instead of applying the selected categories.
Question 357 A revenue model retrieves records through a SQL-compatible Power Query connector. After applying a text transformation, the author needs to determine whether the current Applied Step still delegates to the source. For this connector, View Native Query is normally available when the step folds. What test helps? Delete all data-source credentials because folding depends only on authentication Open Manage Relationships to see the source SQL statement Increase report page size, which reduces query folding overhead Right-click the step and inspect View Native Query availability or generated SQL to check whether the operation folds Explanation Correct Answer D:For a compatible connector, native-query availability and SQL text provide evidence of delegation for the selected transformation. Incorrect Answers A:Credentials govern access to data and cannot reveal which M transformations are delegated. B:Relationships control model filter paths, not the Power Query native statement produced by a selected M step. C:Canvas dimensions do not affect SQL query folding.
Question 358 A bank investigates branch-level loan size versus approval time. One very large branch has an unusual value, but the current scatter chart aggregates every branch into a single mean point. Which change helps evaluate the outlier? Set a branch-level detail field so each branch forms its own scatter point Show a single overall average card Remove approval time from the plot Replace both measures with a month-name slicer Explanation Correct Answer A:Individual branch points reveal exceptional coordinates that a single aggregated mean conceals. Incorrect Answers B:An overall average hides variation and cannot show the suspect branch. C:With only loan size, the relationship to approval time disappears. D:Month-name categories do not provide the two quantitative dimensions.
Question 359 A league report has Attendance, Revenue, and Merchandising bookmarks that swap layouts on the same page. The author wants a built-in navigation strip that reflects the currently active bookmark automatically. What should be inserted? Replace the navigation with a plain text table listing bookmark names. Add unrelated static buttons with no active-state tracking. Insert a Bookmark navigator configured for the intended group of saved bookmarks. Insert a Page navigator even though the three views are bookmarks on one page. Explanation Correct Answer C:The bookmark navigator builds buttons from bookmark states and supports current-selection indication. Incorrect Answers A:A text table displays labels but does not provide bookmark-aware navigation. B:Separate static buttons can trigger bookmarks, but the built-in navigator tracks the active bookmark for the user. D:Page navigators switch report pages; they do not serve as a bookmark-state selector within one page.
Question 360 An auditor assigned Member on a Power BI workspace also belongs to a narrowly filtered RLS role. Their report shows all cases, not just their assigned district. What explains this? The district slicer must be hidden before RLS works Every semantic-model RLS definition applies equally to workspace Admins Workspace Member has edit permission and is not restricted by RLS like a Viewer; use a true consumption access pattern Report theme settings are overriding security roles Explanation Correct Answer C:Power BI RLS applies to Viewers; Admin, Member, and Contributor workspace roles bypass that model row filter. Incorrect Answers A:Slicer visibility is independent of model authorization. B:Elevated workspace roles are explicitly exempt from the Viewer RLS path. D:Colors cannot alter security roles.
