tailieunhanh - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P92

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P92: 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 Replication Chapter 9 437 table has a million records hence you need to capture only the changes. You cannot change the source system. What is the technology you use to create a copy of customer table A. Clustering B. Log Shipping C. Mirroring D. Replication 5. You are working in an organization where there are retail shops in several locations. Each location is running a SQL Server database and the end of each day there is a requirement to transfer a subset of data from all locations to the main server at the head office. What technology can you use to implement this scenario easily A. Linked Server B. Service Broker C. Transactional Replication D. SQL Server Integration Services SSIS 6. You are a DBA of an organization that has real-time data. This data has a high volume of inserts and updates at the head office. It was decided to expand the business to other locations and those locations need information at the head office. Replication mechanism was selected as the method of data distribution. What replication type are you going to implement A. Snapshot B. Transactional C. Peer-to-Peer D. Merge 7. You have asked to implement Disaster Recovery DR to your SQL Server 2008 database. In addition to the DR you are looking into options for using the DR instance as reporting database. What technology can you implement A. Log Shipping B. Transactional Replication C. Merge Replication D. Mirroring 438 Chapter 9 Managing Replication 8. You have configured Transactional Replication and you have not disabled DDL Replication. What is the T-SQL statement that will not be replicated to subscribers if you run it in a Publisher A. ALTER TABLE statement on a table that is a published article B. ALTER VIEW statement on a view that is a published article. C. DROP TABLE statement on a table that is a published article. D. ALTER TRIGGER statement on a table that is a published article and the trigger is a DML trigger statement. 9. You have implemented replication between SQL