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 true about the redaction policy?
A.
The actual data in the tables is copied to the Data Pump target system with the redaction policy applied.
B.
The policy Is not Included In export and Import operation.
C.
The actual data in the tables is copied to the Data Pump target system without being redacted.
D.
The policy Is Included In the export and Import operation but is not applied by default to the objects In the target system.
E.
The policy is included in the export and import operation and applied by default to the objects in the target system.
Answer:
BC
User Votes:
A 1 votes
50%
B 2 votes
50%
C 3 votes
50%
D 2 votes
50%
E 1 votes
50%
Discussions
0/ 1000
econdeal
9 months, 1 week ago
The DATAPUMP_EXP_FULL_DATABASE role includes the powerful EXEMPT REDACTION POLICY system privilege.
Remember that by default the DBA role is granted the DATAPUMP_EXP_FULL_DATABASE role as well as DATAPUMP_IMP_FULL_DATABASE.
This enables users who were granted these roles to be exempt from Data Redaction policies. This means that, when you export objects with Data Redaction policies defined on them, the actual data in the protected tables is copied to the Data Pump target system without being redacted. Users with these roles, including users who were granted the DBA role, are able to see the actual data in the target system.
Want to join our community?
Please log in or signup in order to use this feature
The DATAPUMP_EXP_FULL_DATABASE role includes the powerful EXEMPT REDACTION POLICY system privilege.
Remember that by default the DBA role is granted the DATAPUMP_EXP_FULL_DATABASE role as well as DATAPUMP_IMP_FULL_DATABASE.
This enables users who were granted these roles to be exempt from Data Redaction policies. This means that, when you export objects with Data Redaction policies defined on them, the actual data in the protected tables is copied to the Data Pump target system without being redacted. Users with these roles, including users who were granted the DBA role, are able to see the actual data in the target system.