For endpoint POST /api/tasks (create task): 1) What input parameters are required? 2) What service parameters are needed for authentication and authorization? 3) Provide an example of a valid JSON request with an array of tag_ids. 4) What HTTP response statuses would you use?
Name the main types of JOIN operators in SQL language
What will you do - Gather and analyze requirements - Interact with external and internal customers - Participate in developing technical solutions - Work on integration interactions - Collaborate with UX/UI, development, testing teams during requirement work (analytical support) - Prepare necessary documentation (TSD, PMI) - Develop specifications and development tasks - Conduct analytical control - Maintain a knowledge base - Demonstrate results to the customer - Handle incidents as a third-line technical support We expect that you Have: - At least 3 years of experience as a systems analyst - Knowledge of BPMN, UML (use case, activity, sequence, state, ER) notations - Knowledge of approaches to gather, analyze, describe functional and non-functional requirements - Experience interacting with customers, development teams
Name the main types of HTTP methods (verbs) used in REST API
Draw a UML use case diagram for a task management system considering the following requirements: status model for each task, association with projects, tagging system, user notifications.
List the main types of UML diagrams
Describe the main steps of the positive scenario (Main Flow) for the Use Case 'Add a comment to a task'.
What is XSD?
What alternative flows need to be identified for the 'Create task' scenario?
Write an SQL query that counts the number of tasks per user. The result should include the username and the number of tasks assigned to each user.
Design a physical data model for a task management system. Highlight all physical tables with primary (PK) and foreign (FK) keys. The model should cover all Use Cases you identified earlier.
List the REST API methods on the backend required to implement task management system scenarios. For each method, suggest a valid URI according to REST architectural style.
List the main types of software requirements.
Through which protocols does REST API operate?
Describe the positive scenario (Main Flow) for the Use Case 'Create a task' with all steps.
1) Do you have practical experience working with XML? 2) Create an XML structure for task information (similar to JSON). 3) Explain in your own words what XSD is. 4) How would you validate an XML document against an XSD schema? 5) What is the difference between Simple Type and Complex Type in XSD?
What happens if an administrator tries to execute the SQL query DELETE FROM Users WHERE user_id = 5, assuming the user with ID=5 has tasks in the Tasks table? Consider a classic relational database (PostgreSQL/MySQL).
