Appian Certified Lead Developer v1.0

You are leading a large Appian program with multiple teams. Teams deploy to production on different cadences and often rely on other IT resources for tasks such as networking, security, and integrations.
You currently use compare and deploy for all Appian deployments. It often takes a long time to coordinate across all teams and resources, and production deployments frequently encounter errors.
Which approach helps to mitigate these issues?

You are designing a related action that edits record data. As the application is used by thousands of users, it is very likely that two users will attempt to edit the same record at the same time.
It is extremely important to the business that one user's data is not overwritten by another.
Which locking strategy should be used?

You are developing an application for managing a historical catalog of countries.
You receive an email with the following error from a database-backed synced record, indicating that there is data outside of the supported range of timestamps:
"[APNX-3-1100-007: marshal: unsupported timestamp 1706-09-22 00:12:43]"
What can be done to maintain data integrity and fix the error?

You are leading the development of an Appian application to handle an online ticketing platform for a major concert venue.
The application needs to process thousands of ticket purchases per minute, with each transaction involving multiple data points.
These data points include:
user information (name, email, address)
ticket details (event date, seat location, price)
payment information (credit card number, expiration date)
order history
Which database design approach is best suited to handle the volume of this transactional system, while still ensuring acceptable performance for data retrieval and reporting?

You are designing an application for a global company whose employees work in different countries. The users need to view read-only text, such as labels, in their native language.
Assuming that all users have their user locale set correctly, how should you best design for internationalization?

HOTSPOT -
You are a lead Appian developer responsible for a critical application. Recently, users have reported that a key dashboard is loading very slowly, impacting their productivity.
Match the descriptions to the appropriate troubleshooting tools.
Note: Each troubleshooting tool will be used once. To change your responses, you may deselect your response by clicking the blank space at the top of the selection list.

Your customer requires the development of many applications, spanning across several departments at the customer's company. While each application has its own business needs, all applications should have the same look and feel.
You and your development teams want to ensure that the objects that are designed for these applications are performant and reusable.
What should you recommend to reduce the chances of shared object breakage?

You lead two small development teams that work in a single shared Appian environment. Within this environment, both teams work on two separate, independent applications, with different release schedules. These two separate applications rely on the same objects, which are stored inside a third application as a shared objects library.
Your teams need to maintain these shared objects across development, test, and production environments.
What should you ask both teams to do?

You have an application where employees upload CSV files of customer information through a start form.
Each row in the CSV files represents a customer's information, identified through columns such as email, address, and phoneNumber.
When an employee submits the start form, the process initiates the Import CSV to Database smart service, directly importing the CSV files to a database table named CUSTOMER.
Every column in the CUSTOMER table has a direct mapping to a column in the CSV file, except for customerId.
The customerId column is auto-incremented by the database and provided at time of import.
The process model then syncs the CUSTOMER Xab\eyT\Xh a corresponding Customer record type.
Occasionally, employees will upload CSV files that contain duplicate Customer records. This occurs when they accidentally upload the same CSV file twice, or when they upload a CSV file that mixes new customer rows with existing customer rows.
How should you ensure that the CUSTOMER database table does NOT have duplicate customer information?

You are implementing a new case management application for a customer in Appian.
The customer has a legacy case management application that has been in operation for over 10 years. All of the data and documents in the legacy application must be migrated over to the new application being built in Appian.
You have gathered the following information:
There are roughly 50GB of documents accumulated.
For each document, there is a set of document metadata stored in database table(s) that describes the case(s) the document is associated with.
There is access control set on each document.
The new application has a different folder structure, requiring documents associated with the case to be stored in a subfolder that corresponds to the document type within a top-level case folder.
Documents within each subfolder has security permissions set to allow only certain groups access to the folder.
How should you approach the document migration process?

You need to implement an effective delivery governance model on your project in order to develop applications with standards and adhere to program-specific requirements.
Which three roles should you involve, at a minimum, to implement effective governance? (Choose three.)

You are designing an application for a financial institution. As part of this application, you have a requirement to track overdue payments. This process runs once daily outside of business hours to generate a JSON payload to be sent to SAP, via a POST integration, with all the overdue payment details. The JSON payload is stored as a text process variable.
Which two options might you consider when developing the process model to create a memory efficient model? (Choose two.)

You are building an application for university students to submit written content for review.
Once a submission record is created, an evaluator should be able to view the submission in a form where they can suggest edits and include external URLs for reference. You are aware that when revisions are made, the size limit of the styled text editor component is almost always exceeded. The final product then would be viewed by students but not edited further.
What should you suggest to fix the issue?

You are code reviewing the interface for a complex dashboard on a site.
The interface reevaluates in under 0.5 seconds, but the initial interface load evaluation takes 4 seconds.
What is one potential issue that could be contributing to the high initial load time?