You export and import a table's data using Data Pump connected as a user who Is assigned DBA role with default privileges. There is a data redaction policy on the table. Which two statements are…

Question

Options

• AThe actual data in the tables is copied to the Data Pump target system with the redaction policy
• BThe policy is not Included In export and import operation.
• CThe actual data in the tables is copied to the Data Pump target system without being redacted.
• DThe policy is Included In the export and import operation but is not applied by default to the objects
• EThe policy is included in the export and import operation and applied by default to the objects in

• A
  3% (1)
• B
  86% (25)
• D
  7% (2)
• E
  3% (1)

Explanation

Data Redaction in Oracle applies masking dynamically at query time - it never alters the actual stored data. Because Data Pump reads raw block data directly (bypassing the SQL query layer), it exports the real, unredacted values, which is why C is correct. Separately, Data Redaction policies are managed via DBMS_REDACT and stored in internal metadata that Data Pump does not include in its export/import operation - even for a DBA with default privileges - making B correct.

Why the distractors are wrong:

• A is wrong because it claims the policy is copied alongside the data - it isn't; only the raw data travels to the target.
• D and E are wrong because they both assume the policy is included in the operation (just with different application behavior). In reality, it's excluded entirely from the dump file.

Memory tip: Think of Data Redaction as a one-way mirror on the window, not a filter on the pipes. Data Pump moves water through the pipes (raw storage), completely bypassing the window - so it sees unmasked data and carries no knowledge of the mirror (policy). To protect data on the target, you must manually recreate the redaction policy there.

No community discussion yet for this question.