Company: Trainocate
Difficulty: medium
Amazon Athena Features From the options provided below, which two statements correctly describe the features or functionalities of Amazon Athena? A. Amazon Athena uses a variety of query languages including SQL, LDAP, JPQL as well as CQL. B. Amazon Athena queries data directly from Amazon S3. C. Amazon Athena is not suitable for complex analysis such as large joins, window functions and arrays. D. Amazon Athena resources are allocated in accordance to processing and memory requirements prior to deployment. E. Amazon Athena is compatible with data formats such as CSV, JSON, ORC, AVRO and Parquet. Name the two options that are correct, and briefly explain why each of the remaining options is wrong.