AWS Database and Analytics Services Flashcards

A company needs to run complex SQL analytics on petabytes of structured data with minimal administration. Which AWS service is BEST suited?

Answer: Amazon Redshift

Amazon Redshift is a fully managed petabyte-scale data warehouse optimized for complex analytical queries using SQL.

Which Amazon DynamoDB feature automatically distributes data and traffic across multiple partitions to handle increased load?

Answer: Adaptive Capacity

DynamoDB Adaptive Capacity automatically redistributes capacity to partitions that receive more traffic, preventing throttling.

A team wants to query data stored in S3 using standard SQL without loading it into a database. Which service enables this?

Answer: Amazon Athena

Amazon Athena is a serverless interactive query service that allows you to analyze data directly in S3 using standard SQL.

What is the purpose of Amazon ElastiCache write-through strategy?

Answer: Data is written to both cache and the database simultaneously

Write-through ensures cache and database stay synchronized by writing to both on every update, preventing stale reads.

Which AWS Glue component serves as a central metadata repository for all your data assets?

Answer: Glue Data Catalog

The AWS Glue Data Catalog is a persistent metadata store that holds table definitions, schemas, and connection information.

A developer needs sub-millisecond latency for a DynamoDB-backed leaderboard. Which service should be added?

Answer: Amazon DynamoDB Accelerator (DAX)

DAX is a fully managed, highly available in-memory cache for DynamoDB that delivers microsecond response times.

Which Amazon Kinesis service is used to load streaming data into AWS data stores like S3, Redshift, or OpenSearch?

Answer: Kinesis Data Firehose

Kinesis Data Firehose is the easiest way to reliably load streaming data into data lakes, data stores, and analytics services.