A company is using Amazon Redshift as its data warehouse solution. The Redshift cluster handles the following types of workloads: ✑ Real-time inserts through Amazon Kinesis Data Firehose ✑ Bulk inserts through COPY commands from Amazon S3 ✑ Analytics through SQL queries Recently, the cluster has started to experience performance issues. Which combination of actions should a database specialist take to improve the cluster’s performance? (Choose three.)

Topic #: - All AWS Certified Database - Specialty Questions

A. Modify the Kinesis Data Firehose delivery stream to stream the data to Amazon S3 with a high buffer size and to load the data into Amazon Redshift by using the COPY command.
B. Stream real-time data into Redshift temporary tables before loading the data into permanent tables.
C. For bulk inserts, split input files on Amazon S3 into multiple files to match the number of slices on Amazon Redshift. Then use the COPY command to load data into Amazon Redshift.
D. For bulk inserts, use the parallel parameter in the COPY command to enable multi-threading.
E. Optimize analytics SQL queries to use sort keys.
F. Avoid using temporary tables in analytics SQL queries.

- Awsexamhub website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Suggested Answer:

Reference Material:

Suggested Answer:

Reference Material:

Share this post

Join the Discussion