Sobes.tech

What are ACID requirements? Briefly comment on each property.

Middle+
69

What is the difference between CMD and ENTRYPOINT in Dockerfile?

Middle+
56

How have you used dunder methods in your work and for which implementations have they been useful?

Middle+
54

What are the advantages of ORM compared to raw SQL?

Middle+
53

What is data normalization and what is it used for?

Middle+
53

How can GIL limitations be bypassed and subsequent requests not blocked when executing one?

Middle+
52

What is a lambda function, why is it convenient, and where is it used?

Middle+
52

What are the normal forms and what do they solve?

Middle+
50

What is the difference between WHERE and HAVING operators?

Middle+
49

What is GIL, what are its advantages, disadvantages, and the inconveniences it creates?

Middle+
47

How to prevent shared resource usage by threads so that resources are isolated for each instance?

Middle+
46

What mechanism in the database prevents duplicate creation during concurrent requests with the same idempotency key?

Middle+
46

What are the differences between PostgreSQL, MongoDB, and ClickHouse, and when should each be chosen?

Middle+
46

What happens if two requests with the same idempotency key arrive simultaneously from different threads or processes?

Middle+
42

How was your CI pipeline structured: what stages and jobs did it consist of?

Middle+
40

class PayoutService: def __init__(self): # ... pass def create_payout(self, idempotency_key: str, terminal_id: int, amount: float) -> dict: """ Should return a dictionary of the form: {"payout_id": <int>, "terminal_id": <int>, "amount": <float>, "status": "success"} Guarantees: - on first call with a new idempotency_key — a new payout is created - on subsequent calls with an already used idempotency_key — the result of the first call is returned, a new payout is NOT created - amount must be > 0, otherwise — raise ValueError """ raise NotImplementedError

Middle+
39

In which cases would you consciously refuse ORM in favor of raw SQL queries?

Middle+
38

How are microservices divided by responsibility and according to what rule?

Middle+
37

What is a generator, how does it work, what is its optimality, and how to distinguish it in code?

Middle+
36
/2