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%

Off

Get Premium ACD200 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Delpha

15 days ago

Option B with a SSIS package? Sounds like a good way to make your job security more... permanent.

upvoted 0 times

...

Mica

18 days ago

Option A with a trigger? That's like using a sledgehammer to crack a nut. Talk about going overboard!

upvoted 0 times

Elliot

1 days ago

A) Create 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].

upvoted 0 times

...

Kimberely

1 months ago

I'm torn between options C and D. A view or a stored procedure both sound reasonable, but I'd probably lean towards the stored procedure to keep the logic more encapsulated.

upvoted 0 times

Theola

15 days ago

Creating a view might work too, but a stored procedure seems like a more efficient choice.

upvoted 0 times

...

Juan

18 days ago

I agree, a stored procedure would help keep the logic centralized and easier to manage.

upvoted 0 times

...

Remona

20 days ago

I think a stored procedure would be the best option for this scenario.

upvoted 0 times

...

Franklyn

20 days ago

I think a stored procedure would be the best option for this scenario.

upvoted 0 times

...

Anglea

1 months ago

Option A with a trigger is a bit too much for this use case. It might work, but it feels like overkill and could lead to potential performance issues down the line.

upvoted 0 times

Lashawn

11 days ago

I agree, a view would simplify the process without the need for triggers or stored procedures.

upvoted 0 times

...

Jerry

13 days ago

I think creating a view between both tables would be the most efficient way.

upvoted 0 times

...

Malcolm

19 days ago

Using a SSIS package to run at regular intervals might be a bit more complex than necessary.

upvoted 0 times

...

Lizbeth

26 days ago

Creating a stored procedure to query data from both tables could also be a good option.

upvoted 0 times

...

Titus

28 days ago

Agreed, a view would simplify the process and avoid potential performance issues.

upvoted 0 times

...

Hui

1 months ago

I think creating a view between both tables would be the most efficient way.

upvoted 0 times

...

Tricia

2 months ago

Option B with a SSIS package running at regular intervals seems like a good approach. It allows for more flexibility and control over the data synchronization process.

upvoted 0 times

...