CLF-C02 Database Services 4 — Questions and Answers
Question 1: Which AWS service is a fully managed Apache Cassandra-compatible database?
- Amazon DynamoDB
- Amazon Keyspaces (for Apache Cassandra) (Correct answer)
- Amazon DocumentDB
- Amazon Neptune
Correct answer: Amazon Keyspaces (for Apache Cassandra)
Amazon Keyspaces is a scalable, serverless, managed database service compatible with the Apache Cassandra query language (CQL).
Question 2: A company's DynamoDB table experiences throttling during traffic spikes. Which feature should they enable to handle unpredictable workloads automatically?
- DynamoDB Streams
- DynamoDB On-Demand Mode (Correct answer)
- DynamoDB Global Tables
- DynamoDB TTL
Correct answer: DynamoDB On-Demand Mode
DynamoDB On-Demand Mode automatically scales read and write capacity to handle any traffic volume without capacity planning.
Question 3: What does Amazon RDS handle automatically that would require manual effort on a self-managed database?
- Writing SQL queries
- Designing database schemas
- Patching the database software and taking backups (Correct answer)
- Choosing the right database engine
Correct answer: Patching the database software and taking backups
Amazon RDS automates routine tasks including hardware provisioning, database setup, patching, and backups.
Question 4: Which DynamoDB feature allows you to capture a time-ordered sequence of item-level changes in a table?
- DynamoDB Accelerator (DAX)
- DynamoDB Global Tables
- DynamoDB Streams (Correct answer)
- DynamoDB On-Demand
Correct answer: DynamoDB Streams
DynamoDB Streams captures a time-ordered sequence of changes to items in a table, enabling event-driven architectures.
Question 5: An e-commerce company needs its database to remain available across multiple AWS regions simultaneously for global users. Which service supports this?
- Amazon RDS Multi-AZ
- Amazon DynamoDB Global Tables (Correct answer)
- Amazon ElastiCache
- Amazon Redshift
Correct answer: Amazon DynamoDB Global Tables
DynamoDB Global Tables automatically replicate data across multiple AWS Regions, providing single-digit millisecond latency globally.
Question 6: Which of the following database engines is NOT supported by Amazon RDS?
- MySQL
- Oracle
- MongoDB (Correct answer)
- PostgreSQL
Correct answer: MongoDB
Amazon RDS supports MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Aurora, but not MongoDB (which is supported via Amazon DocumentDB).
Question 7: What is the benefit of using automated backups in Amazon RDS?
- They replicate data to another AWS region automatically
- They allow point-in-time recovery within the backup retention period (Correct answer)
- They eliminate the need for Multi-AZ deployments
- They improve database query performance
Correct answer: They allow point-in-time recovery within the backup retention period
RDS automated backups enable point-in-time recovery, allowing you to restore a database to any second within the retention window.
CLF-C02 Database Services 4
Which AWS service is a fully managed Apache Cassandra-compatible database?