Microsoft
70-457 · Question #160
70-457 Question #160: Real Exam Question with Answer & Explanation
Sign in or unlock 70-457 to reveal the answer and full explanation for question #160. The question stem and answer options stay visible for context.
Question
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.
Options
- AEnable inbound connections on TCP port 1434 in the Windows Firewall on the server.
- BExecute the following Transact-SQL command:
- CExecute the Reconfigure command.
- DExecute the following Transact-SQL command:
- ERestart the SQL Server Agent Service.
- FEnable inbound connections on TCP port 135 in the Windows Firewall on the server.
Unlock 70-457 to see the answer
You've previewed enough free 70-457 questions. Unlock 70-457 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.