DAS-C01 · Question #166
A company is building an analytical solution that includes Amazon S3 as data lake storage and Amazon Redshift for data warehousing. The company wants to use Amazon Redshift Spectrum to query the data
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #166. The question stem and answer options stay visible for context.
Question
A company is building an analytical solution that includes Amazon S3 as data lake storage and Amazon Redshift for data warehousing. The company wants to use Amazon Redshift Spectrum to query the data that is stored in Amazon S3. Which steps should the company take to improve performance when the company uses Amazon Redshift Spectrum to query the S3 data files? (Select THREE )
Options
- AUse gzip compression with individual file sizes of 1-5 GB
- BUse a columnar storage file format
- CPartition the data based on the most common query predicates
- DSplit the data into KB-sized files.
- EKeep all files about the same size.
- FUse file formats that are not splittable
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-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.