SAA-C03 Question 514
Single answerA company is designing a new application that requires a database to store user session data. The data is expected to be highly dynamic, with frequent updates and reads. The application must also handle unpredictable traffic spikes seamlessly. Which AWS database service is the most suitable for this use case?
- A
Amazon RDS with MySQL
- B
Amazon Aurora
- C
Amazon DynamoDB
- D
Amazon Redshift
Show answer and explanation
Correct answer: C
Explanation
Amazon DynamoDB is the best choice for this use case because it is a fully managed NoSQL database that supports high-frequency read/write operations and scales automatically to handle unpredictable traffic. This makes it ideal for storing dynamic user session data. Relational databases like RDS or Aurora are better suited for structured transactional data and do not offer the same level of scalability and performance for such workloads.
- A. Incorrect.
Amazon RDS with MySQL is a managed relational database service, suitable for structured data and complex queries. However, it is not optimized for high-frequency dynamic updates or unpredictable traffic spikes compared to purpose-built NoSQL solutions.
- B. Incorrect.
Amazon Aurora is a high-performance relational database suitable for transactional workloads. While it offers scalability and reliability, it is not the best fit for storing highly dynamic session data and handling unpredictable traffic spikes.
- C. Correct.
Amazon DynamoDB is a fully managed NoSQL database designed for high-performance, low-latency workloads. It is ideal for storing highly dynamic data like user sessions and can scale seamlessly to handle unpredictable traffic spikes.
- D. Incorrect.
Amazon Redshift is a data warehouse solution optimized for analytics and complex queries on large datasets. It is not suitable for dynamic session data or high-frequency read/write operations.