PrepAway - Latest Free Exam Questions & Answers

what is the maximum size for a Microsoft SQL Server DB …

In the Amazon RDS which uses the SQL Server engine, what is the maximum size for a Microsoft SQL Server
DB Instance with SQL Server Express edition?

PrepAway - Latest Free Exam Questions & Answers

A.
10 GB per DB

B.
100 GB per DB

C.
2 TB per DB

D.
1TB per DB

Explanation:
The maximum storage size for a Microsoft SQL Server DB Instance is 4 TB for all instances except the SQL
Server Express edition, which limits storage to a total of 300 GB. The minimum storage size for a Microsoft
SQL Server DB Instance is 20 GB for the Microsoft SQL Server Express and Web Editions and 200 GB for the
Standard and Enterprise Editions.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html

10 Comments on “what is the maximum size for a Microsoft SQL Server DB …

  1. a says:

    D

    The maximum storage size for SQL Server DB instances is the following:

    General Purpose (SSD) storage: 4 TB for all editions

    Provisioned IOPS storage: 4 TB for all editions

    Magnetic storage: 1 TB for all editions




    3



    0
    1. QuizBuster says:

      Weird! Either it has increased in the mean time from 10 to 16GB or they have forgoten to mention “magnetic storage” in the question?




      0



      0

Leave a Reply

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