Microsoft
70-467 · Question #33
70-467 Question #33: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #33. The question stem and answer options stay visible for context.
Question
You are designing an extract, transform, load (ETL) process for loading data from a SQL Azure database into a large fact table in a data warehouse each day with the prior day's sales data. The ETL process for the fact table must meet the following requirements: - Load new data in the shortest possible time. - Remove data that is more than 36 months old. - Minimize record locking. - Minimize impact on the transaction log. You need to design an ETL process that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- APartition the fact table by date.
- BPartition the fact table by customer.
- CPartition the fact table by date.
- DPartition the fact table by date.
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.