Oracle Global Human Resources Cloud Implementation Specialist — Question 5

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B, as the COLMAP option in the MAP parameter allows you to specify which columns should be included in the replication process, thus excluding sensitive data. Option A is incorrect because the FILTER option is not the right method for excluding specific columns. Option C is unhelpful since not specifying columns in the ADD TRANDATA command does not prevent replication of sensitive data that is already included. Option D provides options for column selection but does not specifically address the need to exclude sensitive data using COLMAP.