Question 200 An AI-assisted Power BI page draft shows a chart titled Freight Revenue but plots CargoTons, even though the approved revenue measure is available. What is the author’s obligation? Assume the correct chart title guarantees its numeric axis Turn off RLS to encourage Copilot to select a different value Publish without review because the model has a Certified badge Correct the selected measure and reconcile displayed revenue with approved sample calculations before publishing Explanation Correct Answer D:AI-assisted report drafting can choose semantically wrong fields and requires author validation. Incorrect Answers A:Text labels do not prove which measure is bound. B:RLS controls data access, not visual measure selection. C:Model endorsement does not validate every generated visual.
Question 201 A retailer ranks store profit figures 400, 350, 350, and 300 using descending RANKX with ties="Skip". What rank is returned for the store earning 300? 3 2 5 4 Explanation Correct Answer D:Skip counts both stores tied at rank 2 and assigns the next lower store rank 4. Incorrect Answers A:Rank 3 would be Dense behavior, which is not the configured tie rule. B:The two 350 stores take rank 2; the 300 store follows them. C:There are only four stores and the last position is fourth, not fifth.
Question 202 A video-streaming report has a carefully designed desktop page and a simplified portrait mobile layout. A business user rotates their phone from portrait to landscape in the Power BI mobile app. What behavior should the author anticipate? Landscape orientation permanently deletes the report’s mobile layout definition The phone orientation changes the underlying DAX relationships used in the report The mobile app may display the portrait-optimized layout while upright and the regular report page when the phone is turned sideways Power BI mobile reports have no concept of alternative page layouts Explanation Correct Answer C:Power BI supports mobile-optimized portrait pages while allowing users to view the standard desktop page in landscape orientation. Incorrect Answers A:Rotation is a display choice and does not delete the authored mobile layout. B:Orientation cannot change semantic-model relationships or DAX definitions. D:A mobile layout can be separately authored for individual report pages.
Question 203 A delivery team uses DirectQuery to SQL and expects a Power BI dashboard tile to change the instant a database row is updated. The report itself shows a newer value after users refresh. What explains the tile difference? DirectQuery dashboard tiles can reflect their last scheduled tile refresh even though report queries can requery SQL on interaction DirectQuery dashboards always use the same in-memory Import snapshot until the model is republished All dashboard tiles are live streaming feeds that push each SQL row change A workspace Viewer role permanently disables SQL queries for that user Explanation Correct Answer A:Dashboard tile caching and its refresh schedule are distinct from the query timing of a DirectQuery report visual. Incorrect Answers B:DirectQuery is not a full Import cache and query behavior is not tied solely to model republishing. C:Ordinary DirectQuery dashboard tiles are not automatically event-driven streaming displays of each database update. D:Viewer permissions alone do not imply that a permitted report stops executing queries.
Question 204 A source Amount field has 65 rows: 51 valid numeric, 10 null, and 4 conversion errors. Management wants the fraction that produces errors rather than the fraction that is empty. Which measure is relevant? 10 ÷ 65, approximately 15.4% 14 ÷ 65, approximately 21.5% 4 ÷ 65, approximately 6.2%, representing conversion errors 51 ÷ 65, approximately 78.5% Explanation Correct Answer C:Column quality distinguishes errors from empty values; four error rows out of 65 give about 6.2%. Incorrect Answers A:That is the empty/null proportion, not the error proportion. B:Combining nulls and errors answers overall nonvalid share rather than errors only. D:That describes valid rows rather than conversion errors.
Question 205 Operations staff need dispatch and financial reports; external distributors should see only delivery KPIs. Both groups use one Power BI app from a shared workspace. Which design meets these different distribution needs? Make all distributors workspace Admins Configure separate app audiences and assign the appropriate reports and users to each audience Publish every report to one unrestricted audience and tell distributors to ignore finance pages Hide finance pages inside the report and treat page hiding as data security Explanation Correct Answer B:App audiences provide tailored content navigation and distribution for different consumer groups. Incorrect Answers A:Admin privileges overgrant authoring and access. C:A single broad audience does not enforce the desired content separation. D:Hidden pages are not a substitute for audience and model access permissions.
Question 206 A hospital user was granted Contributor to edit a workspace report but also belongs to a restrictive RLS role. The user sees all patient rows in the workspace model. What is the likely reason? Model RLS can always override a Contributor editing role Hiding PatientID in the Fields pane is required to activate RLS Contributor is a workspace editing role and is not RLS-constrained the way Viewer is A report theme disables role filters Explanation Correct Answer C:RLS applies to Viewer consumers; people with model edit rights are not restricted by the same role filter. Incorrect Answers A:Elevated workspace permissions intentionally bypass Viewer RLS behavior. B:Hiding fields does not determine role enforcement. D:Themes have no access-control semantics.
Question 207 A machine table has DeviceID, MetricType, Reading, with multiple readings per metric. Operations wants the highest observed temperature and vibration by device, not the sums. Which pivot aggregation is appropriate? Use Sum of Reading because every metric must be additive Pivot MetricType with Max of Reading grouped by DeviceID Pivot DeviceID into one numeric value without metric types Drop duplicate readings arbitrarily before taking the maximum Explanation Correct Answer B:Maximum retains the highest observation per device/metric while creating metric-specific columns. Incorrect Answers A:Summing sensor snapshots produces a different and often meaningless metric. C:Pivoting DeviceID as a value loses the measurement categories. D:Discarding rows before Max risks dropping the actual peak.
Question 208 An e-learning company has active subscriber counts 4,100 at January end, 4,300 at February end, and 4,050 at March end. It needs its March 31 active subscriber figure. What should the DAX calculation represent? 4,050 active subscribers at the latest snapshot date in March 12,450 by adding monthly active counts 4,150 by averaging all months and calling it current 4,100 because January is the first available month Explanation Correct Answer A:Active subscribers is a stock measured as-of a date, so the March snapshot is the current value. Incorrect Answers B:Adding snapshots counts the same subscribers in multiple months. C:Average active count is not the March closing population. D:January is not the requested as-of date.
Question 209 A custom Date dimension contains every date in 2026 except February 3 and also contains a BLANK date row. Power BI rejects Mark as date table. What needs correction? Build a continuous, unique nonblank daily date column spanning the intended full-year range Increase report bookmark count Add a duplicate row for February 2 instead of the missing date Sort text MonthName alphabetically Explanation Correct Answer A:Marked date validation checks for gaps, blanks, duplicates, and valid dates. Incorrect Answers B:Bookmarks do not repair a broken calendar sequence. C:A duplicated existing day worsens the uniqueness problem. D:Alphabetical month labels do not create missing calendar dates.
Question 210 A report must color defects per batch: green below 2%, amber from 2% through 5%, and red above 5%. What formatting mechanism implements this clearly? Conditional-format rules with explicit numeric range boundaries for the measure A single unconditional background color for every row Changing every defect percentage to text labels and sorting by name A random fill color determined by visual rendering order Explanation Correct Answer A:Threshold rules map each rate into the declared bands without changing the measure itself. Incorrect Answers B:A uniform fill cannot show three performance categories. C:Text conversion is unnecessary and can break numeric boundary comparisons. D:Random formatting is not aligned with approved defect criteria.
