Multi-AZ deployment ___________ supported for Microsoft SQL Server DB Instances.
A.
is not currently
B.
is as of 2013
C.
is planned to be in 2014
D.
will never be
Multi-AZ deployment ___________ supported for Microsoft SQL Server DB Instances.
Multi-AZ deployment ___________ supported for Microsoft SQL Server DB Instances.
Things changed: https://aws.amazon.com/about-aws/whats-new/2014/05/19/amazon-rds-for-sqlserver-introduces-multi-az-support/
So answer is C: planned to be in 2014 🙂
It should be A. AWS provides multi-AZ for MS-SQL but only in 2 regions.
Explanation:
B: NA
C: Not specific date/month/year has been published by AWS
D: AWS services gets revised everyday, hence this option is NA
Availability & Reliability
Automatic Host Replacement – Amazon RDS will automatically replace the compute instance powering your deployment in the event of a hardware failure.
Multi-AZ Deployments – When you create or modify your DB Instance to run as a Multi-AZ deployment, Amazon RDS will automatically provision a primary database in one Availability Zone and maintain a synchronous “standby” replica in a different Availability Zone. In the event of planned database maintenance or unplanned service disruption, Amazon RDS will automatically failover the SQL Server database to the up-to-date standby. Database operations can resume quickly without any manual intervention.
I choose A
Ignore answers from networkmanagers.
C.
C
Hi All, Does anybody have a pdf material to share ??
A.
is not currently
I agree A
Because:
Amazon RDS supports Multi-AZ with Mirroring for the following SQL Server versions and editions:
SQL Server 2016: Standard and Enterprise Editions
SQL Server 2014: Standard and Enterprise Editions
SQL Server 2012: Standard and Enterprise Editions
SQL Server 2008 R2: Standard and Enterprise Editions
C.
is planned to be in 2014
Do you think this is valid 😀
Amazon RDS provides high availability and failover support for DB instances using Multi-AZ deployments.
Multi-AZ deployments for Oracle, PostgreSQL, MySQL, and MariaDB DB instances use Amazon
technology, while SQL Server DB instances use SQL Server Mirroring
A, B and D are false.
C is grammatically incorrect.
If the question is expecting most suitable answer, option will be C.
yes,i agree with you!
A
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html
Microsoft SQL Server Multi-AZ Deployment Notes and Recommendations
The following are some restrictions when working with Multi-AZ deployments for Microsoft SQL Server DB instances:
Cross-region Multi-AZ is not currently supported.
You can’t configure the standby to accept database read activity.
Multi-AZ with Mirroring is not supported for DB instances with dedicated tenancy.
Multi-AZ with Mirroring is not supported for DB instances with in-memory optimization enabled. For more information, see Unsupported SQL Server Features for In-Memory OLTP in the Microsoft documentation.
You can’t rename a database on a SQL Server DB instance that is in a SQL Server Multi-AZ with Mirroring deployment. If you need to rename a database on such an instance, first turn off Multi-AZ for the DB instance, then rename the database, and finally turn Multi-AZ back on for the DB instance.
Multi-AZ is available with Microsoft SQL Server 2008 R2 and 2012 Standard and Enterprise Editions. It is presently available in few Regions.
Looks like it’s now supported, answer options need to be updated.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html
Amazon RDS supports Multi-AZ deployments for DB instances running Microsoft SQL Server by using SQL Server Database Mirroring.
Amazon RDS supports Multi-AZ with Mirroring for SQL Server in all AWS Regions, with the following exceptions:
Not supported
US West (N. California)
Asia Pacific (Singapore)
AWS GovCloud (US)
Supported in most cases
Asia Pacific (Sydney) – Supported for DB instances in VPCs.
Asia Pacific (Tokyo) – Supported for DB instances in VPCs.
South America (São Paulo) – Supported on all DB instance classes except m1 or m2.