How did you find out that something was breaking or degrading? What did you look at?
Middle+
116
Python
11040
584
System setup and instructions for replacing Pinkman mentions with targetAI.
Senior
115
What are EXPLAIN and EXPLAIN ANALYZE in PostgreSQL? How to perform DELETE/UPDATE without applying actual changes?
Senior
115
What is Python and what are its main principles?
Junior
114
Tell me about GIN index. Why did you use full-text search in PostgreSQL instead of Elasticsearch?
Middle
114
Tell us how frontend development was organized in your previous company?
Junior — Middle
114
How is memory organized in Python? Tell me about arenas, pools, blocks.
Senior
113
If an external service is slow — how to localize this and what to do about it?
Middle
113
How was idempotency ensured when working with Kafka? What happens if a task in Airflow is restarted after an error during Kafka reading?
Middle
113
Did you encounter SQL optimization tasks due to issues in production or did you initiate them yourself?
Middle
113
Are there issues with transmitting objects over Unix sockets between processes? How to eliminate serialization?
Middle
112
If you make a return of the connection inside a context manager, will it be open or closed?
Middle
112
What types of JOIN exist in SQL?
Senior
112
What are iterators and generators in Python? What are their advantages?
Senior
112
Tell me about indexes in PostgreSQL, which ones do you know?
Middle
112
Why did you choose the GIN index for full-text search? Why didn't you use search engines like Elasticsearch?
Middle
112
Tell me about GIL and how it influences the choice between threading, multiprocessing, and asyncio.
Middle
112
Identify the issue with the following Python function and explain why it occurs: ```python from typing import Any def add_item(item: Any, my_list: list = []) -> list: my_list.append(item) return my_list add_item(5) ```
Senior
111
broker = KafkaBroker("localhost:9092") app = FastStream(broker) @broker.subscriber("raw_texts_topic", group_id="text_parsers") async def handle_text(text_data: dict): # Парсинг и сохранение в БД занимает ~10 секунд parse_text_and_save_to_postgres(text_data)
Middle+
110
What will the function return: def foo(): try: return 1 except Exception: return 2 else: return 3 finally: return 4
Middle
109