How do you work with SQL? What are the differences between INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN?
Middle
341
System Analyst
2735
0
Can you describe a method in OpenAPI?
Middle
333
How actively are you currently looking for a job? Are there offers that need to be accepted soon?
Middle
273
What is the difference between Monolith and Microservice?
Middle+
254
What usually goes wrong in tasks? Tell about a specific task you were assigned as an analyst.
Middle
241
What services have you designed through Kafka and what is their specific feature?
Middle+
240
There is an Excel file, I want to load it into a DataFrame. How to do it? What is the function called?
Middle
238
What architectural approaches are there besides microservices and monolithic architecture? What are the pros and cons of microservices architecture?
Middle
236
The main service with its database should communicate with: 1) an internal service that periodically cannot handle the load, 2) a partner's service that responds only after a day via REST. Where to use synchronous, where asynchronous interaction, and what tools?
Middle
235
What is a checklist in this context and what is its purpose?
Middle+
226
Tell us about your integration experience: did you have asynchronous Kafka and synchronous integrations?
Middle
226
Describe the attribute composition of the main database tables of the library at the top level.
Middle+
225
Have you heard of SELF JOIN?
Middle
225
What is a requirement? Provide a definition of a requirement in the context of systems analysis.
Middle
222
Physical structure — specify data types and constraints.
Middle
221
What requirements do the user interface requirements relate to?
Middle
220
Why does an index speed up search? What can it do?
Middle
220
What is backward compatibility? How have you achieved backward compatibility in your systems?
Middle
218
What should be considered regarding scenarios with limits?
Middle+
216
Designing synchronous and asynchronous interactions between modules — you say you did not participate in the design, you had an architect. How does this relate to your resume?
Middle
216