Which of the following statements regarding Amazon Athena are accurate? Select TWO.
Click on the arrows to vote for the correct answer
A. B. C. D. E.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.htmlOption 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.
The correct statements regarding Amazon Athena are A and D.
A) Amazon Athena queries data directly from Amazon S3 and there are no additional data storage commitments beyond the object storage.
Amazon Athena is a serverless interactive query service that allows users to analyze data stored in Amazon S3 using SQL. Athena uses S3 as its underlying data store, and queries data directly from S3. This means that there are no additional data storage commitments beyond the object storage in S3. Users are only charged for the amount of data scanned by their queries, making Athena a cost-effective option for ad-hoc querying of large datasets.
D) Amazon Athena is compatible with data formats such as CSV, JSON, ORC, AVRO and Parquet
Amazon Athena supports a variety of data formats, including CSV, JSON, ORC, AVRO, and Parquet. This means that users can store their data in the format that best suits their needs, and then query it using Athena's SQL interface. Athena also supports nested data types and arrays, making it easy to query semi-structured data.
B) Amazon Athena is not suitable for complex analysis such as large joins, window functions and arrays.
This statement is incorrect. Amazon Athena is designed to handle complex queries, including large joins, window functions, and arrays. It uses a distributed SQL engine that scales automatically to handle large datasets and complex queries. However, the performance of Athena queries can be impacted by the size and complexity of the data, so it is important to optimize queries and use appropriate partitioning and compression techniques.
C) Amazon Athena resources are allocated in accordance to processing and memory requirements prior to deployment.
This statement is also incorrect. Amazon Athena is a serverless service, which means that users do not need to provision or manage any resources. Athena automatically scales up or down to handle the workload, and users are only charged for the amount of data scanned by their queries. However, users can specify certain parameters for their queries, such as the amount of memory to use for sorting and the maximum number of concurrent queries.
E) Amazon Athena uses a variety of query languages including SQL, LDAP, JPQL as well as CQL.
This statement is also incorrect. Amazon Athena uses only one query language, which is SQL. It does not support LDAP, JPQL, or CQL.