nerdexam
CompTIA

DA0-002 · Question #64

Which of the following allows a data analyst to send out a spreadsheet containing sensitive information without revealing personal details?

The correct answer is B. Redacting all PII. To send a spreadsheet with sensitive information while ensuring personal details are not revealed, the most direct and effective method is to redact all Personally Identifiable Information (PII) from the document. This removes or obscures any data that could identify individuals

Data Governance

Question

Which of the following allows a data analyst to send out a spreadsheet containing sensitive information without revealing personal details?

Options

  • AUsing a UUID in the data file
  • BRedacting all PII
  • CAdding access controls to the ID column
  • DEncrypting the spreadsheet

How the community answered

(29 responses)
  • B
    90% (26)
  • C
    3% (1)
  • D
    7% (2)

Why each option

To send a spreadsheet with sensitive information while ensuring personal details are not revealed, the most direct and effective method is to redact all Personally Identifiable Information (PII) from the document. This removes or obscures any data that could identify individuals before the spreadsheet is shared.

AUsing a UUID in the data file

Using a UUID might pseudonymize an identifier, but it doesn't guarantee the removal of all other PII that could lead to re-identification or ensure personal details are not revealed.

BRedacting all PIICorrect

Redacting all PII (Personally Identifiable Information) involves removing or obscuring any data that could directly or indirectly identify an individual from the spreadsheet. This directly achieves the goal of sharing sensitive information without revealing personal details, as the identifying elements are no longer present.

CAdding access controls to the ID column

Adding access controls limits who can view the ID column, but it does not remove personal details from the spreadsheet itself for authorized viewers who receive it.

DEncrypting the spreadsheet

Encrypting the spreadsheet protects its contents from unauthorized access, but once decrypted by an authorized recipient, all personal details would be fully visible.

Concept tested: Data anonymization and PII redaction

Source: https://learn.microsoft.com/en-us/compliance/regulatory/gdpr-pii

Topics

#Data Privacy#PII#Data Redaction#Sensitive Data

Community Discussion

No community discussion yet for this question.

Full DA0-002 Practice