You administer a Microsoft SQL Server 2012 default instance.
The instance is hosted by a server that has a local firewall configureD. The firewall only allows
inbound connections on port 1433. The server only hosts a single instance of SQL Server.
You need to ensure that the instance is configured to allow remote connections even if the SQL
Server is unresponsive to client connections.
What should you do? Choose all that apply.
A.
Enable inbound connections on TCP port 1434 in the Windows Firewall on the server.
B.
Execute the following Transact-SQL command:
sp_configure ‘remote admin connections’,
C.
Execute the Reconfigure command.
D.
Execute the following Transact-SQL command:
sp_configure ‘remote access’, 1
E.
Restart the SQL Server Agent Service.
F.
Enable inbound connections on TCP port 135 in the Windows Firewall on the server.
Explanation:
http://msdn.microsoft.com/en-us/library/ms191464.aspx
http://msdn.microsoft.com/en-us/library/ms190468.aspx
(B) Contains an incomplete command, it should be “sp_configure ‘remote admin connections’, 1”
Still agree with answer of (A),(B),(C) though.
sp_configure ‘remote access’, 1 is deprecated and is only good for stored procedures.
https://msdn.microsoft.com/en-us/library/ms191464.aspx
It’s designed to trick younger DBA’s who know ABC must be right, but don’t know what D is and would think to themselves that it is also a possible answer. It is not. The only way to exclude it is to know what D is which is to force test takers to learn a concept that is deprecated. If this wasn’t a choose all that applies or choose 3 type question, then ok. You should know remote admin connections. Or if the question wrote that you wan’t to be able to access sqlserver to fix it when its down, abc also is more likely. But this is just another poorly conceived question
A-B-C
https://msdn.microsoft.com/en-us/library/ms190468.aspx