An insurance company stores transaction data that the company compressed with gzip.
The company needs to query the transaction data for occasional audits.
Which solution will meet this requirement in the MOST cost-effective way?
An insurance company stores transaction data that the company compressed with gzip.
The company needs to query the transaction data for occasional audits.
Which solution will meet this requirement in the MOST cost-effective way?
The most cost-effective solution for the insurance company to store and query gzip-compressed transaction data for occasional audits is to store the data in Amazon S3 and use Amazon S3 Select to query the data. Amazon S3 is a cost-effective object storage service, and S3 Select allows retrieval of specific data elements from within larger objects using simple SQL expressions, minimizing the need to transfer entire files for queries. S3 Select also supports GZIP compression, making it suitable for the given scenario.
Actually, I think A makes more sense.
B and C are not cost effective. A is more cost effective than D. I go with A.
Looks like that A - fit better in question requirements
On the assumptions that querying the audit data is time sensitive and the transaction data is compressed into a single object I would go with using S3 and S3 select to query the data.
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
there is no such thing as Glacier Flexible Retrieval, so its no A . its either B or D and most likely its D for the cost
B. Store the data in Amazon S3. Use Amazon S3 Select to query the data. Amazon S3 is a cost-effective object storage service, and S3 Select allows you to retrieve only a subset of data from an object by using simple SQL expressions. S3 Select works on objects stored in CSV, JSON, or Apache Parquet format. It also supports GZIP and BZIP2 compression formats, which makes it suitable for the given scenario where the data is compressed with gzip. While Amazon Athena is a powerful query service, it can be more expensive than S3 Select for occasional queries. Amazon Glacier and Glacier Select are designed for long-term archival storage and not for frequent access or queries, which might not be suitable for occasional audits. Therefore, option B is the most cost-effective choice for this scenario.
ill go with B, because. of cost to query
B. Store the data in Amazon S3. Use Amazon S3 Select to query the data. Amazon S3 is a cost-effective storage service, and S3 Select allows you to retrieve only a subset of data from an object by using simple SQL expressions. S3 Select works on objects stored in CSV, JSON, or Apache Parquet format. It also supports GZIP compression, which is the format used by the company. This makes it a cost-effective solution for occasional queries needed for audits.
Option B (Amazon S3 with S3 Select) is generally more cost-effective and operationally efficient for occasional audits of gzip-compressed data. It provides faster access to data and lower querying costs, which are critical factors for ad-hoc and timely data retrievals. While Option A (Amazon Glacier Flexible Retrieval with S3 Glacier Select) offers cheaper storage, its longer retrieval times and potential higher querying costs make it less suitable for use cases requiring timely access to data.