Home / DE Professional practice test / Ensuring Data Security and Compliance / Question

Databricks Data Engineer Professional · free practice question

A data governance team needs to store email addresses in a way that allows analysts to join datasets by user identity without ever seeing the raw email values…

Exam-style question on Ensuring Data Security and Compliance from the free DE Professional practice test, with the answer and a full explanation below.

Updated November 16, 2026

Ensuring Data Security and Compliance Medium

A data governance team needs to store email addresses in a way that allows analysts to join datasets by user identity without ever seeing the raw email values. Which anonymization or pseudonymization technique is MOST appropriate for this requirement?

  1. ASuppression — remove the email column entirely from all datasets before storing.
  2. BGeneralisation — replace each email with a broader category such as the email domain.
  3. CTokenization — replace each email with a random token while maintaining a secure reverse-lookup mapping.
  4. DDeterministic hashing — replace each email with a consistent hash value using a function such as SHA-256.
  5. EData masking via a column mask UDF — show partial email values such as 'a***@example.com'.
Answer & explanation

Correct answer: D

WHY D is correct: Deterministic (consistent) hashing maps each unique email to the same hash value every time. This means analysts can JOIN two hashed datasets on the hash column to correlate activity across tables — without ever accessing the raw email. Because SHA-256 (or similar) is a one-way function, analysts cannot reverse the hash to recover the original value, satisfying the anonymization requirement.

WHY NOT A: Suppression removes the data entirely, which means there is no identifier left to join on. This would make correlation across datasets impossible, which contradicts the requirement.

WHY NOT B: Generalisation replaces specific values with broader categories (e.g., exact age → age range, full email → domain). While it reduces identifiability, joining on a domain like 'gmail.com' is not meaningful for identifying individual users across datasets.

WHY NOT C: Tokenization is a pseudonymization technique — it replaces PII with a token while retaining a reverse-mapping. Because re-identification is possible via the mapping table, it does not fully anonymize the data. Additionally, if the goal is solely to enable joins without re-identification risk, hashing is simpler and does not require a mapping store.

WHY NOT E: Partial masking (showing part of the email) still exposes PII and would not prevent a determined analyst from identifying users. It is also reversible for common email patterns and does not constitute anonymization.

Take the full DE Professional practice test free →

Would you pass today?

This question is one of 60 in the free, timed Databricks Data Engineer Professional practice test. Take it and get a section-by-section score.

Start the free test →