___________________________________________________________________
AWS CLF-C02 Database Exam Questions
2026–2027 | Amazon RDS, DynamoDB
& AWS Database Certification Prep
1. Which AWS service is designed to simplify the setup, operation, and scaling
of a relational database?
A. Amazon DynamoDB
B. Amazon RDS
C. Amazon ElastiCache
D. Amazon S3
Answer: Amazon RDS
Rationale: Amazon RDS is a managed relational database service that handles
many administrative tasks such as provisioning, patching, backups, and
maintenance.
2. Which database engines are supported by Amazon RDS?
A. MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Db2
B. MongoDB, Cassandra, Redis, and Neo4j only
C. DynamoDB and Neptune only
D. Hadoop and Spark only
,Answer: MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Db2
Rationale: Amazon RDS supports several popular relational database engines,
allowing organizations to use familiar SQL-based technologies.
3. A company wants to run a MySQL database without managing the
underlying operating system. Which service should it use?
A. Amazon EC2
B. Amazon RDS for MySQL
C. Amazon S3
D. Amazon DynamoDB
Answer: Amazon RDS for MySQL
Rationale: RDS provides managed MySQL databases while AWS manages the
underlying infrastructure and many routine administrative tasks.
4. Which task is AWS generally responsible for when using Amazon RDS?
A. Writing application SQL queries
B. Managing the physical infrastructure
C. Designing database schemas
D. Creating database indexes
Answer: Managing the physical infrastructure
Rationale: AWS manages the underlying physical infrastructure, while
customers remain responsible for database configuration, schemas, queries, and
application-level requirements.
5. Which Amazon RDS feature provides automatic backups of a database?
A. Amazon CloudFront
B. Automated backups
C. AWS Artifact
D. Amazon Athena
,Answer: Automated backups
Rationale: Amazon RDS automated backups provide point-in-time recovery
capabilities during the configured backup retention period.
6. What is a key benefit of Amazon RDS Multi-AZ deployment?
A. It automatically converts relational databases into NoSQL databases
B. It provides high availability and automatic failover
C. It eliminates all database costs
D. It provides unlimited storage at no charge
Answer: It provides high availability and automatic failover
Rationale: Multi-AZ deployments maintain a standby database instance in
another Availability Zone and can automatically fail over when the primary
becomes unavailable.
7. A company requires a database that can automatically fail over to another
Availability Zone if the primary database fails. Which Amazon RDS feature
should it select?
A. Read replica
B. Multi-AZ deployment
C. Database migration task
D. Amazon S3 versioning
Answer: Multi-AZ deployment
Rationale: Multi-AZ is designed primarily for availability and failover rather than
read scaling.
8. What is the primary purpose of an Amazon RDS read replica?
A. Disaster recovery of the entire AWS account
B. Increasing read scalability
C. Encrypting database connections
D. Replacing database backups
, Answer: Increasing read scalability
Rationale: Read replicas asynchronously replicate data from a source database
and can serve read traffic, helping applications scale read-heavy workloads.
9. Which statement correctly compares RDS Multi-AZ deployments and read
replicas?
A. Both are primarily designed for the exact same purpose
B. Multi-AZ focuses on high availability, while read replicas primarily support read
scaling
C. Read replicas always provide synchronous replication
D. Multi-AZ deployments cannot use multiple Availability Zones
Answer: Multi-AZ focuses on high availability, while read replicas primarily
support read scaling
Rationale: The two features address different architectural requirements: Multi-
AZ improves availability and failover, while read replicas help distribute read
workloads.
10.Which Amazon RDS capability allows a database to be restored to a specific
point in time?
A. Point-in-time recovery
B. Amazon Inspector
C. AWS Shield
D. Route 53 failover routing
Answer: Point-in-time recovery
Rationale: Point-in-time recovery uses automated backups and transaction logs
to restore an RDS database to a selected time within the retention period.
11.Which AWS service is a managed NoSQL key-value and document
database?
AWS CLF-C02 Database Exam Questions
2026–2027 | Amazon RDS, DynamoDB
& AWS Database Certification Prep
1. Which AWS service is designed to simplify the setup, operation, and scaling
of a relational database?
A. Amazon DynamoDB
B. Amazon RDS
C. Amazon ElastiCache
D. Amazon S3
Answer: Amazon RDS
Rationale: Amazon RDS is a managed relational database service that handles
many administrative tasks such as provisioning, patching, backups, and
maintenance.
2. Which database engines are supported by Amazon RDS?
A. MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Db2
B. MongoDB, Cassandra, Redis, and Neo4j only
C. DynamoDB and Neptune only
D. Hadoop and Spark only
,Answer: MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Db2
Rationale: Amazon RDS supports several popular relational database engines,
allowing organizations to use familiar SQL-based technologies.
3. A company wants to run a MySQL database without managing the
underlying operating system. Which service should it use?
A. Amazon EC2
B. Amazon RDS for MySQL
C. Amazon S3
D. Amazon DynamoDB
Answer: Amazon RDS for MySQL
Rationale: RDS provides managed MySQL databases while AWS manages the
underlying infrastructure and many routine administrative tasks.
4. Which task is AWS generally responsible for when using Amazon RDS?
A. Writing application SQL queries
B. Managing the physical infrastructure
C. Designing database schemas
D. Creating database indexes
Answer: Managing the physical infrastructure
Rationale: AWS manages the underlying physical infrastructure, while
customers remain responsible for database configuration, schemas, queries, and
application-level requirements.
5. Which Amazon RDS feature provides automatic backups of a database?
A. Amazon CloudFront
B. Automated backups
C. AWS Artifact
D. Amazon Athena
,Answer: Automated backups
Rationale: Amazon RDS automated backups provide point-in-time recovery
capabilities during the configured backup retention period.
6. What is a key benefit of Amazon RDS Multi-AZ deployment?
A. It automatically converts relational databases into NoSQL databases
B. It provides high availability and automatic failover
C. It eliminates all database costs
D. It provides unlimited storage at no charge
Answer: It provides high availability and automatic failover
Rationale: Multi-AZ deployments maintain a standby database instance in
another Availability Zone and can automatically fail over when the primary
becomes unavailable.
7. A company requires a database that can automatically fail over to another
Availability Zone if the primary database fails. Which Amazon RDS feature
should it select?
A. Read replica
B. Multi-AZ deployment
C. Database migration task
D. Amazon S3 versioning
Answer: Multi-AZ deployment
Rationale: Multi-AZ is designed primarily for availability and failover rather than
read scaling.
8. What is the primary purpose of an Amazon RDS read replica?
A. Disaster recovery of the entire AWS account
B. Increasing read scalability
C. Encrypting database connections
D. Replacing database backups
, Answer: Increasing read scalability
Rationale: Read replicas asynchronously replicate data from a source database
and can serve read traffic, helping applications scale read-heavy workloads.
9. Which statement correctly compares RDS Multi-AZ deployments and read
replicas?
A. Both are primarily designed for the exact same purpose
B. Multi-AZ focuses on high availability, while read replicas primarily support read
scaling
C. Read replicas always provide synchronous replication
D. Multi-AZ deployments cannot use multiple Availability Zones
Answer: Multi-AZ focuses on high availability, while read replicas primarily
support read scaling
Rationale: The two features address different architectural requirements: Multi-
AZ improves availability and failover, while read replicas help distribute read
workloads.
10.Which Amazon RDS capability allows a database to be restored to a specific
point in time?
A. Point-in-time recovery
B. Amazon Inspector
C. AWS Shield
D. Route 53 failover routing
Answer: Point-in-time recovery
Rationale: Point-in-time recovery uses automated backups and transaction logs
to restore an RDS database to a selected time within the retention period.
11.Which AWS service is a managed NoSQL key-value and document
database?
