AWS AWS Database Services 2 — Questions and Answers
Question 1: Which Amazon RDS feature creates a synchronous standby replica in a different Availability Zone for high availability?
- Read Replicas
- Multi-AZ deployment (Correct answer)
- Cross-Region snapshots
- Aurora Serverless
Correct answer: Multi-AZ deployment
Multi-AZ deployment maintains a synchronous standby replica in another AZ for automatic failover.
Question 2: What is the primary purpose of Amazon RDS Read Replicas?
- Automatic failover during outages
- Offloading read traffic to scale read performance (Correct answer)
- Encrypting data at rest
- Backing up to S3 automatically
Correct answer: Offloading read traffic to scale read performance
Read Replicas use asynchronous replication to scale read-heavy workloads.
Question 3: Which DynamoDB capacity mode automatically scales to accommodate traffic without manual provisioning?
- Provisioned mode
- On-demand mode (Correct answer)
- Reserved mode
- Burst mode
Correct answer: On-demand mode
On-demand mode scales capacity automatically and charges per request.
Question 4: What does Amazon ElastiCache primarily provide?
- Managed relational database
- In-memory caching layer (Correct answer)
- Object storage
- Data warehouse
Correct answer: In-memory caching layer
ElastiCache provides managed in-memory caching using Redis or Memcached.
Question 5: Which AWS database service is purpose-built for petabyte-scale data warehousing and analytics?
- Amazon Redshift (Correct answer)
- Amazon RDS
- Amazon DynamoDB
- Amazon Neptune
Correct answer: Amazon Redshift
Redshift is a columnar, MPP data warehouse for analytical queries at scale.
Question 6: Amazon Neptune is optimized for which type of database workload?
- Document storage
- Graph relationships (Correct answer)
- Time-series data
- Key-value caching
Correct answer: Graph relationships
Neptune is a managed graph database supporting property graph and RDF models.
Question 7: What is the maximum number of Availability Zones across which DynamoDB automatically replicates data within a region?
- One
- Two
- Three (Correct answer)
- Four
Correct answer: Three
DynamoDB synchronously replicates data across three AZs in a region for durability.
Which Amazon RDS feature creates a synchronous standby replica in a different Availability Zone for high availability?