AWS - Certified Solutions Architect Database Services and Migration Questions and Answers

Question 1

A company is planning to migrate a 10TB on-premises Oracle database to Amazon Aurora PostgreSQL.
The migration must be completed with minimal downtime.
The source database contains numerous stored procedures and functions specific to Oracle's PL/SQL.
What is the correct sequence of actions using AWS services to achieve this migration?

Accepted Answer

Use the AWS Schema Conversion Tool (SCT) to convert the schema and code objects, then use AWS Database Migration Service (DMS) to migrate the data.

Answer

Use AWS Snowball Edge to transport the data, then use AWS DMS to apply ongoing changes.

Answer

Use AWS DMS for a full load and ongoing replication, and manually convert the schema at the target.

Answer

Use AWS Backup to create a backup of the on-premises database and restore it to an Aurora cluster.

Question 2

A popular e-commerce website uses an Amazon RDS for MySQL database. During peak shopping events, the website experiences slow performance due to a high volume of read traffic, which impacts the primary database's ability to handle write operations. The company needs a solution to improve read performance and offload queries from the primary database instance. Which RDS feature is specifically designed to address this requirement?

Accepted Answer

Creating Read Replicas

Answer

Enabling Multi-AZ deployment

Answer

Increasing the RDS instance size (vertical scaling)

Answer

Switching to Provisioned IOPS (PIOPS) storage

Question 3

A development team is building a new mobile gaming application that requires a database for storing player scores and session data. The application needs extremely low latency (single-digit milliseconds) for both reads and writes, and it must scale seamlessly to handle millions of users with unpredictable traffic patterns. Which AWS database service is the most appropriate choice for this use case?

Accepted Answer

Amazon DynamoDB

Answer

Amazon RDS for PostgreSQL with Multi-AZ

Answer

Amazon Redshift

Answer

Amazon S3

Question 4

A financial services company is running a critical OLTP application on Amazon RDS for MySQL. They are looking to improve performance, scalability, and availability beyond what standard RDS offers. They want a solution that is MySQL-compatible, provides significantly higher throughput, and has a self-healing, fault-tolerant storage architecture distributed across three Availability Zones. Which AWS database service should they migrate to?

Accepted Answer

Amazon Aurora

Answer

Amazon RDS for SQL Server

Answer

Amazon ElastiCache for Redis

Answer

Amazon DynamoDB with Global Tables

Question 5

An application is built on Amazon EC2 instances with an Amazon RDS for PostgreSQL database as its backend. Performance monitoring reveals that the database is under heavy load due to a large number of repetitive read queries for frequently accessed data, such as user profiles and product catalogs. This is causing high latency for all users. What is the most effective way to improve application latency by reducing the load on the RDS database?

Accepted Answer

Implement Amazon ElastiCache to serve as an in-memory cache.

Answer

Implement Amazon CloudFront to cache the data at the edge.

Answer

Increase the provisioned IOPS of the RDS database's storage.

Answer

Create more RDS Read Replicas.

Question 6

Which of the following BEST describes the primary distinction between an Amazon RDS Multi-AZ deployment and an RDS Read Replica?

Accepted Answer

Multi-AZ provides high availability via a standby instance for failover, while a Read Replica provides read scalability.

Answer

Multi-AZ uses asynchronous replication for scalability, while a Read Replica uses synchronous replication for durability.

Answer

Multi-AZ is primarily for disaster recovery in another region, while a Read Replica is for high availability in another AZ.

Answer

A Multi-AZ standby instance can be used for read operations, while a Read Replica cannot.