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.