Data Masking for Financial Clients | Dataford Interview Questions

How would you implement data masking for a financial client?

Write a SQL query that returns a masked view of client records for non-privileged users. Keep the same row set, but replace sensitive values with masked versions based on the access level.

Output

One row per client record.
Columns: client_id, display_name, masked_email, masked_account_number, risk_segment.
For access_level = 'FULL', show the original email and account number. For all other access levels, mask the email and account number.
Sort by client_id ascending.

Schema

client_access_view

Column	Type	Description
client_idPK	INT	Unique client record identifier
display_name	VARCHAR(255)	Client display name shown to users
email	VARCHAR(255)	Client email address
account_number	VARCHAR(32)	Client bank account number
risk_segment	VARCHAR(50)	Client risk classification
access_level	VARCHAR(20)	Viewer access level used to decide masking

Your question is Data Masking for Financial Clients. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem