Data Warehousing on AWS Training ETL and Data Integration

Question 1

Which AWS service is the primary recommended method for bulk-loading data into Amazon Redshift?

Accepted Answer

COPY command

Answer

The COPY command loads data in parallel from S3, DynamoDB, EMR, or SSH sources and is far faster than row-by-row inserts.

Question 2

Which file format provides the best performance when loading data into Redshift using the COPY command?

Accepted Answer

Parquet

Answer

Parquet is a columnar format that Redshift can read efficiently, reducing the amount of data transferred and parsed during COPY.

Question 3

What is the recommended number of files when loading data into Redshift via COPY from S3?

Accepted Answer

A multiple of the number of slices in your cluster

Answer

Splitting data into a multiple of the cluster's slice count allows each slice to load data in parallel for maximum throughput.

Question 4

Which AWS service provides a fully managed ETL service that can move data into Amazon Redshift?

Accepted Answer

AWS Glue

Answer

AWS Glue is a fully managed serverless ETL service that can discover, catalog, and transform data before loading it into Redshift.

Question 5

What does the MANIFEST file do when used with the Redshift COPY command?

Accepted Answer

Specifies an explicit list of S3 files to load, ensuring exactly those files are loaded

Answer

A MANIFEST file lists exact S3 object paths to load, preventing accidental inclusion of unwanted files that match a prefix pattern.

Data Warehousing on AWS Training Practice Test