Data Warehousing on AWS Training Data Warehousing on AWS: Architecture Design 2

Question 1

Which Amazon Redshift feature allows you to query data directly in S3 without loading it into Redshift tables?

Accepted Answer

Redshift Spectrum

Answer

Redshift Spectrum extends Redshift queries to data stored in S3 without requiring data to be loaded into the cluster.

Question 2

In a Redshift architecture, what is the purpose of a leader node?

Accepted Answer

It coordinates query execution and communicates with clients

Answer

The leader node receives client queries, develops execution plans, and coordinates parallel processing across compute nodes.

Question 3

A company needs its data warehouse to handle unpredictable query spikes without degrading performance for other users. Which Redshift feature addresses this?

Accepted Answer

Concurrency Scaling

Answer

Concurrency Scaling automatically adds transient cluster capacity to handle bursts of concurrent queries.

Question 4

What distribution style should you choose for a large fact table in Redshift to minimize data movement during joins?

Accepted Answer

KEY distribution

Answer

KEY distribution collocates rows with the same distribution key value on the same node slice, reducing data movement during joins.

Question 5

Which AWS service acts as the primary staging area for data before it is loaded into Amazon Redshift using the COPY command?

Accepted Answer

Amazon S3

Answer

The Redshift COPY command loads data in parallel from Amazon S3, making S3 the standard staging layer for bulk loads.

Data Warehousing on AWS Training Practice Test

Data Warehousing on AWS Training Practice Test

Data Warehousing on AWS Training Data Warehousing on AWS: Architecture Design 2