Data redaction essentially serves as a way to mask sensitive information, so when a database query is returned that contains sensitive information such as Social Security numbers, credit card numbers and other personally identifiable information, that data is replaced by X's if it falls within a specific column.