YOU HAVE CONFIGURED TRANSACTIONAL REPLICATION AND YOU HAVE NOT DISA...

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.