The correct answer is C, Amazon DynamoDB. It is a fully managed NoSQL database service provided by AWS, designed to be highly scalable and capable of automatically adjusting its capacity to handle the changing demand of applications. DynamoDB offers consistent single-digit millisecond latency at any scale, making it suitable for applications that require low-latency access to data even as their popularity and demand grow. Additionally, DynamoDB automatically replicates data across multiple Availability Zones to ensure high availability and durability. The other options are not suitable for the requirements: A (Amazon Aurora Serverless) is a relational database service, B (Amazon ElastiCache) is an in-memory cache service, and D (Amazon Redshift) is a data warehousing service, none of which are NoSQL databases.