Databases · Senior · Question 49 of 75
Which measures protect sensitive columns (e.g. personal data) in a database?
- 1Hiding columns by giving them unusual names
- 2Storing data in JSON so it's harder to read
- ✓Correct answer: Least-privilege roles, encryption in transit and at rest, column-level encryption or tokenization for the most sensitive fields, and audit logging
Explanation
Also limit who can access backups and replicas, which contain the same data. Mask data when copying production into staging.