PrepAway - Latest Free Exam Questions & Answers

If you are using Amazon RDS Provisioned IOPS storage with MySQL and Oracle database engines…

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 __________ .

PrepAway - Latest Free Exam Questions & Answers

A.
1,000 to 1, 00, 000

B.
100 to 1, 000

C.
10, 000 to 1, 00, 000

D.
1, 000 to 10, 000

15 Comments on “If you are using Amazon RDS Provisioned IOPS storage with MySQL and Oracle database engines…

  1. Magwif says:

    Answer is D
    the question is related to Push-Button Scaling

    https://aws.amazon.com/rds/mysql/

    Push-Button Scaling
    DB Instance Class – Using the Amazon RDS APIs or a few clicks of the AWS Management Console, you can scale the compute and memory resources powering your deployment up or down. Scaling operations typically complete within a handful of minutes.
    Storage and IOPS – As your storage requirements grow you can provision additional storage on-the-fly with zero downtime. 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 increments and storage from 100GB to 6TB.




    0



    0
    1. Youda says:

      Amazon RDS provides three storage types: General Purpose (SSD), Provisioned IOPS (input/output operations per second), and magnetic.

      General Purpose (SSD) – General Purpose (SSD), also called gp2, volumes offer cost-effective storage that is ideal for a broad range of workloads. These volumes deliver single-digit millisecond latencies and the ability to burst to 3,000 IOPS for extended periods of time. Between a minimum of 100 IOPS (at 33.33 GiB and below) and a maximum of 10,000 IOPS (at 3,334 GiB and above), baseline performance scales linearly at 3 IOPS per GiB of volume size. This storage type is excellent for small to medium-sized databases.




      0



      0
      1. Youda says:

        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
        MariaDB 1000–30,000 IOPS 100 GB–6 TB 3:1–10:1
        Microsoft SQL Server, Enterprise and Standard editions 1000–20,000 IOPS 200 GB–16 TB 1:1–50:1
        Microsoft SQL Server, Web and Express editions 1000–20,000 IOPS 100 GB–16 TB 1:1–50:1
        MySQL 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
        PostgreSQL 1000–30,000 IOPS 100 GB–6 TB 3:1–10:1




        0



        0

Leave a Reply

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