A company is planning on moving its applications to the AWS Cloud. They have some large SQL data sets that need to be hosted in a data store on the cloud. The data store needs to have features that support client connections with many types of applications, including business intelligence (BI), reporting, data, and analytics tools. Which of the following service should be considered for this requirement?

Answer options:

A.Amazon DynamoDB
B.Amazon Redshift
C.Amazon Kinesis
D.Amazon Simple Queue Service

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-
https://docs.aws.amazon.com/redshift/latest/mgmt/welcome.html
https://aws.amazon.com/kinesis/data-streams/