A financial company uses Amazon S3 as its data lake and has set up a data warehouse using a multi-node Amazon Redshift cluster. The data files in the data lake are organized in folders based on the data source of each data file. All the data files are loaded to one table in the Amazon Redshift cluster using a separate COPY command for each data file location. With this approach, loading all the data files into Amazon Redshift takes a long time to complete. Users want a faster solution with little or no increase in cost while maintaining the segregation of the data files in the S3 data lake. Which solution meets these requirements?
A) Use Amazon EMR to copy all the data files into one folder and issue a COPY command to load the data into Amazon Redshift.
B) Load all the data files in parallel to Amazon Aurora, and run an AWS Glue job to load the data into Amazon Redshift.
C) Use an AWS Glue job to copy all the data files into one folder and issue a COPY command to load the data into Amazon Redshift.
D) Create a manifest file that contains the data file locations and issue a COPY command to load the data into Amazon Redshift.
Correct Answer:
Verified
Q103: A company wants to run analytics on
Q104: A company uses Amazon Elasticsearch Service (Amazon
Q105: A company operates toll services for highways
Q106: A manufacturing company uses Amazon Connect to
Q107: A manufacturing company has been collecting IoT
Q109: A manufacturing company wants to create an
Q110: A global pharmaceutical company receives test results
Q111: A marketing company has data in Salesforce,
Q112: A human resources company maintains a 10-node
Q113: A media analytics company consumes a stream
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents