The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P149: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Self Test Appendix Appendix 45 entirely. Solution C would allow the user to continue to use the system without causing other users to lose their data. 14. You are administrating a SQL Server cluster that is running three instances of Microsoft SQL Sever 2008. Each instance uses SQL Service Broker to send messages to other instances both on the cluster and on other machines in the Enterprise. After patching and rebooting the host machines you see that one of the instances is not getting its service broker messages. One of the instances is using TCP port 1433 and the other two are using dynamic port numbers. The server that is not receiving SQL Service broker messages is using a dynamic TCP port number. You examine the SQL Server ERRORLOG and find the following relevant messages 2008-11-05 23 14 Server Server is listening on any ipv6 49237 2008-11-05 23 14 Server Server is listening on any ipv4 49237 2008-11-05 23 14 Server Server i _s listening on 1 ipv6 49551 2008-11-05 23 14 Server Server is listening on ipv4 49551 . You know that the SQL Service Broker Endpoint is configured on port 5200. How should you resolve this issue with the least impact to the users of the databases hosted by this instance A. Move one or more instances to the other node then restart this instance so that the endpoint can take the TCP port number it has been assigned. B. Change the port number of the ENDPOINT to a free TCP port number that is not configured for use by the other instances by using the ALTER ENDPOINT command changing the state from stopped to started at the same time. Reconfigure the routes on the machines that send SQL Service Broker messages to this server to use the new TCP port number. C. Restart the problem instance hoping that it gets access to its port number. D. Use the Cluster Administrator to move the problem instance to its own node so that the service can gain access to the port number in question. The correct answer is B. Even .
