Answer: C, D and F
Option A is incorrect -AuroRA/RDS provides a relational database to fulfill the requirements and no different in database design compared to MYSQL. Aurora/RDS provides measurable performance in terms of scalability, but being a relational database, the platform cannot provide facilities like movement of data to archive layer, expiry of data and others.
NoSQL database fits in the specific requirements and DynamoDB is a right solution to address the business needs
https://docs.aws.amazon.com/rds/index.html?id=docs_gateway#lang/en_us
Option B is incorrect - Redshift provides a data warehousing layer. It does not support messaging applications. An Amazon Redshift data warehouse is an enterprise-class relational database query and management system. Amazon Redshift supports client connections with many types of applications, including business intelligence (BI), reporting, data, and analytics tools. Amazon Redshift achieves efficient storage and optimum query performance through a combination of massively parallel processing, columnar data storage, and very efficient, targeted data compression encoding schemes
https://docs.aws.amazon.com/redshift/latest/dg/c_redshift_system_overview.html
Option C is correct - Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. DynamoDB lets you offload the administrative burdens of operating and scaling a distributed database, so that you don`t have to worry about hardware provisioning, setup and configuration, replication, software patching, or cluster scaling.
Amazon DynamoDB also provides expiry of items and automatically removed after expiry of data and also copy of data from one table to other using DynamoDB Streams
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Introduction.html
Option D is correct -. Amazon CloudSearch provides Search capabilities for business applications. Amazon CloudSearch is a fully managed service in the cloud that makes it easy to set up, manage, and scale a search solution for your website. Amazon CloudSearch enables you to search large collections of data such as web pages, document files, forum posts, or product information. With Amazon CloudSearch, you can quickly add search capabilities to your website without having to become a search expert or worry about hardware provisioning, setup, and maintenance. As your volume of data and traffic fluctuates, Amazon CloudSearch automatically scales to meet your needs.
https://docs.aws.amazon.com/cloudsearch/latest/developerguide/what-is-cloudsearch.html
Option E is incorrect - ElasticSearch provides search for enterprise repositories. Amazon Elasticsearch Service (Amazon ES) is a managed service that makes it easy to deploy, operate, and scale Elasticsearch clusters in the AWS Cloud. Elasticsearch is a popular open-source search and analytics engine for use cases such as log analytics, real-time application monitoring, and clickstream analysis. With Amazon ES, you get direct access to the Elasticsearch APIs; existing code and applications work seamlessly with the service
https://docs.aws.amazon.com/elasticsearch-service/latest/developerguide/what-is-amazon-elasticsearch-service.html
Option F is correct - Amazon Simple Storage Service (Amazon S3) is storage for the Internet. You can use Amazon S3 to store and retrieve any amount of data at any time, from anywhere on the web. S3 provides S3 for object Storage, S3-IA for storage of objects with infrequent access and S3 Glacier to host objects in Archival Layer.
https://docs.aws.amazon.com/AmazonS3/latest/gsg/GetStartedWithS3.html
Option G is incorrect -Amazon EFS does not fit in requirement. Amazon Elastic File System (Amazon EFS) provides simple, scalable file storage for use with Amazon EC2. With Amazon EFS, storage capacity is elastic, growing and shrinking automatically as you add and remove files, so your applications have the storage they need, when they need it. Amazon EFS has a simple web services interface that allows you to create and configure file systems quickly and easily.
https://docs.aws.amazon.com/efs/latest/ug/whatisefs.html