AWS AWS Storage and Databases 5 — Questions and Answers
Question 1: Which DynamoDB capacity mode automatically adjusts read and write throughput based on actual traffic patterns?
- Provisioned capacity mode
- On-demand capacity mode (Correct answer)
- Reserved capacity mode
- Burst capacity mode
Correct answer: On-demand capacity mode
DynamoDB on-demand mode automatically scales to accommodate workloads without requiring capacity planning.
Question 2: An EC2 instance needs high-performance block storage with consistent low latency for a database workload. Which EBS volume type is most appropriate?
- st1 (Throughput Optimized HDD)
- sc1 (Cold HDD)
- gp2 (General Purpose SSD)
- io2 Block Express (Correct answer)
Correct answer: io2 Block Express
io2 Block Express provides the highest performance EBS storage with up to 256,000 IOPS, designed for I/O-intensive database workloads.
Question 3: What is Amazon Aurora's storage replication factor across Availability Zones?
- 2 copies across 2 AZs
- 4 copies across 2 AZs
- 6 copies across 3 AZs (Correct answer)
- 3 copies across 3 AZs
Correct answer: 6 copies across 3 AZs
Aurora automatically replicates data 6 ways across 3 Availability Zones to ensure durability and high availability.
Question 4: Which AWS service acts as a fully managed cache layer that supports both Redis and Memcached engines?
- Amazon DynamoDB Accelerator (DAX)
- Amazon ElastiCache (Correct answer)
- Amazon MemoryDB for Redis
- AWS Global Accelerator
Correct answer: Amazon ElastiCache
Amazon ElastiCache is a managed in-memory caching service that supports both Redis and Memcached.
Question 5: A developer 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 SQL queries directly against data stored in S3.
Question 6: Which S3 feature allows you to automatically transition objects to cheaper storage classes based on their age?
- S3 Replication
- S3 Lifecycle policies (Correct answer)
- S3 Versioning
- S3 Intelligent-Tiering
Correct answer: S3 Lifecycle policies
S3 Lifecycle policies define rules to automatically transition objects to less expensive storage classes or expire them after a set number of days.
Question 7: Which AWS Database Migration Service (DMS) feature allows you to continuously replicate ongoing changes from a source database to a target database?
- Full load migration
- Change Data Capture (CDC) (Correct answer)
- Schema Conversion Tool
- Parallel load
Correct answer: Change Data Capture (CDC)
DMS Change Data Capture (CDC) continuously captures and replicates data modifications from the source database to the target with minimal downtime.
AWS AWS Storage and Databases 5
Which DynamoDB capacity mode automatically adjusts read and write throughput based on actual traffic patterns?