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

INSERT statements

Answer

AWS Glue

Answer

Kinesis Firehose

Question 2

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

Accepted Answer

Parquet

Answer

CSV

Answer

JSON

Answer

XML

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

1 large file

Answer

Exactly 100 files

Answer

One file per table column

Question 4

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

Accepted Answer

AWS Glue

Answer

AWS Data Pipeline

Answer

Amazon EMR

Answer

AWS Batch

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

Defines table schema for the COPY operation

Answer

Provides column-level encryption keys

Answer

Maps source columns to destination columns

Question 6

Which Amazon Kinesis service can deliver streaming data directly to Amazon Redshift for near real-time loading?

Accepted Answer

Kinesis Data Firehose

Answer

Kinesis Data Streams

Answer

Kinesis Data Analytics

Answer

Kinesis Video Streams