DAS-C01 · Question #2
DAS-C01 Question #2: Real Exam Question with Answer & Explanation
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #2. The question stem and answer options stay visible for context.
Question
A company wants to improve the data load time of a sales data dashboard. Data has been collected as .csv files and stored within an Amazon S3 bucket that is partitioned by date. The data is then loaded to an Amazon Redshift data warehouse for frequent analysis. The data volume is up to 500 GB per day. Which solution will improve the data loading performance?
Options
- ACompress .csv files and use an INSERT statement to ingest data into Amazon Redshift.
- BSplit large .csv files, then use a COPY command to load data into Amazon Redshift.
- CUse Amazon Kinesis Data Firehose to ingest data into Amazon Redshift.
- DLoad the .csv files in an unsorted key order and vacuum the table in Amazon Redshift.
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-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.