DA0-001 practice question 21 of 35

A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

Full set: 361 questions

Domain Data Analysis

Answer options
A: January 1, 2020 to April 1, 2020
B: January 1, 2020 to April 7, 2020
C: January 1, 2020 to April 8, 2020
D: January 1, 2020 to April 9, 2020 Correct answer
Correct Answer:
D. January 1, 2020 to April 9, 2020
Explanation

The term "year to date" (YTD) refers to the period starting from the beginning of the current calendar year (January 1) and ending on the current date of the request. The request is made on April 9, 2020, which becomes the specified end date for the YTD period. Therefore, the report's date range should include all data from January 1, 2020, up to and including April 9, 2020. The statement that the data is "current through the end of the day" implies the system's capability to provide data for the current date, even if the business day is not yet complete.

Why Incorrect

A. January 1, 2020 to April 1, 2020: This range is incorrect because it arbitrarily stops on April 1 and does not include data up to the current date as required by a "year to date" report.
B. January 1, 2020 to April 7, 2020: This range is incorrect as it omits available data for April 8, failing to be current "to date."
C. January 1, 2020 to April 8, 2020: This range represents the last completed day but is not fully "to date." A YTD calculation typically includes the current, albeit partial, period up to the specified date of the report.

References

1. University of Washington, Finance - Glossary of Financial Terms. The definition for Year-to-Date (YTD) states: "The period beginning with the first day of the current fiscal year up to a specified date." In the context of the question, the "specified date" is April 9, 2020. (Reference: UW Finance, Glossary, "Y" section, definition for Year-to-Date).

2. Microsoft Corporation, DAX function reference for TOTALYTD. In data analysis languages like DAX (Data Analysis Expressions), time intelligence functions that calculate YTD values operate on a set of dates from the beginning of the year until the last date in the current filter context. The problem implies the context includes the current date. The TOTALYTD function "evaluates the year-to-date value of the expression in the current context." The current context is defined by the request date, April 9. (Reference: Microsoft Docs, TOTALYTD function (DAX), Remarks section).

3. Kimball, R., & Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (3rd ed.). Wiley. Chapter 5, "Date and Time Dimensions," discusses handling time-series analysis. While emphasizing the use of complete periods for comparability, the fundamental definition of a "to-date" report includes transactions up to the moment of the query, which in this case is on April 9. The business need dictates including the most current data available. (Reference: Chapter 5, section on "Time-of-Day Dimension").

Scroll to Top