
Ultimate access to all questions.
You are responsible for creating a secure data environment where only specific analysts can access sensitive columns, like Personally Identifiable Information (PII). What approach effectively limits access to sensitive data while still permitting widespread use of non-sensitive data?
A
Store sensitive data in a separate database and implement strict access controls.
B
Apply column-level security features to allow access to sensitive columns according to roles.
C
Encrypt sensitive columns and share decryption keys exclusively with authorized analysts.
D
Anonymize sensitive data in shared datasets and grant access to raw data when requested.