The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P145: 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 25 18. Your developers complain that they can t connect to the server using SQL Server Management Studio. You ve used Terminal Services to log on to the server and you ve confirmed that TCP IP is enabled. You now want to test it with a local connection. What should you do A. Nothing just connect B. Disable Shared Memory in Configuration Manager C. Move TCP IP above Shared Memory in the connection protocol order D. Disable Shared Memory using sp_configure shared memory enabled Correct Answer Explanation B. Disabling Shared Memory will force SQL Server to use the next protocol to connect which is TCP IP by default. Incorrect Answers Explanations A C D. Answer A is incorrect local connections will use the Shared Memory protocol by default. Answer C is incorrect because Shared Memory cannot be moved in the connection protocol order only disabled. Answer D is incorrect because the sp_configure option is invalid. 19. You are responsible for a large-capacity server that has a default instance of SQL Server 2008 installed and hosts databases for multiple applications belonging to several of your customers. A new database needs to be moved to the server which has a different collation and the collation ofTempDB needs to match it. You can t change the collation for your existing TempDB because it will affect all the applications. What could you do A. Create another TempDB with the right collation and configure the new database to use it B. Configure the database to use a different TempDB on a remote server C. Install a new instance for the database with a default collation the same as the database D. A separate server with a separate instance is the only option Correct Answer Explanation C. You can have only one TempDB database per instance and it might be feasible to install a second instance on a large capacity server. Incorrect Answers Explanations A B D. Answer A is incorrect you can have only one TempDB per instance. Answer B is incorrect .
