The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P142: 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. | 10 Appendix Self Test Appendix Chapter 2 Installing SQL Server 2008 1. Which SQL Server 2008 edition supports IA64 A. Web and Compact Editions B. Standard and Workgroup Editions C. Enterprise and Developer editions D. All of the above Correct Answer Explanation C. The Enterprise and Developer Editions support IA64. 2. How many instances can be created in SQL Server 2008 Standard Edition A. 1 B. 4 C. 16 D. Unlimited Correct Answer Explanation C. SQL Server 2008 Standard Edition supports 16 instances as do the Workgroup Web and Express Editions. The Enterprise Edition can have up to 50. 3. How many SQL Server default instances can be installed on a single nonclustered server A. 1 B. 4 C. 16 D. Unlimited Correct Answer Explanation A. There can only be one default instance of SQL Server on any SQL Server installation. 4. Which of the following editions has all the features and functionality but is not licensed for production A. Compact Edition B. Web Edition C. Developer Edition D. Workgroup Edition Self Test Appendix Appendix 11 Correct Answer Explanation C. The Developer Edition has all the features and functionality of SQL Server 2008 Enterprise Edition but it is not licensed for production use. 5. Which SQL Server 2008 edition is best suited for mobile applications A. Compact Edition B. Web Edition C. Developer Edition D. Workgroup Edition Correct Answer Explanation A. The Compact Edition is best used for desktop and mobile applications because of its smaller footprint than the other versions. This is critical in mobile devices where disk space is at a premium. 6. Which SQL Server 2008 edition provides the most Analysis Services features A. Enterprise Edition B. Standard Edition C. Workgroup Edition D. Web Edition E. Express Edition Correct Answer Explanation A. Only the Enterprise and Developer Editions provide all the Analysis Services features. 7. Which tool should be on an existing SQL Server 2000 or 2005 database instance prior to upgrading to SQL Server .
