SAA-C03 Question 249
Single answerA company is migrating an on-premises application to AWS. The application needs to store large amounts of structured data and requires high availability, scalability, and the ability to run complex queries. Which AWS service is the most suitable for this use case?
- A
Amazon RDS
- B
Amazon DynamoDB
- C
Amazon Redshift
- D
Amazon S3
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS is the most appropriate choice because it is a managed relational database service that supports structured data, high availability, scalability, and complex SQL queries, which are all requirements for the company's application. Other options like DynamoDB, Redshift, and S3 do not meet all the criteria for this specific use case.
- A. Correct.
Amazon RDS is a managed relational database service suitable for applications that require structured data, high availability, scalability, and support for complex SQL queries. It meets the needs of the described application.
- B. Incorrect.
Amazon DynamoDB is a NoSQL database service designed for key-value and document-based applications. While it is highly scalable and available, it is not ideal for running complex queries involving relationships and joins between tables.
- C. Incorrect.
Amazon Redshift is a data warehousing solution optimized for analytics and reporting on large datasets. It is not intended for transactional workloads or applications that require real-time complex queries.
- D. Incorrect.
Amazon S3 is an object storage service designed for storing and retrieving unstructured data. It does not support structured data storage or complex querying requirements.