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?
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/
A.
Kinesis Firehose + RDS
B.
Kinesis Firehose + RedShift
C.
EMR using Hive
D.
EMR running Apache Spark
Explanation:
Explanation/Reference:
Kinesis Firehose provides a managed service for aggregating streaming data and inserting it into RedShift. RedShift also