Question 300 A financial cooperative has DisbursementDate transactions and wants Year-to-Date DAX measures and an unbroken month axis, including months with no transactions. A separate date dimension has one row per day and covers the full analysis period, but model authors need consistent date semantics. What additional date-table configuration should they consider? Use a sparse text MonthName column as the date key Remove missing dates from the calendar to reduce it Mark the appropriate contiguous date column as a date table where required Mark the transaction ID column as the date table Explanation Correct Answer C:A proper date table has a unique contiguous Date column that supports conventional time analysis. Incorrect Answers A:Month text repeats across years and is not a unique contiguous daily key. B:Omitting days prevents complete-period date filtering. D:Transaction IDs are not calendar dates.
Question 301 A transit authority prints ticket inspections by route and depot. Report Builder has a Route parameter and a Depot parameter. Users should see only depots belonging to the selected route before generating the PDF. Which design supports this? Create a Power BI Card for each route and ask the user to print screenshots Use a dashboard bookmark that cannot pass report query parameters Use cascading paginated-report parameters so the Depot available-values dataset is filtered by the chosen Route Give viewers Workspace Admin and let them edit the underlying depot table Explanation Correct Answer C:Cascading parameters narrow later parameter choices based on earlier selections, allowing correct depot-specific report output. Incorrect Answers A:A Card screenshot cannot provide parameterized multipage printed reports. B:Bookmarks restore report visual states and are not a replacement for parameter dependencies in Report Builder. D:Administrator permissions do not establish dependent parameter values and are unnecessary for report execution.
Question 302 A sales model has CustomerID values A, A, B, and BLANK(). What does DISTINCTCOUNT(CustomerID) produce without blank filtering? Three distinct values: A, B, and the blank member Two distinct IDs because BLANK is always ignored Four because duplicated A is counted twice One because only a blank value is counted Explanation Correct Answer A:DISTINCTCOUNT includes one BLANK in its distinct-value result, along with A and B. Incorrect Answers B:Ignoring blanks corresponds to a different counting rule. C:A duplicate A does not add a distinct value. D:The column contains two nonblank IDs as well.
Question 303 A transit authority has ticket validation rows with Station, TicketID, and numeric Fare. The new dashboard needs the mean Fare per station, excluding null fares rather than calculating the sum. Which Group By operation computes the requested field? Group by Station and use Average on numeric Fare Group by Station with Sum on Fare Remove duplicate TicketIDs before averaging without checking repeat rides Pivot Station values into date columns Explanation Correct Answer A:Average computes the arithmetic mean of non-null Fare values within each Station group. Incorrect Answers B:Sum yields aggregate revenue rather than fare per valid record. C:A customer can legitimately have multiple rides; blind deduplication can delete real fares. D:Pivot changes the shape of categories and does not directly compute mean Fare per station.
Question 304 A clinic’s VisitCost CSV includes `120.00`, `N/A`, and `135.00`. Billing staff confirm `N/A` means the amount was not provided, not a free visit. What should Power Query do before converting VisitCost to Decimal? Replace N/A with zero to make the total look complete Drop the entire row, including valid patient metadata Replace only the known `N/A` token with null and convert valid numbers to Decimal Treat the column as a calendar date to bypass conversion errors Explanation Correct Answer C:This keeps both valid cost measurements and the missing-value distinction intact. Incorrect Answers A:A zero asserts a genuinely free visit, contradicting the supplied data meaning. B:Missing one numeric value does not require losing the other fields. D:Date conversion is semantically unrelated to billable amount data.
Question 305 An audit team creates five different report layouts using the same certified semantic model. They must avoid five independent copies of metric calculations. What architecture fits? Copy the entire fact database into every report PBIX Replace measures with static screenshots Build multiple thin reports connected to the governed shared semantic model Create disconnected datasets for each chart Explanation Correct Answer C:Thin reports reuse the same published model and measure logic across different presentations. Incorrect Answers A:Independent fact copies can drift in calculations and refresh state. B:Screenshots cannot recalculate under user filters. D:Disconnected data copies lose central semantic governance.
Question 306 A consultant has both a directly shared report link and membership in a security group assigned to the app audience. The direct link is revoked. What else must be checked to remove effective access? Assume direct-link removal overrides every security group Hide the report home page and keep the grants Remove or review the group-based app/model grants and validate the consultant’s remaining access paths Rename the model to a random string Explanation Correct Answer C:Access can be inherited through app audiences, groups and workspace roles independently of one link. Incorrect Answers A:One revoked grant cannot override a separate group entitlement. B:UI hiding does not revoke underlying access. D:Names are not permission boundaries.
Question 307 A factory supervisor selects Plant 7 on an output chart and wants a detail page filtered to Plant 7. The design already has a plant detail page with a drillthrough filter. Which action uses the selected data context? Use a bookmark that resets all slicers to the developer’s last saved selection Use Drillthrough from the selected Plant data point to the details page Use an ordinary Page navigator and assume it carries the selected Plant filter Use a static URL to the report home page and expect the plant selection to transfer Explanation Correct Answer B:Drillthrough navigates to a detail page and passes the selected Plant filter context, matching the investigative requirement. Incorrect Answers A:A stored bookmark can restore saved filter state rather than the specific plant the user selected. C:Page navigation changes pages but does not inherently pass the selected visual data as drillthrough context. D:A generic URL lacks the required data-point filter payload.
Question 308 A wagon movements DirectQuery model at a freight rail operator takes 25 seconds for each visual. The SQL database is reachable and users require DirectQuery because the data must stay at source. Which investigation should come first? Inspect generated queries, indexes, folding, and source-side query duration Increase the number of bookmark states Hide all report page titles Move every measure into a text formatted calculated column Explanation Correct Answer A:DirectQuery response time depends on SQL queries and source performance; examining wagon movements queries and plans identifies the bottleneck. Incorrect Answers B:Bookmarks do not reduce the duration of source queries. C:Titles affect display but not network/database execution. D:Text-calculated columns can degrade modeling and do not repair an expensive source query.
Question 309 Three contracts report revenue-margin rates of 10%, 30%, and 50% respectively, with different revenue sizes. An analyst intentionally evaluates AVERAGEX(Contracts, Contracts[MarginPct]) across all three contracts. What result is returned? 50%, the maximum single-contract margin 30% An overall revenue-weighted margin, which cannot be determined without each contract’s revenue 90%, the sum of the three percentages Explanation Correct Answer B:AVERAGEX evaluates each contract percentage and computes the unweighted arithmetic mean (10%+30%+50%)/3 = 30%. Incorrect Answers A:The highest contract margin is not representative of the three-row mean. C:AVERAGEX over the stored percent column does not automatically weight by revenue. D:Summing rate values without dividing by the number of rows is not their average.
Question 310 A call-center model contains per-agent daily handling minutes and a service-level percentage. Analysts propose summing both measures into one daily table. Which aggregation decision is defensible? Sum daily percentages across agents as though they were additive hours Sum additive minutes, but recompute the service-level rate from aggregated numerator and denominator counts Take a simple average of all percentages regardless of case volumes Convert both values to text to prevent numeric aggregation Explanation Correct Answer B:Ratios require appropriate weighting or recomputation; additive duration can be summed. Incorrect Answers A:Percentage sums can exceed 100% and misrepresent service-level performance. C:Unweighted means bias the result if agents handled different case counts. D:Text conversion prevents correct numeric analytics and does not define the right grain.
