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.
Question 51 A government agency wants a detailed report of Amount by both Districts and fiscal quarter, with row-group subtotals and expansion into underlying groups. Which native visual fits this pivot-like requirement? Single-value card Scatter chart with transaction ID on both axes Waterfall chart without categories Matrix visual with rows, columns, and subtotals Explanation Correct Answer D:The matrix displays a two-dimensional Districts × quarter grid, enabling grouping and subtotals. Incorrect Answers A:A card cannot show both category and quarter breakdowns. B:Paired transaction identifiers do not create the requested cross-tabulation. C:A waterfall illustrates contributions to net change rather than a quarter matrix.
Question 52 A hotel operator receives booking snapshots as encrypted CSV files once per day, and no live SQL endpoint or OneLake Delta table exists. The company needs subsecond slicer interaction for those snapshots and accepts daily staleness. What should the analyst deploy? DirectQuery against the CSV as if it were an interactive SQL query endpoint A Direct Lake model without providing supported Fabric Delta tables Load the received data into an Import semantic model and schedule refresh after the daily delivery A live connection to an unrelated semantic model without booking fields Explanation Correct Answer C:Import materializes the snapshot for rapid in-memory reporting and refreshes when the next daily file becomes available. Incorrect Answers A:DirectQuery needs a source and connector that can execute remote interactive queries; a static CSV snapshot is not a SQL endpoint. B:Direct Lake requires appropriate supported lake data, which the scenario explicitly lacks. D:An unrelated existing model cannot substitute for the organization’s booking data.
Question 53 Six ticket validations line amounts are [51, 54, 50, 47, 44, 41]. A measure computes COUNTROWS(FILTER(Fact, Fact[Fare] > 50)). How many rows satisfy this strict greater-than condition? 2 3 1 5 Explanation Correct Answer A:There are 2 values strictly above 50: 51, 54; values equal to or below the cutoff are excluded. Incorrect Answers B:3 would include an amount that is equal to or below the cutoff. C:1 misses one of the above-cutoff rows. D:5 counts too many rows by including values that fail the predicate.
Question 54 A report for a factory group suddenly renders slowly after a new DAX measure is added to one visual. The analyst wants to identify which visual consumes DAX query versus rendering time. Which tool is suitable? Manage relationships Report page bookmarks Power BI Performance Analyzer Power Query Column quality Explanation Correct Answer C:Performance Analyzer records timing per visual, helping separate DAX query cost from visual display overhead. Incorrect Answers A:Relationship editing may affect performance but does not provide the requested timing breakdown. B:Bookmarks restore states without diagnosing the new measure’s execution time. D:Column quality profiles missing/error data but does not time report visuals.
Question 55 A loan disbursements report author must make an annotation overlay, two descriptive charts, and a menu appear or disappear together in one report state. Which pane helps group and layer those visual objects? Power Query applied steps Power BI gateway settings The Date table relationships dialog Selection pane with grouped visual objects Explanation Correct Answer D:The Selection pane controls visibility, layering and grouping of report visuals used in the overlay. Incorrect Answers A:Applied steps operate on source rows and columns, not chart layering. B:A gateway cannot group or hide report objects. C:Date relationships affect filter propagation rather than visual object stacking.
Question 56 An ingestion API writes a batch containing separate LineID values under one BatchID. One retry duplicates each line with the same BatchID, LineID, timestamp and amount. The analyst must remove retry copies without losing legitimate line items that share a batch. Which Power Query cleanup is appropriate? Remove duplicates on BatchID alone Group by BatchID and sum every ingested amount Deduplicate using the true line identity (such as BatchID plus LineID and validated record fields), keeping one copy of each genuine line Add a different random LineID to each retry record Explanation Correct Answer C:Using the complete line-level business key removes retry copies but retains different LineID rows within the same BatchID. Incorrect Answers A:Every legitimate line in the batch would collapse to one row, losing transactions. B:Summing uncorrected retries doubles line amounts instead of removing duplicate writes. D:New surrogate IDs conceal the duplicates and leave their amounts counted twice.
Question 57 A nonprofit wants an analyst to create a new report from its certified donations semantic model, while preventing the analyst from changing the original model definition. What permission is most directly relevant? Full database owner on the underlying operational source Disable all model permissions Build permission on the semantic model, with consumption rights as needed Workspace Admin over the model owner team Explanation Correct Answer C:Build authorizes creating content based on a semantic model without necessarily allowing edits to that shared model. Incorrect Answers A:Database owner rights are not required to author a report over a published semantic model. B:Removing all permissions also prevents report creation. D:Workspace Admin overgrants permissions to manage the entire workspace.
Question 58 A university has a Yes/No student-withdrawal outcome plus attendance frequency, program, and course-load fields. An analyst wants to explore which recorded factors are associated with withdrawal. Which visual should be evaluated, with the limitation that observed associations are not proof of causal interventions? An unfiltered Card showing only the total number of enrolled students The Key Influencers visual with withdrawal as the analyzed outcome and candidate predictors as explanatory fields A static text box listing the course names without modeling the dropout outcome A report-page navigator whose buttons contain no statistical relationships Explanation Correct Answer B:Key Influencers can examine drivers associated with the selected binary outcome; its explanatory patterns need business and sampling scrutiny before causal claims. Incorrect Answers A:A single total does not compare characteristics of students with and without withdrawal. C:Listing names does not measure associations between course load/attendance and the target. D:Navigation controls do not analyze statistical relationships in the underlying rows.
Question 59 A factory group has a finished production records transformation to reuse as a frozen starting point for an experiment. The experiment must not inherit subsequent changes to the original query. Which command meets that independence requirement? Duplicate the finished query Create a reference that stays dependent on the original Append the query to itself Group rows by all columns Explanation Correct Answer A:Duplicate copies the existing applied steps into an independent query that can be changed without inheriting later edits. Incorrect Answers B:Reference creates a dependent query and would continue to reflect changes in the original production records pipeline. C:Appending doubles or stacks records; it does not make an independent transformation definition. D:Grouping changes aggregation and fails to create a maintainable parallel query.
Question 60 Four Zones members have [Total Consumption] values [69, 55, 80, 46] respectively. Using RANKX(ALL(Dim[Zones]), [Total Consumption], , DESC, DENSE), what is the rank of the member with value 69? 4 2 1 3 Explanation Correct Answer B:Descending totals are [80, 69, 55, 46], making 69 position 2. Incorrect Answers A:Rank 4 belongs to the amount 46, not 69. C:Rank 1 belongs to the amount 80, not 69. D:Rank 3 belongs to the amount 55, not 69.
