You manage a large data warehouse.
You must archive data that is more than two years old. The data must all be accessible without code changes. You create a new volume for the data archive and create a new file group named Archive.
You need to develop a storage that will minimize space utilization and protect data from accidental deletion.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation:
Step 1: Create an archive table on the new filegroup
Step 2: Create a partition scheme aligned to primary and archive filegroups Creates a scheme in the current database that maps the partitions of a partitioned table or index to filegroups.
Step 3: Apply partition scheme to tables
Step 4: Compress the archive table
References:
https://www.sqlshack.com/archiving-sql-server-data-using-partitions/