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