nerdexam
CompTIACompTIA

DA0-002 · Question #11

DA0-002 Question #11: Real Exam Question with Answer & Explanation

The correct answer is C: Sensitive. 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

Explanation

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.

Common mistakes.

  • A. Public data is generally accessible to anyone and typically does not require security triggers for protection, as its disclosure causes no harm.
  • B. Open data is publicly available data that anyone can access, use, and share without restrictions, so security triggers are not usually needed for it.
  • D. Non-sensitive data poses little to no risk if exposed, thus security triggers are usually overkill for such information.
  • F. 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

Reference. 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 PracticeBrowse All DA0-002 Questions