DBS-C01 · Question #259
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 insert
The correct answer is B. Stream real-time data into Redshift temporary tables before loading the data into permanent C. For bulk inserts, split input files on Amazon S3 into multiple files to match the number of slices on E. Optimize analytics SQL queries to use sort keys.. https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon- Tip #6: Improving the efficiency of temporary tables Tip #9: Maintaining efficient data loads Amazon Redshift best practices suggest using the COPY command to perform data loads of file- Tip #3
Question
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.)
Options
- AModify the Kinesis Data Firehose delivery stream to stream the data to Amazon S3 with a high
- BStream real-time data into Redshift temporary tables before loading the data into permanent
- CFor bulk inserts, split input files on Amazon S3 into multiple files to match the number of slices on
- DFor bulk inserts, use the parallel parameter in the COPY command to enable multi-threading.
- EOptimize analytics SQL queries to use sort keys.
- FAvoid using temporary tables in analytics SQL queries.
How the community answered
(39 responses)- A31% (12)
- B46% (18)
- D15% (6)
- F8% (3)
Explanation
https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon- Tip #6: Improving the efficiency of temporary tables Tip #9: Maintaining efficient data loads Amazon Redshift best practices suggest using the COPY command to perform data loads of file- Tip #3: Sort key recommendation Sorting a table on an appropriate sort key can accelerate query performance, especially queries with range-restricted predicates, by requiring fewer table blocks to be read from disk.
Topics
Community Discussion
No community discussion yet for this question.