Appian Exam ACD200 Topic 1 Question 51 Discussion

Actual exam question for Appian's ACD200 exam

Question #: 51
Topic #: 1

An organization has decided to integrate with a third-party to scan incoming documents and capture the details in a table called [appian].[document]. Each document will form a new case in Appian to be displayed on a Record List.

The record needs to show data from both [appian].[document] and [appian].[caseData], which holds additional case information.

What is the most efficient way to achieve this?

ACreate a trigger on the [appian].[document] table to copy all the data across to the [appian].[caseData] table and point the record at [appian].[caseData].

BCreate a SSIS package to run at a regular interval.

CCreate a view between both the [appian].[document] and [appian].[caseData] tables to feed the record.

DCreate a stored procedure to query the data from both the [appian].[document] and [appian].[caseData] tables.

Show Suggested Answer

Suggested Answer: C, D

by Peter at Mar 20, 2025, 08:27 AM

Limited Time Offer

25%

16 days ago

I would go with option D. A stored procedure can encapsulate the logic and provide a clean interface to fetch the data, instead of relying on a view.

upvoted 0 times

Pamella

3 days ago

I think option D is the best choice. It provides a clean interface to fetch the data.

upvoted 0 times

...

Casey

17 days ago

Option C seems the most efficient to me. A view will combine the data from both tables and provide a single source of truth for the record display.

upvoted 0 times

...

Arletta

24 days ago

I think the most efficient way is to create a view between both tables.

upvoted 0 times

...