Answer-first summary for fast verification
Answer: Run the ANALYZE COMPRESSION command against the identified tables. Manually update the compression encoding of columns based on the output of the command.
The `ANALYZE COMPRESSION` command in Redshift performs an analysis of an existing table and suggests the most optimal compression encoding for each column based on a sample of the data. You can then use this output to manually recreate the tables or alter column encodings where applicable.
Author: Ritesh Yadav
Ultimate access to all questions.
A company uses Amazon Redshift as its data warehouse. Data encoding is applied to the existing tables of the data warehouse. A data engineer discovers that the compression encoding applied to some of the tables is not the best fit for the data. The data engineer needs to improve the data encoding for the tables that have sub-optimal encoding. Which solution will meet 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.
No comments yet.