Data Warehousing on AWS Training Data Warehousing on AWS: Trends, Network And Critical Thinking 4

Question 1

A company wants to share live Redshift data with a business partner's AWS account without copying or moving the data. Which feature enables this?

Accepted Answer

Redshift Data Sharing

Answer

Redshift Data Sharing allows producers to share live, transactionally consistent data with consumer accounts without copying data or ETL pipelines.

Question 2

What is the primary benefit of using materialized views in Amazon Redshift for frequently run complex queries?

Accepted Answer

They precompute and store query results, reducing repeated computation overhead

Answer

Materialized views store the precomputed result of complex queries, allowing subsequent requests to read the cached result rather than rerunning the full computation.

Question 3

A Redshift cluster's storage is 85% full but compute utilization is low. Using RA3 nodes, what is the most cost-efficient way to add storage capacity?

Accepted Answer

Increase the RA3 managed storage quota independently without changing node count

Answer

RA3 nodes use Redshift Managed Storage (RMS), which can scale storage capacity independently from compute, avoiding the cost of adding unnecessary compute nodes.

Question 4

Which trend is driving the adoption of the 'data mesh' architectural pattern in large enterprises using AWS?

Accepted Answer

Domain-oriented, decentralized data ownership with federated governance at scale

Answer

Data mesh decentralizes data ownership to domain teams while enforcing federated governance, addressing the scalability bottlenecks of centralized data platform teams.

Question 5

A data engineer must load 500GB of compressed Parquet files from S3 into Redshift as quickly as possible. Which COPY command optimization is most impactful?

Accepted Answer

Split files into sizes matching the number of Redshift cluster slices for parallel loading

Answer

Splitting source files so each Redshift slice processes approximately one file enables fully parallel loading, maximizing ingestion throughput.

Data Warehousing on AWS Training Practice Test

Data Warehousing on AWS Training Practice Test

Data Warehousing on AWS Training Data Warehousing on AWS: Trends, Network And Critical Thinking 4