4. Your security administrator has determined that all the SQL Servers in your
organization need to listen on nondefault TCP ports, and she doesn’t want
network users to see the SQL Servers in a browse list. Which two actions
would achieve this goal?
A. Stop and disable the browser service on each SQL Server
B. Use Configuration Manager on each server to change each instance to
listen on port 50000
C. Use Configuration Manager on each server to change each instance to
listen different ports
D. Configure the SQL Browser Service to hide each instance
E. Enable Show Advanced Options using sp_configure and use the
Default TCP port option to configure the port for each instance
Correct Answer & Explanation: A and C. Stopping the browser service will
stop all instances on that server being browsable. Configuration Manager
is the only place you can change the TCP port for an instance. Each instance
on a server must listen on a unique port. Answers & Incorrect Answers &
Explanations: B, D, E. Answer B is incorrect because configuring each instance
with the same port on the same server will prevent all but one instance from
working. Answer D is incorrect because you cannot hide an instance using the
SQL Browser Service. Answer E is incorrect because Configuration Manager is
the only place you can change the TCP port for an instance.
Bạn đang xem 4. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P143 PPTX