Sobes.tech

What are the advantages and disadvantages of using indexes in databases?

Junior — Middle
171

How do unit, module, and integration testing differ from each other?

Junior — Middle
171

What steps are necessary to update a microservice without interrupting other system components?

Junior — Middle
171

Have you had experience using asynchronous input/output in your projects?

Junior — Middle
171

Describe your experience working in team projects and the role you played there.

Junior — Middle
171

How is a unique trace identifier used for process tracking and analysis in a system?

Junior — Middle
171

How to make 10 requests to an external API in parallel and return the result?

Middle
171

Can you explain how the WebSocket protocol works and how it differs from regular HTTP requests?

Junior — Middle
171

How to manage dependencies and their versions when working with pip for Python projects?

Junior — Middle
171

Condition: Given two arrays of objects. Each object contains a numeric field 'code'. Return a new array containing all objects from array a for which there exists an object in array b with the same 'code' value. The order of elements in the result is determined by the order of the corresponding 'code' in array b: objects from a should be arranged in the order in which their 'code' appears in b. If multiple objects with the same 'code' appear in b, only the first occurrence is considered. Input data: - a — array of objects of the form { code: number, ...rest }, length from 0 to 10^5 - b — array of objects of the form { code: number, ...rest }, length from 0 to 10^5 Output data: Array of objects from a, filtered and ordered by the first occurrence of the corresponding 'code' in b. Constraints: - 0 <= a.length, b.length <= 100 000 - The 'code' field is a non-negative integer - b may contain duplicate 'code' values — only the first occurrence is considered Example function: ```python # Available without import: json, sys, io def intersect_by_code(a, b): # Write solution here return [] ```

171

How is the connection to a PostgreSQL database established?

Junior — Middle
171

Have you participated in remote work or performed tasks outside the office?

Junior — Middle
171

What was the maximum size of data you ever stored or processed in your practice?

Junior — Middle
171

Explain what S3 storage is and how it is used in cloud solutions.

Junior — Middle
171

Do you believe that encapsulation implies a strict separation between public contracts and internal implementations related to data management?

Junior — Middle
171

What reasons might prevent the use of PyCharm in your work?

Junior — Middle
171

How to distinguish and choose between the Poetry tool and the pip package manager for managing dependencies in Python?

Junior — Middle
171
/555