A large educational institute is using Amazon S3 buckets to save data for all graduation streams. During annual external audits from local government bodies, institutes need to fetch data of specific streams to get it audited from auditors. A large amount of data is saved in these S3 buckets, making it cumbersome to download whole data & retrieve only a small amount of information from it. The IT Team is looking for your consultation for this issue without incurring additional costs or compromising security. Which of the following actions is recommended for resolution?

Answer options:

A.Store objects in CSV format compressing it with Snappy using server-side encryption. Use Amazon S3 Select to retrieve a subset of data.
B.Store objects in JSON format compressing it with GZIP using server-side encryption. Use Amazon S3 Select to retrieve a subset of data.
C.Store objects in Apache Parquet format compressing the whole object with GZIP using server-side encryption. Use Amazon S3 Select to retrieve a subset of data.
D.Store objects in CSV format compressing it with BZIP2 without any encryption. Use Amazon S3 Select to retrieve a subset of data.

Correct Answer – B
Amazon S3 Select can be used to query a subset of data from the objects stored in the S3 bucket using simple SQL. For using this, objects need to be stored in an S3 bucket with CSV, JSON, or Apache Parquet format. GZIP & BZIP2 compression is supported with CSV or JSON format with server-side encryption.
Option A is incorrect as with Amazon S3 Select, only GZIP & BZIP2 compression is supported with CSV format.
Option C is incorrect as Whole Object compression is not supported for Parquet using GZIP. (Column compression is supported).
Option D is incorrect as although this will work, saving objects in S3 without encryption will risk the security of objects.
For more information on using S3 Select, refer to the following URL:
https://docs.aws.amazon.com/AmazonS3/latest/dev/selecting-content-from-objects.html