DA0-002 practice question 22 of 25
[Visualization and Reporting]A manager wants to use the information in a recurring report on incomplete timesheets for the prior month to guide…
Full set: 111 questions[Visualization and Reporting]
A manager wants to use the information in a recurring report on incomplete timesheets for the prior month to guide employee outreach. Which of the following report types is the best for this task?
A snapshot report is the most appropriate choice because it captures the state of data for a specific, completed period—in this case, the "prior month." This creates a static, historical record that is perfect for a recurring review. The manager needs a definitive list of employees with incomplete timesheets as of the end of the last month to perform outreach. A snapshot report provides this exact point-in-time, unchangeable list, ensuring that everyone is working from the same historical data for the follow-up task.
A. Summary: A summary report primarily aggregates data (e.g., counts, totals). While useful for an overview, it would not inherently provide the specific employee details needed for outreach without being a detail report.
B. Infographic: An infographic is a graphical visualization for storytelling or presenting high-level insights, not for providing an actionable, detailed list for an operational task.
D. Ad hoc: An ad hoc report is a one-time report created for a specific, non-repeating purpose. The scenario explicitly states the report is "recurring," making this option incorrect. ---
1. Kimball, R., & Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (3rd ed.). Wiley. In Chapter 5, "Accumulating Snapshot and Periodic Snapshot Fact Tables," the authors describe periodic snapshots as capturing data "on a predictable, periodic basis" such as monthly. A report generated from this data structure is a snapshot report, ideal for analyzing a prior month's status.
2. Microsoft. (2023). Power BI documentation: Use aggregations in Power BI Desktop. Microsoft Learn. This document defines aggregation as the process of summarizing values (e.g., SUM, COUNT). This highlights the primary function of a summary report, which contrasts with the manager's need for a specific list of employees (detail-level data).
3. University of California, Berkeley, School of Information. (n.d.). Course curriculum for "Working with Data: Intermediate Data Analysis". The distinction between different report types is a fundamental concept in data analysis education. Courseware typically defines snapshot reports as capturing a state at a point in time, essential for historical and period-over-period analysis, which directly applies to the scenario's need for a "prior month" report.
Keep practicing
Take the free DA0-002 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DA0-002 practice questions
- Question 1[Data Analysis]A data analyst learns that a report detailing employee sales is reflecting…
- Question 2[Data Analysis]A data analyst is evaluating all conditions in a query. Which of the follo…
- Question 3[Data Analysis]A data analyst creates a report that identifies the middle 50% of the coll…
- Question 4[Data Governance]Which of the following explains the purpose of UAT?
- Question 5[Data Analysis]A product goes viral on social media, creating high demand. Distribution c…
- Question 6[Data Analysis]A data analyst team needs to segment customers based on customer spending …
