DEA-C01 Question 184
Select 2A data engineering team is designing a data storage solution for a financial analytics platform. The platform requires real-time access to high-frequency transactional data for analysis, while historical data can be queried infrequently for compliance and auditing purposes. Which combination of AWS storage solutions should the team use to optimize cost and performance?
- A
Amazon S3 Standard for real-time transactional data and Amazon S3 Glacier for historical data
- B
Amazon RDS for real-time transactional data and Amazon S3 Glacier for historical data
- C
Amazon DynamoDB for real-time transactional data and Amazon S3 Standard-IA for historical data
- D
Amazon Redshift for real-time transactional data and Amazon S3 Intelligent-Tiering for historical data
- E
Amazon DynamoDB for real-time transactional data and Amazon S3 Glacier Deep Archive for historical data
Show answer and explanation
Correct answers: C, E
Explanation
To determine the appropriate storage solution, it is crucial to consider the access patterns and cost-performance trade-offs. For real-time transactional data, Amazon DynamoDB offers low-latency, highly scalable access. For historical data that is infrequently accessed, Amazon S3 Standard-IA provides a balance of cost and accessibility, while S3 Glacier Deep Archive is ideal for long-term archival storage with minimal access requirements.
- A. Incorrect.
Amazon S3 Standard is suitable for frequently accessed data, but it does not offer low-latency access for real-time transactional data. Additionally, using S3 Glacier for historical data could be acceptable for infrequent access, but it doesn’t optimize for real-time transactional requirements.
- B. Incorrect.
Amazon RDS is an appropriate choice for structured data with transactional access patterns, but it is not optimized for real-time access to high-frequency transactional data. S3 Glacier is cost-effective for archiving but not ideal for querying historical data.
- C. Correct.
Amazon DynamoDB is a highly performant NoSQL database ideal for real-time, high-frequency transactional access. Amazon S3 Standard-IA (Infrequent Access) is a cost-effective solution for historical data that is infrequently accessed but needs occasional querying.
- D. Incorrect.
Amazon Redshift is a data warehouse solution optimized for complex analytical queries, not for real-time transactional data. S3 Intelligent-Tiering is suitable for dynamically adjusting storage costs but is not ideal for explicitly infrequently accessed historical data.
- E. Correct.
Amazon DynamoDB is the best choice for real-time, high-frequency transactional data due to its low latency and scalability. Amazon S3 Glacier Deep Archive is highly cost-effective for long-term storage of historical data when access is extremely infrequent.