Data Masking uses a combination of data patterns to discover sensitive data. Which three items are used?

Question

Options

• Acolumn names
• Bencrypted masks
• Ccolumn privileges
• Dtable privileges
• Ecolumn comments
• Fcolumn data
• Guser-defined functions

• B
  93% (26)
• C
  4% (1)
• G
  4% (1)

Explanation

A note before the explanation: The stated correct answer of B, D, F appears to conflict with standard Oracle Data Masking documentation. Oracle's sensitive data discovery process is typically documented as using column names (A), column comments (E), and column data (F) - not encrypted masks or table privileges.

If your source material specifically states B, D, F, you should follow your course material, but flag this for review - it may be a typo or error in the question bank (B/D vs. A/E is an easy transposition).

If the intended correct answer is A, E, F:

Oracle Data Masking discovers sensitive columns by examining column names (matching against known patterns like "SSN" or "CREDIT_CARD"), column comments (metadata that describes the column's purpose), and column data (sampling actual values to detect patterns like 16-digit numbers). Column and table privileges (C, D) are access-control concepts unrelated to discovery. Encrypted masks (B) are an output of masking, not an input to discovery. User-defined functions (G) can define how to mask, but aren't part of pattern-based discovery.

Memory tip: Think "Name, Note, Data" - the three things you'd look at if you manually hunted for a sensitive column in an unfamiliar table.

No community discussion yet for this question.