Exam ACD200 topic 1 question 38 discussion

Actual exam question from Appian's ACD200

Question #: 38
Topic #: 1

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

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.

Show Suggested Answer

Suggested Answer: AB 🗳️

by cecomavu at April 5, 2025, 1:43 p.m.

Comments

Submit Cancel

Lowcoder

7 months, 2 weeks ago

Selected Answer: AB

more columns in Group By can increase result complexity and slow transformation in appian, Specially when Appian process large data sets into CDT/Records

upvoted 1 times

...

Lowcoder

7 months, 2 weeks ago

Selected Answer: AB

more columns in Group By can increase result complexity and slow transformation in appian, Specially when Apian large data sets into CDT/Records

upvoted 1 times

...

Saurabh04

7 months, 2 weeks ago

Selected Answer: AB

Why the others are incorrect: • C. Create index on filtered column (❌) • This affects query execution time in the database, not the transform phase in Appian. • D. Lower the batch size (❌) • This affects memory consumption and possibly performance, but it typically results in more round trips and doesn’t directly reduce transform time.

upvoted 1 times

...