Topic 1 Question 31
A monitoring service generates 1 TB of scale metrics record data every minute. A Research team performs queries on this data using Amazon Athena. The queries run slowly due to the large volume of data, and the team requires better performance. How should the records be stored in Amazon S3 to improve query performance?
CSV files
Parquet files
Compressed JSON
RecordIO
ユーザの投票
コメント(4)
Answer is B. Athena is best in Parquet format.
👍 22gaku10162021/09/21You can improve the performance of your query by compressing, partitioning, or converting your data into columnar formats. Amazon Athena supports open source columnar data formats such as Apache Parquet and Apache ORC. Converting your data into a compressed, columnar format lowers your cost and improves query performance by enabling Athena to scan less data from S3 when executing your query
👍 11emailtorajivk2021/10/12- 正解だと思う選択肢: B
B it is
👍 3apprehensive_scar2022/02/03
シャッフルモード