Answer-first summary for fast verification
Answer: VACUUM REINDEX Orders
Option C is CORRECT because VACUUM REINDEX Orders will reindex interleaved tables followed by a full vacuum. This command will reclaim disk space and reindex the interleaved sort key, meeting both requirements of reclaiming disk space and maintaining optimal sort key performance.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 38/60
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?
A
VACUUM FULL Orders
B
VACUUM DELETE ONLY Orders
C
VACUUM REINDEX Orders
D
VACUUM SORT ONLY Orders
No comments yet.