Data Access · interview question
A bug appears around repository boundaries. What is the strongest first debugging move?
Multiple choiceHardchapter-11-curatedpremiumdata-accessrepository-boundaries
class OrderRepository:
def by_id(self, order_id: str) -> tuple | None:
return connection.execute("SELECT id FROM orders WHERE id = ?", (order_id,)).fetchone()Answer and explanation
Correct answer
D. Trace one concrete example, inspect the state transitions, and compare them to the intended rule before rewriting anything.
Why
That approach is reliable because it creates evidence. If business rules and SQL are tangled together, both testing and change impact get worse.
Test yourself on Data Access
A free test with instant, explained results. No account needed.
More Data Access questions
- What assumption should be made explicit when working with transactions?
- Which response shows the healthiest evidence-first mindset around repository boundaries?
- What production risk should you worry about most if transactions is handled lazily?
- A senior interviewer asks for one tradeoff behind transactions. What is the strongest follow-up?
- What do interviewers usually hear as a strong signal when you discuss transactions well?
- What assumption should be made explicit when working with basic sqlite queries?