How familiar are you with Elasticsearch / search indices and related interfaces or command line?
System Analyst
When designing an API — what exactly could you not do alone, who did you ask?
With an 8 Mbps mobile internet connection, how long will it take to download a 120MB video?
Describe what needs to be done for a simple API — for example, a courier order history: a list with the total and address.
Task: develop a backend method for updating order status, accessible only to administrators. Create a technical specification for the developer.
It would be incorrect: - You can send a body in a GET request - POST requests can be sent without a body - PUT completely overwrites the existing resource or creates a new one if absent - The UPDATE method partially updates the resource's state - DELETE is idempotent
There is a SOAP service. Which of the edits will not cause errors in existing clients? - Rename the existing element phone → msisdn - Change the type from string to int for an existing element - Change the namespace of the schema/operations - Add a new optional element (minOccurs="0") to an existing type - None of the options will avoid errors
What exactly did you do when designing the API — what was your responsibility?
Where have you deployed microservices?
What data formats can be transmitted in the request body in REST?
Do you have any questions about the project, client, domain, or project stage?
What are ports used for? For example, shop.r2.ru:8773 and shop.r2.ru:80 — can you access the same domain through different ports?
Tell me about your experience as a systems analyst — what did you do on your last project?
What versioning methods have you worked with in practice for HTTP API?
What are the main HTTP methods you know and what are they used for?
To select clients from the Customers table who have at least one order in the Orders table, which query will do this correctly? SELECT * FROM Customers WHERE id = (SELECT customer_id FROM Orders); SELECT * FROM Customers c JOIN Orders o ON c.id = o.customer_id; SELECT * FROM Customers, Orders WHERE Customers.id = Orders.id; SELECT * FROM Customers WHERE id IN (SELECT customer_id FROM Orders);
Condition: NUMBER is a positive number and should not fall within the range from 5 to 10 inclusive. Expression: NOT (NUMBER < 0) AND ((NUMBER > 10) AND (NUMBER < 5))
What parts can be present in an HTTP response - Method - Headers - Path - Status - Body - QUERY parameters
BE is on servers, where is FE?
In what format have you worked: employment contract, GPH, or individual entrepreneur?