MENU
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?
Suggested Answer: B, C, E
Get Premium ACD200 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
30 comments · newest first
TW
Twana
11 months ago
Surprised this isn't more straightforward!
ME
Melina
11 months ago
A process model could work, but triggers are more efficient.
ST
Staci
12 months ago
Wait, can a materialized view even do that? Seems off.
CA
Carissa
12 months ago
Definitely agree, triggers automate the process.
RE
Renay
12 months ago
I think a trigger is the best way to handle this!
JA
Jaime
1 year ago
I feel like a process model could work too, but it seems more complex than just using a trigger for this specific case.
TI
Tiara
1 year ago
I practiced a similar question, and I think using a trigger would allow for real-time auditing, but I’m not 100% confident.
MA
Malcolm
1 year ago
I'm not entirely sure, but I remember something about materialized views being more for performance rather than auditing.
CL
Clement
1 year ago
I think a trigger might be the best option here since it can automatically log the deleted row without needing extra steps.
PE
Pedro
1 year ago
This looks like a pretty straightforward question. I'd start by identifying the key objects involved in a Salesforce CPQ migration, like Quote, Order, and Assets.
MA
Marti
1 year ago
Hmm, I'm a bit unsure about this one. The options all sound like they could be part of the IFRS development process. I'll need to think it through step-by-step.
CO
Cory
1 year ago
I'm a bit confused on the differences between these two costing systems. I'll need to review my notes to make sure I understand which one is more detailed and which one is easier to administer.
RO
Rosann
1 year ago
I'm a bit confused by the different subnet notations in the options. Let me double-check my understanding of CIDR and subnet masks.
AN
Annett
1 year 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.
UL
Ulysses
1 year ago
Process model might be too complicated for just inserting a deleted row into a history table.
OD
Odelia
1 year ago
Materialized view won't work for this scenario.
GL
Glendora
1 year ago
I agree, Trigger will allow you to automatically insert the deleted row into the history table.
ED
Edwin
1 year ago
I think Trigger is the best option for this.
EL
Elbert
1 year ago
Trigger it is then, thanks for the input!
ET
Ettie
1 year ago
Yeah, Trigger would definitely be the way to go for inserting the deleted row into a history table.
SH
Shawna
1 year ago
I agree, Trigger would be the most efficient method.
MU
Muriel
1 year ago
I think Trigger is the best option for this.
SH
Shelba
1 year 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!
IN
India
1 year 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.
MI
Miesha
1 year ago
I think a trigger is the way to go as well. It's a simple and effective solution for auditing purposes.
MI
Miesha
1 year ago
I agree, a trigger would be the most efficient method for inserting the deleted row into a history table.
MI
Mike
1 year 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.
BR
Brittani
2 years ago
I personally think a Materialized view could also be a good option for this task.
LO
Lorrine
2 years ago
I agree with Filiberto, using a Trigger would be the best option for this scenario.
FI
Filiberto
2 years ago
I think the most efficient method would be using a Trigger.