You are a developer who has been hired to lead the development of a new application. The application needs to interact with a backend data-store. The application also needs to perform many complex join operations. Which of the following would be the ideal data-store option? (Select Two)

Answer options:

A.AWS DynamoDB
B.AWS RDS
C.AWS Redshift
D.AWS S3

Answer – B and C
Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks. Since you need complex query design, it is better to choose one of the available relational database services.
Amazon Redshift is an Internet hosting service and data warehouse product that forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing data warehouse company ParAccel, to handle large scale data sets and database migrations.
Both of the options above support complex joins.
Option A is incorrect since AWS DynamoDB does not support complex joins.
Option D is incorrect since this is used for Object-level storage.
For more information on AWS RDS, please refer to the below URL-
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Welcome.html
For more information on AWS Redshift-
https://aws.amazon.com/redshift/