10. What action will result in schema changes in Subscriber where DDL
replication is enabled?
A. Changing column type smalldatetime to date
B. Adding a new table
C. Modifying DDL trigger
D. Adding Stored procedure
Answer A is the correct answer. By enabling DDL replication, modification
done to the replicated articles will be replicated. Therefore, changing column
types will be replicated. DDL triggers are not replicated.
Bạn đang xem 10. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P156 PDF