PrepAway - Latest Free Exam Questions & Answers

15 Comments on “Is decreasing the storage size of a DB Instance permitted?

  1. Ganesh Ghube says:

    Answer is = C

    Amazon RDS Provisioned IOPS Storage to Improve Performance

    For any production application that requires fast and consistent I/O performance, we recommend Provisioned IOPS (input/output operations per second) storage. Provisioned IOPS storage is a storage type that delivers fast, predictable, and consistent throughput performance. When you create a DB instance, you specify an IOPS rate and storage space allocation. Amazon RDS provisions that IOPS rate and storage for the lifetime of the DB instance or until you change it. Provisioned IOPS storage is optimized for I/O intensive, online transaction processing (OLTP) workloads that have consistent performance requirements. Provisioned IOPS helps performance tuning.

    Note
    You cannot decrease storage allocated for a DB instance.




    0



    0
  2. thewildbat says:

    I think the answer is A: Depends on the RDMS used

    For existing MySQL, MariaDB, PostgreSQL, and Oracle DB instances, you might observe some I/O capacity improvement if you scale up your storage. Note that you cannot change the storage capacity nor the type of storage for a SQL Server DB instance due to extensibility limitations of striped storage attached to a Windows Server environment.

    http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html#CHAP_Storage.FactsAbout

    Looking at the above it is clear that you can chnage it apart from SQL Server.




    0



    0

Leave a Reply

Your email address will not be published. Required fields are marked *