Your team has been tasked with the development of an application. The backend store needs to store data on which ad-hoc queries can run, and table joins are required. Which of the following would you use to host the underlying data store?

Answer options:

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

Answer – A
The AWS Documentation gives an example comparison of when to use AWS RDS for SQL data and DynamoDB for NoSQL data.
Option B is incorrect because this should not be used when you have table joins to be carried out.
Option C is incorrect because this is used for object level storage.
Option D is incorrect because this is used for querying data in S3.
For more information on when to use SQL over NoSQL, please refer to the below URL-
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SQLtoNoSQL.html