Question 1

You have been asked to produce a Tempo report, with the following requirements:

The report should display in Appian.

The data is held in a business database, but performance in Appian is a key requirement.

Which three actions can you take to minimize the performance impact of your report? (Choose three.)

Options :

A : Display the report as a task report on the Tasks tab

B : Limit the number of series values and categories in the report.

C : Use local variables in your report interface to avoid redundant database queries

D : Use the query process analytics function to retrieve the data.

E : Perform aggregation in the database using a view prior to reading the data into Appian

Answer: B,C,E

Question 2

You need to show joined data from 5 tables. Each table contains a large number of rows and could generate a

large result set after executing the Joins.

The business is not expecting live data, and a 2-hour refresh is acceptable. Performance is a top priority.

What should you use? (Choose the best answer.)

Options :

A : Table

B : View

C : Stored procedure

D : Materialized view

Answer: C

Question 3

You are analyzing a poorly-performing process model. You find that the process model in question has a lot of nodes and is mainly used to do background updates. Which two things can be done to increase its performance? (Choose two.)

Options :

A : Define the correct alerts for the process model.

B : Remove all activity chaining.

C : Use swim lanes in the process model.

D : Refactor some nodes into subprocesses when possible.

Answer: B,D

Question 4

A user is uploading a document in the Appian environment and wants to restrict the uploading of documents without extensions. How can this be done at the environment level?

Options :

A : Enable File Upload > Block files without an extension, under Administration Console.

B : Document can be uploaded but cannot be restricted.

C : Configure Validation rules wherever required.

D : No actions are required from the developer; Appian auto-validates these documents.

Answer: A

Question 5

You need to insert the deleted row of a table into a history table for audit purposes.

What is the most efficient method to achieve this?

Options :

A : Materialized view

B : Process mode

C : View

D : Trigger

Answer: D