QuestionQ257

Data Store Management

An insurance company stores transaction data that it has compressed with gzip.

The company must query the transaction data for occasional audits.

Which solution meets this requirement in the MOST cost-effective manner?

  • A Store the data in Amazon Glacier Flexible Retrieval. Use Amazon S3 Glacier Select to query the data.
  • B Store the data in Amazon S3. Use Amazon S3 Select to query the data.
  • C Store the data in Amazon S3. Use Amazon Athena to query the data.
  • D Store the data in Amazon Glacier Instant Retrieval. Use Amazon Athena to query the data.
Explanation

S3 Glacier Flexible Retrieval is designed for low-cost archival data accessed infrequently. S3 Glacier Select runs SQL filtering directly against archived data and returns only the required subset, avoiding retrieval of the full archive for each audit. This minimizes both ongoing storage cost and occasional audit-access cost.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!