How to optimize the performance of database queries without increasing the data volume?
Middle
175
System Analyst
2753
0
How do you evaluate experience in designing integrations, working with REST and SOAP?
Middle
175
What is more interesting: working with business requirements or designing solutions (system analysis)?
Middle+
175
What exactly does a consultant do in your company? What is their role?
Middle
175
Why are you considering offers now?
Senior
175
What types of indexes do you know, what are their disadvantages, and why can't you create an index on everything?
Middle
175
What is the main problem of the chosen service interaction structure - No caching to speed up data processing - No retry mechanism in case of failure - No adaptation to changes in preferences - Synchronous calls increase delays due to response time dependency - Authorization check issues in API - Error in processing responses from API
Middle+
175
What criteria do you use when choosing an HTTP method?
Middle
175
Did you have a team or did you handle this whole story alone?
Middle
175
Error loading file Not a diagram file
Middle+
175
Do you have an individual entrepreneur or self-employment status, and are you ready to close it if necessary?
Middle
175
List the main types of software requirements.
Middle
175
Will there be work related to LLM, vibe coding, or own microservices in the project, or is it about a full-fledged product?
Middle
175
Case 4: Need to protect against fraud during attribution when events are sent directly from our server to the AppsFlyer server. Context: the application is subjected to emulator attacks, install fraud, fake survey filling. The basic AppsFlyer anti-fraud (Protect360) filters out some traffic, but the business requires implementing an internal custom validation before sending final target events to advertising channels. Advertising channels transmit a click_id, which must be used to filter events — we only pay for credit issuance. Develop an API interaction scheme and business rules for secure conversion transmission: under what conditions is an event marked as valid and sent to the partner, and when is it invalid, and how is it processed in each case.
Middle
175
Do you have experience working with WebSocket for real-time data exchange?
Middle
175
How is delivery guaranteed in Kafka? Describe the entire chain from preparation to processing by the receiver.
Middle+
175
How to choose between PUT and PATCH for complex mutations?
Middle+
175
You are a system analyst for the Corporate Account Opening system for legal entities. A task has been received from the business customer: to implement an account opening service. The account opening service includes creating a contract and reserving an account. When opening an account, the client's contract was successfully created (saved in the database), but the reservation service returned a technical error. What requirements, as an analyst for the Corporate Account Opening system for legal entities, would you present to the Contract Functional Part (FP) and Reservation FP? Consider options for implementing an integration scenario, taking into account a distributed microservice architecture.
Middle+
175
What exactly do you want to see in the documentation plan and how would you structure it?
Middle+
175
What are indexes and what are they used for? How do indexes appear in a database?
Middle+
175