Appian Lead Developer (ACD301) Free Practice Test

Question 1

As part of an upcoming release of an application, a new nullable field is added to a table that contains customer dat a. The new field is used by a report in the upcoming release and is calculated using data from another table.
Which two actions should you consider when creating the script to add the new field?

A. Add a view that joins the customer data to the data used in calculation.

B. Create a rollback script that removes the field.

C. Create a script that adds the field and then populates it.

D. Create a rollback script that clears the data from the field.

E. Create a script that adds the field and leaves it null.

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

You are in a backlog refinement meeting with the development team and the product owner. You review a story for an integration involving a third-party system. A payload will be sent from the Appian system through the integration to the third-party system. The story is 21 points on a Fibonacci scale and requires development from your Appian team as well as technical resources from the third-party system. This item is crucial to your project's success. What are the two recommended steps to ensure this story can be developed effectively?

A. Acquire testing steps from QA resources.

B. Identify subject matter experts (SMEs) to perform user acceptance testing (UAT).

C. Break down the item into smaller stories.

D. Maintain a communication schedule with the third-party resources.

Correct Answer: C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

You have 5 applications on your Appian platform in Production. Users are now beginning to use multiple applications across the platform, and the client wants to ensure a consistent user experience across all applications.
You notice that some applications use rich text, some use section layouts, and others use box layouts. The result is that each application has a different color and size for the header.
What would you recommend to ensure consistency across the platform?

A. In the common application, create a rule that can be used across the platform for section headers, and update each application to reference this new rule.

B. In each individual application, create a rule that can be used for section headers, and update each application to reference its respective rule.

C. In the common application, create one rule for each application, and update each application to reference its respective rule.

D. Create constants for text size and color, and update each section to reference these values.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

You add an index on the searched field of a MySQL table with many rows (>100k). The field would benefit greatly from the index in which three scenarios?

A. The field contains many datetimes, covering a large range.

B. The field contains long unstructured text such as a hash.

C. The field contains big integers, above and below 0.

D. The field contains a textual short business code.

E. The field contains a structured JSON.

Correct Answer: A,C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

A customer wants to integrate a CSV file once a day into their Appian application, sent every night at 1:00 AM. The file contains hundreds of thousands of items to be used daily by users as soon as their workday starts at 8:00 AM. Considering the high volume of data to manipulate and the nature of the operation, what is the best technical option to process the requirement?

A. Build a complex and optimized view (relevant indices, efficient joins, etc.), and use it every time a user needs to use the data.

B. Process what can be completed easily in a process model after each integration, and complete the most complex tasks using a set of stored procedures.

C. Use an Appian Process Model, initiated after every integration, to loop on each item and update it to the business requirements.

D. Create a set of stored procedures to handle the volume and the complexity of the expectations, and call it after each integration.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Appian Lead Developer (ACD301) Free Practice Test