DAS-C01 · Question #30
A financial services company needs to aggregate daily stock trade data from the exchanges into a data store. The company requires that data be streamed directly into the data store, but also…
The correct answer is C. Use Amazon Kinesis Data Firehose to stream data to Amazon Redshift. Use Amazon Redshift as. Amazon Kinesis Data Firehose can stream data directly into Amazon Redshift without manual consumer management, satisfying the real-time ingestion requirement. Redshift supports SQL for data modifications, handles complex analytic queries with low latency, and integrates…
Question
A financial services company needs to aggregate daily stock trade data from the exchanges into a data store. The company requires that data be streamed directly into the data store, but also occasionally allows data to be modified using SQL. The solution should integrate complex, analytic queries running with minimal latency. The solution must provide a business intelligence dashboard that enables viewing of the top contributors to anomalies in stock prices. Which solution meets the company's requirements?
Options
- AUse Amazon Kinesis Data Firehose to stream data to Amazon S3. Use Amazon Athena as a data
- BUse Amazon Kinesis Data Streams to stream data to Amazon Redshift. Use Amazon Redshift as
- CUse Amazon Kinesis Data Firehose to stream data to Amazon Redshift. Use Amazon Redshift as
- DUse Amazon Kinesis Data Streams to stream data to Amazon S3. Use Amazon Athena as a data
How the community answered
(32 responses)- A9% (3)
- B16% (5)
- C72% (23)
- D3% (1)
Explanation
Amazon Kinesis Data Firehose can stream data directly into Amazon Redshift without manual consumer management, satisfying the real-time ingestion requirement. Redshift supports SQL for data modifications, handles complex analytic queries with low latency, and integrates natively with Amazon QuickSight for BI dashboards - meeting all stated requirements. Kinesis Data Streams to S3 with Athena (options A and D) would introduce higher query latency. Kinesis Data Streams to Redshift (option B) requires building a consumer application, adding complexity. Firehose-to-Redshift is the fully managed, end-to-end solution here.
Topics
Community Discussion
No community discussion yet for this question.