Q49 — AWS DEA-C01 Ch.1

Question 49 of 100 | ← Chapter 1

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

Correct Answer: C. VACUUM REINDEX Orders

Explanation

为了同时满足公司回收磁盘空间和分析排序键列的需求，应选择`VACUUMREINDEX`命令。此命令不仅可以帮助回收未使用的空间，提高磁盘空间利用率，还能重建表的索引，包括排序键，从而优化查询性能。`VACUUMFULL`会重建整个表并回收空间，但可能不必要且耗时；`VACUUMDELETEONLY`仅回收空间；`VACUUMSORTONLY`不回收空间，仅优化排序键。因此，C选项`VACUUMREINDEXOrders`最符合需求。