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

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

Contribute your Thoughts:

Tricia
1 days 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 days ago
But wouldn't creating a trigger to copy data across be the best option?
upvoted 0 times
...
Alesia
3 days ago
I disagree, I believe creating a stored procedure would be more efficient.
upvoted 0 times
...
Odette
7 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
...
Casey
8 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
15 days ago
I think the most efficient way is to create a view between both tables.
upvoted 0 times
...

Save Cancel