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.
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)- A4% (1)
- C80% (20)
- D4% (1)
- F12% (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.
Public data is generally accessible to anyone and typically does not require security triggers for protection, as its disclosure causes no harm.
Open data is publicly available data that anyone can access, use, and share without restrictions, so security triggers are not usually needed for it.
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.
Non-sensitive data poses little to no risk if exposed, thus security triggers are usually overkill for such information.
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.
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
Community Discussion
No community discussion yet for this question.