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

Question 1

A data architect wants to separate storage costs from compute costs in a modern cloud data warehouse. Which Redshift deployment mode best achieves this?

Accepted Answer

Redshift RA3 nodes with managed storage

Answer

RA3 nodes decouple compute and storage by using high-performance SSDs as cache while offloading data to S3-backed managed storage.

Question 2

What is the recommended approach for sharing live data across multiple Redshift clusters without copying or moving data?

Accepted Answer

Redshift Data Sharing

Answer

Redshift Data Sharing allows producer clusters to share live data with consumer clusters without data movement or copying.

Question 3

In the AWS lake house architecture, which service serves as the centralized metadata catalog connecting Redshift, Athena, and EMR?

Accepted Answer

AWS Glue Data Catalog

Answer

The AWS Glue Data Catalog provides a unified metadata repository that Athena, Redshift Spectrum, and EMR can all use to query S3 data.

Question 4

Which Redshift sort key type is most effective when queries frequently filter on a single column using range predicates?

Accepted Answer

Compound sort key

Answer

Compound sort keys work best when queries filter predominantly on the leading sort column, enabling zone map pruning for range predicates.

Question 5

A company is designing a data warehouse and needs to preserve a complete history of changes to dimension attributes over time. Which technique should they use?

Accepted Answer

Type 2 SCD (add new row)

Answer

Type 2 SCD preserves full history by inserting a new row for each change, with effective date ranges or current-row flags.

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 3