System Analyst

What is the purpose of a partition key when working with Kafka?

When does the need for organizing a Consumer Group in Kafka arise?

What is the difference between PUT and PATCH methods?

Can more than one actor (excluding the system) participate in the main flow of events in a Use Case?

How to physically implement a one-to-one relationship between two tables?

Қиын сұраулардың дұрыс жұмыс істеп тұрғанын қалай түсінуге болады, олар жай ғана ұзақ жұмыс істейді?

What types of requirements are there? Is the requirement 'all buttons must be red' functional or non-functional?

What is the main difference between partitions and indexes?

How does a large number of records affect the choice of HTTP method?

Provide a specific example when LEFT JOIN needs to be used.

Есть таблица заказов с полями: id заказа, id клиента, статус, дата создания. Куда логично повесить индекс?

What is idempotency and when is it important? Provide a business scenario.

What methods of integrating two systems are you aware of?

How close was the interaction with designers, frontend, and backend developers?

How can idempotency be verified?

Which HTTP method should be used to implement a method for retrieving 100+ thousand employees with filtering?

What happens if an attribute is not passed or null/0 is passed in PUT and PATCH requests?

Explain the order of executing an SQL query at the operator level.

What is the main difference between data transmission in URL and in body?

Where can data be transmitted in an HTTP request?