tailieunhanh - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P157

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P157: 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 85 Chapter 10 Monitoring and Troubleshooting 1. What protocol and port number need to be open between the client machine and SQL Server for clients to resolve instance names to port numbers A. TCP 1433 B. TCP 1434 C. UDP 1433 D. UDP 1434 The correct answer is D. The SQL Server Browser listens on UDP port 1434 while the default instance listens on TCP port 1433. The other two ports listed are not used by SQL Server. 2. You have been informed that a job has been failing. Where should you look to see why the job has failed A. ERRORLOG file B. file C. Job history within SQL Server Management Studio D. Windows Application log The correct answer is C. Job history is written to the table which can be viewed from within the job history in the SQL Server Management Studio. While job failures are written to the ERRORLOG and Windows Application log the reason for the failure is not viewable anywhere except in the job history within SSMS or by querying the table directly. 3. If the SQL Server service is not able to start which log will contain the reason why A. B. Windows Security Event log C. Windows System Event log D. ERRORLOG The correct answer is D. The reason the instance didn t start will be in the ERRORLOG file. If the SQL Agent can t start the reason will be in the file. Service failures are not logged to the Windows Security or System Event logs. 86 Appendix Self Test Appendix 4. Your SQL Server will not start. You have been told by the systems administrator that they changed the permissions on the SQL Server folder tree. Where can you find information about why the SQL Server will not start A. The SQL Server Agent log file B. Windows Application log C. Windows Security log D. Windows System log The correct answer is B. Errors about SQL Server not starting will be logged to the Windows Application log. These errors are not written to the system log security log or .