Answer-first summary for fast verification
Answer: Partition the data in S3, use columnar storage formats, and create the view in Athena.
To optimize query performance in Athena, it is recommended to partition the data in S3, which reduces the amount of data scanned by each query. Using columnar storage formats like Parquet or ORC further improves query performance by reducing I/O operations. Creating the view in Athena makes it easily accessible to other analysts, ensuring efficient data access and analysis.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are required to use Athena to query a large dataset stored in S3 and create a view that can be used by other analysts. What steps would you take to ensure the query performance is optimal and the view is easily accessible?
A
Partition the data in S3, use columnar storage formats, and create the view in Athena.
B
Use row-based storage formats, create the view in Athena, and cache the results.
C
Compress the data in S3, use row-based storage formats, and create the view in Athena.
D
Encrypt the data in S3, use columnar storage formats, and create the view in Athena.
No comments yet.