Flashcards in Section 17: Databases in AWS Deck (8)
Which database helps you store data in a relational format, with SQL language compatibility and capability of processing transactions?
Which database do you suggest to have caching capability with a Redis compatible API?
ElastiCache can create a Redis cache or a Memcached cache
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?
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?
This is AWS' managed graph database
You would like to store big objects of 100 MB into a reliable and durable Key Value store. What do you recommend?
S3 is indeed a key value store! (where the key is the full path of the object in the bucket)
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?
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?