The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P148: 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. | 40 Appendix Self Test Appendix C. Do not compress backup Answer B is the correct answer. If you are dealing with a slow WAN link you do not want to run the risk that someone disables the global compression settings and slows down the WAN by turning off the compression. 3. You are setting up log shipping for a database between two instances of SQL Server 2008. You want to ensure that your users have access to the database when the logs are not actively being restored so that they can read the updated data for reporting purposes. In what state should you leave the database A. RECOVERY B. NO RECOVERY C. STANDBY Answer C is the correct answer. If you leave the database in the STANDBY state the users can connect to the database which is left in a read-only state and query it. If the database is in a RECOVERY state then you will not be able to restore any more logs to it. If the database is in a NO RECOVERY state then the users will not be able to access it at all. If you do this be sure to tell the log shipping to disconnect the users when restoring the backups. 4. Which of the following database mirroring modes requires the use of a witness instance A. High Performance with automatic failover B. High Performance C. High Safety D. High Safety with automatic failover The correct answer is D. Automatic failover is available only with High Safety and only when a witness server is configured. High Safety can be used without a witness server if automatic failover is not required but the loss of any transactions is unacceptable. 5. You are setting up your deployment scripts to create your database mirroring endpoints on your production SQL Server. Each server has a single instance on it. Which script will correctly create the database mirroring endpoint A. CREATE ENDPOINT MyEndpoint STATE STARTED Self Test Appendix Appendix 41 AS HTTP PATH sql MyEndpoint AUTHENTICATION BASIC FOR DATABASE_MIRRORING B. CREATE ENDPOINT MyEndpoint STATE STARTED AS TCP LISTENER_PORT 5022 FOR .
