6 Comments on “Which Transact-SQL statement should you insert at line 06?”

1. gri yer says:

   May 29, 2016 at 6:06 pm

   C of course..

   https://msdn.microsoft.com/en-us/library/hh213002.aspx

   
   
   
   2

   
   
   
   0
2. SQL123 says:

   June 5, 2016 at 11:24 am

   i think it is C too. Do not have ‘YES’ option.

   
   
   
   1

   
   
   
   0
3. dbo says:

   June 7, 2016 at 10:33 am

   C

   
   
   
   1

   
   
   
   0
4. Stan says:

   June 8, 2016 at 2:41 pm

   The correct answer is C.

   Asynchronous commit because: Production transactions should be minimally affected. (in synchronous commit, the transaction running on the primary waits confirmation before returning to the client. This may cause a usual small delay from the point of view of the application.)

   Allow connections: read_only
   https://msdn.microsoft.com/en-us/library/hh213002.aspx

   SECONDARY_ROLE ( ALLOW_CONNECTIONS = { NO | READ_ONLY | ALL } )
   where,
   NO
   No direct connections are allowed to secondary databases of this replica. They are not available for read access. This is the default setting.
   READ_ONLY
   Only read-only connections are allowed to secondary databases of this replica. The secondary database(s) are all available for read access.
   ALL
   All connections are allowed to secondary databases of this replica, but only for read access. The secondary database(s) are all available for read access.

   
   
   
   1

   
   
   
   0
5. Dan says:

   November 25, 2016 at 1:09 pm

   correct answer C because:

   – Production transactions should be minimally affected:
   AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT

   – If the primary server goes offline, the secondary server should not automatically take over:
   FAILOVER_MODE = MANUAL

   – The secondary server should allow reporting queries to be performed:
   SECONDARY_ROLE (
   ALLOW_CONNECTIONS = READ_ONLY,
   READ_ONLY_ROUTING_URL = ‘TCP://SecondaryServer:1433’)

   
   
   
   1

   
   
   
   0
6. v says:

   February 1, 2017 at 9:54 am

   C. YES is not a valid option

   https://msdn.microsoft.com/en-us/library/hh213002.aspx

   Quote from TSQL instructions:
   SECONDARY_ROLE ( ALLOW_CONNECTIONS = { NO | READ_ONLY | ALL } )

   
   
   
   1

   
   
   
   0