Question 470 A cost file has Department, Month, and Amount rows. Several Department–Month pairs appear more than once because they represent separate valid expenses. The analyst must produce one column per month and sum all legitimate amounts. What is required when pivoting? Pivot and choose Do Not Aggregate even though there are repeated Department–Month pairs Remove duplicate Department–Month rows, losing valid expenses Unpivot Department identifiers into numeric Amount cells Pivot the Month column with Sum as the aggregation of Amount Explanation Correct Answer D:Sum makes each Department–Month output cell the total of its valid source rows; pivoting without aggregation cannot resolve duplicate intersections. Incorrect Answers A:Do Not Aggregate requires a unique pair and fails or loses information for repeated combinations. B:Deduplication would delete genuine expense transactions. C:Unpivot changes the orientation of columns and does not create monthly totals.
Question 471 An ingest folder contains monthly CSVs plus a temporary lock file and a README. The Combine Files step errors when it tries to parse the non-CSV files. What should be changed? Convert the whole directory into a single report chart Give every report reader filesystem administrator rights Filter the Folder connector listing to the approved extension/name pattern before invoking Combine Files Replace the CSV Amount column with text month names Explanation Correct Answer C:Filtering the file inventory prevents unrelated file formats from passing into the sample transformation. Incorrect Answers A:A visualization cannot selectively exclude source file formats. B:Reader administration is unrelated to ETL file discovery. D:Data value conversion does not prevent parsing the README as a CSV.
Question 472 An incident fact table has five rows, but one CaseID is missing. Management wants the total number of recorded events, not the number of populated CaseID values. What DAX measure is appropriate? COUNT(Incidents[CaseID]) as the required event count DISTINCTCOUNT(Incidents[CaseID]) as the row count COUNTROWS(Incidents) SUM(Incidents[CaseID]) over textual IDs Explanation Correct Answer C:COUNTROWS counts all five fact records, including the one whose ID is missing. Incorrect Answers A:COUNT on the ID skips blank entries and can undercount events. B:DISTINCTCOUNT counts identifiers, not necessarily total records. D:Text identifiers are not summable quantities.
Question 473 An analyst records a slow Power BI report. Performance Analyzer shows DAX query 40 ms, visual display 4,500 ms, and other operations 30 ms. What should be investigated first? The visual design, rendering complexity or custom-visual processing rather than the source query Add indexes to the warehouse because the query must be slow Increase the frequency of scheduled Import refresh Move all data to DirectQuery to solve display rendering Explanation Correct Answer A:The measured delay is in visual display, not the DAX query. Addressing render complexity targets the actual bottleneck. Incorrect Answers B:The DAX query takes only 40 ms, so indexing is unlikely to remove the 4,500 ms visual delay. C:Scheduled refresh affects data freshness, not the current visual paint duration. D:DirectQuery changes how data is fetched and could add network latency without fixing expensive visual rendering.
Question 474 A report author uses the Selection pane to hide the Monthly Trend visual, but the existing Summary bookmark still restores the old visible layout. The bookmark name and intended filtering behavior must stay the same. What should the author do? Activate the old Summary bookmark without modifying its captured state. Change source credentials to force the saved bookmark to update. Set the intended visual visibility and select Update on the Summary bookmark while preserving its required display/data settings. Delete the NetSales measure used by the chart to prevent it from rendering. Explanation Correct Answer C:Updating an existing bookmark re-records the supported report state after visibility changes, retaining the same bookmark identity. Incorrect Answers A:Activating an existing bookmark reapplies the old captured settings without writing the author’s revised visibility. B:Credential changes affect source authentication, not the stored state of report visuals. D:Deleting a model measure can break other visuals and is not a way to save the intended layout.
Question 475 A report owner needs to publish an initial Power BI app for departmental viewers, selecting its audiences and granting access. The person does not need to remove workspace users. Which workspace role can perform this by default? Only a tenant-wide Fabric administrator, never a workspace role Member (or Admin), with app publishing and audience permission capabilities Contributor with no special delegation, which cannot initially publish an app Viewer, which can only consume authorized content Explanation Correct Answer B:Members can publish and manage the workspace app and its audience permissions; Admins can as well. Incorrect Answers A:Publishing a workspace app is not restricted solely to tenant administrators. C:Contributors cannot publish a new app or manage who can edit it, even where app updates can be delegated. D:Viewer has no app publishing capability.
Question 476 A sales semantic model links Region to Store and Sales. A developer enables Both on several relationships, creating two active ways for a Region selection to reach Sales. Totals now depend on unexpected propagation. What is the first structural correction? Increase the number of date tables until the ambiguity disappears Review the filter paths and keep only the required unambiguous direction, normally dimensions filtering fact Make all remaining relationships bidirectional so every path has equal weight Change all monetary fact fields to text Explanation Correct Answer B:A deliberate star-schema path avoids competing routes for the same filter and improves predictability and performance. Incorrect Answers A:Unrelated date tables cannot resolve a duplicate Region-to-fact path. C:More bidirectional edges can create additional ambiguous paths. D:Text conversion damages measures without addressing filter propagation.
Question 477 A logistics map shows multiple depots named Springfield. Geocoding sends some markers to the wrong country. What is the appropriate data preparation? Remove all geographic information except the word Springfield Add country/region or explicit coordinate fields so names have unambiguous geographic context Sort depot names by freight amount and assume location follows order Replace location with an unrelated category index Explanation Correct Answer B:Additional administrative geography or trusted coordinates disambiguate repeated place names. Incorrect Answers A:A lone common place name maps to multiple locations. C:Sorting by measure does not identify geography. D:Arbitrary category numbers are not map coordinates.
Question 478 An education analyst has tuition-payment rows labeled Subject, EnrollmentID, and NetFee. Management wants average NetFee for each subject, excluding null amounts and retaining valid repeated enrollments. Which operation fits? Group by Subject and take Average of NetFee Group by Subject and take Sum of NetFee Remove every repeated Subject row before calculation Append the Subject lookup underneath the payments table Explanation Correct Answer A:Average yields a mean of non-null payment amounts in each Subject group, preserving valid multiple records. Incorrect Answers B:Sum answers total revenue, not a per-enrollment mean. C:Removing every repeated Subject would eliminate legitimate enrollments and bias the calculation. D:Appending lookup records makes mixed-grain rows rather than a subject summary.
Question 479 A finance analyst finds RANKX intermittently ranks two apparently equal cost ratios differently because their Decimal Number calculations differ in the last binary digits. Which corrective approach directly addresses numeric precision? Convert the cost ratios to a report page title Turn on bidirectional filtering for unrelated dimensions Replace descending order with ascending order and keep unrounded floats Round the compared expression to an appropriate business precision or use Fixed Decimal Number Explanation Correct Answer D:Microsoft warns binary floating precision can alter equality comparisons; rounding or fixed decimal makes ties intentional. Incorrect Answers A:A title has no effect on the numeric expression being compared. B:Relationship direction does not normalize floating-point representations. C:Reversing order does not remove tiny differences that break apparent ties.
Question 480 An operations source contains valid 0 downtime values plus empty strings meaning the sensor did not report. Reports need to distinguish operational zero from missing measurements. What transform is appropriate? Map the empty markers to null, retain real zeros, and type the measured field numerically Replace missing markers with 0 without tracking missingness Replace every real zero with null and mark production offline Convert the downtime column to month-name text Explanation Correct Answer A:Null distinguishes unobserved values from a genuine recorded zero and permits correct completeness calculations. Incorrect Answers B:Zero imputation can hide device reporting failures. C:A true zero downtime is valid business evidence and should remain. D:Month names do not represent downtime magnitude.
