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 agoyouonebe
Most Recent 1 month agodf94e2b
1 month agoTester_TKK
1 month, 3 weeks agoAM027
2 months, 1 week agoYUICH
4 months, 3 weeks agoYUICH
4 months, 3 weeks agodiv_div
4 months, 3 weeks agoBigMrT
5 months, 1 week agoctndba
7 months agoRockyLeon
6 months, 3 weeks agomohamedTR
8 months, 1 week agomanig
8 months, 3 weeks agoLR2023
8 months, 3 weeks agoPashoQ
9 months agocas_tori
10 months, 1 week agomns0173
10 months, 1 week agolenneth39
10 months, 2 weeks agoandrologin
11 months ago