Microsoft
70-768 · Question #43
How can you enhance the model to support analysis by date?
The correct answer is C. Create a date table in a new SQL Server database, and import it into the model by using the. See the full explanation below for the reasoning.
Question
How can you enhance the model to support analysis by date?
Options
- ACreate calculated columns in the Internet Sales and Direct Sales tables to derive year, quarter,
- BCreate a calculated table using the CALENDARAUTO function and add calculated columns to the
- CCreate a date table in a new SQL Server database, and import it into the model by using the
- DCreate a calculated column in the Internet Sales and Direct Sales tables using the CALENDAR
How the community answered
(22 responses)- A5% (1)
- B5% (1)
- C82% (18)
- D9% (2)
Community Discussion
No community discussion yet for this question.