AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ197

Data Store Management

A company has used an Amazon Redshift table 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 it does not run out of storage capacity. 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
Explanation

VACUUM REINDEX reclaims disk space occupied by rows marked for deletion and makes an additional analysis pass over interleaved sort keys to reanalyze their value distribution. VACUUM FULL does not reindex interleaved tables, DELETE ONLY does not perform the sort-key analysis, and SORT ONLY does not reclaim deleted-row space.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!