Amazon Exam DAS-C01 Topic 6 Question 55 Discussion

Actual exam question for Amazon's DAS-C01 exam

Question #: 55
Topic #: 6

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?

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 in the WHERE clause

Show Suggested Answer

Suggested Answer: C

by Gladys at May 03, 2022, 03:36 PM

Limited Time Offer

25%

Off

Get Premium DAS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!