A Company Wants to Improve the Data Load Time of a Sales

question 135

Multiple Choice

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?

• A) Compress .csv files and use an INSERT statement to ingest data into Amazon Redshift.
• B) Split large .csv files, then use a COPY command to load data into Amazon Redshift.
• C) Use Amazon Kinesis Data Firehose to ingest data into Amazon Redshift.
• D) Load the .csv files in an unsorted key order and vacuum the table in Amazon Redshift.

---

Definitions:

Nucleus Accumbens

A region in the brain's forebrain that plays a central role in the reward circuit, associated with pleasure, reinforcement learning, and addiction.

Dopamine

Dopamine is a neurotransmitter involved in regulating mood, cognition, reward, and pleasure, among other functions.

Basolateral Nucleus

A region of the amygdala involved in memory consolidation and emotional responses, influencing both arousal and the processing of sensory information.

Conditioned Stimulus

A previously neutral stimulus that, after being paired with an unconditioned stimulus, elicits a conditioned response.