Sobes.tech

System Analyst

Tell me about the HTTP POST method and whether it can be made idempotent.

216

What is a partition in Kafka? Why are they created?

Middle
216

Have you worked on optimizing SQL queries in PostgreSQL? How does the optimization process work?

215

How to display frequently changing data in a mobile application without updating the app itself?

Middle
215

What is the purpose of a Sequence Diagram in describing system interactions? When is it needed?

215

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

215

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.

215

What work format are you considering?

Middle
215

Design a database for a library: main tables, entities, relationships between them.

Middle+
215

Provide examples of non-functional requirements you have described.

215

What was the document list you submitted for development — what did it look like?

215

How would you store data for correct OEE calculation?

Senior
215

How does a JSON parser determine whether it is a simple array or object?

Middle
215

Why is Redis used for caching, and Postgres for transactions?

Middle
215

What is a caching feature and danger in a microservice?

Middle
215
/138