Question

A large amount of structured data is stored in Amazon S3 using the JSON format. You need to use a service to analyze the S3 data directly with standard SQL. In the meantime, the data should be easily visualized through data dashboards. Which of the following services is the most appropriate?

A. Amazon Athena and Amazon QuickSight

B. AWS Glue and Amazon Athena

C. AWS Glue and Amazon QuickSight

D. Amazon Kinesis Data Stream and Amazon QuickSight

Answer 1

A. Amazon Athena and Amazon QuickSight

Answer: A

Explanation

Option​ ​A ​is​ CORRECT because Amazon Athena is the most suitable to run ad-hoc queries to analyze data in S3. Amazon Athena is serverless, and you are charged for the amount of scanned data. Besides, Athena can integrate with Amazon QuickSight that visualizes the data via dashboards.

Option​ ​B ​is​ ​incorrect because AWS Glue is an ETL (extract, transform, and load) service that organizes, cleanses, validates, and formats data in a data warehouse. This service is not required in this scenario.

Option​ ​C ​is​ ​incorrect because it is the same as Option B. AWS Glue is not required.

Option​ ​D ​is​ ​incorrect because, with Amazon Kinesis Data Stream, users cannot perform queries for the S3 data through standard SQL.