ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 9 - Certified Data Architect discussion

Report
Export

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

A.
Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
Answers
A.
Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
B.
Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
Answers
B.
Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
C.
Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
Answers
C.
Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
D.
Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
Answers
D.
Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
Suggested answer: B, C

Explanation:

To capture and report on any changes made to ten text fields on the Contact object for the past 3 months, the data architect should write an Apex trigger on Contact after insert and after update events and store the old values in another custom object, or turn on field Contact object history tracking for these ten fields and create reports on contact history. An Apex trigger can capture the old and new values of the fields, as well as the user and time of the change, and store them in a custom object that can be used for reporting. Field history tracking can also track the changes to the fields and store them in a history table that can be used for reporting. However, field history tracking only retains data for up to 18 months or 24 months with an extension, so it may not be suitable for longer-term reporting needs. The other options are not feasible or effective for capturing and reporting on field data changes.

asked 23/09/2024
Xiaoyi Wu
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first