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

Spectrum has lower per-query pricing than Athena

Answer

Spectrum supports more file formats than Athena

Answer

Spectrum requires no IAM permissions to access S3

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

Amazon SQS

Answer

Amazon SNS

Answer

AWS CloudFormation

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

Running ad hoc SQL queries directly on S3 data

Answer

Migrating on-premises databases to Amazon RDS

Answer

Monitoring S3 bucket access patterns and costs

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

Load data directly into Redshift tables using the Kinesis connector, bypassing S3

Answer

Store streaming data in DynamoDB and replicate to Redshift nightly via DMS

Answer

Push data directly into Redshift using Kinesis Data Streams producers

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 Spectrum

Answer

AWS Database Migration Service

Answer

Amazon Aurora Global Database

Question 6

What is the purpose of AWS Glue Data Quality in a data lake pipeline?

Accepted Answer

To evaluate datasets against user-defined rules and flag anomalies or quality issues

Answer

To encrypt sensitive columns in S3 data before querying

Answer

To optimize SQL query plans in Amazon Redshift

Answer

To replicate high-quality data across AWS regions automatically

Question 7

In a modern AWS data lakehouse architecture, what role does Amazon Redshift typically serve?

Accepted Answer

The analytical serving layer providing fast SQL queries on curated, structured data

Answer

Primary object storage layer for raw, unprocessed data

Answer

The streaming ingestion engine replacing Amazon Kinesis

Answer

A metadata catalog replacing the AWS Glue Data Catalog