Data Warehousing on AWS Training Data Lake Integration

Question 1

What AWS service allows Amazon Redshift to query data directly in Amazon S3 without loading it into Redshift?

Accepted Answer

Redshift Spectrum

Answer

AWS Glue

Answer

Amazon Athena

Answer

AWS Data Pipeline

Question 2

When using Redshift Spectrum, where are external table definitions stored?

Accepted Answer

AWS Glue Data Catalog or Amazon Athena metastore

Answer

Amazon DynamoDB

Answer

Amazon RDS

Answer

Amazon ElastiCache

Question 3

Which file format is NOT natively supported for querying with Redshift Spectrum?

Accepted Answer

Microsoft Excel (.xlsx)

Answer

Parquet

Answer

ORC

Answer

JSON

Question 4

What is the primary performance advantage of using columnar file formats like Parquet with Redshift Spectrum?

Accepted Answer

They reduce the amount of data scanned, lowering costs and improving query speed

Answer

They support more complex nested data types

Answer

They automatically eliminate duplicate rows

Answer

They enable real-time streaming ingestion into Redshift

Question 5

In Redshift Spectrum, external tables referencing S3 data must be created inside which type of schema?

Accepted Answer

External schema

Answer

Internal schema

Answer

Public schema

Answer

Temporary schema

Question 6

Which statement best describes a data lake architecture on AWS?

Accepted Answer

Raw data in multiple formats is stored in Amazon S3, serving as a centralized repository

Answer

Data is always stored in a normalized relational format in Amazon RDS

Answer

All data must be transformed before it is stored

Answer

Data lakes require Redshift as the primary storage layer

Question 7

What IAM configuration is required for Redshift Spectrum to access data in S3?

Accepted Answer

An IAM role with S3 read and Glue catalog permissions must be attached to the Redshift cluster

Answer

Root account credentials must be embedded in the CREATE EXTERNAL SCHEMA statement

Answer

S3 buckets must be configured with public read access

Answer

No IAM configuration is required; Redshift has implicit access to all S3 buckets