You are designing a table that will store transactions for an online retailer. You anticipate that the online retailer will have an average of 500,000 transactions per day. You need to design a solution for data aging and archiving. The solution must minimize the amount of time it takes to return query results for active data.
What should you implement?
A. a linked server
B. a table schema
C. Service Broker
D. table partitioning