Appian Certified Lead Developer Sample Questions:

1. You are running an inspection as part of the first deployment process from TEST to PROD. You receive a notice that one of your objects will not deploy because it is dependent on an object from an application owned by a separate team.
What should be your next step?

A) Check the dependencies of the necessary object. Deploy to PROD if there are few dependencies and it is low risk.
B) Create your own object with the same code base, replace the dependent object in the application, and deploy to PROD.
C) Halt the production deployment and contact the other team for guidance on promoting the object to PROD.
D) Push a functionally viable package to PROD without the dependencies, and plan the rest of the deployment accordingly with the other team's constraints.

2. You have an active development team (Team A) building enhancements for an application (App X) and are currently using the TEST environment for User Acceptance Testing (UAT).
A separate operations team (Team B) discovers a critical error in the Production instance of App X that they must remediate. However, Team B does not have a hotfix stream for which to accomplish this. The available environments are DEV, TEST, and PROD.
Which risk mitigation effort should both teams employ to ensure Team A's capital project is only minorly interrupted, and Team B's critical fix can be completed and deployed quickly to end users?

A) Team B must address the changes directly in PRO As there is no hotfix stream, and DEV and TEST are being utilized for active development, it is best to avoid a conflict of components. Once Team A has completed their enhancements work, Team B can update DEV and TEST accordingly.
B) Team B must address changes in the TEST environment. These changes can then be tested and deployed directly to PROD. Once the deployment is complete, Team B can then communicate their changes to Team A to ensure they are incorporated as part of the next release.
C) Team B must communicate to Team A which component will be addressed in the hotfix to avoid overlap of changes. If overlap exists, the component must be versioned to its PROD state before being remediated and deployed, and then versioned back to its latest development state. If overlap does not exist, the component may be remediated and deployed without any version changes.
D) Team A must analyze their current codebase in DEV to merge the hotfix changes into their latest enhancements. Team B is then required to wait for the hotfix to follow regular deployment protocols from DEV to the PROD environment.

3. Review the following result of an explain statement:

Which two conclusions can you draw from this?

A) The worst join is the one between the table order_detail and order.
B) The join between the tables 0rder_detail and product needs to be fine-tuned due to Indices
C) The worst join is the one between the table order_detail and customer
D) The request is good enough to support a high volume of data. but could demonstrate some limitations if the developer queries information related to the product
E) The join between the tables order_detail, order and customer needs to be tine-tuned due to indices.

4. Your Agile Scrum project requires you to manage two teams, with three developers per team. Both teams are to work on the same application in parallel. How should the work be divided between the teams, avoiding issues caused by cross-dependency?

A) Group epics and stories by technical difficulty, and allocate one team the more challenging stories.
B) Allocate stories to each team based on the cumulative years of experience of the team members.
C) Group epics and stories by feature, and allocate work between each team by feature.
D) Have each team choose the stories they would like to work on based on personal preference.

5. As part of your implementation workflow, users need to retrieve data stored in a third-party Oracle database on an interface. You need to design a way to query this information.
How should you set up this connection and query the data?

A) Configure a timed utility process that queries data from the third-party database daily, and stores it in the Appian business database. Then use a!queryEntity using the Appian data source to retrieve the data.
B) In the Administration Console, configure the third-party database as a "New Data Source." Then, use a!queryEntity to retrieve the data.
C) Configure an expression-backed record type, calling an API to retrieve the data from the third-party database. Then, use a!queryRecordType to retrieve the data.
D) Configure a Query Database node within the process model. Then, type in the connection information, as well as a SQL query to execute and return the data in process variables.

Solutions: