Explore the storage types available when provisioning an Amazon RDS instance. Learn about General Purpose SSD, Provisioned IOPS SSD, and Magnetic storage options for your database needs. Prepare for the AWS Certified Database Specialty exam with our comprehensive guide.
Table of Contents
Question
When provisioning an Amazon RDS instance, which of the following storage types are available? (Select THREE.)
A. Magnetic
B. Protected IOPS SSD
C. Provisioned IOPS SSD
D. Universal Purpose SSD
E. General Purpose SSD
F. General Purpose IOPS
Answer
A. Magnetic
C. Provisioned IOPS SSD
E. General Purpose SSD
Explanation
Amazon RDS has storage types of General Purpose SSD, Provisioned IOPS SSD, and magnetic for backward compatibility. General Purpose SSD or Provisioned IOPS are recommended for any new storage needs.
Amazon RDS offers three main storage types to cater to different performance and cost requirements:
- General Purpose SSD (gp2): This is the default and most cost-effective SSD option. It provides a balance of price and performance, suitable for a wide range of database workloads. General Purpose SSD storage delivers single-digit millisecond latencies and the ability to burst to 3,000 IOPS for extended periods of time.
- Provisioned IOPS SSD (io1): This storage type is designed for I/O-intensive workloads that require high performance and low latency. With Provisioned IOPS SSD, you can specify the desired IOPS (input/output operations per second) based on your application needs. It provides consistent performance and supports up to 64,000 IOPS per database instance.
- Magnetic (Standard): This is the lowest-cost storage option and is suitable for infrequent access or for small database workloads where data is accessed less frequently. Magnetic storage does not provide the same level of performance as SSD storage options but can be a cost-effective choice for certain use cases.
Note that “Protected IOPS SSD,” “Universal Purpose SSD,” and “General Purpose IOPS” are not valid storage types offered by Amazon RDS.
When selecting the storage type for your RDS instance, consider factors such as performance requirements, cost constraints, and the nature of your database workload to choose the most appropriate option for your specific use case.
Getting Started with Databases EDDBASv1EN-US assessment question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Getting Started with Databases EDDBASv1EN-US assessment and earn Getting Started with Databases EDDBASv1EN-US badge.