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
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
Things changed: https://aws.amazon.com/about-aws/whats-new/2014/05/19/amazon-rds-for-sqlserver-introduces-multi-az-support/
0
0
So answer is C: planned to be in 2014 🙂
0
0
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
0
0
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.
0
0
I choose A
0
0
Ignore answers from networkmanagers.
1
0
C.
0
0
C
0
0
Hi All, Does anybody have a pdf material to share ??
0
0
A.
is not currently
0
0
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
0
0
C.
is planned to be in 2014
0
0
Do you think this is valid 😀
0
0
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
0
0
A, B and D are false.
C is grammatically incorrect.
If the question is expecting most suitable answer, option will be C.
0
0
yes,i agree with you!
0
0
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.
0
0
Multi-AZ is available with Microsoft SQL Server 2008 R2 and 2012 Standard and Enterprise Editions. It is presently available in few Regions.
0
0