ExamTopics Logo
Mail Us[email protected]
Menu
Appian Discussions
exam questions

Exam ACD200 All Questions

View all questions & answers for the ACD200 exam
Go to Exam

Exam ACD200 topic 1 question 38 discussion

Actual exam question from Appian's ACD200
Question #: 38
Topic #: 1
[All ACD200 Questions]

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 Hide Answer
Suggested Answer: AB 🗳️
by cecomavu at April 5, 2025, 1:43 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Lowcoder
2 weeks, 4 days 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
2 weeks, 4 days 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
3 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago