Question 1

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 2

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 3

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 4

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 5

Your Appian project just went live with the following environment setup: DEV > TEST (SIT/UAT) > PROD. Your client is considering adding a support team to manage production defects and minor enhancements, while the original development team focuses on Phase 2. Your client is asking you for a new environment strategy that will have the least impact on Phase 2 development work. Which option involves the lowest additional server cost and the least code retrofit effort?

Options :

A :

Phase 2 development work stream: DEV > TEST (SIT) > STAGE (UAT) > PROD Production support work stream: DEV > TEST2 (SIT/UAT) > PROD

B :

Phase 2 development work stream: DEV > TEST (SIT) > STAGE (UAT) > PROD Production support work stream: DEV2 > STAGE (SIT/UAT) > PROD

C :

Phase 2 development work stream: DEV > TEST (SIT/UAT) > PROD Production support work stream: DEV > TEST2 (SIT/UAT) > PROD

D :

Phase 2 development work stream: DEV > TEST (SIT/UAT) > PROD Production support work stream: DEV2 > TEST (SIT/UAT) > PROD

Answer: C

Higher Test Marks with Free Online Certified-Lead-Developer Exam Practice

Buying Options: