A.CreateanewTimedimensionbasedontheHolidaytable.Usederivedcolumnsforthemonthandtheyear.
B.CreateaServerTimedimension.Withinthisdimension，enablethetimeperiodsyear，month，anddate.SelecttheAdditionalManufacturingcalendaroption.
C.CreateanewTimedimensionbasedonthedatevalueswithintheProductOrderStatustable.FlagthosedaysonwhichnoorderswerereceivedasHoliday.
D.CreateanewTimedimensionbasedonadatasourceviewnamedquery.DerivethedataforthisdatasourceviewfromuniquedateswithintheProductOrderStatustable.Useasubquerytoidentifytheholidaysandderivedcolumnsforthemonthandtheyear.
参考答案：D
