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?
A.
Partition the Orders and OrderDetails tables based on date.
B.
Use the SQL Server Change Tracking feature.
C.
Use Microsoft Sync Services.
D.
Use the SQL Server Change Data Capture feature.