Exam Certified Data Architect topic 1 question 80 discussion

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.

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

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.

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)

why can't CD

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