Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Appian ACD200 Exam - Topic 1 Question 51 Discussion

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?
C) Create a view between both the [appian].[document] and [appian].[caseData] tables to feed the record. and D) Create a stored procedure to query the data from both the [appian].[document] and [appian].[caseData] tables.
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].
B) Create a SSIS package to run at a regular interval.

Appian ACD200 Exam - Topic 1 Question 51 Discussion

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

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Elli
6 months ago
Wait, why not just use a view instead of copying data?
upvoted 0 times
...
Estrella
6 months ago
A sounds like a lot of unnecessary data duplication.
upvoted 0 times
...
Daryl
6 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
6 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
7 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
7 months ago
Option C seems the most efficient, views are great for this!
upvoted 0 times
...
Iluminada
7 months ago
SSIS package? That feels like overkill for this task.
upvoted 0 times
...
Shannon
7 months ago
I disagree, D would give more control over the query.
upvoted 0 times
...
Leonor
7 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
8 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
8 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
8 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
8 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
9 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
9 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
9 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
9 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
1 year ago
Option B with a SSIS package? Sounds like a good way to make your job security more... permanent.
upvoted 0 times
Jolanda
1 year ago
D) Create a stored procedure to query the data from both the [appian].[document] and [appian].[caseData] tables.
upvoted 0 times
...
Pilar
1 year ago
C) Create a view between both the [appian].[document] and [appian].[caseData] tables to feed the record.
upvoted 0 times
...
Anthony
1 year 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
1 year ago
Option A with a trigger? That's like using a sledgehammer to crack a nut. Talk about going overboard!
upvoted 0 times
An
1 year ago
C) Create a view between both the [appian].[document] and [appian].[caseData] tables to feed the record.
upvoted 0 times
...
Tamera
1 year ago
B) Create a SSIS package to run at a regular interval.
upvoted 0 times
...
Elliot
1 year 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 year 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
1 year ago
Creating a view might be simpler, but a stored procedure would offer more flexibility in the long run.
upvoted 0 times
...
Tyra
1 year ago
I agree, a stored procedure would help keep the logic centralized and make it easier to manage.
upvoted 0 times
...
Theola
1 year ago
Creating a view might work too, but a stored procedure seems like a more efficient choice.
upvoted 0 times
...
Juan
1 year ago
I agree, a stored procedure would help keep the logic centralized and easier to manage.
upvoted 0 times
...
Remona
1 year ago
I think a stored procedure would be the best option for this scenario.
upvoted 0 times
...
Franklyn
1 year ago
I think a stored procedure would be the best option for this scenario.
upvoted 0 times
...
...
Anglea
1 year 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
1 year ago
I agree, a view would simplify the process without the need for triggers or stored procedures.
upvoted 0 times
...
Jerry
1 year ago
I think creating a view between both tables would be the most efficient way.
upvoted 0 times
...
Malcolm
1 year ago
Using a SSIS package to run at regular intervals might be a bit more complex than necessary.
upvoted 0 times
...
Lizbeth
1 year ago
Creating a stored procedure to query data from both tables could also be a good option.
upvoted 0 times
...
Titus
1 year ago
Agreed, a view would simplify the process and avoid potential performance issues.
upvoted 0 times
...
Hui
1 year ago
I think creating a view between both tables would be the most efficient way.
upvoted 0 times
...
...
Tricia
1 year 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
...
Arletta
1 year ago
But wouldn't creating a trigger to copy data across be the best option?
upvoted 0 times
...
Alesia
1 year ago
I disagree, I believe creating a stored procedure would be more efficient.
upvoted 0 times
...
Odette
1 year 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
Verdell
1 year ago
I would go with option C, creating a view between the tables.
upvoted 0 times
...
Thora
1 year ago
Creating a trigger on the document table seems like a good idea too.
upvoted 0 times
...
Ryan
1 year ago
I agree, a stored procedure would encapsulate the logic nicely.
upvoted 0 times
...
Pamella
1 year ago
I think option D is the best choice. It provides a clean interface to fetch the data.
upvoted 0 times
...
...
Casey
1 year 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
1 year ago
I think the most efficient way is to create a view between both tables.
upvoted 0 times
...

Save Cancel