Question 1

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 2

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

Question 3

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 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

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

Free Certified-Lead-Developer Mock Exam – Practice Online Confidently

Buying Options: