AWS Certified Solutions Architect Database Services and Migration 3

Question 1

Which Amazon Aurora feature allows a single database cluster to span multiple AWS Regions with sub-second replication lag?

Accepted Answer

Aurora Global Database

Answer

Aurora Global Database replicates data across up to five secondary AWS Regions with typically less than one second of replication lag.

Question 2

A company needs to analyze clickstream data and run complex analytical queries on petabytes of data. Which AWS database service is most appropriate?

Accepted Answer

Amazon Redshift

Answer

Amazon Redshift is a fully managed data warehouse optimized for OLAP workloads and petabyte-scale analytical queries.

Question 3

What is the maximum number of Read Replicas supported by Amazon RDS for MySQL?

Accepted Answer

5

Answer

Amazon RDS for MySQL supports up to 5 Read Replicas per DB instance to distribute read traffic.

Question 4

A solutions architect needs to enable point-in-time recovery for a DynamoDB table. Which feature must be enabled?

Accepted Answer

DynamoDB Point-in-Time Recovery (PITR)

Answer

DynamoDB PITR continuously backs up table data and allows restoration to any point within the last 35 days.

Question 5

During a heterogeneous database migration using AWS DMS, what does AWS Schema Conversion Tool (SCT) handle?

Accepted Answer

Converting stored procedures, views, and schema objects to the target dialect

Answer

AWS SCT analyzes the source schema and converts database objects like tables, views, and stored procedures to the equivalent target database syntax.

AWS Practice Test