CLF-C02 Question 251
Select 2A retail company wants to analyze large volumes of transactional data in near real-time to track purchasing trends. They also require a service to perform ad hoc SQL queries on their data stored in Amazon S3 without needing to set up a database. Which combination of AWS services can best address these requirements?
- A
Amazon Kinesis Data Streams
- B
Amazon Athena
- C
AWS Glue
- D
Amazon QuickSight
- E
Amazon Redshift
Show answer and explanation
Correct answers: A, B
Explanation
To meet the requirements of analyzing large volumes of transactional data in near real-time and performing ad hoc SQL queries on S3 without managing a database, the combination of Amazon Kinesis Data Streams and Amazon Athena is the most suitable solution. Kinesis handles the real-time data streaming, while Athena provides the ability to query data stored in S3 using SQL.
- A. Correct.
Amazon Kinesis Data Streams is designed for real-time data streaming, which allows the company to analyze transactional data in near real-time. This fits the requirement for tracking purchasing trends.
- B. Correct.
Amazon Athena is a serverless service that enables users to perform ad hoc SQL queries directly on data stored in Amazon S3 without needing to set up or manage a database. This addresses the requirement for querying data in S3.
- C. Incorrect.
AWS Glue is primarily used for ETL (Extract, Transform, Load) processes and building data catalogs; while useful, it is not directly suited for real-time data streaming or ad hoc SQL querying.
- D. Incorrect.
Amazon QuickSight is a business intelligence tool for data visualization and reporting, not for real-time data streaming or querying data in S3.
- E. Incorrect.
Amazon Redshift is a data warehouse service that is more suitable for large-scale, structured analytics workloads rather than ad hoc SQL queries on S3 or real-time streaming.