The date dimension must always contain dates from 2010 through the end of the current year. Which option satisfies this requirement?

• A. Include dates from 2010 to CurrentYear
• B. Exclude weekends from the date range
• C. Include only fiscal-year dates
• D. Include dates from 2000 to 2009

Answer: (A)

The date dimension should provide a complete, continuous set of calendar dates from a fixed start point up to the end of the current year. Including dates from 2010 to CurrentYear does exactly that: it guarantees every day from January 1, 2010, through December 31 of the current year is present, and the upper bound updates automatically as time passes. This continuity is essential for accurate time-based analysis and for keeping the dimension up to date without manual tweaks.

Excluding weekends would eliminate dates, breaking the full calendar. Including only fiscal-year dates would skip many days that are part of the calendar, and including dates from 2000 to 2009 would miss the 2010 onward period.