AWS Certified Solutions Architect Database Services and Migration 2 — Questions and Answers
Question 1: A company needs to migrate a 10 TB Oracle database to AWS with minimal downtime. Which service combination is most appropriate?
- AWS Database Migration Service (DMS) with AWS Schema Conversion Tool (SCT) (Correct answer)
- AWS DataSync with Amazon S3
- AWS Snowball with AWS Import/Export
- AWS Direct Connect with manual export/import
Correct answer: AWS Database Migration Service (DMS) with AWS Schema Conversion Tool (SCT)
AWS DMS handles ongoing replication while SCT converts schema objects from Oracle to the target AWS database engine.
Question 2: Which Amazon RDS feature automatically distributes read traffic across multiple database replicas?
- RDS Multi-AZ
- RDS Read Replicas with a custom load balancer
- RDS Proxy
- Aurora Reader Endpoint (Correct answer)
Correct answer: Aurora Reader Endpoint
Aurora's reader endpoint automatically load-balances connections across all Aurora Replicas in the cluster.
Question 3: A solutions architect needs to store session state for a highly available web application. Which DynamoDB feature ensures that reads always reflect the latest write?
- DynamoDB Streams
- Eventually consistent reads
- Strongly consistent reads (Correct answer)
- DynamoDB Accelerator (DAX)
Correct answer: Strongly consistent reads
Strongly consistent reads in DynamoDB return the most up-to-date data, reflecting all writes that received a successful response.
Question 4: Which AWS service provides a fully managed, Redis-compatible in-memory data store that supports cluster mode?
- Amazon MemoryDB for Redis
- Amazon ElastiCache for Memcached
- Amazon ElastiCache for Redis (Correct answer)
- Amazon DynamoDB Accelerator (DAX)
Correct answer: Amazon ElastiCache for Redis
Amazon ElastiCache for Redis supports cluster mode enabled, allowing data to be sharded across multiple shards for scalability.
Question 5: A company is running a PostgreSQL database and wants to reduce costs by automatically pausing the database during inactivity. Which option supports this?
- Amazon RDS for PostgreSQL with Multi-AZ
- Aurora Serverless v2 (Correct answer)
- Amazon Redshift Serverless
- Amazon RDS Proxy with scheduled scaling
Correct answer: Aurora Serverless v2
Aurora Serverless v2 automatically scales capacity and can be configured to pause during periods of inactivity to reduce costs.
Question 6: When using AWS DMS to migrate data, what is the purpose of a replication instance?
- It stores the migrated data permanently
- It provides the compute resources to run replication tasks (Correct answer)
- It converts the database schema to the target format
- It monitors the migration and sends CloudWatch alerts
Correct answer: It provides the compute resources to run replication tasks
A DMS replication instance is an EC2 instance that hosts the replication engine and performs the actual data movement between source and target.
Question 7: A company wants to implement database caching to reduce RDS load. DAX is not suitable because the application uses complex SQL joins. Which service should be used?
- Amazon DynamoDB
- Amazon ElastiCache for Redis (Correct answer)
- Amazon Redshift
- Amazon Aurora Global Database
Correct answer: Amazon ElastiCache for Redis
Amazon ElastiCache for Redis can cache query results from relational databases, reducing load on RDS for complex SQL workloads.
AWS Certified Solutions Architect Database Services and Migration 2
A company needs to migrate a 10 TB Oracle database to AWS with minimal downtime.
Which service combination is most appropriate?