Data Warehousing on AWS Training Cost Management

Question 1

Which Amazon Redshift pricing model charges based on the number of queries run rather than cluster uptime?

Accepted Answer

Redshift Serverless pricing

Answer

Redshift Serverless charges in Redshift Processing Units (RPUs) per second only when queries are running, with no idle costs.

Question 2

How do Reserved Instances reduce Amazon Redshift costs compared to On-Demand pricing?

Accepted Answer

They offer up to 75% discount in exchange for a 1- or 3-year commitment

Answer

Reserved Instances provide significant discounts (up to 75%) over On-Demand rates when you commit to 1 or 3 years of usage.

Question 3

Which Redshift feature allows you to automatically scale compute capacity up or down based on workload demand?

Accepted Answer

Concurrency Scaling

Answer

Concurrency Scaling automatically adds temporary cluster capacity during bursts of concurrent queries, charging only per second of use.

Question 4

What is the most cost-effective storage option for infrequently accessed historical data that still needs to be queryable via Redshift?

Accepted Answer

Store in S3 and query with Redshift Spectrum

Answer

Redshift Spectrum queries data directly in S3 without loading it into the cluster, making S3 storage far cheaper than Redshift node storage.

Question 5

Which Redshift node type is recommended for large datasets (2+ TB per node) where storage cost is more important than raw compute speed?

Accepted Answer

RA3.xlplus

Answer

RA3 nodes use Amazon S3-backed Redshift Managed Storage, which is cheaper per TB than DC2 local SSD storage for large datasets.

Data Warehousing on AWS Training Practice Test