You need to ensure that old data and current data can be queried according to the business requirements. What should you do?()
A、Specify a view based on the archival data table and current data tables.
B、Specify that the data must be queried by using a stored procedure.
C、Specify that both the archival data table and the current data tables must have indexes created on the same columns.
D、Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.