AWS Certified Data Engineer – Associate (DEA-C01) — Question 76

A company has used an Amazon Redshift table that is named Orders for 6 months. The company performs weekly updates and deletes on the table. The table has an interleaved sort key on a column that contains AWS Regions.
The company wants to reclaim disk space so that the company will not run out of storage space. The company also wants to analyze the sort key column.
Which Amazon Redshift command will meet these requirements?

Answer options

• A. VACUUM FULL Orders
• B. VACUUM DELETE ONLY Orders
• C. VACUUM REINDEX Orders
• D. VACUUM SORT ONLY Orders

Correct answer: C

Explanation

The command VACUUM REINDEX Orders is the correct choice as it reclaims storage space associated with interleaved sort keys and optimizes the table for performance analysis. The other options either do not focus on reclaiming space effectively for interleaved sort keys or do not address the need to analyze the sort key column.