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

On-Demand pricing

Answer

Reserved Instance pricing

Answer

Spot Instance pricing

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

They provide automatic scaling at no extra charge

Answer

They eliminate storage costs for the cluster

Answer

They provide free data transfer between nodes

Question 3

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

Accepted Answer

Concurrency Scaling

Answer

Manual Resize

Answer

Elastic Resize

Answer

Auto Scaling Groups

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

Store in Redshift DC2 nodes

Answer

Store in Glacier and restore on demand

Answer

Archive to EBS snapshots

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

DC2.large

Answer

DC2.8xlarge

Answer

DS2.8xlarge

Question 6

How can you reduce Redshift costs for a development cluster that is only used during business hours?

Accepted Answer

Schedule cluster Pause and Resume to run only during work hours

Answer

Use Spot Instances for the cluster nodes

Answer

Switch to Reserved Instances with partial upfront payment

Answer

Enable Concurrency Scaling permanently