A company is planning on using AWS Redshift as their data store. They have a lot of files that are going to be dropped into AWS S3 by different departments. They want to have the ability to automate the way the files get loaded into Redshift. How can they accomplish this in an efficient and cost-effective manner?

Answer options:

A.Create a cron job on an EC2 Instance to poll the S3 buckets and drop the content onto AWS Redshift
B.Use S3 events to invoke Lambda functions that will transfer the files to AWS Redshift.
C.Use AWS Redshift triggers to poll the S3 buckets and drop the content onto its tables
D.Use AWS S3 events to call SQS and then use the queues to drop the content onto its tables

Answer – B
An example of this is given in the AWS Blog sites. Here you can use AWS Lambda code available in a Gut repository which can be used to automatically transfer files from various S3 buckets to AWS Redshift
Option A is incorrect since this does not cost efficient
Option C is incorrect since there are no triggers as of yet in Redshift
Option D is incorrect since there SQS would be ineffective in this scenario
For more information on this use case scenario, please visit the url
https://aws.amazon.com/blogs/big-data/a-zero-administration-amazon-redshift-database-loader/