Question 42: You are working in an e-commerce company which receive application server logs using Kinesis FireHose stream. Analytics team continuously uses these data for 1 year and do lot of query execution and after

one year this data is not that useful and needs to be archived. Which of the following option will help in design correct solution for the given requirement?

A. Kinesis FireHose will save data in a specified S3 bucket.

B. Kinesis FireHose will save data in a Redshift Cluster table.

C. Kinesis FireHose will save data in a MySQL RDS.

D. You will be creating a Lifecycle policy for the object stored in S3 bucket.

E. You will be creating Lifecycle policy for the MySQL RDS

1. A,B

2. B,C

3. C,D

4. D,E

5. A,D

Correct Answer : 5 Exp : As question has two requirement

1. Data should be ingested using the Kinesis FireHose and then it should be queried from the storage.

2. After one year all the data should be archived

So for the first requirement you can ingest data in S3 bucket. Even you can specify the schema to this data and data can be saved as Parquet or ORC file in the S3 bucket. Once data saved in S3 bucket, you can query

that data using Athena or Redshift Spectrum directly for further analysis.

Now once data saved in S3 bucket, you can add lifecycle policy to that data so that after one year they can be archived and saved to the AWS Glacier.

5