RDS pricing considerations in AWS - Cheat Sheet & Quick Revision

Recall & Review

beginner

What are the main factors that affect the cost of using Amazon RDS?

The main factors include the instance type (size and power), storage type and amount, database engine, backup storage, data transfer, and additional features like Multi-AZ deployments.

intermediate

How does choosing a Multi-AZ deployment impact RDS pricing?

Multi-AZ deployments create a standby replica in another availability zone for high availability, which roughly doubles the cost because you pay for two instances and their storage.

beginner

What is the difference between On-Demand and Reserved Instances in RDS pricing?

On-Demand instances are billed by the hour with no long-term commitment, while Reserved Instances require a commitment (1 or 3 years) and offer significant discounts in exchange.

beginner

Why does storage type affect RDS pricing?

Different storage types (General Purpose SSD, Provisioned IOPS SSD, Magnetic) have different costs and performance levels. Higher performance storage costs more but can improve database speed.

intermediate

How do backup storage and data transfer influence RDS costs?

Backup storage beyond the database size and data transferred out of AWS regions incur additional charges, increasing the overall cost of running RDS.

Which factor does NOT directly affect Amazon RDS pricing?

A Number of database users

B Storage type

C Instance type

D Backup storage

RDS pricing depends on instance type, storage, backups, and data transfer, but not on the number of database users.

What is the main benefit of Reserved Instances in RDS pricing?

A No upfront cost

B Lower hourly cost with commitment

C Higher performance

D Automatic backups

Reserved Instances offer a lower hourly rate in exchange for a 1 or 3-year commitment.

How does enabling Multi-AZ affect your RDS bill?

A No change

B Slight increase for backups

C Reduces cost by sharing resources

D Roughly doubles the cost

Multi-AZ creates a standby instance, so you pay for two instances and their storage.

Which storage type is usually the most expensive in RDS?

A Magnetic

B General Purpose SSD

C Provisioned IOPS SSD

D Standard HDD

Provisioned IOPS SSD offers high performance at a higher cost.

What additional cost can occur if you transfer data out of AWS regions from RDS?

A Data transfer charges

B No additional cost

C Backup storage fees

D Instance type upgrade

Data transferred out of AWS regions incurs data transfer charges.

Explain the key pricing factors to consider when planning to use Amazon RDS.

Think about what you pay for: compute power, storage, backups, availability, and network.

Describe how choosing Multi-AZ deployment and Reserved Instances can impact your RDS costs and availability.

Consider trade-offs between cost and reliability.