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
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?
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
Strange, there is no correct answer. Because:
The maximum storage size for a Microsoft SQL Server DB Instance is 4 TB – Source: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html
A is Correct
According to Microsoft: https://www.microsoft.com/en/server-cloud/products/sql-server-editions/sql-server-express.aspx
No correct answer.
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.
a
the question is deprecated.
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
I’d go with A for the “test correct answer.”
For this question A may looks better.
SQL Server Express Edition 2005, 2008, 2008 R2, 2012, 2014, and 2016: An entry-level database product that enables small database applications. The maximum size of a database supported is 10 GB. This product is offered at no-additional cost over the base Microsoft Windows Server instance price on EC2.
https://aws.amazon.com/windows/products/sql/
Confusing, but I think I’ve got it now:
– https://aws.amazon.com/windows/products/sql/ is for SQL Server on EC2. Limit (Express) is 10GB.
– http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html is for SQL Server on RDS. Limit (Express) is 300GB.
The question mentions RDS so 300GB would be the right answer … but this isn’t one of the options. 🙁
SQL Server Express
Microsoft SQLServer Express Edition
Microsoft SQL Server Express Edition is an affordable database management system that supports database sizes up to 10 GB. Refer to Microsoft’s web site for more details.
The question is deprecated. The question was valid before 2014.
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.
Correction for max:
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.
I agree with the answer. A
A
The maximum number of databases on a single Microsoft SQL Server DB instance is 30.
The maximum storage size for a SQL Server DB instance is 4 TB for the Enterprise, Standard, and Web editions, and 300 GB for the Express edition.
300GB/30 = 10G per DB
Yup, this is correct. Do it for yourself in the console.
Select Express Edition.
As soon as you try and allocate more than 300GB of storage, you receive a warning message in red. It says in the message, “Please note that SQL Express limits storage to 10GB per database”.
Answer A is “10GB per DB”.
A is correct.
A
No answer is correct. It should be 300GB.
The maximum storage size for a SQL Server DB instance is 4 TB for the Enterprise, Standard, and Web editions, and 300 GB for the Express edition.
Looks like answers are wrongly listed.
SQL Server 2016 SP1 Express edition
Use SQL Server programming features to build small data-driven applications up to 10 GB of maximum disk size—that will scale across editions as you grow—with this free, entry-level database.
https://www.microsoft.com/en-cy/sql-server/sql-server-editions-express
Answer is D
I tested it on AWS console for express edition.
(Minimum: 20 GB, Maximum: 1024 GB) Higher allocated storage may improve IOPS performance.
Limits for Microsoft SQL Server DB Instances
The Amazon RDS implementation of Microsoft SQL Server on a DB instance have some limitations you should be aware of:
You can create up to 30 databases on each of your DB instances running Microsoft SQL Server. The Microsoft system databases, such as master and model, don’t count toward this limit.
Some ports are reserved for Amazon RDS use and you can’t use them when you create a DB instance.
Amazon RDS for SQL Server does not support importing data into the msdb database.
You can’t rename databases on a DB instance in a SQL Server Multi-AZ with Mirroring deployment.
The minimum storage size for a SQL Server DB instance is 20 GB for the Express and Web Editions, and 200 GB for the Standard and Enterprise Editions.
The maximum storage size for a SQL Server DB instance is 4 TB for the Enterprise, Standard, and Web editions, and 300 GB for the Express edition.
If you have a scenario that requires a larger amount of storage, it is possible to use sharding across multiple DB instances to get around this limit. This approach requires data-dependent routing logic in applications that connect to the sharded system, so that data gets queried from and written to the appropriate shard. You can either use an existing framework like Hibernate Shards or write custom code to enable this. If you do choose to use an existing framework, it must not require any components to be installed on the same server as the DB instance. For an example of a sharding solution using an existing framework, see Using an Example of Sharding with Hibernate.
Because of the extensibility limitations of striped storage attached to Windows Server, Amazon RDS doesn’t currently support increasing storage on a SQL Server DB instance. We recommend that you provision storage according to anticipated future storage growth. If you need to increase the storage of a SQL Server DB Instance, you can backup your databases, create a new DB instance with increased storage, and then restore the databases into the new DB instance. For more information, see Importing and Exporting SQL Server Databases.
Amazon RDS doesn’t support some features of SQL Server. This includes components such as SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Data Quality Services, and Master Data Services. To use these features, you can run SQL Server components in an Amazon EC2 instance with Amazon EBS storage, pursuant to Microsoft licensing policies.
Because of limitations in Microsoft SQL Server, restoring to a point in time before successful execution of a DROP DATABASE might not reflect the state of that database at that point in time. For example, the dropped database is typically restored to its state up to 5 minutes before the DROP DATABASE command was issued, which means that you can’t restore the transactions made during those few minutes on your dropped database. To work around this, you can reissue the DROP DATABASE command after the restore operation is completed. Dropping a database removes the transaction logs for that database.
Thanks.
The maximum storage size for a SQL Server DB instance is 4 TB for the Enterprise, Standard, and Web editions, and 300 GB for the Express edition.
The maximum storage size for SQL Server DB instances is the following:
General Purpose (SSD) storage: 16 TB for all editions
Provisioned IOPS storage: 16 TB for all editions
Magnetic storage: 1 TB for all editions