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.
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)- A70% (31)
- B16% (7)
- C5% (2)
- D9% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.