CLF-C02 Database Services 3 — Questions and Answers
Question 1: What type of database is Amazon DynamoDB?
- Relational SQL database
- Graph database
- NoSQL key-value and document database (Correct answer)
- Columnar data warehouse
Correct answer: NoSQL key-value and document database
DynamoDB is a fully managed NoSQL database service that supports both key-value and document data models.
Question 2: Which Amazon RDS feature automatically creates a standby replica in a different Availability Zone to provide failover support?
- Read Replicas
- Multi-AZ Deployment (Correct answer)
- Aurora Global Database
- RDS Proxy
Correct answer: Multi-AZ Deployment
RDS Multi-AZ Deployment maintains a synchronous standby replica in another AZ and automatically fails over if the primary instance fails.
Question 3: A developer wants to offload database connection management to reduce overhead on an Amazon RDS instance. Which service helps?
- Amazon ElastiCache
- AWS Lambda
- Amazon RDS Proxy (Correct answer)
- AWS Glue
Correct answer: Amazon RDS Proxy
Amazon RDS Proxy pools and manages database connections, reducing overhead and improving application scalability.
Question 4: What is the primary use case for Amazon Redshift?
- Running transactional OLTP workloads
- Storing document data for web apps
- Performing large-scale data analytics and business intelligence (Correct answer)
- Caching frequently accessed data
Correct answer: Performing large-scale data analytics and business intelligence
Amazon Redshift is a petabyte-scale data warehouse designed for OLAP queries and business intelligence workloads.
Question 5: Which AWS service provides a fully managed ledger database with an immutable, cryptographically verifiable transaction log?
- Amazon QLDB (Correct answer)
- Amazon DynamoDB
- Amazon RDS
- Amazon Timestream
Correct answer: Amazon QLDB
Amazon QLDB (Quantum Ledger Database) maintains an immutable journal of all data changes, making it ideal for compliance-sensitive applications.
Question 6: How does Amazon RDS Read Replicas differ from Multi-AZ Deployments?
- Read Replicas provide automatic failover; Multi-AZ improves read performance
- Read Replicas are used for disaster recovery; Multi-AZ is for analytics
- Read Replicas improve read scalability; Multi-AZ provides high availability with automatic failover (Correct answer)
- Read Replicas sync data synchronously; Multi-AZ syncs asynchronously
Correct answer: Read Replicas improve read scalability; Multi-AZ provides high availability with automatic failover
Read Replicas scale read traffic asynchronously, while Multi-AZ maintains a synchronous standby for automatic failover.
Question 7: Which AWS database service is MongoDB-compatible and fully managed?
- Amazon Neptune
- Amazon QLDB
- Amazon DocumentDB (Correct answer)
- Amazon Keyspaces
Correct answer: Amazon DocumentDB
Amazon DocumentDB is a fully managed document database service that is compatible with MongoDB workloads and drivers.
CLF-C02 Database Services 3
What type of database is Amazon DynamoDB?