Appian Lead Developer (ACD200) — Question 22

You are investigating a slow-performing query entity which is mapped to a view and you decide to look in the data_store_details.csv log to gain more information. You see that the majority of the time is spent in the transform phase.
Which two actions can you take to reduce the time spent in the transform phase? (Choose two.)

Answer options

• A. Reduce the use of unnecessary columns in the GROUP BY clause in the database view.
• B. Reduce the number of columns returned from the query.
• C. Create a database index on the column being filtered against.
• D. Lower the batch size parameter of the query.

Correct answer: A, B

Explanation

Options A and B are correct because limiting unnecessary columns in the GROUP BY clause and reducing the returned columns can significantly decrease processing time during transformation. Options C and D may improve overall query performance but do not directly address the time consumed in the transform phase.