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.
Bạn đang xem 8. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P156 PDF