Youneedtoensurethatolddataandcurrentdatacanbequeriedaccordingtothebusinessrequirements.Whatshouldyoudo?()

A.Specifyaviewbasedonthearchivaldatatableandcurrentdatatables.

B.Specifythatthedatamustbequeriedbyusingastoredprocedure.

C.Specifythatboththearchivaldatatableandthecurrentdatatablesmusthaveindexescreatedonthesamecolumns.

D.SpecifythataSQLServerAgentjobmustbeusedtocopycurrentdataintothearchivaldatatableeachnight.