nerdexam
CompTIA

CV0-002 · Question #516

Which of the following solutions BEST complies with laws requiring secure data-at-rest for a critical application while keeping in mind the need for reduced costs?

The correct answer is B. Enable encryption on the back-end database.. To comply with data-at-rest encryption laws for a critical application while reducing costs, enabling encryption on the backend database itself is the most cost-effective and direct solution. This leverages built-in database features without requiring new hardware.

Security

Question

Which of the following solutions BEST complies with laws requiring secure data-at-rest for a critical application while keeping in mind the need for reduced costs?

Options

  • AInstall a new array with hardware encryption disks.
  • BEnable encryption on the back-end database.
  • CUse IPSec on the storage array.
  • DEnable HTTPS on the application.

How the community answered

(45 responses)
  • A
    4% (2)
  • B
    78% (35)
  • C
    7% (3)
  • D
    11% (5)

Why each option

To comply with data-at-rest encryption laws for a critical application while reducing costs, enabling encryption on the backend database itself is the most cost-effective and direct solution. This leverages built-in database features without requiring new hardware.

AInstall a new array with hardware encryption disks.

Installing a new array with hardware encryption disks is a viable solution for data-at-rest encryption but is typically the most expensive option due to the procurement and installation costs of new hardware, which goes against the "reduced costs" requirement.

BEnable encryption on the back-end database.Correct

Enabling encryption on the back-end database is the most direct and often cost-effective way to secure data-at-rest for a critical application. Modern database systems (e.g., SQL Server, Oracle, PostgreSQL, MySQL) offer transparent data encryption (TDE) or similar features that encrypt the database files at rest without requiring expensive hardware upgrades.

CUse IPSec on the storage array.

IPSec (Internet Protocol Security) is a protocol suite used for securing IP communications by authenticating and encrypting each IP packet of a communication session. It is used for data-in-transit, not for data-at-rest on a storage array.

DEnable HTTPS on the application.

Enabling HTTPS (Hypertext Transfer Protocol Secure) on the application encrypts data-in-transit between the client and the application server. It does not provide encryption for data stored at rest within the backend database or storage.

Concept tested: Data-at-rest encryption for databases (cost-effective)

Source: https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption-tde

Topics

#Data at Rest Encryption#Database Encryption#Cost Optimization#Compliance

Community Discussion

No community discussion yet for this question.

Full CV0-002 Practice