Back to challenges
Database TestingDatabaseAdvanced
Audit log records
?
Scenario
Your interview prompt
An admin console writes audit log records when users create, update, delete, restore, export, or change permissions. Each audit record should include actor, action, target, timestamp, request id, source IP, and before/after changes where safe.
List flows, risks, edge cases, data conditions, UX, security, API/backend, and performance concerns.
Tip: a stronger answer usually mixes happy path, negative cases, state changes, data, backend, UX, accessibility, and risk.
How to structure your answer
Happy pathNegative casesData rulesSecurity/API risksUX/performance