Tell me about the HTTP POST method and whether it can be made idempotent.
System Analyst
What is a partition in Kafka? Why are they created?
Have you worked on optimizing SQL queries in PostgreSQL? How does the optimization process work?
How do functional requirements differ from non-functional requirements?
How to display frequently changing data in a mobile application without updating the app itself?
What is the reason for your job search? What is your current situation?
What is the purpose of a Sequence Diagram in describing system interactions? When is it needed?
How do you evaluate the impact of a new feature on the system?
What types of requirements are there? Is the requirement 'all buttons must be red' functional or non-functional?
How does a B-tree index work?
Given: Frogs can be green or speckled. All green frogs are cheerful. If a frog is sad, it sits on the ground. All speckled frogs swim in the pond. Which of the following statements are true/false? 1. All frogs are sad. 2. Only sad frogs are on the shore. 3. All cheerful frogs are green. 4. All frogs are cheerful. 5. If a frog is green, then it swims.
Is caching provided in REST API? Which methods are cached?
What work format are you considering?
Design a database for a library: main tables, entities, relationships between them.
Provide examples of non-functional requirements you have described.
What was the document list you submitted for development — what did it look like?
How would you store data for correct OEE calculation?
How does a JSON parser determine whether it is a simple array or object?
Why is Redis used for caching, and Postgres for transactions?
What is a caching feature and danger in a microservice?