Question 270 A regional manager is a Viewer in a Power BI workspace and has Build permission on an RLS-protected semantic model. They use Analyze in Excel with that model and ask whether Build lets them inspect all regions. What is the correct answer? Yes, because Excel bypasses Power BI semantic-model roles whenever a pivot is used Yes, because Build automatically makes the user Contributor in the source workspace No, because Excel can never connect to Power BI semantic models No; the RLS role still restricts rows for a Viewer with Build when analyzing the semantic model through Excel Explanation Correct Answer D:Microsoft explicitly states that RLS remains enforced for Viewer users who also have Build, including Analyze in Excel. Incorrect Answers A:The consuming tool does not by itself override the semantic-model authorization context. B:Build allows derived analysis but does not silently elevate a Viewer to the Contributor workspace role. C:Analyze in Excel is a supported workflow for eligible users with appropriate model access.
Question 271 Incident response durations are 42, 18, 30, and 55 minutes. The metric uses ascending RANKX and shorter durations are better. What is the place of the 18-minute response? First; it is the smallest duration among the four compared values Fourth because 18 is the smallest value under descending ranking Second because 30 is lower than 18 Third because 42 is the next chronological observation Explanation Correct Answer A:Ascending order ranks the minimum numeric expression as 1. Incorrect Answers B:Fourth would correspond to descending order with these values. C:Thirty exceeds 18 and cannot rank ahead in ascending order. D:Event order is not the configured numeric ranking order.
Question 272 A manager wants a notification when an inventory quantity Card exceeds 1000. The metric appears in a report only, not a dashboard. Which configuration is ordinarily needed? Create a report title called Alert 1000 Place the SQL password in a tooltip Use a matrix relationship as an email trigger Pin a supported KPI/Card/Gauge visual to a dashboard and configure the numeric data alert on that tile Explanation Correct Answer D:Power BI data alerts operate on supported dashboard tiles rather than every report visual directly. Incorrect Answers A:A title cannot monitor numeric threshold changes. B:Credentials do not supply alert evaluation. C:Relationships do not send threshold emails.
Question 273 A charitable grant can belong to three program categories. A bridge maps GrantID to those categories. A report sums GrantAmount by category and then sums category totals, counting the same grant three times. What is the modeling issue? A bridge automatically divides every amount equally without an explicit allocation rule Adding a fourth category makes the total correct Sort category names alphabetically to avoid multiple counting Multi-category membership alone does not assign fractional amount allocation; define business-approved allocation weights or use a deduplicated reporting measure Explanation Correct Answer D:Without a business allocation, aggregating overlapping category subtotals double-counts the shared fact. Incorrect Answers A:Bridge keys describe relationships, not how money should be allocated. B:More categories increase potential overlap. C:Sorting changes order rather than the arithmetic.
Question 274 A retail matrix displays Store rows nested beneath Region and ProductFamily columns. Managers want to hide repeated Region subtotals but still see each Store and final totals. Which formatting approach should be used? Remove every Store row from the underlying model Replace all ProductFamily values with a static text label Change the report page background to match subtotal font color Adjust Matrix Row subtotals settings for the relevant hierarchy level Explanation Correct Answer D:Matrix formatting can control row subtotal display independently of detail rows. Incorrect Answers A:Dropping stores would eliminate detail instead of changing subtotal presentation. B:A static label destroys the intended product breakdown. C:Hiding text by color is not a sound subtotal control or accessibility practice.
Question 275 A brand’s analyst connects to a governed Power BI sales-returns semantic model. The report now needs a local promotional-budget table in addition to the remote model’s calculations. The analyst has appropriate Build access and must not copy all the governed model’s tables into a separate Import copy. Which supported design should be evaluated? Export the entire governed model to CSV and rebuild every measure from scratch Add a local model and create a composite model with a DirectQuery connection to the shared semantic model plus the permitted local table Use ordinary live connection alone while assuming it permits unrelated local tables without a local model Append the promotional-budget rows directly to the sales-return transaction fact in the source model without controlling permissions Explanation Correct Answer B:Power BI supports adding a local model to a live semantic-model connection, enabling composite extensions while the governed model remains a remote source. Validate supported RLS and cross-source relationship limits. Incorrect Answers A:A CSV fork discards the shared semantic layer and risks diverging definitions. C:A pure live-connected report has no local model; extending it with local data requires creating one. D:A source-model mutation is not the requested report-local extension and can disrupt fact grain and governance.
Question 276 A hotel operator receives January and February bookings extracts with exactly the same columns (BookingID, StayDate, RoomRevenue). A later extract lacks an optional DiscountCode column that exists in the earlier file, but both months must be kept. How does a normal schema-aligned append represent that optional field for later rows? Duplicate the earlier rows to fill the missing field Append the records, with null for absent DiscountCode values Drop the entire later extract Use an inner merge on the transaction ID Explanation Correct Answer B:Append preserves the later rows and supplies null for the column missing from that source. Incorrect Answers A:Duplicating January creates false records rather than recording absent discounts. C:Discarding the file violates the include-both-months requirement. D:An inner merge would combine matching identifiers horizontally instead of stacking periods.
Question 277 An insurer reports claims reserve balances of 800, 760, and 720 thousand at three successive quarter-month ends. Paid claims during those months are recorded separately. Which treatment is correct for the quarter-end reserve measure? Sum reserve snapshots to 2,280 thousand Use the closing reserve snapshot of 720 thousand, while paid-claims flows can be summed over the months Treat the last reserve as a monthly payment and add it three times Show the first reserve as the year-end figure without checking dates Explanation Correct Answer B:A reserve balance is a stock; cashflow payments are additive transactions over a period. Incorrect Answers A:Summing repeated reserve stocks inflates the closing liability. C:A closing stock is not a repeated monthly flow. D:The first snapshot does not represent the quarter-ending balance.
Question 278 An insurer displays text labels "Nov 2025", "Dec 2025", "Jan 2026", and "Feb 2026" on a trend chart. Alphabetical sorting breaks chronological order. The date table already contains Year and MonthNumber. What model change is most reliable? Sort the text labels descending by alphabet Use the maximum monthly claim value as the sort key Create a unique YearMonthSort = Year * 100 + MonthNumber and sort the YearMonthLabel by it Sort only by MonthNumber, which repeats each January across all years Explanation Correct Answer C:A year-month integer orders months across years and provides a deterministic unique mapping for each displayed YearMonthLabel. Incorrect Answers A:Text order places similar month words together regardless of year and is not a time sequence. B:Sorting by claim magnitude changes the order as values fluctuate and destroys the chronology. D:MonthNumber is only 1–12 and cannot distinguish January 2025 from January 2026.
Question 279 A retailer plots each branch as one scatter point with gross margin on the x-axis and footfall on the y-axis. The legend currently shows a predetermined branch type, but managers want groups formed from similarity in these two performance measures. What should the analyst use? Add a constant horizontal target and treat every branch above it as the same multivariate cluster. Show only the company-wide mean for both measures instead of any branch points. Use clustering on the numeric scatter observations rather than using the predefined branch-type legend as the grouping rule. Rename the chart to “Clusters” without changing any point classification. Explanation Correct Answer C:Clustering groups observations based on their numeric positions, which is distinct from coloring existing business categories. Incorrect Answers A:A threshold on one metric divides points by a predefined rule; it does not discover similarity across two dimensions. B:An overall average obscures variation and cannot detect groups of individual branches. D:Changing a chart title does not perform any analytical grouping of its points.
Question 280 A company merges annual contracts from two systems. One produces “2026-07-31” and the other “31/07/2026”. Both represent 31 July, but a single unqualified text-to-date conversion creates errors in one subset. What preparation is safest? Identify the source format for each feed, convert each to an actual Date using explicit parsing rules, and append typed rows only after validation Convert both sets to Whole Number and drop the delimiter characters Treat every month/day/year string as a day/month/year date regardless of its originating source Concatenate the two raw text fields and let report consumers interpret the joined string Explanation Correct Answer A:Source-aware parsing handles both representations without changing their underlying calendar day and yields one consistent Date type in the combined table. Incorrect Answers B:Removing separators does not resolve which components are day and month or create Date semantics. C:Assuming a universal format risks silently reversing dates for ambiguous source entries. D:Text concatenation preserves neither typed date filtering nor a comparable date dimension.
