AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 31

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.)

Accepted Answer

Correct answer: B, C. The correct answer is B, C. Option B: Use a columnar storage file format. Option C: Partition the data based on the most common query predicates.

AWS Certified Data Engineer - Associate DEA-C01 — Question 31