nerdexam
CompTIA

DA0-002 · Question #11

A database administrator needs to implement security triggers for an organization's user information database. Which of the following data classifications is the administrator most likely using?…

The correct answer is C. Sensitive E. Private. Security triggers are typically implemented on databases containing data that requires strict access control and protection due to its nature and potential impact if compromised. Therefore, data classified as sensitive or private would necessitate such security measures.

Data Concepts and Environments

Question

A database administrator needs to implement security triggers for an organization's user information database. Which of the following data classifications is the administrator most likely using? (Select two).

Options

  • APublic
  • BOpen
  • CSensitive
  • DNon-Sensitive
  • EPrivate
  • FEncrypted

How the community answered

(25 responses)
  • A
    4% (1)
  • C
    80% (20)
  • D
    4% (1)
  • F
    12% (3)

Why each option

Security triggers are typically implemented on databases containing data that requires strict access control and protection due to its nature and potential impact if compromised. Therefore, data classified as sensitive or private would necessitate such security measures.

APublic

Public data is generally accessible to anyone and typically does not require security triggers for protection, as its disclosure causes no harm.

BOpen

Open data is publicly available data that anyone can access, use, and share without restrictions, so security triggers are not usually needed for it.

CSensitiveCorrect

Sensitive data classification refers to information that requires protection from unauthorized access to safeguard the privacy or security of an individual or organization, often necessitating security controls like triggers to prevent breaches.

DNon-Sensitive

Non-sensitive data poses little to no risk if exposed, thus security triggers are usually overkill for such information.

EPrivateCorrect

Private data, similar to sensitive, is information intended for a restricted audience or specific individuals and must be protected from general public access, thus warranting security measures like triggers to enforce confidentiality.

FEncrypted

Encrypted describes a state or method of protecting data, not a classification category itself, although sensitive and private data are often encrypted for security.

Concept tested: Data classification for security

Source: https://learn.microsoft.com/en-us/microsoft-365/compliance/understanding-your-data-governance-data-classification?view=o365-worldwide

Topics

#Data Classification#Data Security#Database Security#Security Triggers

Community Discussion

No community discussion yet for this question.

Full DA0-002 Practice