The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P144: 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. | 20 Appendix Self Test Appendix A. A firewall is blocking port 1433 B. The SQL Browser Service isn t running C. The SQL Server tools on the developer workstations haven t been service packed D. TCP IP is disabled by default in Developer Edition Correct Answer Explanation D. TCP IP is disabled by default in Developer Edition which means that all remote connections will fail. Incorrect Answers Explanations A B C. Answer A is incorrect. Although this would cause the same issue all remote protocols are disabled and that is the most likely cause. Answer B is incorrect because the SQL Server Browser Service isn t required to connect to a default instance using default port 1433. Answer C is incorrect. Technically it may be possible for this to cause an issue but it is not the most likely cause of the problem. 8. A SQL Server recently suffered from all CPUs running at 100 percent which you found to be caused by a missing index. You fixed the problem but you want to stop any new occurrences from saturating all CPUs. Which of these options would achieve this A. Use sp_configure to set max degree of parallelism B. Use Configuration Manager to configure the SQL Server Service to use fewer CPUs C. Run the Database Tuning Advisor and apply any recommendations D. Use sp_configure to set cost threshold for parallelism Correct Answer Explanation A. Setting max degree of parallelism to less than the number of CPUs will prevent SQL Server running parallel executions across all CPUs. Incorrect Answers Explanations B C D. Answer B is incorrect you cannot use Configuration Manager to configure SQL Server CPU usage. Answer C is incorrect because DTA recommendations will only reduce the amount of parallelism that occurs. Answer D is incorrect because cost threshold for parallelism controls how expensive queries must be before being considered for parallelism. 9. A developer has contacted you because he wants to enable AWE memory on his Developer Edition instance but he says that he can t
