- A
Encrypt the spreadsheet and send the full file as-is to preserve all records.
Why wrong: Encryption helps protect data in transit or storage, but it does not address unnecessary exposure of sensitive fields. If the auditor does not need SSNs or bank account numbers, those fields should not be shared at all. Encryption is useful, but it is not a substitute for minimizing the data disclosed.
- B
Remove or redact the fields the auditor does not need, then share only the minimum necessary data.
Data minimization is the best practice here. The analyst should provide only the information required for the audit and redact SSNs and bank details that are not needed. This reduces the amount of sensitive data exposed to an external party and lowers the impact of any accidental disclosure. It is the most privacy-conscious and operationally sound choice.
- C
Store the file in a shared cloud folder and grant the auditor read-only access.
Why wrong: Read-only access does not solve the core issue because the auditor would still see more sensitive information than necessary. Access control alone is not enough when the file contains unneeded personal data. The safer approach is to remove the unnecessary data before any sharing occurs, even with restricted permissions.
- D
Convert the file to PDF so the sensitive information is harder to edit.
Why wrong: Converting to PDF changes the format, but it does not remove or protect unnecessary personal information. The sensitive fields would still be visible to the recipient. This option may reduce accidental edits, but it does not support privacy requirements or data minimization.
Quick Answer
The correct choice is to remove or redact the unnecessary fields before sharing, because this directly applies the principle of data minimization. By stripping out Social Security numbers and bank account details—leaving only employee names, departments, and salary totals—the analyst ensures that only the minimum necessary data is disclosed, reducing the risk of exposing sensitive personally identifiable information (PII) to the external auditor. On the Security+ SY0-701 exam, this scenario tests your understanding of data minimization as part of privacy and confidentiality controls, often paired with least privilege and need-to-know concepts. A common trap is assuming that encryption alone is sufficient, but encryption still exposes the data if the auditor has the key; the correct action is to eliminate the data entirely. Remember the mnemonic “MINIMIZE” — Make It Necessary, Ignore the MInus, Zero Extras.
SY0-701 Security Program Management and Oversight Practice Question
This SY0-701 practice question tests your understanding of security program management and oversight. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
An HR analyst must send a compensation spreadsheet to an external auditor. The auditor only needs employee names, departments, and salary totals; Social Security numbers and bank account fields are not required. What should the analyst do before sharing the file?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Remove or redact the fields the auditor does not need, then share only the minimum necessary data.
Option B is correct because the principle of data minimization requires sharing only the information necessary for the task. By removing or redacting the Social Security numbers and bank account fields, the analyst reduces the risk of exposing sensitive personally identifiable information (PII) to the external auditor, aligning with least privilege and need-to-know principles.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Encrypt the spreadsheet and send the full file as-is to preserve all records.
Why it's wrong here
Encryption helps protect data in transit or storage, but it does not address unnecessary exposure of sensitive fields. If the auditor does not need SSNs or bank account numbers, those fields should not be shared at all. Encryption is useful, but it is not a substitute for minimizing the data disclosed.
- ✓
Remove or redact the fields the auditor does not need, then share only the minimum necessary data.
Why this is correct
Data minimization is the best practice here. The analyst should provide only the information required for the audit and redact SSNs and bank details that are not needed. This reduces the amount of sensitive data exposed to an external party and lowers the impact of any accidental disclosure. It is the most privacy-conscious and operationally sound choice.
Related concept
Read the scenario before looking for a memorised answer.
- ✗
Store the file in a shared cloud folder and grant the auditor read-only access.
Why it's wrong here
Read-only access does not solve the core issue because the auditor would still see more sensitive information than necessary. Access control alone is not enough when the file contains unneeded personal data. The safer approach is to remove the unnecessary data before any sharing occurs, even with restricted permissions.
- ✗
Convert the file to PDF so the sensitive information is harder to edit.
Why it's wrong here
Converting to PDF changes the format, but it does not remove or protect unnecessary personal information. The sensitive fields would still be visible to the recipient. This option may reduce accidental edits, but it does not support privacy requirements or data minimization.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates may focus on security controls like encryption or access restrictions (options A, C, D) without recognizing that the core issue is data minimization—removing unnecessary sensitive data before sharing, not just protecting the file in transit or at rest.
Detailed technical explanation
How to think about this question
Data minimization is a core principle of privacy frameworks like GDPR and NIST SP 800-53, requiring that only the minimum necessary data be collected, processed, or shared. In practice, redaction can be performed using spreadsheet functions (e.g., replacing cell values with 'REDACTED') or using data loss prevention (DLP) tools that automatically strip sensitive fields before sharing. A real-world scenario is a payroll audit where the auditor only needs aggregated salary totals, not individual identifiers, to avoid compliance violations.
KKey Concepts to Remember
- Read the scenario before looking for a memorised answer.
- Find the constraint that changes the correct option.
- Eliminate answers that are true in general but not in this case.
TExam Day Tips
- Watch for words such as best, first, most likely and least administrative effort.
- Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A security analyst at a medium-sized enterprise encounters this scenario during an investigation or architecture review. The correct answer reflects best practice for the specific threat or control described. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Security exam questions test whether you can match controls to threats in context — not just recall definitions.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
- →
Security Program Management and Oversight — study guide chapter
Learn the concepts, then practise the questions
- →
Security Program Management and Oversight practice questions
Targeted practice on this topic area only
- →
All SY0-701 questions
1,152 questions across all exam domains
- →
Security+ SY0-701 study guide
Full concept coverage aligned to exam objectives
- →
SY0-701 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Related SY0-701 practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
General Security Concepts practice questions
Practise SY0-701 questions linked to General Security Concepts.
Threats, Vulnerabilities, and Mitigations practice questions
Practise SY0-701 questions linked to Threats, Vulnerabilities, and Mitigations.
Security Architecture practice questions
Practise SY0-701 questions linked to Security Architecture.
Security Operations practice questions
Practise SY0-701 questions linked to Security Operations.
Security Program Management and Oversight practice questions
Practise SY0-701 questions linked to Security Program Management and Oversight.
Security+ social engineering questions
Practise SY0-701 questions linked to Security+ social engineering questions.
Security+ cryptography practice questions
Practise SY0-701 questions linked to Security+ cryptography.
Security+ IAM questions
Practise SY0-701 questions linked to Security+ IAM questions.
Security+ risk management questions
Practise SY0-701 questions linked to Security+ risk management questions.
Security+ incident response questions
Practise SY0-701 questions linked to Security+ incident response questions.
Security+ malware questions
Practise SY0-701 questions linked to Security+ malware questions.
Security+ vulnerability management questions
Practise SY0-701 questions linked to Security+ vulnerability management questions.
Practice this exam
Start a free SY0-701 practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this SY0-701 question test?
Security Program Management and Oversight — This question tests Security Program Management and Oversight — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Remove or redact the fields the auditor does not need, then share only the minimum necessary data. — Option B is correct because the principle of data minimization requires sharing only the information necessary for the task. By removing or redacting the Social Security numbers and bank account fields, the analyst reduces the risk of exposing sensitive personally identifiable information (PII) to the external auditor, aligning with least privilege and need-to-know principles.
What should I do if I get this SY0-701 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
5 more ways this is tested on SY0-701
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. An HR analyst must send a salary file to an external auditor. The auditor only needs names, departments, and salary totals, not Social Security numbers or bank account details. Which two actions should the analyst take first? Select two.
easy- ✓ A.Remove unnecessary sensitive fields before sharing
- ✓ B.Use an approved encrypted transfer method
- C.Upload the file to a public link and send the URL by email
- D.Rename the file to a less obvious name and send it normally
- E.Save the file locally on a USB drive and hand-deliver it
Why A: Option A is correct because removing unnecessary sensitive fields (like Social Security numbers and bank account details) before sharing the file reduces the risk of exposing personally identifiable information (PII) and aligns with the principle of data minimization. This step ensures that only the required data (names, departments, salary totals) is transmitted, which is a foundational security control before any data transfer occurs.
Variation 2. An HR analyst needs to send a payroll reconciliation file to an external auditor. The file contains employee names, SSNs, bank account numbers, and salary details, but the auditor only needs employee IDs, payment totals, and a control total. What should the analyst do first?
medium- A.Encrypt the full spreadsheet and send it without changing the contents.
- ✓ B.Redact or remove unnecessary sensitive fields before sharing the minimum required data.
- C.Compress the file into a password-protected archive and email the password separately.
- D.Copy the file to a personal cloud storage account to make sharing easier.
Why B: Option B is correct because the principle of data minimization requires that only the necessary data (employee IDs, payment totals, control total) be shared with the external auditor. Redacting or removing unnecessary sensitive fields (SSNs, bank account numbers, salary details) reduces the risk of exposure and complies with privacy regulations. This step should occur before any encryption or transmission to ensure the auditor never receives data they do not need.
Variation 3. An HR analyst must share a spreadsheet with an external auditor. The spreadsheet includes employee names, Social Security numbers, bank account numbers, and salary data, but the auditor only needs employee names and total payroll. Which three actions best protect the data? Select three.
medium- ✓ A.Remove fields the auditor does not need before sharing the file.
- ✓ B.Send the file using an encrypted transfer method.
- ✓ C.Share the file only with the named auditor account or approved firm contact.
- D.Leave the full spreadsheet intact because the auditor requested a copy.
- E.Post the spreadsheet in a shared public portal for easier access.
Why A: Option A is correct because removing unnecessary fields (e.g., Social Security numbers, bank account numbers) before sharing the spreadsheet minimizes the exposure of sensitive personally identifiable information (PII) and financial data. This practice, known as data minimization, aligns with the principle of least privilege and reduces the risk of unauthorized access or data breach. By stripping out extraneous columns, the HR analyst ensures the auditor receives only the required data (employee names and total payroll), thereby protecting the organization from compliance violations under regulations like GDPR or PCI DSS.
Variation 4. A data analyst needs a copy of a customer file for product testing. The file includes names, email addresses, purchase history, and government ID numbers, but the test team only needs the names and purchase history. What is the BEST handling action?
medium- A.Provide the full file because the test team is internal and already trusted.
- ✓ B.Remove or mask the government ID numbers before sharing the minimum necessary fields.
- C.Encrypt the file and send it by email to the entire test group.
- D.Keep the file unchanged and rely on the team not to open the sensitive columns.
Why B: Option B is correct because it applies the principle of least privilege and data minimization. The test team only needs names and purchase history, so removing or masking the government ID numbers before sharing the minimum necessary fields protects sensitive personally identifiable information (PII) and complies with data protection regulations like GDPR or CCPA. This action reduces the risk of unauthorized exposure of high-risk data while still enabling the test team to perform their work.
Variation 5. An HR manager wants to share employee data with a benefits analytics vendor. The dataset includes names, employee IDs, home addresses, and medical leave codes. Security wants to reduce privacy exposure while still allowing the vendor to complete the analysis. What is the best first step?
medium- A.Send the full file as-is if the vendor agrees not to disclose it
- ✓ B.Provide only the minimum necessary fields and replace direct identifiers with project IDs
- C.Keep the names but mark the spreadsheet confidential before sending it
- D.Upload the file to a public cloud folder and restrict the link to the vendor
Why B: Option B is correct because it implements data minimization, a core privacy principle, by providing only the minimum necessary fields and replacing direct identifiers (names, employee IDs) with project-specific pseudonyms. This reduces exposure of personally identifiable information (PII) while preserving the vendor's ability to perform analytics on the medical leave codes and other non-identifying data. It aligns with the CompTIA SY0-701 objective of applying privacy-enhancing techniques like anonymization and data masking.
Last reviewed: Jun 11, 2026
This SY0-701 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SY0-701 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.