A team is currently making use of Kinesis streams for streaming web clicks for an application. There is now a requirement to enable a data analyst team to perform SQL queries on the live data for analytical purposes. Which of the following can be added to the architecture to achieve this requirement?

Answer options:

A.Create an EMR Cluster with Spark. Stream the data from Kinesis streams to Spark. Use Spark to perform the queries.
B.Use the KCL library to directly perform the SQL queries on the incoming data
C.Embed the SQL queries while developing the application using the KPL Library.
D.Use the Data Pipeline service to transfer the data to AWS RDS. Use normal SQL queries for the analysis.

Answer – A
An example of this is given in the AWS documentation
Options B and C are incorrect as these do not give dynamic options for using SQL queries for analysis
Option D is incorrect since AWS RDS should be used to host OLTP database
For more information on this use case, please refer to the below URL
https://aws.amazon.com/blogs/big-data/querying-amazon-kinesis-streams-directly-with-sql-and-spark-streaming/