New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Amazon SAA-C03 Exam - Topic 9 Question 2 Discussion

Actual exam question for Amazon's SAA-C03 exam
Question #: 2
Topic #: 9
[All SAA-C03 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 i an Amazon S3 bucket once every hour. The S3 bi 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.

Which actions should a solutions architect take to improve the query performance and reliability? (Select TWO.)

Show Suggested Answer Hide Answer
Suggested Answer: C, E

by Cathrine at Sep 20, 2022, 07:21 PM

Limited Time Offer

25%

Off

Get Premium SAA-C03 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ollie
4 months ago
I think Kinesis might complicate things more than help.
upvoted 0 times
...
Ruthann
4 months ago
Isn't using ETL for Parquet a bit overkill for this?
upvoted 0 times
...
Kayleigh
4 months ago
Wait, why would you store files as large single objects?
upvoted 0 times
...
Joye
4 months ago
Definitely agree with reducing object sizes!
upvoted 0 times
...
Katie
4 months ago
Partitioning by date and region sounds smart!
upvoted 0 times
...
Mona
5 months ago
I’m a bit confused about using Kinesis for batch processing; I thought it was more for real-time data. Is that really a good option here?
upvoted 0 times
...
Grover
5 months ago
I practiced a similar question where using ETL to convert files to Parquet format was a recommended solution. It makes sense for performance.
upvoted 0 times
...
Carla
5 months ago
Partitioning the data by date and region sounds familiar; I think it can significantly improve query efficiency in Athena.
upvoted 0 times
...
Kallie
5 months ago
I remember that reducing S3 object sizes can help with query performance, but I'm not sure if it should be less than 126 MB specifically.
upvoted 0 times
...
Kami
5 months ago
This looks like a straightforward networking question. I think I'll go with option A - using Access Context Manager to create a secure perimeter and restrict access to the allowed IP ranges.
upvoted 0 times
...
Cheryll
5 months ago
Okay, I've got this. The key is understanding what a "done increment of product" means. If the sprint is successful, it should result in a completed, usable piece of the final product. So the answer is B. True.
upvoted 0 times
...
Alyce
5 months ago
I'm a bit confused by the code snippet. I'll need to re-read it a few times to make sure I understand what's happening before I can confidently answer this.
upvoted 0 times
...

Save Cancel