A large retail firm saves its global sales reports in the S3 bucket & uses S3 Lifecycle rules to move this data from Standard_IA storage class to AWS S3 Glacier post 180 days. Due to the financial year-end, the Finance team is looking for a sales report for only the Europe region where a mismatch is reported in the sales figure. Which of the following is a recommended way to fetch this data with the least effort?

Answer options:

A.Retrieve this data from Amazon Glacier to S3 bucket & use Amazon S3 select to query specific continent data using simple SQL.
B.Retrieve this data from Amazon Glacier to S3 bucket & use Amazon Athena to query specific continent data using SQL.
C.Use Amazon S3 Glacier Select to query specific continent data which is restored to S3 bucket from AWS S3 Glacier.
D.Use Amazon S3 Glacier Select to query specific continent data directly from Amazon S3 Glacier using simple SQL.

Correct Answer – D
Amazon S3 Glacier Select can be used to query specific data from Amazon S3 Glacier instead of querying whole data. Amazon S3 Glacier Select can directly query data from Amazon S3 Glacier & restoration of data to the S3 bucket is not required for querying this data.
Option A is incorrect because for data stored in Amazon S3 Glacier, it’s not necessary to restore data to the S3 bucket.
Option B is incorrect because for data stored in Amazon S3 Glacier, it’s not necessary to restore data to the S3 bucket. Also, Amazon Athena is an interactive query tool to analyze data with an S3 bucket.
Option C is incorrect because with Amazon S3 Glacier Select, you do not need to restore data from Glacier to S3.
For more information on using Amazon S3 Glacier Select, refer to the following URL:
https://aws.amazon.com/glacier/features/#amazon-glacier-select