AWS AWS Database Services 3 — Questions and Answers
Question 1: Which Aurora feature allows the database to automatically start, stop, and scale capacity based on application demand?
- Aurora Global Database
- Aurora Serverless (Correct answer)
- Aurora Multi-Master
- Aurora Backtrack
Correct answer: Aurora Serverless
Aurora Serverless automatically scales compute capacity up and down based on load.
Question 2: How many copies of your data does Amazon Aurora maintain across Availability Zones?
- Two copies across two AZs
- Four copies across two AZs
- Six copies across three AZs (Correct answer)
- Three copies across one AZ
Correct answer: Six copies across three AZs
Aurora stores six copies of data across three Availability Zones.
Question 3: Which DynamoDB feature provides a fully managed in-memory cache to reduce read latency to microseconds?
- DynamoDB Streams
- DAX (Correct answer)
- Global Tables
- TTL
Correct answer: DAX
DynamoDB Accelerator (DAX) is an in-memory cache delivering microsecond read latency.
Question 4: What is the purpose of DynamoDB Global Tables?
- Encrypt items at rest
- Provide multi-region, multi-active replication (Correct answer)
- Compress large attributes
- Enforce schema validation
Correct answer: Provide multi-region, multi-active replication
Global Tables replicate data across multiple regions with multi-active read/write support.
Question 5: Which RDS engine is NOT available as a managed option?
- MySQL
- PostgreSQL
- MongoDB (Correct answer)
- MariaDB
Correct answer: MongoDB
RDS supports MySQL, PostgreSQL, MariaDB, Oracle, and SQL Server, but not MongoDB.
Question 6: What does DynamoDB's TTL (Time to Live) feature do?
- Caches frequently accessed items
- Automatically deletes expired items (Correct answer)
- Replicates items across regions
- Encrypts items with a rotating key
Correct answer: Automatically deletes expired items
TTL automatically removes items after a specified expiration timestamp.
Question 7: Which service is best suited for storing and querying time-series data like IoT sensor readings?
- Amazon Timestream (Correct answer)
- Amazon Aurora
- Amazon Redshift
- Amazon Neptune
Correct answer: Amazon Timestream
Amazon Timestream is a purpose-built, serverless time-series database.
Which Aurora feature allows the database to automatically start, stop, and scale capacity based on application demand?