Answer - B.
This is mentioned in the AWS Documentation.
Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud.
You can start with just a few hundred gigabytes of data and scale to a petabyte or more.
This enables you to use your data to acquire new insights for your business and customers.
Option A is invalid since this is a fully managed NoSQL database.
Option C is invalid since this is an object data store.
Option D is invalid since this is a MySQL or PostgreSQL data store.
For more information on AWS Redshift, please visit the following URL-
https://docs.aws.amazon.com/redshift/latest/mgmt/welcome.html
Out of the given options, the service that is specifically designed to host large data warehouses is AWS Redshift (Option B).
AWS Redshift is a fully managed petabyte-scale data warehouse service in the cloud that offers high scalability and performance. It is optimized for analytics workloads and supports SQL-based queries. With Redshift, users can easily store and analyze large amounts of structured and semi-structured data using existing business intelligence tools.
AWS DynamoDB (Option A) is a NoSQL database service that is suitable for handling large amounts of unstructured data with a high degree of scalability, but it is not designed specifically for data warehousing.
AWS Simple Storage Service (Option C) is an object storage service that provides durable and scalable object storage for data backups, archive data, and other storage needs, but it is not a data warehouse service.
AWS Aurora (Option D) is a relational database service that is designed to be highly scalable and available. It is suitable for running transactional workloads and is not specifically optimized for analytical workloads like a data warehouse.
Therefore, AWS Redshift is the best option to host the data warehouse in the AWS cloud.
