PracticeISCFree practice exam

ISC · Security and Confidentiality and Privacy · 7 practice questions

Least Privilege and Masking for PII: CPA ISC

Valid login credentials do not justify access to full sensitive records or unrestricted exports. Follow NorthCo’s SSN data through role design, default masking, controlled full-value access, and export permissions.

The ruleLimit sensitive-data viewing and export permissions to documented business needs. Mask SSNs by default and require approved, logged exceptions for access to full values.

Try one first

TechWorks' developers sometimes run ad hoc queries directly on the production customer database, which contains unencrypted personally identifiable information (PII). Developers share production credentials for debugging, there is no role-based access control or separation between production and development environments, and database logging is incomplete. Management wants to reduce unauthorized internal access to customer PII while minimizing disruption to development. Which of the following is the best mitigation action?
Hint

Which option most directly eliminates developers' broad, shared access to live production data rather than only shifting financial risk or focusing on stored bytes?

Step by step

  1. Identify the actual business need

    NorthCo’s application displays full SSNs to representatives despite database encryption and MFA. Most representatives need only the last four digits; a few documented exception cases require full values.

  2. Limit roles and mask by default

    Remove unnecessary full-SSN viewing rights from routine roles and show only the last four digits by default. Design permissions around the work each role must perform.

  3. Control full-value exceptions

    For documented exception cases, require just-in-time approval before revealing the full SSN. Limit access to the approved period and log the reveal.

  4. Authorize exports separately

    Do not let routine lookup access or an approved full-SSN reveal automatically grant bulk export rights. Restrict full-data exports to approved roles with a documented business need and require separate export approval.

Key points

  • Remember: Permission to log in is not permission to view full SSNs or export them.
  • Encryption at rest does not hide full SSNs that the application displays to authorized users.
  • Logs support accountability, but they do not replace limits on viewing and export permissions.

How the exam traps you

  • Choose stronger database encryption while leaving full SSNs visible to the same users. Change application permissions and default displays to limit what those users can see.
  • Assume a business need to view one full SSN also justifies bulk export. Evaluate export permissions separately and restrict them to approved roles with documented needs.

6 more, each from a different angle

0 of 6 answered · 0 correct

Question 2

An entity uses a SaaS customer-support platform that stores mostly routine service tickets, but it also stores scanned driver's licenses for a small subset of customers during identity verification. A risk review found that support supervisors can use an existing application feature to bulk-export those images, even though bulk export is not needed for normal operations. Management is considering whether database encryption at rest, plus quarterly review of the vendor's SOC 2 report, is a sufficient mitigation without changing user permissions or the export feature. Assume lost media is not the concern and the only material risk scenario is misuse of the existing export capability by an authorized user or a compromised supervisor credential. Which factor should govern whether management can conclude the risk has been adequately mitigated?
Hint

Focus on the specific risk scenario that was identified, not on the platform’s average risk profile or the appearance of stronger general controls.

Question 3

A company stores customer personal information in a cloud file‑sharing platform. Several recent incidents occurred when employees accidentally created public share links for folders containing sensitive data. Management wants a control that most directly reduces the risk of future unauthorized disclosures at the moment a share is being created, rather than mainly detecting problems afterward. Which action best mitigates this risk?
Hint

Choose the control that directly stops an accidental sharing action as it happens, not one that mainly detects issues later or generally hardens accounts.

Question 4

During an internal access review, management discovers that several employees who recently left the company still had active VPN accounts for up to 10 days after termination. Assume the main risk is unauthorized access by former employees using valid credentials. Which control is most appropriate to mitigate this risk?
Hint

Which control removes active access at the moment of termination rather than merely making access harder or relying on periodic/manual checks?

Question 5

An outsourced payroll processor receives client files containing employee SSNs and bank account numbers through a secure portal. The portal already requires MFA, files are encrypted in transit and at rest, and login monitoring is in place. After download, operations supervisors save complete files to a shared team folder so staff can resolve payroll exceptions. In routine work, most staff need only employee name, exception code, and the last four digits of the bank account, but two specialists occasionally need full account numbers to correct rejected ACH records. Assume the shared-folder workflow must remain in use during Year 1, but the company can redesign file views and permissions. Which response is required to best mitigate the identified confidentiality/privacy risk?
Hint

Identify where in the workflow full sensitive data becomes visible to more people than necessary, then choose the control that narrows that exposure without stopping the business process.

Question 6

An online retailer tokenizes customer payment card data. The mapping between each token and the actual card number is stored in a separate secured vault managed by the payment processor, while the retailer's order-entry database stores only the tokens. Assume an attacker compromises only the retailer's order-entry database and does not gain access to the vault. Which consequence most directly reflects the effect of this mitigation?
Hint

Focus on what the attacker actually obtained and how tokenization changes the sensitivity of that data.

Question 7

A company encrypts customer personal data in its database and uses TLS to encrypt the same data while it is transmitted between internal systems. Assume the encryption keys are properly managed and the question is only about confidentiality/privacy mitigation. Which situation is the clearest limitation of these controls?
Hint

Ask what encryption protects against and what it does not control once an authorized user can already view the data.

Drill all 151 Mitigation questionsMixed across every rule in the topic, so you have to spot which one applies. That is how the exam does it.

Common questions

Why isn't encryption enough to protect PII from authorized users?

NorthCo’s application decrypts SSNs for display. Encryption at rest does not prevent a logged-in representative from viewing full values that the application permits.

How should full SSN access work when exceptions are necessary?

Mask SSNs by default. For NorthCo’s documented exception cases, require just-in-time approval to reveal full values and log that access.

Should users who can view SSNs also have export access?

Not automatically. NorthCo should grant export permissions separately, based on a documented business need, rather than attach them to routine lookup access.

Watch it solved

A full CPA ISC task-based simulation on Mitigation, worked step by step.

IT Risk-to-Control Mapping | CPA ISC Simulation (TBS) on YouTube

Practice ISC like the real exam

The free ChatCPA simulator: real exam layout, timed testlets, starting with a question on this topic. No account needed to start.

Open the free simulator →

More on Mitigation

All Mitigation practice →

Questions from the ChatCPA bank of 17,658 CPA exam questions, each with a written reason for every wrong answer. ChatCPA is built by Nicholas Miller, CPA (Oregon #14907). How these pages are made. Spot an error? Tell us.