For each DB Instance class, what is the maximum size of associated storage capacity?
A.
5GB
B.
1TB
C.
2TB
D.
500GB
what is the maximum size of associated storage capacity?
For each DB Instance class, what is the maximum size of associated storage capacity?
Now it is 6TB.
“You can now create MySQL, PostgreSQL, and Oracle RDS database instances with up to 6TB of storage and SQL Server RDS database instances with up to 4TB of storage when using the Provisioned IOPS and General Purpose (SSD) storage types. Existing MySQL, PostgreSQL, and Oracle RDS database instances can be scaled to these new database storage limits without any downtime.”
Yes, now its 6 TB
you can now create MySQL, PostgreSQL, and Oracle RDS database instances with up to 6TB of storage and SQL Server RDS database instances with up to 4TB of storage when using the Provisioned IOPS and General Purpose (SSD) storage types.)
But what is the answer for the test as the question seems to be deprecated?
Answer is D.
MySQL DB instances created prior to April 2014 have a file size limit of 2 TB. This 2 TB file size limit also applies to DB instances created from DB snapshots taken prior to April 2014, regardless of when the DB instance was created.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Limits.html#RDS_Limits.FileSize
Mistake i meant C
– MySQL, PostgreSQL, and Oracle RDS database instances with up to 6TB of storage
– SQL Server RDS database instances with up to 4TB of storage
The following table shows the IOPS and storage range for each database engine.
Range of Provisioned IOPS Range of Storage Range of IOPS to Storage (GB) Ratio
MySQL 1000 – 30,000 IOPS 100 GB – 6 TB 3:1 – 10:1
MariaDB 1000 – 30,000 IOPS 100 GB – 6 TB 3:1 – 10:1
PostgreSQL 1000 – 30,000 IOPS 100 GB – 6 TB 3:1 – 10:1
Oracle 1000 – 30,000 IOPS 100 GB – 6 TB 3:1 – 10:1
SQL Server Express and Web 1000 – 20,000 IOPS 100 GB – 4 TB 3:1 – 10:1
SQL Server Standard and Enterprise 1000 – 20,000 IOPS 200 GB – 4 TB 3:1 – 10:1
B (now is 6TB except 4tb for sql server)
For each DB Instance class, you can select from 5GB to 1TB of associated storage capacity.
http://awsdocs.s3.amazonaws.com/RDS/2012-04-23/rds-ug-2012-04-23.pdf
page 10
Question is a little vague as there are multiple storsge options
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html
General Purpose (SSD) Storage – upto 1 TB
Amazon RDS Provisioned IOPS Storage – upto 6 TB except MSSQL 4TB
I would go for Answer B because it doesn’t specify storage type and it matched GP2 storage
Good one!
Range of Provisioned IOPS Range of Storage Range of IOPS to Storage (GB) Ratio
MySQL 1000 – 30,000 IOPS 100 GB – 6 TB 3:1 – 10:1
MariaDB 1000 – 30,000 IOPS 100 GB – 6 TB 3:1 – 10:1
PostgreSQL 1000 – 30,000 IOPS 100 GB – 6 TB 3:1 – 10:1
Oracle 1000 – 30,000 IOPS 100 GB – 6 TB 3:1 – 10:1
MSSQLExp 1000 – 20,000 IOPS 100 GB – 4 TB 3:1 – 10:1
MSSQL Std 1000 – 20,000 IOPS 200 GB – 4 TB 3:1 – 10:1
I choose B
Terrible question…
now 16 tb
It depends on the storage types (General Purpose(SSD) Storage, Provisioned IOPS Storage and magnetic)
And currently it is 16TiB
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html
you can create MySQL, MariaDB, Microsoft SQL Server, PostgreSQL, and Oracle RDS DB instances with up to 16 TiB of storage.
Now 16 TB is right.