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

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 3

Your team has deployed an application to Production with an underperforming view. Unexpectedly, the production data is ten times that of what was tested, and you must remediate the issue. What is the best option you can take to mitigate their performance concerns?

Options :

A : Bypass Appians query rule by calling the database directly with a SQL statement.

B : Create a table which is loaded every hour with the latest data.

C : Create a materialized view or table.

D : Introduce a data management policy to reduce the volume of data.

Answer: C

Question 4

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

Question 5

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

Smartly Prepare Exam with Free Online Certified-Lead-Developer Practice Test

Buying Options: