Python
In what formats is data transmitted and stored when interacting with NoSQL databases?
СовкомбанкCondition There is a database with the following data schema // user id | firstname | lastname | birth 1 | Ivan | Petrov | [phone] | Anna | Petrova | [phone] | Anna | Petrova | [phone] // purchase sku | price | user_id | date 1 | 5500 | 1 | [phone] | 5700 | 1 | [phone] | 4000 | 1 | [phone] | 8000 | 2 | [phone] | 400 | 2 | [phone] // ban_list user_id | date_from 1 | [phone] You need to output: 1. Display unique combinations of user and product id for all purchases made by users before they were banned. Sort first by user name, then by SKU. 2. Find users who made purchases totaling more than 5000 rubles. Display their id, name, surname, and total purchase amount in the format id | name | surname | total amount.
OZONTell us about your experience working on a smart assistant project.
How many hosts can be in a network with a /24 mask?
Do you track tasks and deadlines in Jira or elsewhere?
How do applications in microservice architecture find out each other's current addresses?
Can you tell me more about the difference between Kafka and RabbitMQ?
Provide an example of polymorphism in Python's built-in or standard libraries.
What libraries have you used for interacting with RabbitMQ and Kafka?
```python from collections import Counter def min_s(a: str, s: str) -> str: need = set(a) window = Counter() res = "" c = 0 left = 0 best_len = float('inf') for right, char in enumerate(s): if char in need and \ window[char] += 1 if window[char] == 1: c += 1 while c == len(need): if right - left + 1 < best_len: res = s[left:right + 1] best_len = right - left + 1 if s[left] in need: window[s[left]] -= 1 if window[s[left]] == 0: c -= 1 left += 1 return res ```
What is important to you when choosing a new workplace and a new company? What do you look at?
What is an event loop? How is it related to coroutines?
Are you planning to study somewhere else, for example, in graduate school?
Do you have offers in hand?
What is a transaction in databases? Tell me about ACID.
What parameters in Docker Compose should be set to improve fault tolerance and reliability of the service?
Tell me about indexes in Postgres. What types are there, and how does a B-tree index work?
X5 techWas there a memory leak in Elasticsearch?
How do you assess the deadlines for completing a task? Have you ever experienced a situation where your estimate differed from reality?
Why is a value of 3 used in all calls (value i=3)?