Data Warehousing on AWS Training Cost Management 2

Question 1

What is the charge model for Redshift Spectrum queries?

Accepted Answer

Per TB of data scanned in S3

Answer

Redshift Spectrum charges $5 per TB of data scanned in S3, incentivizing use of columnar compressed formats to minimize scan size.

Question 2

Which S3 storage class should you use for Redshift Spectrum external tables that are accessed monthly?

Accepted Answer

S3 Intelligent-Tiering

Answer

S3 Intelligent-Tiering automatically moves data between access tiers based on actual usage patterns, optimizing cost without manual intervention.

Question 3

What is the most effective way to reduce Redshift Spectrum costs when querying partitioned data?

Accepted Answer

Use partition pruning in WHERE clauses to limit scanned partitions

Answer

Partition pruning uses WHERE clause filters on partition columns (e.g., year, month) to skip scanning irrelevant S3 partitions entirely.

Question 4

How does column compression in Redshift directly impact storage costs?

Accepted Answer

It reduces the amount of data stored, lowering S3 and node storage costs

Answer

Column compression encodings like ZSTD can reduce data size by 3-10x, directly reducing the amount of storage billed.

Question 5

Which AWS Cost Explorer feature helps identify unexpected increases in Redshift spending?

Accepted Answer

AWS Cost Anomaly Detection

Answer

AWS Cost Anomaly Detection uses machine learning to identify unusual spending patterns and sends alerts when anomalies are detected.

Data Warehousing on AWS Training Practice Test