A retail organization is developing a data lake solution utilizing Amazon S3 to store a large amount of data.The solution must be accessible via SQL queries.The organization wants to minimize infrastructure costs.What AWS service should be part of their solution?

Answer options:

A.Amazon DynamoDB
B.Amazon Redshift Spectrum
C.Amazon Aurora
D.Amazon Athena

Answer: D
Option A is incorrect because DynamoDB is not accessible via SQL queries.
Option B is incorrect because it is not the most optimal solution. Amazon Redshift Spectrum requires an Amazon Redshift cluster, thus requiring additional infrastructure costs.
Option C is incorrect because Amazon Aurora requires infrastructure to store the data.
Option D is CORRECT because Amazon Athena can be used to query data in S3 directly using SQL query syntax.It is also a serverless service requiring no infrastructure.
Reference:
https://docs.aws.amazon.com/athena/latest/ug/what-is.html