JuniorProcess ModelsWhen working with a synced Record Type in Appian, I understand that data sync keeps the record data up to date in Appian's cache. However, two things are unclear to me:Which smart services automatically trigger a sync when data is written, and which ones require manual intervention?If a developer configures a scheduled sync (full or incremental) when setting up the Record Type, does that eliminate the need to worry about which smart services auto-sync or not?According to Appian's documentation, what is the correct understanding of how these sync mechanisms work together?This is one of the most common points of confusion especially the assumption that a scheduled sync covers all data changes. It does not, and understanding why requires knowing how ...#records#data-sync#smart-servicesnadaelrabie3mo ago2191
SeniorJuniorScenarioProcess ModelsYour user interface contains three independent sections, each displaying data from different database tables. These tables have no foreign key relationships or any other relational links. The requirement is to allow users to update the data in all three sections and save the changes back to the database using Write to Records.Question 1: How would you design the process model to handle writing data from all three unrelated sections back to their respective tables?Question 2: Based on your initial design, restructure the process model to demonstrate:How an End shape would be incorporatedHow a Terminate shape would be incorporatedExplain the purpose and placement of each within the redesigned flow.Question 1: Designing for Multiple Unrelated SectionsWhen your UI contains three independent sections (A, B, and C) that map to three different database tables with no relational l...#designAnonymous3mo ago1151
JuniorSeniorCommonDatabaseIf there is an error occurred in a queryEntity rule, what are the possible reasons ?When answering this in a technical interview, categorize your response to show a structured understanding of how Appian interacts with the database."Errors in an a!queryEntity() ru...Anonymous6mo ago1112
SeniorJuniorDatabaseWhat is view and materialized view ? What is the difference?View:A view is a virtual table based on a SQL query.It does not store data physically.Every time you query a view, the database re-runs the underlying SELECT query to fetch the lat...Anonymous6mo ago891
SeniorJuniorScenarioDatabaseCan you describe a database‑related challenge you faced in one of your recent projects and explain how you resolved it?Challenge: In one of my projects, users started entering emojis in text fields such as names, comments, and messages. Our MySQL database was using the utf8 character set, which onl...Anonymous6mo ago760
JuniorSeniorScenarioDatabaseYou are given two tables: Employee and Department. Each employee is associated with a department through the dept_id column. Write an SQL query to retrieve the number of employees in each department.Ensure that the result includes all departments, even those that currently have no employees.Assuming Tables:Department Table| dept_id | department_name || ------- | --------------- || 1 | HR || 2 | IT || 3 | Finance || 4...pain07m7mo ago741
JuniorDatabaseDifference between Store procedure & View ?ViewA View is a virtual table created using a SQL SELECT statement. It does not store data itself (except indexed/materialized views); it only stores the query.Key PointsRead-only ...Anonymous6mo ago661
JuniorDatabaseWhat is a JOIN in SQL? List and explain the types of JOINs used in SQL with examplesA JOIN clause is used to combine rows from two or more tables, based on a related column between them.Here are the different types of the JOINs in SQL:(INNER) JOIN: Returns records...Anonymous7mo ago551
JuniorCommonDatabaseWhat is the maximum limit to retrieve data through Query Entity ?It is 1MB (default) limit and it can be increased, when increasing this value, apply a corresponding increase to the maximum memory heap size of JVM for the application server.Anonymous7mo ago540
SeniorLead/ArchitectScenarioQuery ExpressionsProvide 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_performanceridgesawfly51753w ago140