Correct Answer: B
The AWS Documentation mentions the following.
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.
Although Kinesis has capabilities for analyzing & transforming streaming data, the question refers to having a data store for storing data from different applications BI, Reporting …which is where a Data Lake or Data Warehouse solutions come into the picture. Kinesis would be more appropriate in situations where one needs to process streaming data.
Amazon Redshift supports client connections with many types of applications, including business intelligence (BI), reporting, data, and analytics tools.
Option A is incorrect since DynamoDB is used for NoSQL datastore.
Option C is incorrect since Kinesis is used for analyzing & transforming streaming data.
Option D is incorrect since SQS is a message queue service used by distributed applications to exchange messages through a polling mode.
For more information on AWS Redshift, please visit the below URL-