What type of index do you recommend for searching JSON columns in PostgreSQL?
Senior
140
Java
14621
265
Describe the basic hierarchy of exceptions in Java. What are checked and unchecked exceptions?
Senior
140
How is the duplicate check implemented technically — as a separate verification process before insertion or something else?
Senior
140
What is Spring Actuator? What methods (probes) are used to check the application context state for pod balancing in Kubernetes/OpenShift?
Senior
140
What is idempotency and how can it be ensured?
Senior
140
What are microservices and why are they popular? Should they always be used?
Senior
140
What is the Java Memory Model? How does it affect multithreading?
Senior
140
What other scaling methods exist besides horizontal?
Senior
140
Into which microservices should you split an online store?
Senior
140
Have you encountered the problem of distributed transactions? Tell us about the Saga pattern.
Senior
140
Why did you have to engage in SQL optimization, and how were responsibilities divided between data engineers and developers?
Senior
139
Refine the method so that it returns an error upon overflow. Demonstrate with an example of adding two numbers.
Senior
139
Tell about the hierarchy of collections in Java.
Middle
139
How will the service learn about new user orders? How will the data about the number of orders be stored and updated?
Senior
139
How to display all departments including Accounting? What will be in max_salary for Accounting?
Senior
139
What methodology are you used to working with? How do you evaluate tasks and how often do you deploy to production?
Senior
139
There is a backend and a UI. The stack is standard: Java, Spring, React, Postgres. Task: Design a REST endpoint that needs to fetch data from 3 sources and deliver it to the UI, while ensuring maximum possible throughput and minimal response time (max/min criteria based on our specific conditions, since essentially, there is no silver bullet here and we need to find a compromise). It is known that the expected peak RPS for this REST endpoint will be 200. Details about the sources: 1st source - our database, query takes about 3 seconds. 2nd source - a related REST service, degrades to 2 minutes under 100 RPS, in normal mode responds in 5 seconds. We cannot change the behavior of this source on their side. 3rd source - a related REST service, randomly (no discernible pattern) returns 503, in normal mode response takes 10 seconds. We cannot change the behavior of this source on their side.
Middle+
138
Как обеспечить exactly-once семантику в Kafka?
Senior
138
Are we talking about metadata or transactional data when optimizing objects?
Senior
138
What is the purpose of the volatile keyword?
Senior
138