Your question is Database design for scalable automation. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
What are the considerations for database design when building a scalable automation framework?
Discuss how you would model automation definitions, execution history, schedules, workers, results, and audit records. Cover workload characterization, transaction boundaries, indexing, partitioning, concurrency, consistency, retention, recovery, observability, and the tradeoffs between relational, key-value, and event-oriented storage.