Microsoft
70-463 · Question #129
70-463 Question #129: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #129. 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 Server 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. - Ensure that data loads correctly. - 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 destination fact table by date.
- BPartition the destination fact table by date.
- CPartition the destination fact table by customer.
- DPartition the destination fact table by date.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 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.