11. You have table named tblSETTINGS, which takes the following format:
CREATE TABLE tblSETTINGS
(SETTINGNAME VARCHAR(150))
This table changes frequently. What replication type can you include to repli-
cate the preceding table?
A. Snapshot Replication
B. Transactional Replication
C. Merge Replication
D. Cannot implement any replication type
The correct answer is C. You cannot use Transaction Replication because there
is no primary key in the table. Snapshot Replication cannot be used because
it is not feasible when there are frequent updates. Therefore, you have to use
Merge Replication.
Bạn đang xem 11. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P156 PDF