Python
If processing becomes a serious CPU-bound task, what problems might arise and how can they be avoided?
ООО ИЦ Ай-текоWhat contract must an object implement to become a context manager in Python?
Лига Цифровой ЭкономикиWhat are MCP servers, how are they configured, and what are they used for?
If the primary key is a UUID and it is inconvenient to perform backfill with ranges, how to organize processing of a large table?
Did you also work through an outstaffing company at [organization]?
Are you still working at [organization]?
What does asyncio.gather do and after how long will it return a result if two async functions run for 5 and 15 seconds respectively, but only contain CPU-bound calculations without await?
Напиши SQL-запрос, чтобы Найти самое длительное видео из 10 наиболее коротких видео таблицы video (id, duration, author_id). with sbq as ( select id, duration, author_id from video order by duration limit 10 ) select id, duration, author_id from sbq order by duration DESC limit 1 select id, duration, author_id from video order by duration limit 1 offset 9 shortest = Video.objects.order_by('duration').values('id')[:10][-1] result = Video.objects.filter(id__in=Subquery(shortest)).order_by("-duration").first()
How do you ensure the stable operation of PostgreSQL and diagnose the causes of performance degradation?
ООО ИЦ Ай-текоWhat HTTP methods do you know and what are they used for?
LeetCode #? — The client complains about a slow sales analytics endpoint: a complex SQL with multiple JOINs and calculations that can take over a minute. A data freshness delay of 5–10 minutes is acceptable. What is the simplest solution you would suggest?
What is a proxy model in Django and what is it used for?
What are asynchronous, multithreading, and multiprocessing? How do they differ and when should each be used?
Tell us about working under very tight deadlines: were you able to complete the task on time and how did you overcome the difficulties?
Why did you decide to leave [organization]?
Tell me what network protocols you know.
What is your experience with Python and why did you choose Python specifically?
Лига Цифровой ЭкономикиWhat is a decorator in Python? Have you used decorators in practice?
Have you developed services from scratch or mainly improved existing developments?
Лига Цифровой ЭкономикиHow strict were you regarding typing in your work?
Лига Цифровой Экономики