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 DataSync with Amazon S3

Answer

AWS Snowball with AWS Import/Export

Answer

AWS Direct Connect with manual export/import

Question 2

Which Amazon RDS feature automatically distributes read traffic across multiple database replicas?

Accepted Answer

Aurora Reader Endpoint

Answer

RDS Multi-AZ

Answer

RDS Read Replicas with a custom load balancer

Answer

RDS Proxy

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

DynamoDB Streams

Answer

Eventually consistent reads

Answer

DynamoDB Accelerator (DAX)

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 MemoryDB for Redis

Answer

Amazon ElastiCache for Memcached

Answer

Amazon DynamoDB Accelerator (DAX)

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

Amazon RDS for PostgreSQL with Multi-AZ

Answer

Amazon Redshift Serverless

Answer

Amazon RDS Proxy with scheduled scaling

Question 6

When using AWS DMS to migrate data, what is the purpose of a replication instance?

Accepted Answer

It provides the compute resources to run replication tasks

Answer

It stores the migrated data permanently

Answer

It converts the database schema to the target format

Answer

It monitors the migration and sends CloudWatch alerts

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?

Accepted Answer

Amazon ElastiCache for Redis

Answer

Amazon DynamoDB

Answer

Amazon Redshift

Answer

Amazon Aurora Global Database