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…
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)- A73% (43)
- B7% (4)
- C2% (1)
- D15% (9)
- E3% (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
Community Discussion
No community discussion yet for this question.