Appian Exam ACD200 Topic 1 Question 7 Discussion

Actual exam question for Appian's ACD200 exam

Question #: 7
Topic #: 1

[All ACD200 Questions]

You need to insert the deleted row of a table into a history table for audit purposes.

What is the most efficient method to achieve this?

AMaterialized view

BProcess model

CView

DTrigger

Show Suggested Answer

Suggested Answer: B, C, E

by Taryn at Feb 06, 2023, 03:38 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Annett

1 months ago

I was about to suggest a view, but then I realized that's just a transparent window to the data, not a way to actually store the history. Trigger is the clear winner here. Unless, of course, you want to add some spice and go with a process model. You know, really make things complicated.

upvoted 0 times

Elbert

2 days ago

Trigger it is then, thanks for the input!

upvoted 0 times

...

Ettie

7 days ago

Yeah, Trigger would definitely be the way to go for inserting the deleted row into a history table.

upvoted 0 times

...

Shawna

13 days ago

I agree, Trigger would be the most efficient method.

upvoted 0 times

...

Muriel

27 days ago

I think Trigger is the best option for this.

upvoted 0 times

...

Shelba

1 months ago

A trigger is definitely the way to go here. It's like a ninja in the shadows, silently recording every row that gets deleted. Efficient and stealthy, my kind of solution!

upvoted 0 times

...

India

2 months ago

A materialized view? Really? That seems a bit overkill for just keeping a history of deleted rows. I'd go with the good old trigger approach.

upvoted 0 times

Miesha

9 days ago

I think a trigger is the way to go as well. It's a simple and effective solution for auditing purposes.

upvoted 0 times

...

Miesha

12 days ago

I agree, a trigger would be the most efficient method for inserting the deleted row into a history table.

upvoted 0 times

...

Mike

2 months ago

Hmm, I think a trigger would be the most efficient way to handle this. Automatically inserting the deleted row into a history table seems like a pretty straightforward use case for a trigger.

upvoted 0 times

...