Bitzu

SAA-C03 ยท High-performing databases and caching

RDS engines, Aurora storage and Provisioned IOPS

RDS engines (MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, Db2), Aurora storage architecture and features, and Provisioned IOPS storage for RDS.

Key points

  • RDS engines: IBM Db2, MariaDB, SQL Server, MySQL, Oracle, PostgreSQL.
  • Storage: General Purpose SSD (gp3, older gp2) for most and dev/test; Provisioned IOPS SSD (io2 Block Express, older io1) for production OLTP; magnetic deprecated.
  • Aurora (MySQL, PostgreSQL): one shared cluster volume, copies in three AZs, auto-grows; new readers copy no data.
  • Aurora Standard: per-I/O charges; I/O-Optimized: none, worth it when I/O is 25%+ of the bill.

Source: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Welcome.html

Practice questions

Single choice

Which of these database engines is NOT offered as an Amazon RDS engine?

  1. Microsoft SQL Server
  2. MariaDB
  3. IBM Db2
  4. MongoDB
Show answer

Answer: D. MongoDB

RDS supports Db2, MariaDB, SQL Server, MySQL, Oracle and PostgreSQL. MongoDB-compatible document workloads go to Amazon DocumentDB, not RDS. Db2 is easy to overlook because it was added later, but it is a supported RDS engine.

Select all that apply

Which statements about Amazon Aurora storage are correct?

  1. Each reader instance keeps its own full copy of the data on a private volume
  2. You must choose a fixed allocated storage size when creating the cluster
  3. The cluster volume grows automatically as the data grows
  4. The cluster volume keeps copies of the data in three Availability Zones
  5. A new reader instance attaches to the shared volume without copying tables
Show answer

Answer: C. The cluster volume grows automatically as the data grows, D. The cluster volume keeps copies of the data in three Availability Zones, E. A new reader instance attaches to the shared volume without copying tables

The Aurora cluster volume holds copies of the data across three AZs, grows automatically as data is added, and is shared by every instance, so a new reader attaches to it instead of copying tables. You do not pre-size Aurora storage, and readers do not keep their own full copy on separate volumes.

True or false

Aurora Standard is always the cheaper Aurora storage configuration, whatever the I/O volume.

Show answer

Answer: False

False. Aurora Standard adds a charge per million I/O requests, while Aurora I/O-Optimized has no I/O charges. When I/O spending reaches about 25% or more of the total Aurora bill, I/O-Optimized usually costs less.

Practice 8 questions on this topic in Bitzu

Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.

Download on the App StoreGet it on Google Play

More SAA-C03 topics in this module