Question 34: You are having 200GB of data, with the fixed schema, this data is from an ecommerce website and needs to be saved as key-value pair. However, you should be able run SQL queries on this data and support

the transactions. New data can be added with the same structure and whenever new data is added it require consistent read. Which of the following storage solution is best suited for the given requirement?

1. AWS S3

2. AWS DynamoDB

3. AWS Glacier

4. AWS RDS

5. AWS Kinesis

Correct Answer : 4 Exp : Question is asking that data has fixed schema and needs to be fetched based on Key Value pair. For that you can remove Glacier option because it is an archival solution and does not provide

key-value access of data. It is an Object storage solution, Similarly S3 is object storage solution.

Remaining options are DynamoDB, RDS and Kinesis.

DynamoDB provides key-value storage solution with the consistent read, but it does not support SQL based queries. Hence we can discard this option as well.

Kinesis : It is for streaming data and it is not a good fit for key-value data structure. Hence, can not be a correct option.

RDS : This provides SQL Query based data fetch as well as support for transactions. It also gives us the consistent read. This is not a good solution for key-value access pattern, but using primary key as a key and

rest of the row as a value, you can create key-value access pattern. Hence, this is a perfect fit for the given option in the question.

4