Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 761 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02

Question #: 761
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company wants to measure the effectiveness of its recent marketing campaigns. The company performs batch processing on .csv files of sales data and stores the results in an Amazon S3 bucket once every hour. The S3 bucket contains petabytes of objects. The company runs one-time queries in Amazon Athena to determine which products are most popular on a particular date for a particular region. Queries sometimes fail or take longer than expected to finish running.
Which actions should a solutions architect take to improve the query performance and reliability? (Choose two.)

A. Reduce the S3 object sizes to less than 128 MB.
B. Partition the data by date and region in Amazon S3.
C. Store the files as large, single objects in Amazon S3.
D. Use Amazon Kinesis Data Analytics to run the queries as part of the batch processing operation.
E. Use an AWS Glue extract, transform, and load (ETL) process to convert the .csv files into Apache Parquet format.

Show Suggested Answer

Suggested Answer: AB 🗳️

by attila9778 at Oct. 26, 2022, 11:08 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

attila9778

Highly Voted 2 years, 8 months ago

B, E As per: https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-tips-for-amazon-athena/ we can use: 1. Partition your data, and 5. Optimize columnar data store generation A is not an optimal choice, detailed in 4. Optimize file sizes: "However, if your files are too small (generally less than 128 MB), the execution engine might be spending additional time with the overhead of opening S3 files, listing directories, getting object metadata, setting up data transfer, reading file headers, reading compression dictionaries, and so on." C also not the right choice: "On the other hand, if your file is not splittable and the files are too large, the query processing waits until a single reader has completed reading the entire file. That can reduce parallelism."

upvoted 8 times

...

BECAUSE

Most Recent 2 years ago

Selected Answer: BE

B and E are the answers

upvoted 2 times

...

ruqui

2 years ago

Selected Answer: BC

According to https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-tips-for-amazon-athena, answer should be B, C

upvoted 2 times

...