The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P52: 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. | Managing High Availability Chapter 6 237 C. High Safety D. High Safety with automatic failover 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 AS HTTP PATH sql MyEndpoint AUTHENTICATION BASIC FOR DATABASE_MIRRORING B. CREATE ENDPOINT MyEndpoint STATE STARTED AS TCP LISTENER_PORT 5022 FOR DATABASE_MIRRORING C. CREATE DATABASE_MIRRORING ENDPOINT MyEndpoint STATE STARTED AS TCP LISTENER PORT 5022 D. CREATE ENDPOINT MyEndpoint STATE STARTED AS TCP LISTENER PORT 1433 FOR DATABASE_MIRRORING 6. You are designing your high-availability solution. Because of the importance of the database system you are required to have more than one independent backup server running at all times. Which high-availability solution fits these requirements A. Database mirroring B. Log shipping C. Clustering D. Replication 7. You have installed SQL Server 2008 in a clustered environment. You are installing SSIS on the SQL Server. You have installed SQL Server 2008 as a named instance and need to tell SSIS that it needs to connect to the named instance. What file should you edit 238 Chapter 6 Managing High Availability A. C Program Files Microsoft SQL Server 100 DTS Binn . config B. C Program Files Microsoft SQL Server 100 DTS Binn MsDtsConfig. C. C Program Files Microsoft SQL Server 100 DTS Binn . config D. C Program Files Microsoft SQL Server 100 DTS Binn MsDtsConfig. 8. You are selecting your high-availability solution for your production environment. You have a single data center that houses all your servers. Which high-availability solution requires administrative overhead after the initial setup is complete A. Database mirroring B. Replication C. Clustering D. Log shipping 9. You are considering the licensing costs for your new
