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.
Question 551 A hotel builds a portrait mobile layout for a bookings report. The phone app correctly shows it, but opening the same report link in a mobile web browser shows the ordinary page layout. What is the most accurate interpretation? The mobile layout was deleted when the report link was copied The report’s Date relationship needs to be changed to Both Mobile-optimized report views are surfaced through the Power BI iOS/Android mobile apps; a browser may continue to show the standard view Creating a mobile layout automatically replaces every version of the desktop page Explanation Correct Answer C:Microsoft documents the optimized phone view for mobile apps, whereas browser viewing retains the standard report layout. Incorrect Answers A:Copying a report link does not remove its separately authored mobile view. B:Relationship cross-filtering has nothing to do with mobile layout selection. D:The desktop report page remains available after creating a mobile-optimized arrangement.
Question 552 After an Azure SQL password rotation, a Power BI refresh fails. A consultant asks for SQL Server administrator privileges for every report reader. Which course follows least privilege? Update the configured connection identity and grant only necessary source and report permissions Give all readers SQL admin accounts Move the source password into a visual tooltip Turn off both data-source and report authentication Explanation Correct Answer A:A managed refresh identity can authenticate the source without disclosing privileged database accounts to viewers. Incorrect Answers B:Database administration far exceeds report consumption rights. C:Tooltips expose secrets rather than protect them. D:Disabling authentication defeats basic access controls.
Question 553 A call center wants a benchmark through its weekly handling-time data at the statistical median of visible weeks, which should change with filters. Which analytic line is appropriate? A constant line hardcoded to an arbitrary 100 A line chart with the value axis hidden A supported Median line using the filtered numeric series A static report bookmark labeled Median Explanation Correct Answer C:A median reference calculates the middle value under the supported visual/filter context. Incorrect Answers A:A constant is not necessarily the observed median. B:Hiding the axis does not compute a distribution statistic. D:Bookmarks do not calculate dynamic central tendency.
Question 554 A project manager has been granted Build on an approved Power BI semantic model and permission to publish a thin report. They are asked to obtain direct SQL administrator credentials as an additional requirement. Is that necessary? Yes; every thin report author requires direct source-database Admin No; the thin report can use the authorized semantic-model connection without granting SQL administration Yes; only model owners may view data in a live-connected report No; anyone with the report URL can bypass both model and item security Explanation Correct Answer B:Build and report access operate at the semantic-model layer; direct SQL administration is unnecessary for normal thin-report authoring. Incorrect Answers A:SQL Admin violates least privilege and is not generally required. C:Authorized report creators can consume the existing model. D:Report URLs do not bypass model and item access checks.
Question 555 An online store’s PurchaseValue column has a small set of conversion errors. Support wants the exact failed source rows and original field values before choosing whether to repair or exclude them. Which Power Query step supports this? Immediately replace every error with zero and delete the original values Delete the entire transaction table because some rows have errors Use Keep Errors on the affected column in a diagnostic query and inspect the failing records Sort the report visuals by color Explanation Correct Answer C:Keep Errors isolates rows with conversion failures so investigators can identify specific invalid source tokens. Incorrect Answers A:Automatic zero replacement obscures which source strings failed and asserts an invented value. B:A few invalid rows do not justify discarding all valid transaction data. D:Report styling cannot diagnose source conversion failures.
Question 556 A published Power BI app uses a model with Region RLS. A team wants to add every regional app reader to the underlying workspace as Contributor “so they can troubleshoot access,” while still expecting RLS to restrict data. What should governance recommend? Make everyone Admin because the model role will always override their workspace permissions Give all readers the Member role and use a page filter as the sole security boundary Keep users on a Viewer/app-consumer access pattern, assign the intended RLS membership, and troubleshoot with role testing instead of elevating them Disable the model RLS role and hide rows in a bookmark Explanation Correct Answer C:Consumers should retain permissions that allow RLS to apply; validating role behavior does not require authoring privileges. Incorrect Answers A:Workspace Admin is exempt from model RLS and far exceeds consumer needs. B:Member is an editor-level role that is not protected by Viewer RLS, and page filtering is not security. D:Bookmarks change user interface state and cannot substitute for semantic-model row security.
Question 557 A claim filings source at an insurance provider has one row for each ClaimID, MetricType and MetricValue. Each identifier/metric pair is unique and contains a monetary MetricValue. The output should retain actual values, not the number of rows. Which pivot Values aggregation is consistent? Change all amounts to Boolean True Use the original MetricValue with a non-count aggregation appropriate to its unique pairs Use Count Rows and discard monetary values Group only by identifier and remove MetricType distinctions Explanation Correct Answer B:Retaining MetricValue gives the intended monetary values under the created metric columns. Incorrect Answers A:Boolean conversion cannot preserve metric amounts. C:Count Rows produces one per pair rather than the currency amount. D:Dropping MetricType merges distinct measures together.
Question 558 A nonprofit reports unrestricted cash at the end of each month. The governing board requests December 31 year-end cash, not total cash receipts. Which aggregation is required? Add all twelve month-end balances to calculate annual cash Retrieve the latest valid cash balance as of December 31, rather than SUM across monthly balances Return the January opening snapshot as the year-end result Use COUNTROWS of transactions as the closing dollar amount Explanation Correct Answer B:A period-end stock balance is identified by the as-of date; monthly stocks cannot be summed as flows. Incorrect Answers A:Monthly sums count the same cash multiple times. C:January is not the final year-end position. D:Transaction count is not a currency balance.
Question 559 A subscription company has one unique row per Plans member and thousands of renewals rows referring to each member by its key. A relationship is created, but totals double after the lookup is expanded. What is the best diagnosis? Disable the transaction-date relationship Create another measure with the same sum Investigate multiple lookup matches per fact key and restore unique dimension membership Increase numeric display precision Explanation Correct Answer C:Repeated dimension matches multiply facts when merged, inflating totals despite unchanged source transactions. Incorrect Answers A:The date relationship does not cause duplicate lookup matches. B:Another SUM repeats the incorrect multiplied fact total. D:Number format cannot fix multiplied rows.
Question 560 A report for a university must show how total Tuition changed month by month over two years, keeping time in chronological order. The analyst now must overlay current and previous year monthly results to see whether the seasonal shape differs. Which arrangement is appropriate? Pie with twenty-four unlabeled segments Scatter without ordered month labels Line chart with separate year series and month axis Single grand-total card Explanation Correct Answer C:Separate year series make month-aligned trends directly comparable. Incorrect Answers A:Pie slices are poor for comparing two chronological trajectories. B:An unordered scatter omits the aligned month sequence. D:A single total hides seasonality across years.
