Back to problems

Audit Logs Service

System Design · Snowflake · Medium

Requirements People must be able to retrieve audit records associated with their own account. Account actions produce audit entries, which must be preserved in an append-only transactional record. Account-level reads need to return with low latency. Define a persistence design for both the transaction-log data and its query indexes. Explain how the system will expand as both the number of accounts and the amount of log data increase. Reads must enforce permissions: no user…

Checking your access…