WNS Vuram

1. Can you describe your role in the current project? Do you mentor or lead junior developers?
2. Have you been involved in production deployments? What responsibilities did you handle during PROD releases?
3. What is a record type in Appian, and why should it be used?
4. What are the limitations of record types?
5. What process model best practices do you typically follow in Appian?
6. What is the difference between escalation and exception handling?
7. In task properties, what is the difference between tp!owner and tp!assignee?
8. What is task chaining in Appian? Why is it used, and what are its limitations?
9. An interface has three sections, each displaying data from different database tables with no foreign key or record relationships. You need to write this data to the database using Write to Records. How would you design the process model?
10. Based on the above process model design:
11. How would you redesign it using End nodes?
12. How would you redesign it using Terminate nodes?
13. Users are experiencing noticeable loading issues on the Appian home page. How would you troubleshoot the performance problem?
14. A queryEntity rule is taking a long time to respond. What steps would you take to identify and resolve the issue?
15. When should you use a stored procedure versus a database view? What are the key differences?
16. What challenges have you faced in your current project, and how were they resolved?
17. What are database indexes? What are their advantages and disadvantages?
18. Given two tables — Employee and Department — related by dept_id, write an SQL query to retrieve the count of employees per department.
19. Write an Appian expression rule to return duplicate values from an array.

Input: {1, 2, 3, 1, 4} Output: {1}