The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P143: 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 15 C. Tempdb D. System Correct Answer Explanation B Resource. Master and resource are system databases but do not perform the function to persist read-only versions of system objects. There is no system database named system. 18. Which is the compatibility version associated with SQL Server 2008 A. 80 B. 90 C. 100 D. 200 Correct Answer Explanation C 100. 80 is associated with SQL Server 2000 and 90 is associated with SQL Server 2005. 200 is an invalid compatibility version. 19. Which SQL Server tool is used to check that SQL Server component services are running A. SQL Server Management Studio SSMS B. Business Intelligence Development Studio BIDS C. SQL Server Configuration Manager D. SQL Server Profiler E. Database Engine Tuning Advisor Correct Answer Explanation C SQL Server Configuration Manager. 20. Which type of file contains data and database objects such as tables and indexes A. Data files B. Log files C. File groups D. Binary files E. Correct Answer Explanation A data files. 16 Appendix Self Test Appendix Chapter 3 Configuring SQL Server 2008 1. You ve just started as a DBA at a company that has recently installed a dedicated server running both a SQL Server 2008 default instance and the database for the company s ERP system. You want to implement a process to test the database with new SQL Server patches and service packs before they are applied to the live database. There is no budget to buy any new servers but the existing hardware is under-utilized and you re confident it will suffice for your short-term needs. Which of these options would meet your needs A. Restore a copy of the live database as test on to its own disk array. Apply patches and service packs to the new database and test them before applying them to the live database. B. Install a named instance for testing. Create a database snapshot on the named instance pointing to the live database on the default instance. Apply patches and service packs to the
