Question 40 A national bookstore already has a certified shared Power BI semantic model containing governed measures and relationships for book sales. A new report author must reuse its calculations and security rather than create another model. What is the appropriate starting connection? Rebuild all metrics in disconnected report-level tables Connect the report to the existing published semantic model Create a new Import model from its upstream database Export every table into CSV before report creation Explanation Correct Answer B:A live connection to the certified book sales model reuses its existing DAX definitions, relationships and governed access. Incorrect Answers A:Disconnected duplicated tables defeat the shared measures and filters the report author must preserve. C:A separate imported copy risks diverging metric definitions and is explicitly unnecessary when the certified book sales model exists. D:CSV extraction loses the reused semantic layer and creates a new data-maintenance dependency.
Question 41 A transit data source has repeated event rows for the same TicketID at each Station. The analyst needs total Fare and distinct TicketID count per Station. Power BI Desktop must support the query; what workflow fits? Count every row as a different TicketID even if IDs repeat Append a Stations lookup underneath the fare events Group by Station and compute Sum(Fare) plus an appropriate distinct TicketID aggregate in M, validating repeated ticket rows Create a report bookmark for each TicketID Explanation Correct Answer C:Power Query grouping can provide sums; in Desktop a distinct ticket count can be implemented using an explicit M distinct-count expression over grouped rows. Incorrect Answers A:Row count overstates unique tickets when multiple events share an ID. B:Append stacks records and does not compute the required station summary. D:Bookmarks cannot aggregate source ticket identifiers.
Question 42 A support-case fact has CreatedDate and ResolvedDate. A Power BI page needs independent slicers for when a case was opened and when it was resolved; both date filters must apply without special measure overrides. Which model works? A single Date table related actively to both CreatedDate and ResolvedDate One Date slicer renamed twice while still attached to CreatedDate only Separate Created Date and Resolved Date role-playing dimensions, each related actively to its fact key Remove both date relationships and use text labels Explanation Correct Answer C:Independent date dimensions provide two simultaneously active filter paths that match the fact’s actual date columns. Incorrect Answers A:Two active paths from the same Date table to the same fact are not generally valid in this design. B:Renaming does not create a separate ResolvedDate filter path. D:Disconnected text labels do not filter the event facts automatically.
Question 43 An executive dashboard at a factory group needs a single large label for the current total OutputUnits, with no comparisons or breakdowns on this tile. Which visual meets the focused requirement? Scatter plot with a missing X axis Matrix requiring multiple row groupings Card showing the filtered total measure Stacked column chart with empty categories Explanation Correct Answer C:A card presents one aggregated current OutputUnits measure clearly at a glance. Incorrect Answers A:Scatter charts need paired numeric coordinates, which are absent here. B:A matrix is useful for row-column breakdowns, not a solitary headline metric. D:A stacked chart adds categorical structure the one-value KPI requirement does not have.
Question 44 A meter readings import at an energy utility fails to convert Consumption to Decimal because a small set of rows has the literal "not supplied" instead of a number. Analysts must preserve rows and distinguish genuinely missing amounts from valid zero amounts. What transformation is appropriate? Cast the column to Date and ignore the warning Replace the explicit "not supplied" placeholder with null before converting to Decimal Replace all nonnumeric values with 0 Delete every row with a conversion issue Explanation Correct Answer B:Using null for the 'not supplied' marker preserves the record and does not fabricate a zero-valued Consumption. Incorrect Answers A:A Date type cannot represent the intended numeric Consumption and would not fix its missingness. C:Zero asserts a real measured Consumption; this is false for a record explicitly marked unknown. D:Deleting the record discards other valid fields in meter readings despite a preserve-rows requirement.
Question 45 A subscription company wants a dynamic RLS rule to show a viewer only renewals records whose assigned email matches the viewer’s sign-in identity. Which DAX identity mechanism can support a properly related security table? A bookmarked page title USERPRINCIPALNAME() compared with the authorized email mapping FORMAT() of the metric amount SUM() of all transaction rows Explanation Correct Answer B:USERPRINCIPALNAME() can identify the current principal for a dynamic security mapping used in an RLS expression. Incorrect Answers A:Bookmarks store view state and are not a principal identity source. C:FORMAT changes how values are displayed and supplies no user identity. D:SUM aggregates a numeric column but cannot determine the current viewer.
Question 46 An insurance provider has a complete Date table. For the filtered month of September 2026, [Total ClaimValue] is 139; September 2025 was 96; August 2026 was 160. What does CALCULATE([Total ClaimValue], SAMEPERIODLASTYEAR(DimDate[Date])) evaluate to? 139 160 43 96 Explanation Correct Answer D:SAMEPERIODLASTYEAR shifts the September 2026 date context back one year to September 2025, whose ClaimValue value is 96. Incorrect Answers A:139 is the current September 2026 amount without the one-year time shift. B:160 is the previous month, not the same period one year earlier. C:43 is the year-over-year difference, not the prior-year measure value.
Question 47 A nonprofit shows fiscal month names "Apr", "Aug", "Dec", and "Feb" in alphabetic order. It needs month names to follow calendar order while retaining short labels. What modeling/report setting is appropriate? Sort month names alphabetically descending Remove the Date dimension entirely Sort the month-name column by a numeric month-order column Change the line chart to a donut Explanation Correct Answer C:Sort by column uses month index 1–12 to order month labels chronologically. Incorrect Answers A:Reversing alphabetic order still does not follow calendar chronology. B:Removing the Date table loses time semantics and does not fix month label sort. D:A donut changes visualization type without creating a chronological sort key.
Question 48 An energy utility has a query with ReadingID and Consumption; two downstream transformations must independently start from the same maintained cleaning logic, and edits to shared cleaning steps should flow to both. Which Power Query design fits? Duplicate the base twice and maintain separate independent step histories Export the base to Excel for each report Disable the source query before creating downstream queries Create referencing queries from the shared cleaned base Explanation Correct Answer D:Reference queries inherit updates to the base meter readings query and can add different downstream steps without duplicating upstream cleaning. Incorrect Answers A:Duplicates are independent copies of the applied-step chain, so later base fixes will not automatically propagate. B:External Excel copies introduce redundant storage and do not link to evolving Power Query steps. C:Disabling load can be appropriate for staging, but it does not itself create the needed dependent queries.
Question 49 A transit authority wants an approved, maintained collection of ticket validations reports distributed to hundreds of business users, with different audiences seeing different curated sets. Which Power BI distribution mechanism is suitable? Make every consumer a workspace Admin Send each person a PBIX file each Monday Provide raw database credentials to consumers Publish a Power BI app with configured audiences Explanation Correct Answer D:A Power BI app can package and distribute governed content and tailor access to different audiences. Incorrect Answers A:Workspace Admin overgrants publishing and membership control to ordinary consumers. B:Emailing separate PBIX copies loses centralized updates and administration. C:Source credentials expose unnecessary operational data access and are not a report distribution channel.
Question 50 A sales team needs total invoice amount to respond immediately to product, date, and region slicers. The fact table is named `License Invoices` and contains InvoiceAmount. Which modeling object supplies that total? A calculated column storing the identical company total in every invoice row An M parameter used to supply a single value at data refresh A display folder named InvoiceAmount A measure such as SUM('License Invoices'[InvoiceAmount]) Explanation Correct Answer D:A DAX measure evaluates in the current report filter context, and a quoted table name with spaces is valid DAX syntax. Incorrect Answers A:A precomputed fixed row attribute does not dynamically aggregate selected records. B:Refresh-time query parameters do not recalculate interactively for every report slicer. C:Display folders organize fields; they do not calculate sums.
