Consider this date dimension and choose the appropriate discussion…

Question Answered step-by-step Consider this date dimension and choose the appropriate discussion… Consider this date dimension and choose the appropriate discussion below.Image transcription textFull Date Calendar Fiscal Year- Holiday Weekday KeyDate Date Description Day of Week Month Calendar YearMonth Indicator Indicator 01.01.2002 January 1, 2002 Tuesday January 2002 F2002-01 Holiday Weekday01.02.2002 January 2, 2002 Wednesday January 2002 F2002-01 Non-Holiday Weekday 01.03.20… Show more… Show moreA.This date dimension table is not a good design because it is not normalised, for example the Calendar Month column that has repeating values. B.This date dimension table is not a good design because it is does not contain time. C.This date dimension table is not a good design because it is not normalised, and there are too many columns and rows which would make a query very slow. D.There are many date attributes not supported by the SQL date function, including fiscal periods, seasons, holidays, and weekends. Rather than attempting to determine these nonstandard calendar calculations in a query, we should look them up in a date dimension table.   E. A, B and C above   Engineering & Technology Computer Science INF 785 Share QuestionEmailCopy link Comments (0)