nerdexam
Oracle

1Z0-116 · Question #83

You must mask data consistently In three database copies such that data relations across the databases remain In place. Which Data Masking Format allows this?

The correct answer is A. Shuffle. Shuffle is correct because it reassigns real, existing values within a column using a deterministic algorithm - meaning the same original value always maps to the same masked value across all database copies, preserving foreign key relationships and referential integrity…

Implementing Data Protection

Question

You must mask data consistently In three database copies such that data relations across the databases remain In place. Which Data Masking Format allows this?

Options

  • AShuffle
  • BAuto Mask
  • CArray List
  • DSubstitute
  • ERandom Strings

How the community answered

(59 responses)
  • A
    73% (43)
  • B
    7% (4)
  • C
    2% (1)
  • D
    15% (9)
  • E
    3% (2)

Explanation

Shuffle is correct because it reassigns real, existing values within a column using a deterministic algorithm - meaning the same original value always maps to the same masked value across all database copies, preserving foreign key relationships and referential integrity. Substitute replaces values with similar-looking alternatives from a lookup table but does not guarantee that the same source value receives the same substitution across separate databases, breaking cross-database relations. Array List and Random Strings both generate or pull replacement values without deterministic consistency, so the same original value could mask to different outputs in each copy. Auto Mask automatically selects a masking technique based on data type, giving you no control or guarantee of cross-database consistency.

Memory tip: Think "Shuffle = Same deck, reshuffled the same way every time." Because Shuffle uses the existing data set and applies the same deterministic reordering, identical values always land in the same spot across all copies - keeping your data relationships intact.

Topics

#Data Masking Formats#Data Consistency#Referential Integrity#Database Copies

Community Discussion

No community discussion yet for this question.

Full 1Z0-116 Practice