Data Warehousing on AWS Training Data Lake Integration 3

Question 1

What is a key capability of Redshift Spectrum that differentiates it from Amazon Athena when querying S3 data?

Accepted Answer

Spectrum can join S3 external tables with Redshift local tables in a single SQL query

Answer

Redshift Spectrum's primary differentiator is the ability to combine external S3 data (via external tables) with Redshift's locally stored tables in a single federated SQL query.

Question 2

Which AWS service is best suited for orchestrating multi-step ETL workflows that include branching logic, error handling, and retries?

Accepted Answer

AWS Step Functions

Answer

AWS Step Functions provides serverless state machine orchestration, enabling complex ETL pipelines with conditional branching, parallel execution, and automatic retries on failure.

Question 3

What is the purpose of AWS Glue DataBrew in a data lake integration workflow?

Accepted Answer

Visually preparing and transforming data without writing code using 250+ built-in transformations

Answer

AWS Glue DataBrew is a visual data preparation tool that allows data analysts to clean, normalize, and transform data without writing ETL code.

Question 4

When using Amazon Kinesis Data Firehose to ingest streaming data into an AWS data lake for Redshift analytics, what is the recommended architecture?

Accepted Answer

Deliver data to S3 first via Firehose, then access it with Redshift COPY or Redshift Spectrum

Answer

The best practice is Kinesis Firehose → S3, followed by Redshift COPY for batch loads or Spectrum for direct querying, as S3 provides durable staging and enables bulk parallel loading.

Question 5

Which Redshift feature enables multiple Redshift clusters to access the same data in real time without duplicating it?

Accepted Answer

Redshift Data Sharing

Answer

Redshift Data Sharing allows a producer cluster to share live, transactionally consistent data with consumer clusters across accounts and regions without data movement.

Data Warehousing on AWS Training Practice Test

Data Warehousing on AWS Training Practice Test

Data Warehousing on AWS Training Data Lake Integration 3