AmazonAmazon
DEA-C01 · Question #65
DEA-C01 Question #65: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #65. The question stem and answer options stay visible for context.
Data Store Management
Question
A company is building an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift for a data warehouse. The company wants to use Amazon Redshift Spectrum to query the data that is in Amazon S3. Which actions will provide the FASTEST queries? (Choose two.)
Options
- AUse gzip compression to compress individual files to sizes that are between 1 GB and 5 GB.
- BUse a columnar storage file format.
- CPartition the data based on the most common query predicates.
- DSplit the data into files that are less than 10 KB.
- EUse file formats that are not splittable.
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.
Topics
#Redshift Spectrum#Query Optimization#Data Partitioning#Columnar Storage