Deal of The Day! 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

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.)
C) Store the files as large, single objects in Amazon S3. and E) Use an AWS duo extract, transform, and load (ETL) process to convert the csv files into Apache Parquet format.
A) Reduce the S3 object sizes to less than 126 MB
B) Partition the data by date and region n Amazon S3
D) Use Amazon Kinosis Data Analytics to run the Queries as pan of the batch processing operation

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
7 months ago
I think Kinesis might complicate things more than help.
upvoted 0 times
...
Ruthann
7 months ago
Isn't using ETL for Parquet a bit overkill for this?
upvoted 0 times
...
Kayleigh
7 months ago
Wait, why would you store files as large single objects?
upvoted 0 times
...
Joye
8 months ago
Definitely agree with reducing object sizes!
upvoted 0 times
...
Katie
8 months ago
Partitioning by date and region sounds smart!
upvoted 0 times
...
Mona
8 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
8 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
8 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
8 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
8 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
8 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
8 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