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.
table partitioning

B.
a linked server

C.
a table schema

D.
Service Broker