1. Records Retention & Legal Hold beginner

    A policy says customer records are deleted seven years after the relationship ends. A team implements it literally and still fails the audit. What actually starts the clock, and what does that force into the design?

    2 min answer retentiondeletionobject-lockcrypto-shredding
  2. Records Retention & Legal Hold advanced

    A regulated fintech must prove every customer-facing balance can be reconstructed from an audit trail. Compare event sourcing, CDC into an immutable log, and conventional tables with a triggered audit log.

    3 min answer nubankevent-sourcingcdcaudit
  3. Records Retention & Legal Hold advanced

    Litigation requires preserving all records relating to a matter, overriding normal retention. How is that implemented?

    2 min answer legal-holdretentionpreservationdiscovery
  4. Records Retention & Legal Hold intermediate

    Litigation requires preserving every record relating to one counterparty, overriding a retention policy that deletes after seven years. The data sits in a 400 TB object-store data lake, roughly 60,000 Parquet files, and the relevant rows are perhaps 3% of them spread across most files. Estimate the cost of implementing the hold, and say what you would do.

    3 min answer legal-holdobject-storagetable-formatsretention
  5. Records Retention & Legal Hold advanced

    On 27 September 2022 the SEC and CFTC announced settlements with 15 broker-dealers and one investment adviser totalling over $1.1bn, with individual SEC penalties ranging from $10M to $125M, for failing to preserve business communications conducted on personal messaging apps. What was the architectural failure, and what does it teach about capture obligations generally?

    3 min answer secrecordkeepingcaptureretention
  6. Records Retention & Legal Hold advanced

    Your automated retention job deletes records after seven years. Legal informs you that litigation is anticipated involving accounts from nine years ago. What now?

    2 min answer legal-holdretentionarchitecture