Which of the following statements regarding Amazon Athena are accurate? Select TWO.

Answer options:

A.Amazon Athena queries data directly from Amazon S3 and there are no additional data storage commitments beyond the object storage.
B.Amazon Athena is not suitable for complex analysis such as large joins, window functions and arrays.
C.Amazon Athena resources are allocated in accordance to processing and memory requirements prior to deployment.
D.Amazon Athena is compatible with data formats such as CSV, JSON, ORC, AVRO and Parquet
E.Amazon Athena uses a variety of query languages including SQL, LDAP, JPQL as well as CQL.

Correct Answer – A, D
Amazon Athena a serverless query service that does not need to build databases on dedicated Elastic Block Store (EBS) volumes. Instead, it builds tables from data read directly from Amazon S3 buckets. Amazon Athena does not store any of the data. The service is compatible with the regular data formats that include CSV, JSON, ORC, AVRO and Parquet.
https://docs.aws.amazon.com/athena/latest/ug/what-is.html
Option B is incorrect because Amazon Athena can query Big Data, complex analysis such as large joins, window functions and arrays.
Option C is incorrect because Amazon Athena is serverless. Thus the service scales following the resource demands. No prior resource planning is necessary.
Option E is incorrect because Amazon Athena uses SQL only.