A company requires to use the AWS RDS service to host a MySQL database. This database will be used for production purposes and is expected to experience a high number of read/write activities. Which EBS volume type would be ideal for this database?

Answer options:

A.General Purpose SSD
B.Provisioned IOPS SSD
C.Throughput Optimized HDD
D.Cold HDD

Correct Answer - B
The below snapshot from AWS Documentation shows that the ideal storage option in this scenario is the Provisioned IOPS SSD. It provides a high number of IOPS for the underlying database.
For more information on EBS volume types, please refer to the URL below.
https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EBSVolumeTypes.html