AWS DevOps Engineer Professional DOP-C01 – Question426

You need to perform ad-hoc business analytics queries on well-structured data. Data comes in constantly at a high velocity. Your business intelligence team can understand SQL. What AWS service(s) should you look to first?

A. Kinesis Firehose + RDS
B. Kinesis Firehose + RedShift
C. EMR using Hive
D. EMR running Apache Spark

Correct Answer: B

Explanation:

Explanation:
Kinesis Firehose provides a managed service for aggregating streaming data and inserting it into RedShift.
RedShift also supports ad-hoc queries over well-structured data using a SQL-compliant wire protocol, so the business team should be able to adopt this system easily.
Reference:
https://aws.amazon.com/kinesis/firehose/details/