Database

Lead/Architect Level Interview Questions

Interview Questions (2)

Sorted by: Recently AddedView All Categories

Provide all of the steps you would take to analyze feedback from users of an existing application, plan design changes, and complete a refactor of the application.At your firm's financial services client, a senior transaction advisory group has complained about an existing application. The group handles hundreds of high-value, current financial transaction approvals, related to many thousands of previously approved clients. Because these transactions are time-sensitive, multiple executives often monitor the same queue simultaneously to complete reviews assigned to their group. Their primary issues are not knowing when tasks are completed by other group members, abandoned tasks that have an "in progress" status, delayed task completion time, lack of transparency into assigned tasks, and an inability to reassign tasks they've accepted. Additionally, the group complains about load times for the high volume of data they manage, and irrelevant transactions and tasks showing in their dashboard. 

This question addresses delivery methodology and multiple technical design aspects (task locking, UI/UX, and query performance improvement).Delivery Methodology First, to address t...

#tasklock#query_performance

ridgesawfly5175

2mo ago

Lead/ArchitectScenario

Process Models

In our application, a third-party vendor group currently has access to the system and contains more than 10,000 users across multiple organizations. We want to completely remove this access — meaning we must deactivate all third-party users in the database and also remove them from the Appian third-party group. How would you design this end-to-end solution?

Start With Follow-Up Questions (Very Important in Interviews)Before jumping into the solution, I would ask clarifying questions such as:Where is the user–role–organization mapping ...

#design#storeprocedure#architecture

Anonymous

9mo ago

Loading questions...

Database Appian Interview Questions — Lead/Architect Level

Database

Interview Questions (2)

Database

Interview Questions (2)