CLF-C02 Database Services 2 — Questions and Answers
Question 1: Which AWS database service is best suited for storing and querying highly connected data, such as social network relationships?
- Amazon RDS
- Amazon Neptune (Correct answer)
- Amazon DynamoDB
- Amazon Redshift
Correct answer: Amazon Neptune
Amazon Neptune is a fully managed graph database service designed for highly connected datasets like social networks.
Question 2: A company needs a fully managed in-memory caching service to reduce database load. Which AWS service should they use?
- Amazon RDS
- Amazon DynamoDB Accelerator (DAX)
- Amazon ElastiCache (Correct answer)
- Amazon Aurora
Correct answer: Amazon ElastiCache
Amazon ElastiCache is a fully managed in-memory caching service supporting Redis and Memcached to improve application performance.
Question 3: Which feature of Amazon Aurora makes it different from standard MySQL or PostgreSQL?
- It is a NoSQL database
- It stores data in S3 buckets directly
- It automatically replicates data across 3 Availability Zones with 6 copies (Correct answer)
- It requires manual backups
Correct answer: It automatically replicates data across 3 Availability Zones with 6 copies
Aurora automatically replicates data six times across three Availability Zones, providing high availability and durability.
Question 4: What is Amazon DynamoDB Accelerator (DAX) primarily used for?
- Running complex SQL queries on DynamoDB
- Providing microsecond read latency for DynamoDB tables (Correct answer)
- Automatically scaling DynamoDB write capacity
- Migrating data from RDS to DynamoDB
Correct answer: Providing microsecond read latency for DynamoDB tables
DAX is an in-memory cache for DynamoDB that delivers microsecond response times for read-heavy workloads.
Question 5: Which AWS service would you use to migrate an on-premises Oracle database to Amazon Aurora with minimal downtime?
- AWS Snowball
- AWS Database Migration Service (DMS) (Correct answer)
- Amazon S3 Transfer Acceleration
- AWS DataSync
Correct answer: AWS Database Migration Service (DMS)
AWS DMS enables continuous data replication from source to target databases, minimizing downtime during migration.
Question 6: A startup needs a serverless database that scales automatically and charges only for actual usage. Which service fits best?
- Amazon RDS Multi-AZ
- Amazon Aurora Serverless (Correct answer)
- Amazon Redshift
- Amazon DocumentDB
Correct answer: Amazon Aurora Serverless
Amazon Aurora Serverless automatically starts, scales, and shuts down based on application demand, charging only for consumed capacity.
Question 7: Which AWS database service is designed specifically for time-series data such as IoT sensor readings?
- Amazon RDS
- Amazon Timestream (Correct answer)
- Amazon Neptune
- Amazon QLDB
Correct answer: Amazon Timestream
Amazon Timestream is a purpose-built time-series database for collecting and analyzing data that changes over time, like IoT metrics.
CLF-C02 Database Services 2
Which AWS database service is best suited for storing and querying highly connected data, such as social network relationships?