A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?
A.
Use theFILTERoption in theMAPparameter.
B.
Use theCOLMAPoption in theMAPparameter.
C.
Do not specify those columns in theADD TRANDATAcommand.
D.
Use theCOLSandCOLSEXCEPToptions in theTABLEparameter.
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit