0 votes
in AWS by

A company has hired you for its on-going development project. The project entails streaming data onto Amazon Kinesis streams from various log sources.

You need to analyze real-time data using standard SQL. Which of the following can be used for this purpose?

1 Answer

0 votes
by

Answer - B.

Option A is incorrect since it delivers real-time streaming data to destinations such as Amazon Simple Storage Service.

This is mentioned in the AWS Documentation.

With Amazon Kinesis Data Analytics, you can process and analyze streaming data using standard SQL.

The service enables you to quickly author and run powerful SQL code against streaming sources to perform time-series analytics, feed real-time dashboards, and create real-time metrics.

Option A is incorrect since it delivers real-time streaming data to destinations such as Amazon Simple Storage Service.

Option C is incorrect since this is used to make it easy to analyze data directly in Amazon Simple Storage Service (Amazon S3) using standard SQL.

Option D is incorrect since this is used as a fully managed service for Big Data.

For more information on Kinesis Data Analytics, please visit the following URL-

https://docs.aws.amazon.com/kinesisanalytics/latest/dev/what-is.html

The correct answer to the question is B. Amazon Kinesis Data Analytics.

Amazon Kinesis is a platform for real-time streaming data on AWS. It can be used to ingest and process large amounts of data in real-time from various sources such as web applications, mobile devices, IoT devices, and log files.

Amazon Kinesis Data Analytics is a service that allows you to analyze streaming data with SQL queries. It provides an easy-to-use interface for querying streaming data using standard SQL statements. With Kinesis Data Analytics, you can easily analyze, process, and transform real-time data streams, and gain insights from the data.

Amazon Kinesis Firehose is a service that allows you to load streaming data into data stores and analytics tools. It is designed to be a simple way to move data from Kinesis streams to other services such as Amazon S3, Redshift, and Elasticsearch. However, Firehose does not provide the ability to analyze data with SQL.

Amazon Athena is a service that allows you to run ad-hoc SQL queries against data stored in Amazon S3. Athena is designed for interactive analysis of large datasets and provides a SQL-like interface for querying data. However, Athena is not specifically designed for real-time streaming data and may not be the best option for analyzing real-time data.

Amazon EMR (Elastic MapReduce) is a managed service that allows you to run big data frameworks such as Hadoop, Spark, and Hive on AWS. EMR is designed for batch processing of large datasets and is not optimized for real-time streaming data analysis.

In summary, Amazon Kinesis Data Analytics is the best option for analyzing real-time data with SQL queries. It provides a simple and easy-to-use interface for querying streaming data and gaining insights from the data.

...