DAS-C01 · Question #155
DAS-C01 Question #155: Real Exam Question with Answer & Explanation
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #155. The question stem and answer options stay visible for context.
Question
A company stores Apache Parquet-formatted files in Amazon S3. The company uses an AWS Glue Data Catalog to store the table metadata and Amazon Athena to query and analyze the data. The tables have a large number of partitions. The queries are only run on small subsets of data in the table. A data analyst adds new time partitions into the table as new data arrives. The data analyst has been asked to reduce the query runtime. Which solution will provide the MOST reduction in the query runtime?
Options
- AConvert the Parquet files to the csv file format..Then attempt to query the data again
- BConvert the Parquet files to the Apache ORC file format. Then attempt to query the data again
- CUse partition projection to speed up the processing of the partitioned table
- DAdd more partitions to be used over the table. Then filter over two partitions and put all columns
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.