AWS Certified Solutions Architect – Associate (SAA-C02) — Question 138

A company decides to migrate its three-tier web application from on-premises to the AWS Cloud. The new database must be capable of dynamically scaling storage capacity and performing table joins.
Which AWS service meets these requirements?

Answer options

• A. Amazon Aurora
• B. Amazon RDS for SqlServer
• C. Amazon DynamoDB Streams
• D. Amazon DynamoDB on-demand

Correct answer: A

Explanation

Amazon Aurora is the correct choice as it is a relational database that allows for dynamic scaling and supports complex SQL queries, including table joins. In contrast, Amazon RDS for SqlServer is limited to SQL Server features, while both Amazon DynamoDB Streams and Amazon DynamoDB on-demand are NoSQL databases that do not support traditional table joins.