DEA-C01 Question 182
Single answerA data engineering team is building a data lake for an e-commerce platform. They need to store clickstream data from their website, which will be ingested continuously and queried occasionally for analytics. The queries typically involve aggregations over large datasets, and the team wants to minimize storage costs while ensuring scalability for their analytics workflows. Which storage solution is the most appropriate for this use case?
- A
Amazon S3 with the S3 Standard storage class
- B
Amazon S3 with the S3 Intelligent-Tiering storage class
- C
Amazon DynamoDB
- D
Amazon RDS with PostgreSQL
Show answer and explanation
Correct answer: B
Explanation
The clickstream data in this scenario is ingested continuously but queried only occasionally, making cost-efficiency a key consideration. Amazon S3 with the S3 Intelligent-Tiering storage class is the optimal solution because it minimizes storage costs by automatically transitioning data between access tiers based on usage patterns. Additionally, Amazon S3 integrates well with analytical tools like Amazon Athena and Amazon Redshift Spectrum, making it ideal for large-scale analytics workloads.
- A. Incorrect.
Amazon S3 with the S3 Standard storage class is suitable for frequently accessed data, but it may not be cost-efficient for data that is accessed occasionally, like clickstream data in this scenario.
- B. Correct.
Amazon S3 with the S3 Intelligent-Tiering storage class automatically moves data between access tiers based on usage patterns, making it cost-efficient for infrequently accessed data while still supporting large-scale analytics workflows. This matches the use case described.
- C. Incorrect.
Amazon DynamoDB is a NoSQL database optimized for low-latency read and write operations, but it is not well-suited for storing large-scale, infrequently queried datasets like clickstream data.
- D. Incorrect.
Amazon RDS with PostgreSQL is a relational database that is more appropriate for structured transactional data rather than large-scale, unstructured, or semi-structured data like clickstream data.