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 the FILTER option in the MAP parameter.
B.
Use the COLMAP option in the MAP parameter.
C.
Do not specify those columns in the ADD TRANDATA command.
D.
Use the COLS and COLSEXCEPT options in the TABLE parameter.
COLS | COLSEXCEPT
These parameters are used to Replicat only specific columns from the Source to Target. Suppose, let us consider a scenario, we have 10 columns in the source and we need only 9 columns to be replicated to the target table. Yes, this is possible using the above parameters.
COLS and COLSEXCEPT controls the columns for which data is captured. It means, only data of specific columns are captured and not all the columns.
I think the answer should be D. That way, those columns are not written to the trailfile.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
kuvinod29
1 week, 2 days agoMamun_2021
5 months, 2 weeks agoJESUSBB
1 year, 3 months agoarcan3
2 years, 5 months agoawahba
3 years, 8 months agoRekha
4 years, 1 month ago