nerdexam
AmazonAmazon

DEA-C01 · Question #86

DEA-C01 Question #86: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #86. The question stem and answer options stay visible for context.

Data Store Management

Question

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?

Options

  • AVACUUM FULL Orders
  • BVACUUM DELETE ONLY Orders
  • CVACUUM REINDEX Orders
  • DVACUUM SORT ONLY Orders

Unlock DEA-C01 to see the answer

You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Redshift VACUUM#Sort Keys#Disk Space Management#Table Maintenance
Full DEA-C01 PracticeBrowse All DEA-C01 Questions