You are a database administrator for a Microsoft SQL Server 2012 database named AdventureWorks2012. You create an Availa
Posted: Mon Oct 17, 2022 4:48 pm
You are a database administrator for a Microsoft SQL Server 2012 database named AdventureWorks2012.
You create an Availability Group defined by the following schema. (Line numbers are included for reference only.)
You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
✑ Production transactions should be minimally affected.
✑ The secondary server should allow reporting queries to be performed.
✑ If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?
A. AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL SECONDARY_ROLE ( ALLOW_CONNECTIONS = READ_ONLY, READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433') PRIMARY_ROLE ( ALLOW_CONNECTIONS = READ_WRITE, READ_ONLY_ROUTING_LIST = NONE)
B. AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL SECONDARY_ROLE ( ALLOW_CONNECTIONS = READ_ONLY, READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')
C. AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL SECONDARY_ROLE ( ALLOW_CONNECTIONS = READ_ONLY, READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')
D. AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL SECONDARY_ROLE ( ALLOW_CONNECTIONS = YES, READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')
You create an Availability Group defined by the following schema. (Line numbers are included for reference only.)
You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
✑ Production transactions should be minimally affected.
✑ The secondary server should allow reporting queries to be performed.
✑ If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?
- You Are A Datab 1 (38.52 KiB) Viewed 109 times
B. AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL SECONDARY_ROLE ( ALLOW_CONNECTIONS = READ_ONLY, READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')
C. AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL SECONDARY_ROLE ( ALLOW_CONNECTIONS = READ_ONLY, READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')
D. AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL SECONDARY_ROLE ( ALLOW_CONNECTIONS = YES, READ_ONLY_ROUTING_URL = 'TCP://SecondaryServer:1433')