Appian Exam Appian Certified Senior Developer Topic 1 Question 7 Discussion

Actual exam question for Appian's Appian Certified Senior Developer exam

Question #: 7
Topic #: 1

[All Appian Certified Senior Developer 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 Appian Certified Senior Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Annett

3 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

Ulysses

1 months ago

Process model might be too complicated for just inserting a deleted row into a history table.

upvoted 0 times

...

Odelia

1 months ago

Materialized view won't work for this scenario.

upvoted 0 times

...

Glendora

1 months ago

I agree, Trigger will allow you to automatically insert the deleted row into the history table.

upvoted 0 times

...

Edwin

1 months ago

I think Trigger is the best option for this.

upvoted 0 times

...

Elbert

2 months ago

Trigger it is then, thanks for the input!

upvoted 0 times

...

Ettie

2 months ago

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

upvoted 0 times

...

Shawna

2 months ago

I agree, Trigger would be the most efficient method.

upvoted 0 times

...

Muriel

2 months ago

I think Trigger is the best option for this.

upvoted 0 times

...

Shelba

3 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

3 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

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

2 months ago

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

upvoted 0 times

...

Mike

3 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

...