Microsoft
70-768 · Question #43
70-768 Question #43: Real Exam Question with Answer & Explanation
Sign in or unlock 70-768 to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.
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
Unlock 70-768 to see the answer
You've previewed enough free 70-768 questions. Unlock 70-768 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.