YOU HAVE TABLE NAMED TBLSETTINGS, WHICH TAKES THE FOLLOWING FORMAT

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.