System Analyst

In which cases for security reasons should POST be used instead of GET for read operations?

Have you encountered systems where all operations (read, create, delete) are implemented only through POST? What are the advantages and disadvantages of this approach?

In what order does a DBMS logically process an SQL query?

Do you have experience working with REST API?

Are you familiar with the CAP theorem? Have you used it in your work?

Can you tell me about the advantages and disadvantages of RabbitMQ? How does it differ from Kafka?

Have you ever designed the use of non-standard HTTP headers? In what cases?

На последнем проекте требования поступали только от PM?

Can you elaborate on the achievement: a service for calculating the write-off amount of inventory?

What to do if the database table is very large and cannot handle the load? How would you split a large address directory (e.g., OKTMO)?

Are system requirements functional or non-functional?

You mentioned that it is important for you to have no process chaos. What do you mean by that? What have you encountered?

What is a transaction?

What is your experience with databases? Have you worked with non-relational databases?

Can you name non-idempotent HTTP methods?

What are some ways to optimize database performance?

What can be classified as non-functional requirements?

What HTTP status do you use when the request is valid but the operation cannot be performed due to business constraints (e.g., book limit exceeded)?

How can synchronous interaction be made asynchronous?

What happens if the resource does not exist but a request is sent to it?