Microsoft Certified: Power BI Data Analyst Associate - Full Practice Exam 1

1. A balance fact table stores closing inventory each day. Management wants the month-end balance rather than the sum of daily balances. What kind of calculation is needed?
2. A bookmark should toggle a help panel without resetting users' slicer choices. Which setting is important?
3. A content owner wants to confirm that a regional viewer cannot access other regions after a model update. What is the best verification?
4. A decimal Revenue column contains nulls representing unknown amounts. Finance says unknown is not equivalent to zero. What should you do?
5. A JSON response contains a list of order records, each containing a nested Address record. Which steps expose City as a column?
6. A large SQL source supports query folding. You need only the last twelve months and six columns. Which approach normally reduces transferred data?
7. A manager must see which products contribute most to total profit, ordered from highest to lowest. Which visual best supports comparing many product values?
8. A model needs a proper calendar for classic DAX time intelligence. Which properties should the analyst verify? Select 2 answers.
9. A model refresh fails immediately after a source password rotation. The gateway reports online and network connectivity is unchanged. What should be checked first?
10. A model's [Sales] measure returns 240 for the current product and 1,200 for all products within the selected year. What should DIVIDE([Sales], CALCULATE([Sales], REMOVEFILTERS(Product))) return?
11. A phone layout contains tiny overlapping visuals copied from the desktop canvas. What should the author do?
12. A Power Query solution uses Reference rather than Duplicate for a shared cleaning query. Which statements are correct? Select 2 answers.
13. A product dimension contains a free-text audit note unused by reports, relationships, or security. Why remove it before importing?
14. A report filters Product[Color] to Blue. The measure CALCULATE([Sales], Product[Color] = "Red") is evaluated without KEEPFILTERS. Which color filter applies?
15. A report must query changing SQL data at interaction time rather than store an imported copy. The source supports DirectQuery. Which mode fits?
16. A report needs additional contextual metrics on hover without crowding the main chart. Which feature fits?
17. A report should let users switch an axis between Product, Region, and Channel using one slicer. Which feature is designed for this?
18. A report uses red and green alone to distinguish loss and profit. What improvement best supports users with color-vision differences?
19. A report's margin percentage must change with slicers and be reusable across visuals. Where should the calculation normally live?
20. A sales table has Jan, Feb, and Mar amount columns. Reporting requires Month and Amount columns while preserving CustomerID. What should you do?
21. A scatter chart shows an unusual cluster of high-discount orders with low margin. You need to explore related dimensions without changing the underlying source. Which next step is appropriate?
22. A screen-reader user needs meaningful navigation through a report page. Which actions help? Select 2 answers.
23. A semantic model contains both nonconfidential aggregates and sensitive personal data. What does applying a sensitivity label primarily provide?
24. A service-hosted Import model reads an on-premises SQL server reachable only inside the corporate network. What normally enables scheduled refresh?
25. A slicer selection should affect all pages that contain the same Region slicer. What should the author configure?
26. A staging query feeds three reference queries and should not appear in the semantic model. What should you configure?
27. A star-schema review identifies two valid modeling practices. Which should you retain? Select 2 answers.
28. A transaction table stores one row per second, but all required analysis is daily by product. The model is too large. Which change best reduces its size while preserving requirements?
29. A user selects a customer and needs a separate detail page filtered to that customer. Which feature should you configure?
30. An analyst joins Orders to Customers to retain every order, including orders with missing customer records. Which join should be used with Orders on the left?
31. An executive needs to compare monthly revenue trends for three regions over two years. Which visual is the most direct starting point?
32. An imported date column contains 03/04/2026, meaning 3 April in the source. Desktop interprets it as March 4. Which change fixes interpretation?
33. An RLS role works for a workspace Viewer but an Admin can see all regions. What explains the difference?
34. Consumers need a curated report collection without permission to edit workspace content. Which distribution approach fits?
35. Copilot drafts a narrative describing declining revenue. Which checks should precede distribution? Select 2 answers.
36. Monthly sales arrive as twelve CSV files with identical columns. You need one table containing every month's rows. Which transformation is appropriate?
37. MonthName sorts alphabetically in a chart. Date has MonthName and MonthNumber with a consistent mapping. What should you configure?
38. Orders has OrderDate and ShipDate. A report must slice both roles independently at the same time. Which design is simplest?
39. Performance Analyzer shows 3.8 seconds of DAX query time and 0.1 seconds of visual display time for a sales matrix. What should be investigated first?
40. Regional managers should see only their region through dynamic RLS. A mapping table relates their email to RegionID. Which function commonly identifies the signed-in user's email?
41. Revenue is 125 this year and 100 last year. A KPI should show year-over-year percentage growth. Which displayed result is correct?
42. Sales contains repeated ProductID values; Product contains one row per ProductID. Which relationship usually fits a star schema?
43. Sales rows contain Quantity and UnitPrice. You need total extended revenue across the current filter context. Which measure is correct?
44. Selecting a bar should filter one chart but leave another chart unchanged. Which feature controls this behavior?
45. Several SQL queries must move from test to production together. Which actions support a reusable, working connection design? Select 2 answers.
46. Two customer rows have the same key but different UpdatedAt timestamps. You must retain the latest row deterministically. Which design is safest?
47. Two report teams depend on a shared semantic model. Before deleting a column, what should the model owner inspect?
48. You need customers who have never placed an order. Customers is the left table and Orders is the right table. Which merge kind returns them?
49. You need reusable year-to-date and prior-year transformations applied to many existing measures without duplicating each measure. Which feature fits?
50. You profile a 20-million-row source, but column quality reflects only the first 1,000 rows. How do you inspect quality across the full source?

Comments — 0