AWS AWS Database and Analytics Services 4 — Questions and Answers
Question 1: A company needs to run complex SQL analytics on petabytes of structured data with minimal administration. Which AWS service is BEST suited?
- Amazon RDS Multi-AZ
- Amazon Redshift (Correct answer)
- Amazon DynamoDB Global Tables
- Amazon ElastiCache for Redis
Correct answer: Amazon Redshift
Amazon Redshift is a fully managed petabyte-scale data warehouse optimized for complex analytical queries using SQL.
Question 2: Which Amazon DynamoDB feature automatically distributes data and traffic across multiple partitions to handle increased load?
- DynamoDB Streams
- DynamoDB Accelerator (DAX)
- Adaptive Capacity (Correct answer)
- Global Secondary Indexes
Correct answer: Adaptive Capacity
DynamoDB Adaptive Capacity automatically redistributes capacity to partitions that receive more traffic, preventing throttling.
Question 3: A team wants to query data stored in S3 using standard SQL without loading it into a database. Which service enables this?
- AWS Glue
- Amazon Athena (Correct answer)
- Amazon EMR
- Amazon Redshift Spectrum
Correct answer: Amazon Athena
Amazon Athena is a serverless interactive query service that allows you to analyze data directly in S3 using standard SQL.
Question 4: What is the purpose of Amazon ElastiCache write-through strategy?
- Data is written to cache only, bypassing the database
- Data is written to both cache and the database simultaneously (Correct answer)
- Data is written to the database first, then evicted from cache
- Data is written asynchronously to cache after a database write
Correct 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.
Question 5: Which AWS Glue component serves as a central metadata repository for all your data assets?
- Glue ETL Jobs
- Glue Data Catalog (Correct answer)
- Glue Crawlers
- Glue Workflows
Correct answer: Glue Data Catalog
The AWS Glue Data Catalog is a persistent metadata store that holds table definitions, schemas, and connection information.
Question 6: A developer needs sub-millisecond latency for a DynamoDB-backed leaderboard. Which service should be added?
- Amazon ElastiCache for Memcached
- Amazon RDS Read Replica
- Amazon DynamoDB Accelerator (DAX) (Correct answer)
- Amazon CloudFront
Correct answer: Amazon DynamoDB Accelerator (DAX)
DAX is a fully managed, highly available in-memory cache for DynamoDB that delivers microsecond response times.
Question 7: Which Amazon Kinesis service is used to load streaming data into AWS data stores like S3, Redshift, or OpenSearch?
- Kinesis Data Streams
- Kinesis Data Firehose (Correct answer)
- Kinesis Data Analytics
- Kinesis Video Streams
Correct answer: Kinesis Data Firehose
Kinesis Data Firehose is the easiest way to reliably load streaming data into data lakes, data stores, and analytics services.
AWS AWS Database and Analytics Services 4
A company needs to run complex SQL analytics on petabytes of structured data with minimal administration.
Which AWS service is BEST suited?