Administering a SQL Database Infrastructure — Question 152

You are creating a database that will store usernames and credit card numbers for an application. You need to recommend a solution to store and reuse the credit card numbers in the database.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

Answer options

Correct answer: A

Explanation

The best option is A, Data encryption, as it allows for secure storage and retrieval of sensitive information like credit card numbers. B, Transparent Data Encryption (TDE), is focused on encrypting the entire database at rest but does not provide the same level of control for individual data elements. C, Encrypting File System (EFS), is used for encrypting files on disk but is not specifically designed for database entries. D, Data hashing, is a one-way function and cannot be used to retrieve the original credit card numbers.