nerdexam
CompTIA

SY0-301 · Question #429

A merchant acquirer has the need to store credit card numbers in a transactional database in a high performance environment. Which of the following BEST protects the credit card data?

The correct answer is A. Database field encryption. Database field encryption encrypts only the sensitive credit card number columns, preserving query performance on unencrypted fields while protecting the regulated data at the record level.

Security architecture

Question

A merchant acquirer has the need to store credit card numbers in a transactional database in a high performance environment. Which of the following BEST protects the credit card data?

Options

  • ADatabase field encryption
  • BFile-level encryption
  • CData loss prevention system
  • DFull disk encryption

How the community answered

(44 responses)
  • A
    70% (31)
  • B
    16% (7)
  • C
    5% (2)
  • D
    9% (4)

Why each option

Database field encryption encrypts only the sensitive credit card number columns, preserving query performance on unencrypted fields while protecting the regulated data at the record level.

ADatabase field encryptionCorrect

Database field-level encryption encrypts individual columns such as credit card numbers directly within the database engine. This approach satisfies PCI DSS data protection requirements for cardholder data while allowing the database to remain performant on non-sensitive fields, since queries against unencrypted columns are unaffected and only the sensitive values are encrypted or decrypted on access.

BFile-level encryption

File-level encryption encrypts entire files or tablespace files on disk, which does not protect individual records from users or applications that have legitimate access to open and query the database files.

CData loss prevention system

A data loss prevention system monitors and restricts data movement and egress but does not encrypt stored data, leaving the credit card numbers unprotected at rest.

DFull disk encryption

Full disk encryption protects data if physical media is stolen but provides no protection against logical access by authorized database users or compromised application accounts.

Concept tested: Database field-level encryption for PCI DSS compliance

Source: https://docs-prv.pcisecuritystandards.org/PCI%20DSS/Standard/PCI-DSS-v4_0.pdf

Topics

#database field encryption#PCI DSS#data at rest#credit card protection

Community Discussion

No community discussion yet for this question.

Full SY0-301 Practice