Question 220 A maintenance table mixes WorkCost values `12.50`, `unknown`, and `18.00`. The numeric rows must remain Decimal and the unresolved value must not become zero. Which preparation is justified? Cast the entire column to text and SUM it as a currency value Convert all rows, including `unknown`, to zero before loading Delete every row with a valid numeric amount Replace the known `unknown` token with null, then validate and convert legitimate amounts to Decimal Explanation Correct Answer D:Targeted missing-token handling retains both valid amounts and a missing marker without inventing cost. Incorrect Answers A:Text aggregation is not a reliable monetary total. B:This fabricates a cost for an unresolved source value. C:That discards the actual observations and keeps the malformed record.
Question 221 A multinational app uses one RLS role to filter Regions through a UserRegion mapping table. What identity-based DAX approach is suitable? Use the browser’s chart title as the viewer login Set Region to a constant East for every employee Grant workspace Admin to all consumers so mapping is unnecessary Filter mapping rows by USERPRINCIPALNAME() matching the authenticated viewer identity Explanation Correct Answer D:USERPRINCIPALNAME supplies the executing user identity used in mapped dynamic RLS rules. Incorrect Answers A:A title is arbitrary display text, not authentication. B:A constant region cannot honor different users’ entitlements. C:Admin roles bypass intended Viewer RLS and overgrant access.
Question 222 A hospital enables Personalize visuals for a published report. A regional employee with RLS can switch fields in a chart but asks to use personalization to reveal all hospital regions. Which explanation is correct? Personalization changes permitted visual fields locally but does not grant access to data hidden by the underlying model security role Selecting a different chart type silently elevates the viewer to workspace Admin Any personalized visualization ignores assigned row-level security rules A user must duplicate the source database before personalizing any visual Explanation Correct Answer A:Personalization is a consumer exploration feature and cannot bypass row restrictions enforced by the semantic model. Incorrect Answers B:Report visuals cannot change workspace security role grants. C:RLS is enforced independently of which eligible fields a reader chooses to display. D:Source duplication is neither required for personalization nor an appropriate access-control workaround.
Question 223 A business unit has negative contribution margin of -18 and revenue of 90. The margin-rate measure DIVIDE([Margin], [Revenue]) is formatted as Percentage. What value should appear? -18%, because the numerator is a currency amount -5%, because the values should be subtracted -20% 20%, because the sign is dropped when formatting as Percentage Explanation Correct Answer C:The ratio is -18/90 = -0.20 and the percentage format displays -20%. The sign reflects the actual loss. Incorrect Answers A:Currency margin -18 is not itself the dimensionless margin rate. B:Subtraction does not compute the numerator/denominator ratio. D:Percentage format does not remove the negative sign.
Question 224 An analyst uses Reference for three downstream fact queries, assuming Power Query will always run the upstream source exactly once regardless of load and refresh context. What is the accurate caution? Reference permanently materializes a single global copy of the source for all queries Reference always eliminates the need for source credentials Reference automatically disables all downstream transformations Reference reuses query logic, but query evaluation/caching may still cause multiple source requests depending on execution Explanation Correct Answer D:Query references express dependency, not a universal guarantee of one physical source read. Incorrect Answers A:Refreshing dependent queries can cause multiple evaluations absent appropriate caching behavior. B:Dependencies still require supported source authentication. C:References can apply their own additional M steps.
Question 225 An analyst clones Date as ShipDate = Date in DAX to create a second role-playing dimension. They assume every description, hierarchy and formatting definition is cloned too. What should they verify? The clone automatically copies every model property and hierarchy A cloned Date table cannot be related to any fact Review and recreate necessary formats, descriptions, and hierarchies on the cloned Date table Cloning a Date table overwrites all original fact dates Explanation Correct Answer C:A DAX clone copies columns/data, but important model metadata properties are not necessarily cloned. Incorrect Answers A:Microsoft notes formatting and hierarchies do not automatically copy. B:Role-playing date clones are intended to form separate fact relationships. D:Cloning a dimension does not modify fact rows.
Question 226 A hospital leadership report must track actual and budgeted patient visit cost each month over two years in the same view, revealing periods where actual cost exceeds plan. Both measures already exist. Which visual configuration is most useful? One Card showing only the latest actual cost One pie chart with 24 slices but no time axis A line chart with Month on a true date axis and both [ActualCost] and [BudgetCost] as series Two geographic maps without any coordinates Explanation Correct Answer C:Two aligned time series let users identify when actual values cross the budget and inspect changes over time. Incorrect Answers A:A single current total hides both the budget comparison and the month-to-month movement. B:A pie chart does not clearly communicate two continuous measures as paired monthly trends. D:Maps require spatial fields and cannot substitute for monthly budget-versus-actual trending.
Question 227 A finance unit builds a thin report connected live to a centrally governed semantic model. The analyst worries that saving the PBIX automatically copies all underlying fact rows. Which statement is accurate? Every live-connected thin report includes a complete independent snapshot of all model tables The report can reference the existing semantic model without importing a second copy of its entire fact dataset Thin reports cannot display measures calculated in the shared model Saving report bookmarks necessarily duplicates the semantic model storage Explanation Correct Answer B:Thin reports reuse measures and data of the published semantic model rather than creating a fresh complete imported model by default. Incorrect Answers A:Live report connection does not require duplicating the model’s fact storage. C:Shared model calculations remain usable to authorized report authors. D:Bookmarks capture report state, not fact-table physical copies.
Question 228 A finance scatter chart plots overdue rate against invoice volume by branch. One point is an extreme overdue outlier; the analyst needs to learn its branch identity and then inspect individual invoices. What report design supports both steps? Show only a total Card without branch points Remove the branch identifier and average everything Sort the Date table alphabetically Use branch-level scatter Details and a drillthrough to an invoice-detail page filtered by selected branch Explanation Correct Answer D:A labeled point reveals the branch, and drillthrough can carry that branch filter to transactions. Incorrect Answers A:A single total hides the outlier. B:Aggregating all branches conceals the exceptional case. C:Date sorting cannot identify branch-level cause.
Question 229 A regional finance office uses a personal-mode gateway installed on one analyst laptop. It now needs shared DirectQuery access and failover. What change is required? Keep personal mode because it supports clustering and DirectQuery by default Use a report bookmark as a SQL tunnel Give every viewer the analyst laptop password Deploy a standard on-premises data gateway with centrally managed connections and suitable high availability Explanation Correct Answer D:Standard gateway supports DirectQuery and clusters; personal mode is limited to single-user Import refresh. Incorrect Answers A:Personal mode lacks required shared DirectQuery and HA features. B:Bookmarks cannot proxy on-premises queries. C:Sharing laptop credentials is insecure and not a managed gateway design.
Question 230 A report connected only to Import-mode data needs second-by-second visual updates from an operational SQL source. The Page refresh formatting card is unavailable. Why? Import-only reports always enable one-second page refresh regardless of connection mode Automatic page refresh normally requires a supported DirectQuery/proxy model rather than an ordinary Import-only model A Page navigator setting hides the refresh card The report has too few bookmarks to enable it Explanation Correct Answer B:Power BI exposes automatic page refresh for supported live-query scenarios, not standard Import-only refresh. Incorrect Answers A:Import mode uses scheduled model refresh rather than live requery of visuals. C:Page navigation is unrelated to connection storage mode. D:Bookmark count does not enable the feature.
