Database

Question 1

The DynamoDB single item storage limit that can be added to a DynamoDB table is:

Answer 1

400kb

Question 2

Is DynamoDB is a NoSQL database?

Answer 2

Yes

Question 3

DynamoDB does or does not support interface endpoints

Answer 3

Does not

Question 4

Your company has created a data warehouse using Redshift that is used to analyze data from Amazon S3. From the usage pattern, you have detected that after 30 days, the data is rarely queried in Redshift and it’s not “hot data” anymore. You would like to preserve the SQL querying capability on your data and get the queries started immediately. Also, you want to adopt a pricing model that allows you to save the maximum amount of cost on Redshift.

What does Athena do?
Glacier or Standard IA after 30 days? and why?

Answer 4

athena allows for sql queries to be run on s3 buckets

standard IA because data must remain readibly availalble unlike with glacier that takes time to recover

Question 5

A company has noticed several provisioned throughput exceptions on its DynamoDB database due to major spikes in the writes to the database. The development team wants to decouple the application layer from the database layer and dedicate a worker process to writing the data to DynamoDB.

Which middleware do you recommend on using that can scale infinitely and meet these requirements?

Why not Kinesis data streams?

Answer 5

kinesis data streams cannot scale infinitely, but SQS can.

Question 6

Why is this statement wrong:

Provision EC2 with Windows OS, attach multiple EBS volumes, and move all media files

Answer 6

multiple EBS volumes are supported only for linux, not Windows

Question 7

When RDS applies OS changes, what is the sequence?

standby upgraded first, primary upgraded first, both upgraded at same time…?

Answer 7

the standby is upgraded, then promoted to primary
then old primary is upgraded as secondary.