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 questionsDomain Data Analysis
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.
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.
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").
Keep practicing
Take the free DA0-001 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DA0-001 practice questions
- Question 1Which of the following data analysis tools increases the efficiency of data visualization…
- Question 3Taylor wants to investigate how manufacturing, marketing, and sales expenditures impact o…
- Question 4Five dogs have the following heights in millimeters: 300, 430, 170, 470, 600 Which of the…
- Question 7A research analyst wants to determine whether the data being analyzed is connected to oth…
- Question 8Mario works with a group of R programmers tasked with copying data from an accounting sys…
- Question 9What would be an example of an acceptable form of primary identification for the Data+ ex…
