Your database contains a table named customers, which has a column named credit_card that contains the primary credit card number that the customer uses for purchases. This column of data must be encrypted. How can you best encrypt this column so that regular database users cannot read a credit card number?

Your database contains a table named customers, which has a column named credit_card that contains the primary credit card number that the customer uses for purchases. This column of data must be encrypted. How can you best encrypt this column so that regular database users cannot read a credit card number?

Your database contains a table named customers, which has a column named credit_card that contains the primary credit card number that the customer uses for purchases. This column of data must be encrypted. How can you best encrypt this column so that regular database users cannot read a credit card number?


Answer: -  Create a certificate, then create a key from this certificate. Next encrypt the credit_card column data using this key, a predefined encryption algorithm, and an encryption function.

(Encrypting a column of data requires the use of a key, an encryption algorithm, and a function to perform the encryption. TDE encrypts an entire database and is transparent to an authorized database user.)