Sign in to access Teach Me mode
Sign in to ask questions
Copy as MarkdownCtrl+⇧+C
Chapter 21B: Postgres as System of Record Quiz
Twenty questions. No tricks. If you have walked through the eleven lessons and the capstone, you will know these answers. Each question maps to one of the nine drills or one of the SoR habits the chapter taught.
Scoring guidance:
18-20: ready to take the Reconciler database into multi-tenant production15-17: solid foundation, revisit the lessons where you missed11-14: redo the capstone before relying on this database at work<=10: rerun the chapter starting at Lesson 0, slowly
Best practice: answer once without notes, then review misses and retake after targeted repair.
What This Quiz Measures
- O1: System-of-record framing and the gap CRUD leaves behind
- O2: Migrations as schema history, with safe upgrade and downgrade
- O3: The runs/turns/tool_calls journal and crash resume reasoning
- O4: Idempotency keys and
ON CONFLICTdiscipline - O5: Concurrency claims with
FOR UPDATE SKIP LOCKEDand advisory locks - O6: The outbox pattern, relay, and dedup_key
- O7: Append-only events and immutable history
- O8: RLS policies, roles, tenant isolation, and boundary errors
- O9: MCP boundary and minimal tool surfaces
- O10: Forensics from rows alone, four operational queries
Question-to-Outcome Map
| Question | Primary outcome |
|---|---|
| Q1 | O1 |
| Q2 | O2 |
| Q3 | O2 |
| Q4 | O3 |
| Q5 | O3 |
| Q6 | O4 |
| Q7 | O4 |
| Q8 | O5 |
| Q9 | O5 |
| Q10 | O6 |
| Q11 | O6 |
| Q12 | O7 |
| Q13 | O7 |
| Q14 | O8 |
| Q15 | O8 |
| Q16 | O9 |
| Q17 | O9 |
| Q18 | O10 |
| Q19 | O10 |
| Q20 | Integration |
Checking access...