Exam 1z0-060 topic 1 question 151 discussion

Actual exam question from Oracle's 1z0-060

Question #: 151
Topic #: 1

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
✑ RANDOM redaction on the SAL and COMM columns
✑ PARTIAL redaction on the HIREDATE column
✑ FULL redaction on the MGR column
What would you define to implement this?

A. several redaction policies, with one redaction policy foe each data type defined for the table must be redacted
B. several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type
C. one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted
D. several redaction policies, with one redaction policy for each table column that must be redacted

Show Suggested Answer

Suggested Answer: C 🗳️
You can redact columns of different data types, using different redaction types, for one table or view.
1. Create the policy for the first column that you want to redact.
2. Use the DBMS_REDACT.ALTER_POLICY procedure to add the next column to the policy.
References:
http://docs.oracle.com/database/121/ASOAG/redaction_config.htm#ASOAG10612

by [deleted] at April 4, 2025, 9:01 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!