What types of JOINs do you know? Which JOIN produces a Cartesian product?
System Analyst
According to which standard did you describe the REST API? How to make POST idempotent?
Task: you are a marketplace analyst for selling tables. You need to implement a backend for a detailed information page for a specific table. What integration would you use and what should the analytics contain for the developer and tester?
What data should the aggregator service and EDI service store in their databases?
Are you familiar with API maturity levels (Richardson model)?
What is the difference between functional and non-functional requirements? What non-functional requirements do you know?
What response codes do you know?
What are the components of an API description?
How do you handle a scenario when an external bank is unavailable?
Have you had experience working with business requirements? Were you a fullstack analyst on the project?
Tell us about your experience designing integrations: how do you describe APIs, what protocols have you used, how do you document?
How were deviations handled when working with Kafka and REST (message did not arrive, service did not respond)?
Write the physical database tables for a catalog service (books, authors, genres, price).
What methods exist for scaling a database as the volume of data grows?
How to reflect a client identifier in the specification if it can be in UUID format?
Do you have more experience in run activities or in change? Specifically in software development and production?
Why is scalability in a microservices architecture better than in a monolith?
Have you encountered the concept of CI/CD?
What data will be transferred from one bank to another?
What types of data are there in JSON?