Section 17: Databases in AWS Flashcards Preview

AWS Associate Developer Exam > Section 17: Databases in AWS > Flashcards

Flashcards in Section 17: Databases in AWS Deck (8)
Loading flashcards...
1

Which database helps you store data in a relational format, with SQL language compatibility and capability of processing transactions?
A) Redshift
B) RDS
C) DynamoDB
D) ElastiCache

B) RDS

2

Which database do you suggest to have caching capability with a Redis compatible API?
A) RDS
B) DynamoDB
C) ElasticSearch
D) ElastiCache

D) ElastiCache

ElastiCache can create a Redis cache or a Memcached cache

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?
A) ElastiCache
B) Redshift
C) Aurora
D) RDS

C) Aurora

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?
A) RDS
B) Redshift
C) Neptune
D) ElasticSearch

C) Neptune

This is AWS' managed graph database

5

You would like to store big objects of 100 MB into a reliable and durable Key Value store. What do you recommend?
A) Athena
B) S3
C) DynamoDB
D) ElastiCache

B) S3

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

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?
A) RDS
B) S3
C) Redshift
D) Neptune

C) Redshift

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?
A) DynamoDB
B) Redshift
C) Athena
D) Glacier

C) Athena

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?
A) DynamoDB
B) ElasticSearch
C) Neptune
D) Redshift

B) ElasticSearch