TAILIEUCHUNG - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P156

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P156: 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. | 80 Appendix Self Test Appendix The correct answer is B. Because this replication needs to be near real-time data and the system has a high volume of transactions Transactional replication can be used. Snapshot replication is not an option when there is a huge data load. Peer-to-Peer and Merge can be considered when data inserts updates deletes are at all nodes. 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 The correct answer is B. Log Shipping and Mirroring can be used for the DR method but cannot be used as reporting solutions since the database will be in recovering mode while Log Shipping and Mirroring are in operation. There is no need for Merge Replication since data will be modified only at one end. Therefore Transactional Replication is the answer for this. 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. The correct answer is C. You cannot drop the table when it is being used for replication and all the other DDL statements will be replicated. 9. You have implemented replication between SQL Server 2008 and a SQL Server 2005 database server instance. Because of the system expansion there are some modifications to be done to the existing article. What step can you take A. Since DDL replication is enabled by default there is nothing you have to do. B. Drop the article and .

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• thiết kế CSDL quan hệ
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản