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
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.
https://aws.amazon.com/kinesis/firehose/details/