SAA-C03 · Question #410
SAA-C03 Question #410: Real Exam Question with Answer & Explanation
The correct answer is D: Use Amazon Data Firehose to ingest the data to save it to Amazon S3. Load frequently queried. The most cost-effective way to provide consistent SQL query performance on a heavily structured dataset, where some data is accessed more frequently, is to use Amazon Redshift as your main data warehouse for hot data and Amazon Redshift Spectrum to query cold data that remains in
Question
A company needs to collect streaming data from several sources and store the data in the AWS Cloud. The dataset is heavily structured, but analysts need to perform several complex SQL queries and need consistent performance. Some of the data is queried more frequently than the rest. The company wants a solution that meets its performance requirements in a cost-effective manner. Which solution meets these requirements?
Options
- AUse Amazon Managed Streaming for Apache Kafka (Amazon MSK) to ingest the data to save it
- BUse Amazon Managed Streaming for Apache Kafka (Amazon MSK) to ingest the data to save it
- CUse Amazon Data Firehose to ingest the data to save it to Amazon Redshift. Enable Amazon
- DUse Amazon Data Firehose to ingest the data to save it to Amazon S3. Load frequently queried
Explanation
The most cost-effective way to provide consistent SQL query performance on a heavily structured dataset, where some data is accessed more frequently, is to use Amazon Redshift as your main data warehouse for hot data and Amazon Redshift Spectrum to query cold data that remains in S3. With this approach, frequently queried data is loaded into Redshift for fast, consistent querying, while infrequently accessed data is left in S3 and accessed on demand via Spectrum, avoiding unnecessary data warehousing costs. Amazon Kinesis Data Firehose provides an easy and scalable way to ingest streaming data directly to both S3 and Redshift.
Community Discussion
No community discussion yet for this question.