DBS-C01 · Question #259
DBS-C01 Question #259: Real Exam Question with Answer & Explanation
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #259. The question stem and answer options stay visible for context.
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.
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.