Home » Amazon » AWS Certified Solutions Architect - Associate » What is the maximum size for a Microsoft SQL Server DB Instance with SQL Server Express edition?
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?
A. 10 GB per DB
B. 100 GB per DB
C. 2 TB per DB
D. 1TB per DB
Correct Answer: A
Explanation/Reference:
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
Up to 30 databases can be created on this RDS instance. Therefore 300GB/30=10GB.