Appian ACD200 Exam - 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

Elli

2 months ago

Wait, why not just use a view instead of copying data?

upvoted 0 times

...

Estrella

2 months ago

A sounds like a lot of unnecessary data duplication.

upvoted 0 times

...

Daryl

2 months ago

I have a vague memory of SSIS packages being used for data integration, but I’m not confident if option B is the right choice here.

upvoted 0 times

...

Lashawnda

2 months ago

I practiced a similar question where we had to decide between triggers and stored procedures. I think D could work, but it might be less efficient than a view.

upvoted 0 times

...

Jolene

2 months ago

I'm not entirely sure, but I feel like creating a trigger could lead to data inconsistencies. Option A seems risky.

upvoted 0 times

...

Junita

2 months ago

Option C seems the most efficient, views are great for this!

upvoted 0 times

...

Iluminada

3 months ago

SSIS package? That feels like overkill for this task.

upvoted 0 times

...

Shannon

3 months ago

I disagree, D would give more control over the query.

upvoted 0 times

...

Leonor

3 months ago

I remember we discussed using views in class, and I think option C might be the best way to combine data without duplicating it.

upvoted 0 times

...

Tamar

3 months ago

This is a tricky one. I'm not sure if any of the options are really the "most efficient" way to do this. I might try to get some more information about the specific requirements and the expected volume of data before deciding. If it's a relatively small amount of data, maybe a stored procedure (option D) would be the simplest approach. But if the data is more complex or changes frequently, a view (option C) could be better. I'll need to think this through a bit more.

upvoted 0 times

...

Ronnie

4 months ago

Okay, let me think this through. I think the key here is to find the most efficient way to get the data from both tables into the record list. Option A with a trigger seems like it could work, but that might get messy if the data in the [appian].[document] table changes a lot. Option B with SSIS could work, but that feels a bit overkill for this use case. I'm leaning towards option C with the view - it seems like the cleanest and most maintainable solution.

upvoted 0 times

...

Ronald

4 months ago

Hmm, I'm a bit unsure about this one. I'm not super familiar with Appian, so I'm not sure if a view is the best approach. Maybe option D with a stored procedure would be better? That way I can encapsulate the logic in one place and make it easier to maintain.

upvoted 0 times

...

Olive

4 months ago

This seems like a pretty straightforward question. I'd probably go with option C and create a view between the two tables. That way, the data is always up-to-date and I don't have to worry about maintaining any triggers or scheduled jobs.

upvoted 0 times

...

Charisse

4 months ago

Option A with a trigger sounds like it could work, but I'm not sure if that's the most efficient approach. Triggers can sometimes cause performance issues, especially if the volume of documents is high. I'd probably lean more towards a view or a stored procedure.

upvoted 0 times

...

Maile

4 months ago

I think option D with a stored procedure could work well here. That way, we can encapsulate the logic for querying both tables and return a single result set. It might be a bit more work upfront, but it could make the record list more maintainable in the long run.

upvoted 0 times

...

Deandrea

5 months ago

Hmm, I'm a bit unsure about this one. The question mentions integrating with a third-party system, so I'm not sure if a view would be the best approach. Maybe option B with a SSIS package would be more robust and flexible?

upvoted 0 times

...

Selma

5 months ago

This looks like a straightforward data integration problem. I'd probably start by considering option C - creating a view between the two tables. That seems like the most efficient approach to get the data from both sources into a single record.

upvoted 0 times

...

Delpha

9 months ago

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

upvoted 0 times

Jolanda

8 months ago

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

upvoted 0 times

...

Pilar

8 months ago

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

upvoted 0 times

...

Anthony

8 months 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

...

Mica

9 months ago

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

upvoted 0 times

An

8 months ago

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

upvoted 0 times

...

Tamera

8 months ago

B) Create a SSIS package to run at a regular interval.

upvoted 0 times

...

Elliot

9 months 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

10 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

Cecil

8 months ago

Creating a view might be simpler, but a stored procedure would offer more flexibility in the long run.

upvoted 0 times

...

Tyra

8 months ago

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

upvoted 0 times

...

Theola

9 months ago

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

upvoted 0 times

...

Juan

9 months ago

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

upvoted 0 times

...

Remona

9 months ago

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

upvoted 0 times

...

Franklyn

9 months ago

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

upvoted 0 times

...

Anglea

10 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

9 months ago

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

upvoted 0 times

...

Jerry

9 months ago

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

upvoted 0 times

...

Malcolm

9 months ago

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

upvoted 0 times

...

Lizbeth

10 months ago

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

upvoted 0 times

...

Titus

10 months ago

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

upvoted 0 times

...

Hui

10 months ago

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

upvoted 0 times

...

Tricia

10 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

...