DEA-C01 · Question #194
DEA-C01 Question #194: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #194. The question stem and answer options stay visible for context.
Question
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?
Options
- ARun the ANALYZE command against the identified tables. Manually update the compression
- BRun the ANALYZE COMPRESSION command against the identified tables. Manually update the
- CRun the VACUUM REINDEX command against the identified tables.
- DRun the VACUUM RECLUSTER command against the identified tables.
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.