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

Application users are seeing long wait times between two forms they need to complete for a case.

While reviewing the process model, you identify that activity chaining has been used throughout the process

model, including unattended nodes.

Which three actions can you take to make the process model more efficient? (Choose three.)

Options :

A :

Use MNI for unattended nodes and chain where possible.

B : Shorten long process chains by combining transactions into the smallest number of nodes.

C : Avoid chaining system nodes like Integrations.

D : Move transactions that can be done asynchronously outside of the chain.

E : Reduce the number of swim lanes.

Answer: B,C,D

Question 3

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 4

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

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

Buying Options: