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

Amazon SAP-C02 Exam - Topic 4 Question 75 Discussion

Posted by Tammara on Sep 27, 2026 at 02:06 AM

A company is running an application in the AWS Cloud. The application collects and stores a large amount of unstructured data in an Amazon S3 bucket. The S3 bucket contains several terabytes of data and uses the S3 Standard storage class. The data increases in size by several gigabytes every day.

The company needs to query and analyze the data. The company does not access data that is more than 1-year-old. However, the company must retain all the data indefinitely for compliance reasons.

Which solution will meet these requirements MOST cost-effectively?

Suggested Answer: C

Generally, unstructured data should be converted structured data before querying them. AWS Glue can do that. https://docs.aws.amazon.com/glue/latest/dg/schema-relationalize.html https://docs.aws.amazon.com/athena/latest/ug/glue-athena.html


Get Premium SAP-C02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
15 comments · newest first
MA
Magnus Perez 4 days ago
C makes the most sense here because the tricky part is converting unstructured data to a structured form before querying.
AN
Ana Colombo 20 days ago
Going with C since the tricky part is converting unstructured data to a queryable schema with Glue Data Catalog and querying with Athena.
HY
Hyun Cho 3 days ago
↳ replying to Ana Colombo
Exactly, the confusing part is converting unstructured data to a queryable schema with Glue Data Catalog and querying with Athena, and per-query pricing helps.
RU
Rupali Shukla 7 days ago
↳ replying to Ana Colombo
Wouldn't A be more cost effective here because you only query last year's data and S3 Select avoids full object scans?
MA
Magnus Greco 13 days ago
↳ replying to Ana Colombo
Yes, I ended up with the same conclusion.
PA
Patricia White 19 days ago
↳ replying to Ana Colombo
How does Glue's schema-relationalize specifically enable Athena to query unstructured data here?
PA
Pamella 3 days ago
Redshift Spectrum seems overkill for this scenario.
FA
Fabiola 8 days ago
S3 Glacier Deep Archive is perfect for old data retention.
EF
Effie 13 days ago
Surprised they need to keep all that data indefinitely!
AN
Annice 19 days ago
I disagree, I think C is better for querying.
ER
Erick 24 days ago
Option A is the most cost-effective choice!
TA
Tatum 29 days ago
I feel like Redshift Spectrum might be overkill for this scenario, especially since they only need to query data that's less than a year old.
LA
Lauran 1 month ago
I practiced a similar question where we had to choose between S3 Glacier and S3 Intelligent-Tiering, but I can't recall which one is more cost-effective for long-term storage.
PH
Phuong 1 month ago
I think using Amazon Athena with AWS Glue makes sense since it can handle unstructured data well, but I'm not completely confident about the cost implications.
DE
Dexter 1 month ago
I remember that S3 Select is great for querying specific data, but I'm not sure if it's the best choice for large datasets like this.
0/2000 characters

Save Cancel