AWS Certified Big Data - Specialty (#73)

An organization’s data warehouse contains sales data for reporting purposes. data governance policies prohibit staff from accessing the customers’ credit card numbers. How can these policies be adhered to and still allow a Data Scientist to group transactions that use the same credit card number?

Store a cryptographic hash of the credit card number.
Encrypt the credit card number with a symmetric encryption key, and give the key only to the authorized Data Scientist.
Mask the credit card numbers to only show the last four digits of the credit card number.
Encrypt the credit card number with an asymmetric encryption key and give the decryption key only to the authorized Data Scientist.