Home » Amazon » AWS Certified Solutions Architect - Associate » If you are using Amazon RDS Provisioned IOPS storage with MySQL and Oracle database engines, you can scale the throughput of your database Instance by specifying the IOPS rate from.
If you are using Amazon RDS Provisioned IOPS storage with MySQL and Oracle database engines, you can scale the throughput of your database Instance by specifying the IOPS rate from.
A. 1,000 to 100,000
B. 100 to 1,000
C. 10,000 to 100,000
D. 1,000 to 10,000
Correct Answer: D
Explanation/Reference:
Explanation:
If you are using RDS Provisioned IOPS, you can also scale the throughput of your DB Instance by specifying the IOPS rate from 1,000 IOPS to 10,000 IOPS in 1,000 IOPS https://aws.amazon.com/rds/mysql/
MySQL 1,000–80,000 IOPS 100 GiB–64 TiB
Oracle 1,000–80,000 IOPS 100 GiB–64 TiB
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html
Database Engine Range of Provisioned IOPS
MariaDB 1,000–80,000 IOPS 100 GiB–64 TiB
SQL Server, Enterprise and Standard editions 1,000–64,000 IOPS* 20 GiB–16 TiB
SQL Server, Web and Express editions 1,000–64,000 IOPS* 100 GiB–16 TiB
MySQL 1,000–80,000 IOPS 100 GiB–64 TiB
Oracle 1,000–80,000 IOPS 100 GiB– 64 TiB
PostgreSQL 1,000–80,000 IOPS 100 GiB–64 TiB
Database Engine Range of Provisioned IOPS Range of Storage
MariaDB 1,000–40,000 IOPS 100 GiB–32 TiB
SQL Server, Enterprise and Standard editions 1000–32,000 IOPS 20 GiB–16 TiB
SQL Server, Web and Express editions 1000–32,000 IOPS 100 GiB–16 TiB
MySQL 1,000–40,000 IOPS 100 GiB–32 TiB
Oracle 1,000–40,000 IOPS 100 GiB–32 TiB
PostgreSQL 1,000–40,000 IOPS 100 GiB–32 TiB
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html
Current max IOPS are 40K for all except MS SQL SERVER which is 32k.