Microsoft
70-467 · Question #88
70-467 Question #88: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #88. The question stem and answer options stay visible for context.
Question
You need to implement a strategy for efficiently storing sales order data in the data warehouse. What should you do?
Options
- ASeparate the factOrders table into multiple tables, one for each month that has orders, and
- BSeparate the factOrders table into multiple tables, one for each day that has orders, and use
- CCreate daily partitions in the factOrders table.
- DCreate monthly partitions in the factOrders table.
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 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.