S17:Databases in AWS

Question 1

Which database helps you store data in a relational format, with SQL language compatibility and capability of processing transactions?

Answer 1

RDS

Question 2

Which database do you suggest to have caching capability with a Redis compatible API?

Answer 2

ElastiCache can create a Redis cache or a Memcached cache

Question 3

You are looking to perform OLTP, and would like to have the underlying storage with the maximum amount of replication and auto-scaling capability. What do you recommend?

Answer 3

Aurora

Question 4

As a solution architect, you plan on creating a social media website where users can be friends with each other, and like each other’s posts. You plan on performing some complicated queries such as “What are the number of likes on the posts that have been posted by the friends of Mike?”. What database do you suggest?

Answer 4

Neptune

Question 5

You would like to store big objects of 100 MB into a reliable and durable Key Value store. What do you recommend?

Answer 5

S3 is indeed a key value store! (where the key is the full path of the object in the bucket)

Question 6

You would like to have a database which is efficient at performing analytical queries on large sets of columnar data. You would like to connect that Data Warehouse to a reporting and dashboard tool such as Amazon Quicksight. Which technology do you recommend?

Answer 6

Redshift

Question 7

Your log data is currently stored in S3 and you would like to perform a quick analysis if possible serverless to filter the logs and find a user which may have completed an unauthorized action. Which technology do you recommend?

Answer 7

Athena

Question 8

Your gaming website is currently running on top of DynamoDB. Users have been asking for a search feature to find other gamers by name, with partial matches if possible. Which technology do you recommend to implement that feature?

Answer 8

Anytime you see “search”, think ElasticSearch