Question 1

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?

Options :

A :

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.

B :

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.

C :

Configure an expression-backed record type, calling an API to retrieve the data from the thirdparty database. Then, use a!queryRecordType to retrieve the data.

D :

In the Administration Console, configure the third-party database as a œNew Data Source. Then, use a!queryEntity to retrieve the data.

Answer: D

Question 2

An Appian application contains an integration used to send a JSON, called at the end of a form submission, returning the created code of the user request as the response. To be able to efficiently follow their case, the user needs to be informed of that code at the end of the process. The JSON contains case fields (such as text, dates, and numeric fields) to a customers API. What should be your two primary considerations when building this integration?

Options :

A :

A process must be built to retrieve the API response afterwards so that the user experience is not impacted.

B : The request must be a multi-part POST.

C : The size limit of the body needs to be carefully followed to avoid an error.

D : A dictionary that matches the expected request body must be manually constructed.

Answer: C,D

Question 3

You are tasked to build a large-scale acquisition application for a prominent customer. The acquisition process tracks the time it takes to fulfill a purchase request with an award. The customer has structured the contract so that there are multiple application development teams. How should you design for multiple processes and forms, while minimizing repeated code?

Options :

A : Create a Center of Excellence (CoE).

B : Create a common objects application.

C : Create a Scrum of Scrums sprint meeting for the team leads.

D : Create duplicate processes and forms as needed.

Answer: B

Question 4

You are taking your package from the source environment and importing it into the target environment. Review the errors encountered during inspection: What is the first action you should take to Investigate the issue?

Options :

A : Check whether the object (UUID ending in 18028821) is included in this package

B : Check whether the object (UUD ending in 7t00000i4e7a) is included in this package

C : Check whether the object (UUID ending in 25606) is included in this package

D : Check whether the object (UUID ending in 18028931) is included in this package

Answer: B

Question 5

Review the following result of an explain statement:

Which two conclusions can you draw from this?

Options :

A :

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

B : The worst join is the one between the table order_detail and order.

C :

The join between the tables order_detail, order and customer needs to be tine-tuned due to indices.

D : The join between the tables 0rder_detail and product needs to be fine-tuned due to Indices

E : The worst join is the one between the table order_detail and customer

Answer: C,D