What is the difference between UNION and UNION ALL?
System Analyst
What is the main problem of the chosen solution structure - Module isolation without meta-information exchange - Logic duplication issues in modules - Violation of consistency between modules - Errors in financial report generation - Lack of a centralized deduplication system and related architectural complexities - Issues with accounting for delivery time aspects
How is the performer of an action indicated on a BPMN diagram?
Have you ever had a client add new requirements and comments during a demo — how did you handle it?
Are you currently actively or passively looking for a job? How long have you been viewing market offers?
Have you participated in load testing preparation?
What criteria are important to you when choosing an employer?
Have you ever had to design an API from scratch or only improve existing ones?
Describe the data flow when buying a book — the client is authorized, on the book page, wants to buy it. Where does the API Gateway request go?
Can you give an example of a one-to-one relationship from real life?
What are some ways to optimize database performance?
* What skills should you possess? Choose the competencies that seem mandatory for your position. You can select multiple options. * Choose soft skills you possess. Choose the competencies that seem mandatory for your position. You can select multiple options.
Are you ready for an office or hybrid work environment?
What are the two parts of an HTTP request?
What is the most disliked part of a consultant-analyst's job — what did you like the least?
How to protect an API method from unauthorized access?
Tell me about REST API: POST and GET methods.
How do you describe interaction through a message broker?
Do you know about data exchanges in 1C? How do Accounting and ERP exchange data? What types of exchanges do you know?
What is a message broker?