For workloads with low access frequency where you only need to query data occasionally (for example, during audits), option (A)—S3 Glacier Flexible Retrieval combined with S3 Glacier Select—provides the most cost-effective solution.
Transaction Data Refers To Data Which Are Updating Frequently and To Query That Data occasionally Means It Can Be Query At Any Time (In Question Time Is Not Define). So We Can't Take Risk For Customer To Wait For Hours To Get The Result And The Best Way To Query The Data On Top of The S3 Bucket We Can Use Athena.
https://aws.amazon.com/about-aws/whats-new/2017/11/amazon-glacier-select-makes-big-data-analytics-of-archive-data-possible/#:~:text=Amazon%20Glacier%20Select%20is%20a,archives%20to%20use%20for%20analytics.
Glacier Select allows queries to run directly on data stored in Amazon Glacier
I am not sure whether to go for B or C. Can anyone comment on this?
B: No problem, but not available if Parquet is Gzip compressed. But the problem statement doesn't say Parquet is Gzip compressed.
C: Correct if Parquet is Gzip compressed, but B is more cost-effective if csv or json is Gzip compressed
I think the solution is either B or D but I would go with B because they mentioned storing the data in gzip and not parquet which is optimised for Athena queries
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
tgv
Highly Voted 1 year, 1 month agoyouonebe
Most Recent 2 months, 3 weeks agodf94e2b
2 months, 3 weeks agoTester_TKK
3 months, 2 weeks agoAM027
3 months, 4 weeks agoYUICH
6 months, 1 week agoYUICH
6 months, 1 week agodiv_div
6 months, 2 weeks agoBigMrT
7 months agoctndba
8 months, 3 weeks agoRockyLeon
8 months, 2 weeks agomohamedTR
10 months agomanig
10 months, 1 week agoLR2023
10 months, 2 weeks agoPashoQ
10 months, 3 weeks agocas_tori
11 months, 3 weeks agomns0173
12 months agolenneth39
1 year agoandrologin
1 year ago