Exam AWS Certified Data Analytics - Specialty topic 1 question 46 discussion

D. https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-single-copy-command.html

Correct answer is D as using a single COPY command would load the data in parallel. Amazon Redshift can automatically load in parallel from multiple compressed data files. However, if you use multiple concurrent COPY commands to load one table from multiple files, Amazon Redshift is forced to perform a serialized load. This type of load is much slower and requires a VACUUM process at the end if the table has a sort column defined. Option A is wrong as multiple COPY commands would force Redshift to perform a serialized load. Option B is wrong as using EMR just makes the solution complicated. Option C is wrong as there is no LOAD command with Redshift.

D. https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-single-copy-command.html

D: I passed the test

Answer is D Copy Command is used to load data to redshift. Already single copy command load data in parallel.

Single copy command is the correct answer.

The copy command is by default parallelized and effcient. It uses to load data from sources other than RedShift. If it is RedShift then use INSERT INTO or CREATE TABLE AS commans like in SQL.

The copy command is by default parallelized and effcient. It uses to load data from sources other than RedShift. If it is RedShift then use INSERT INTO or CREATE TABLE AS commans like in SQL.

The copy command is by default parallelized and efficient. It uses to load data from sources other than RedShift. If it is RedShift then use INSERT INTO or CREATE TABLE AS commas like in SQL. No point of creating expensive solution as given in B. The answer should be D

The copy command is by default parallelized and effcient. It uses to load data from sources other than RedShift. If it is RedShift then use INSERT INTO or CREATE TABLE AS commans like in SQL. No point of creating expensive solution as given in B. The answer should be D

Answer is D

It's D. The only requirement is that all the files should lie under a common directory and in the redshift copy command you need to pass the path till directory so that it will consider all the files inside it.

https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-single-copy-command.html

D is correct answer

its D https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-single-copy-command.html

Option D https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-single-copy-command.html

Ans D