The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P158: 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. | 90 Appendix Self Test Appendix A. TCP Port 65216 B. TCP Port 50584 C. UDP Port 65216 D. UDP Port 50584 The correct answer is A. In this case users were connecting to TCP Port 65216 and TCP Port 50584 was being used for the dedicated admin connection. Users do not connect to SQL Server instances over any UDP ports. The only UDP port used is UDP port 1434 which is used by the SQL Browser. 14. You have restarted your SQL Server in single user mode but are unable to connect to the SQL Server using the sqlcmd command line utility. The error message that you receive says that only one administrator can connect at this time. What does this error mean A. The sqlcmd utility cannot be used when the SQL Server is in single user mode. B. Another login that is a member of the sysadmin fixed server role has connected to the SQL Server. Disconnect that login before you can connect. C. The SQL Server is not yet ready for connections. Wait for the SQL Server to complete its startup process before connecting. The correct answer is B. Another user who is a member of the sysadmin fixed server role has connected to the instance. Have that user disconnect and try again. The sqlcmd utility is the recommended utility to use to connect to the SQL Server instance when the instance is in single user mode. It is recommended that you do not use SQL Server Management Studio as it can use more than one connection to the instance. If the SQL Server is not ready for connections it will give you a different error message. 15. You are attempting to troubleshoot a poorly performing stored procedure that is very complex. What tool should you use to identity the problem statement within the procedure A. Database Tuning Wizard B. SQL Server Management Studio C. SQL Server Profiler D. Database Engine Tuning Advisor The correct answer is C. To identify which statements within a stored procedure are having performance problems you should use the SQL Server Profiler. Self Test Appendix Appendix 91 Neither .
