AWS Certified Solutions Architect Database Services and Migration 2

Question 1

A company needs to migrate a 10 TB Oracle database to AWS with minimal downtime. Which service combination is most appropriate?

Accepted Answer

AWS Database Migration Service (DMS) with AWS Schema Conversion Tool (SCT)

Answer

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?

Accepted Answer

Aurora Reader Endpoint

Answer

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?

Accepted Answer

Strongly consistent reads

Answer

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?

Accepted Answer

Amazon ElastiCache for Redis

Answer

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?

Accepted Answer

Aurora Serverless v2

Answer

Aurora Serverless v2 automatically scales capacity and can be configured to pause during periods of inactivity to reduce costs.

AWS Practice Test

AWS Practice Test

AWS Certified Solutions Architect Database Services and Migration 2