Backend · Mid-level · Theory

How do you test backend code that works with a database: do you mock the repositories or spin up a real database?

~4 min by voice

How to approach it

The interviewer wants to see whether you understand that repository mocks don't test the real interaction with the DBMS, and whether you can build a pragmatic strategy: unit tests for pure logic, integration tests with a real database for the data layer, while keeping speed and isolation.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

testing integration tests

Similar questions

How do you write tests with pytest? Tell me about fixtures and how to replace an external dependency in a test. Junior How do you set up testing for a service that works with a database, a message broker and a couple of external APIs? What do you test at which level? Senior How do you build a testing strategy for a Spring Boot service: what do you verify with unit tests using Mockito, what with integration tests, and why? Senior How would you use pytest to test a function that calls an external payment API and writes the result to a database? Mid-level What tests would you write for a backend service, and how is a unit test different from an integration test? Junior

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min