What AWS service(s) should you look to first?

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?

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/

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

Sam T

Sam T

B – yes high velocity to Sql Analysis system (RedShift) use Kinesis Firehose

Reply

James

James

B
The question is related to a topic of online analytical processing (OLAP) system, and RedShift is the AWS’ implementation of OLAP. AWS uses too many things of “Word Games,” such as Cognito, FireHose, and Snowball, etc.. If so confined itself as part of non-standard “Open Sources,” lacking something of science, it is OK.

Reply