SAA-C03 Question 292
Single answerA company is designing a new application that needs to store large volumes of data. The application has a read-intensive access pattern, with frequent queries to retrieve data for analytics. The company requires a highly scalable and cost-effective solution. Which storage option is the most appropriate for this scenario?
- A
Amazon RDS with provisioned IOPS
- B
Amazon DynamoDB with on-demand capacity mode
- C
Amazon S3 with S3 Select
- D
Amazon EFS with General Purpose performance mode
Show answer and explanation
Correct answer: C
Explanation
Amazon S3 with S3 Select is the best choice for a read-intensive analytics workload because it is highly scalable, cost-effective, and designed to handle large volumes of data efficiently. S3 Select further optimizes performance by allowing applications to retrieve only the required data from objects, minimizing data transfer and improving query performance for analytics. Other options, while useful in specific scenarios, are not as well-suited to this read-intensive, analytics-focused workload.
- A. Incorrect.
Amazon RDS with provisioned IOPS is optimized for transactional write-heavy workloads rather than read-intensive analytics use cases.
- B. Incorrect.
Amazon DynamoDB is a NoSQL database service that can handle high throughput, but it is more suited for key-value and document-based workloads rather than large-scale read-intensive analytics.
- C. Correct.
Amazon S3 with S3 Select is ideal for read-intensive use cases where large volumes of data need to be accessed efficiently. S3 Select allows applications to retrieve only the required data from objects, reducing data transfer and improving performance for analytics.
- D. Incorrect.
Amazon EFS with General Purpose performance mode is a file storage service suitable for low-latency, shared file system use cases. However, it is not the most cost-effective or efficient option for a read-intensive analytics workload.