AWS Certified Solutions Architect Database Services and Migration 3 — Questions and Answers
Question 1: Which Amazon Aurora feature allows a single database cluster to span multiple AWS Regions with sub-second replication lag?
- Aurora Multi-AZ
- Aurora Cross-Region Read Replicas
- Aurora Global Database (Correct answer)
- Aurora Serverless v2
Correct answer: Aurora Global Database
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?
- Amazon RDS for MySQL
- Amazon DynamoDB
- Amazon Redshift (Correct answer)
- Amazon ElastiCache for Redis
Correct answer: Amazon Redshift
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?
- 3
- 5 (Correct answer)
- 10
- 15
Correct answer: 5
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?
- DynamoDB Streams
- DynamoDB On-Demand backups
- DynamoDB Point-in-Time Recovery (PITR) (Correct answer)
- DynamoDB Global Tables
Correct answer: DynamoDB Point-in-Time Recovery (PITR)
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?
- Data type mapping and ongoing replication
- Converting stored procedures, views, and schema objects to the target dialect (Correct answer)
- Encrypting data during transit between source and target
- Creating replication instances in the target VPC
Correct answer: Converting stored procedures, views, and schema objects to the target dialect
AWS SCT analyzes the source schema and converts database objects like tables, views, and stored procedures to the equivalent target database syntax.
Question 6: Which RDS feature enables automatic failover to a standby replica in a different Availability Zone with no data loss?
- RDS Read Replicas
- RDS Multi-AZ deployment (Correct answer)
- RDS Automated Backups
- RDS Enhanced Monitoring
Correct answer: RDS Multi-AZ deployment
RDS Multi-AZ keeps a synchronous standby replica in a different AZ and automatically fails over to it with no data loss during an outage.
Question 7: A company wants to use a managed graph database to store and query social network relationships. Which AWS service should they use?
- Amazon DynamoDB
- Amazon Neptune (Correct answer)
- Amazon DocumentDB
- Amazon Keyspaces
Correct answer: Amazon Neptune
Amazon Neptune is a fully managed graph database service that supports property graph and RDF models for relationship-heavy data.
AWS Certified Solutions Architect Database Services and Migration 3
Which Amazon Aurora feature allows a single database cluster to span multiple AWS Regions with sub-second replication lag?