Question 100 A fact table has three rows with Revenue, Profit: (100,20), (0,0), and (200,100). The expression AVERAGEX(Fact, DIVIDE(Fact[Profit], Fact[Revenue])) uses DIVIDE without an alternate result. What percentage is returned? 23.33%, by treating the blank ratio as numeric zero and dividing by three 50%, by using only the last row and discarding the first 35% 70%, by adding the valid percentages without averaging Explanation Correct Answer C:The ratios are 20%, BLANK (zero denominator), and 50%. AVERAGEX averages the two valid numeric results: (20% + 50%)/2 = 35%. Incorrect Answers A:The zero-denominator result is BLANK, which does not contribute a numeric zero to the average. B:The 20% first-row ratio is also valid and must be included. D:Adding percentages without dividing by the count of valid entries is not an average.
Question 101 A subscription company uses an Import table with eight years of renewals records. Only the latest month changes. Full-refreshing all historic periods nightly takes hours. What approach should it evaluate? Incremental refresh partitions with RangeStart/RangeEnd and an appropriate policy A report page tooltip A second copy of every historical table Disable all refresh permanently Explanation Correct Answer A:Incremental refresh partitions data to refresh recent periods while retaining unchanged historical renewals partitions. Incorrect Answers B:Tooltips affect presentation and do not change refresh partitioning. C:Duplicate history increases data movement rather than reducing it. D:Stopping all refresh would leave the newest records stale.
Question 102 A company appends two monthly ticket files. The newer file contains a Severity field absent in the older file. Analysts must retain all earlier rows without inventing Severity. What behavior should they confirm? Merge the files by randomly generated ticket numbers Append by matching column names, leaving Severity null for historical rows where absent Delete all historical rows with no Severity column Populate every missing Severity with Critical by default Explanation Correct Answer B:Append can combine columns by name and represent missing values as null instead of fabricated classifications. Incorrect Answers A:A random-key merge does not stack month records correctly. C:Discarding history is unnecessary. D:Assuming Critical would distort incident-risk reporting.
Question 103 A food chain wants capable business users to change a chart from a region breakdown to a product breakdown in reading view, without editing or republishing the original report. Which author-enabled experience fits? Personalize visuals with permitted field and type changes Admin role for every report reader Duplicate the whole report for each region Create a new semantic-model table for every individual viewer Explanation Correct Answer A:Personalize visuals allows eligible users to explore alternatives locally while preserving the shared authored report. Incorrect Answers B:Admin access is excessive for consumer-level personalization and gives workspace control. C:Report duplication increases maintenance and is unnecessary for visual-level exploration. D:Per-viewer model duplication is not required for changing chart dimensions interactively.
Question 104 A charity submits enrollment dates in day/month/year format. For example, “04/05/2026” means 4 May, but the analyst’s US-configured desktop reads it as April 5. Which Power Query change preserves the source meaning? Rename the Date column but leave text conversion in the default US locale Convert the text to Whole Number and reconstruct the year from its first four digits Use Change Type > Using Locale with Date and English (United Kingdom), then inspect interpreted day and month Sort the unconverted date strings alphabetically before creating the date table Explanation Correct Answer C:The explicit UK locale interprets day before month, yielding May 4 for 04/05/2026; validation of extracted parts guards against silent inversion. Incorrect Answers A:A column name does not determine how an ambiguous day/month text value is parsed. B:A whole number cannot safely preserve the calendar-day/month structure in this source text. D:Lexical sorting of slash-formatted strings does not convert them to true dates or fix month/day ambiguity.
Question 105 A nonprofit needs managers to receive a snapshot of the donations report in email every Monday without manually opening Power BI. Which service capability is designed for recurring deliveries? Configure a report email subscription with the desired schedule Create a Power Query reference to the report Use a many-to-many model relationship Enable a bookmark to run without a subscription Explanation Correct Answer A:Power BI subscriptions send scheduled report/dashboard content to authorized recipients subject to licensing/settings. Incorrect Answers B:Reference queries reuse data shaping and do not email report snapshots. C:Relationships shape filters, not delivery schedules. D:Bookmarks save report display states but do not send recurring mail.
Question 106 A software vendor deploys RLS roles in a license invoices semantic model and wants to verify that North group members cannot access South rows. What validation should the owner perform? Only inspect the theme colors Disable the model’s relationships while testing Use Test as role and validate the actual group’s effective filter behavior Only confirm that the workspace opens Explanation Correct Answer C:Test as role and an intended-principal review verify the row filter actually limits North access to license invoices. Incorrect Answers A:Formatting offers no evidence of RLS enforcement. B:Deleting relationships may break the filter path and invalidate the very security behavior under test. D:Opening a workspace confirms reachability, not row entitlement correctness.
Question 107 A fiscal year runs July 1 through June 30. Analysts need a cumulative revenue measure for August 2026 that includes July and August but excludes January through June. Which DAX pattern fits? TOTALYTD([Revenue], Date[Date]) with its default calendar year boundary SAMEPERIODLASTYEAR(Date[Date]) alone DISTINCTCOUNT(Date[MonthName]) CALCULATE([Revenue], DATESYTD(Date[Date], "6/30")) under classic date-column time intelligence Explanation Correct Answer D:The June 30 year-end parameter resets the YTD window on July 1 so August includes July and August of the new fiscal year. Incorrect Answers A:Default YTD resets on January 1, not July 1. B:A one-year date shift returns comparative dates rather than a fiscal cumulative window. C:Counting months neither accumulates revenue nor defines a fiscal boundary.
Question 108 A star schema has a unique Customer dimension and an Order fact. An analyst enables bidirectional filtering everywhere to make a customer slicer affect order totals. Which relationship configuration is ordinarily sufficient? Both directions on every relationship regardless of ambiguity Single-direction filtering from Customer (one side) to Order (many side) No relationship between Customer and Order A many-to-many bridge even though Customer keys are unique Explanation Correct Answer B:A one-to-many single-direction relationship already propagates the customer selection to orders. Incorrect Answers A:Bidirectional filters create possible ambiguous paths without benefiting this simple star. C:Disconnected tables would prevent the requested slicer effect. D:A bridge is unnecessary when the dimension has unique customer keys.
Question 109 A Finance report displays January=12, February=18 and March=5 in one line chart. The author needs a running sum displayed in the same visual, but not reusable by other model visuals. Which expression is appropriate? A visual-level conditional-formatting rule without any arithmetic A visual calculation using RUNNINGSUM([Sales]) over the visual categories A calculated column with the same cumulative amount on every fact row A measure that removes all date filters and returns 35 for every month Explanation Correct Answer B:RUNNINGSUM works over the visible visual data, producing 12, 30 and 35 in month order. Incorrect Answers A:Formatting changes appearance but does not calculate month-by-month accumulated values. C:A stored row column cannot naturally track the current visual’s displayed category order. D:An all-dates total would be 35 at every month, not the cumulative sequence.
Question 110 A municipal planning report stores AgeYears as a numeric column for 20,000 residents. The report needs a frequency distribution in 10-year age intervals, not one category per exact age. What feature fits? Create numeric bins for the AgeYears column with a 10-year bin size Use a single Card with the average age Create a relationship from AgeYears to an unrelated monetary fact Convert the age column to freeform month names Explanation Correct Answer A:Power BI can group values in a numeric column into fixed-width bins to display a histogram-like frequency distribution. Incorrect Answers B:An average hides the spread and number of observations in each interval. C:Relationship cardinality does not construct age group boundaries. D:Month-name text cannot preserve numeric age intervals or correct counts.
