Situational task: you conducted a business analysis, released requirements, handed them to a systems analyst, and during a demo, the customer says it’s not what they wanted. What are your next steps?
System Analyst
In what cases is the 400 Bad Request code returned? Provide examples for our API.
Standard SQL question: what is the difference between WHERE and HAVING?
Have you ever worked with gRPC?
What do you know about message queues? Is Kafka a message queue?
What is a DataFrame, do you know?
Hospital: need reports on patient visits by doctors. How many tables are needed and what is the relationship between them?
List the non-functional requirements you know, and tell how they are handled in a microservices architecture.
There is a possibility that system B may be unavailable during a request for generation. How to bypass?
Design a database for a library: main tables, entities, relationships between them.
Write an SQL query: select patients who have visited more than four different doctors
According to the HTTP standard and RESTful style, can a GET request have a body?
What did your team look like on the project?
What would you say about an API where all methods are implemented via POST (no GET, PUT, PATCH, DELETE)?
What is a broker and ZooKeeper in Kafka?
Are you describing directly in the OpenAPI specification?
When do you choose REST, and when SOAP?
Can a Kafka message have a Retention Time of -1?
Which microservices should be created when splitting a monolithic online store?
Tell us about yourself, your motivation for changing jobs, and your experience.