Microsoft
70-451 · Question #97
70-451 Question #97: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #97. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains two tables named Orders and OrderDetails. There is also a data warehouse containing a table named factSales. The factSales table has a de-normalized structure and contains columns from Orders and OrderDetails. You plan to design a solution that will extract all data modifications from Orders and OrderDetails and load them into factSales. You have the following requirements: - The load operation is incremental and runs daily. - The schema of the tables cannot be modified. - The history of each modification is maintained for one month. You need to implement the solution by using the least amount of coding and administrative effort. What should you do?
Options
- AUse the SQL Server Change Data Capture feature.
- BPartition the Orders and OrderDetails tables based on date.
- CUse the SQL Server Change Tracking feature.
- DUse Microsoft Sync Services.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 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.