Python
What is the CAP theorem?
The description is provided by a business analyst who wrote the task "as they could" and can give business requirements descriptions. There is a terrible legacy PHP code that receives log files from S3 parses them, writes the result to the necessary location. Known: files arrive once an hour, currently 5 files all files are in one bucket Data should be directed to different places depending on the format – postgres/local file It is necessary to write an ETL that implements this functionality. Specific implementation of methods (reading data/sending data, etc.) can be neglected.
How was your testing department organized, and how do you relate to this area?
How does Kafka outperform Redis Pub/Sub?
When is a Seq Scan considered normal, including on a large table?
What is an abstract class? Have you used it?
How important is a completely white salary to you, and are you considering an alternative part?
How to solve the problem of concurrent access to a product during a sale? How to use Redis to solve this problem without database locking?
SOLID principles: tell about each.
def withdraw(user_id, amount): user = User.objects.get(id=user_id) if user.balance < amount: raise InsufficientFundsError() user.balance -= amount user.save()
Tell us about the interaction of services via REST and Kafka — what were the use cases for each approach?
How does the model technically 'call' tools if it simply predicts text?
[name] asked: Users cannot log into the application, causing the company to lose money. What will be your actions?
What ML models, besides LLM, do you know from a business application perspective?
What is encapsulation? What are its features from the perspective of Python?
What types of PostgreSQL indexes have you used and what are their features?
What happens when a key is inserted into a dict if the hash matches an existing key?
Were the difficulties successfully resolved independently or with team discussion?
Why can multithreading speed up synchronous HTTP requests through requests despite GIL?
What to do if an SQL query is already optimized but still remains heavy?