Exam Certified Data Architect All Questions

View all questions & answers for the Certified Data Architect exam

Exam Certified Data Architect topic 1 question 80 discussion

Actual exam question from Salesforce's Certified Data Architect

Question #: 80
Topic #: 1

[All Certified Data Architect Questions]

Universal Containers (UC) requires 2 years of customer related cases to be available on Salesforce for operational reporting. Any cases older than 2 years and up to 7 years need to be available on demand to service agents. UC creates 5 million cases per year.
Which two data archiving strategies should a data architect recommend? (Choose two.)

A. Sync cases older than 2 years to an external database and provide service agents access to the database.
B. Use Custom objects for cases older than 2 years and use a nightly batch to move them.
C. Use Heroku and external objects to display cases older than 2 years and the Bulk API to hard delete them from Salesforce.
D. Use Big objects for cases older than 2 years and use a nightly batch to move them.

Show Suggested Answer

Suggested Answer: AD 🗳️

by vip_10 at Aug. 13, 2023, 11:02 a.m.

Comments

Submit Cancel

bb0607978

7 months ago

if the requirement is to archive cases older then 2, but not older then 7 years, then you certainly need archiving strategy but also a deleting strategy as well. About B) option: with such big number of records to store, you can not use Custom Object is out of question -> NOT B) About A) option: well Heroku is also an external db, and it used extra stgorage and archiving place (Heroku Connect App i.e.), so Heroku is a natural choice over A) On the end you are left with C) and D) options.

upvoted 2 times

...

lizbette

7 months, 3 weeks ago

Selected Answer: AD

A is definitely right because it's a recommended solution B cannot be right because over time, you'll hit a data limit C cannot be right because Heroku has 20million record limitation, and 5 years x 5 mill cases is 25million which is over the limit D - big objects have enough capacity to handle the data volume A&D

upvoted 2 times

...

tobicky

1 year ago

Selected Answer: AD

Option A is recommended because syncing older cases to an external database and providing service agents access to this database can help reduce the load on the Salesforce org while still making the data accessible. Option D is suggested because Big Objects provide a way to handle and store massive amounts of data within Salesforce’s multi-tenant environment. They are designed to provide consistent performance, whether you have 1 million records, 100 million, or even 1 billion.

upvoted 3 times

...

noox

1 year, 2 months ago

Selected Answer: CD

C and D are correct. A - You can't expect a service agent to know how to use a database. B - Custom Object are not designed for LVD (Large Data Volume)

upvoted 3 times

tobicky

1 year ago

The question doesn’t specify that records need to be deleted. The use of the Bulk API to hard delete them from Salesforce in option C might not be necessary if the requirement is to only make the cases available on demand. The main focus should be on strategies that allow for older cases to be easily accessed without affecting the performance of the Salesforce org.

upvoted 1 times

DonDemik

10 months, 4 weeks ago

1) UC creates 5 million cases per year. 2) There are records up to 7 years old. 1+2 means that a large amount of data is generated in UC and should not be saved in Salesforce but somewhere else. so deleting data from Salesforce is necessary.

upvoted 2 times

...

vkm

1 year, 3 months ago

why can't CD

upvoted 3 times

tobicky

1 year ago

upvoted 2 times

...

vip_10

1 year, 4 months ago

Selected Answer: AD

With option B if the data is stored in custom object still it will count against the org's data storage limit.

upvoted 1 times

...