Model a situation: when two-factor authentication SMS code does not arrive. What could be points of failure?
System Analyst
You need to verify the integration of card authorizations between the banking system and external processing. Choose the most comprehensive testing approach: - Conduct final testing directly in the production environment - Check main operations via REST client - Only verify successful scenarios using API testing tools - Positive + negative scenarios + load testing
Describe the architecture of a server that handles user setting update requests.
What is the main problem with this implementation BEGIN; CREATE TABLE sneakers ( id SERIAL PRIMARY KEY, design JSON NOT NULL ); CREATE OR REPLACE FUNCTION process_sneaker_order(sneaker_id INTEGER) RETURNS VOID AS $$ BEGIN UPDATE sneakers SET design = jsonb_set(design, '{status}', '"Processed"') WHERE id = sneaker_id; END; $$ LANGUAGE plpgsql; INSERT INTO sneakers (design) VALUES ('{"colors":"red,blue", "status":"Pending"}'); PERFORM process_sneaker_order(1); -- COMMIT;
How have you worked with access rights on a project?
Tell me about synchronous and asynchronous interactions — how do you understand this in your own words? Can you give an example from practice?
What types of relationships are on an ER diagram?
What stages of production do you know?
Tell us about synchronous and asynchronous integration.
Do you have experience working with SOAP or XML?
How can cashback be implemented in a banking application? Suggest implementation options.
What is the difference between frontend and backend?
Can a competitor be a stakeholder?
How does Change Management occur if requirements change during development?
With an 8 Mbps mobile internet connection, how long will it take to download a 120MB video?
What data do you always try to clarify, even if the customer does not voice it? What questions do you ask to make the customer think about what they haven't thought of yet?
What are XML and XSD schemas? Why do we create XSD schemas?
Is the interaction synchronous or asynchronous when applying a promo code?
There are several services (three), and you need to add new functionality that affects all three. What are your actions, and what should you pay attention to?
Is the POST method safe?