AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ332

Data Operations and Support

A company uses Amazon Redshift as its data warehouse. Data encoding has been applied to the warehouse’s existing tables. A data engineer finds that the compression encoding used on some tables is not the best fit for the data.

The data engineer needs to improve data encoding for the tables that have suboptimal encoding.

Which solution meets this requirement?

  • A Run the ANALYZE command against the identified tables. Manually update the compression encoding of columns based on the output of the command.
  • B Run the ANALYZE COMPRESSION command against the identified tables. Manually update the compression encoding of columns based on the output of the command.
  • C Run the VACUUM REINDEX command against the identified tables.
  • D Run the VACUUM RECLUSTER command against the identified tables.
Explanation

Amazon Redshift ANALYZE COMPRESSION analyzes the contents of an existing populated table and produces recommended compression encodings for its columns. Those recommendations can be used to manually update the column encodings. ANALYZE gathers query-planning statistics, while VACUUM REINDEX and VACUUM RECLUSTER address table maintenance and row ordering rather than compression selection.

Learn more

Community Discussion

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