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.