
Ultimate access to all questions.
You are tasked with optimizing a Python script that ingests large CSV files into an Amazon Redshift cluster. The current script takes over 2 hours to complete the ingestion for a 1GB file. Which of the following strategies would you consider to reduce the runtime?
A
Use AWS Glue to automate the ETL process and parallelize the data loading into Redshift.
B
Increase the number of nodes in the Redshift cluster to distribute the load more evenly.
C
Rewrite the script to use multiprocessing to handle multiple files concurrently.
D
All of the above.