Which interactive query service processes and analyzes streaming data using standard SQL?

• A. Amazon Kinesis Data Streams
• B. Amazon Kinesis Data Analytics
• C. AWS Glue
• D. Amazon MSK

Answer: (B)

Streaming data can be analyzed in real time by a service that lets you write standard SQL and have it continuously run against an ongoing data stream. That capability is provided by Amazon Kinesis Data Analytics. It connects to streaming sources like Kinesis Data Streams or Kinesis Data Firehose and lets you express what you want to compute with familiar SQL—filters, aggregations, windowed calculations, and more—and the engine executes those queries as data flows, producing results on the fly.

This differs from simply ingesting data or batch ETL. Ingest-only services like Kinesis Data Streams handle the movement of data but don’t offer SQL-based analytics. AWS Glue focuses on ETL and batch processing (and has streaming capabilities in some contexts, but its primary role isn’t continuous SQL streaming analytics). Amazon MSK provides a managed Kafka cluster for building streaming applications, not an SQL-based analytics layer. So the service that processes and analyzes streaming data using standard SQL is Amazon Kinesis Data Analytics.