Chapter 5

Question 1

What would you use for Tabular data with a well defined schema?

Answer 1

AWS Relational Database Service

Question 2

What would you use for analytics and reporting workloads that are heavy ?

Answer 2

A data warehouse like RedShift

Question 3

What is the difference between RDS and Redshift?

Answer 3

RDS stores data using row-level storage where as Redshift uses column based.

Question 4

What would you use for structured very large datasets?

Answer 4

RedShift

Question 5

If you data is semi-structured what repository should you consider?

Answer 5

DynamoDB

Question 6

How does DynamoDB store data?

Answer 6

As key-value pairs

Question 7

What can you use to store data that doesn’t really have a schema?

Answer 7

DynamoDB

Question 8

If you data currently lives in an open-source NoSQL store like MongoDB how can you migrate it easily to AWS?

Answer 8

Amazon DocumentDB

Question 9

What would you use to centrally manage and govern data access across multiple repositories?

Answer 9

AWS Data Lake Formation

Question 10

What tools could be used to run analytics or ETL workstreams on data in the data lake?

Answer 10

Amazon RedShift or EMR