Which service provides streaming data analytics using SQL for real-time queries on data streams?

• A. Amazon Kinesis Data Streams
• B. Amazon Kinesis Data Analytics
• C. AWS Data Exchange
• D. Amazon EMR

Answer: (B)

The scenario tests real-time analytics on streaming data using SQL. Amazon Kinesis Data Analytics is designed precisely for this: it runs continuous SQL queries against streaming data, allowing you to define SELECTs with windows and aggregations so results are produced as data arrives. It can ingest from Kinesis Data Streams or Firehose and output to destinations like another stream, S3, or dashboards, all without managing infrastructure.

The other options don’t fit as the primary streaming SQL analytics service. A streaming data streams service handles ingestion but not real-time SQL analytics by itself. AWS Data Exchange is about sharing data between parties, not analyzing streams. EMR can perform big data processing and can run Spark SQL for streaming workloads, but it’s a general-purpose cluster-based solution rather than a dedicated real-time SQL streaming analytics service.