Exam Certified Data Architect topic 1 question 37 discussion

A is correct and is general best practice.

Not D - it help manage governor limits, but doesn't prevent issues caused by automation tools running during each batch. It also extend the duration of the overall import time. A - Automation tools are not designed for large-scale data loads. Disabling avoids trigger recursion and speeds up the import process.

The most accurate answer is A. Ensure validation rules, triggers, and other automation tools are disabled. During a large data import, these features can cause delays and conflicts. Disabling them can help prevent errors and improve the performance of the data import. D. Import the data in smaller batches over a 24-hour period: This could help avoid overloading the system, but it might not be enough to prevent all unwanted results, especially if the issues are caused by validation rules, triggers, or other automation tools

Because we want to save all data and prevent any problems so VR should be disabled and also salesforce recommend to by VR and triggers during import and instead preprocess the data

A is only plausible if there is a trigger framework in place that allows code to be disabled via custom settings. Otherwise, the unit tests would fail while trying to disable them and you'd end up working more on commenting code out/deployment and dealing with that fall out rather than your import. But even disabling validation rules and flows can cause well written unit tests to fail if there are dependencies. For this reason, I think it's the answer is D. It's slower, but you'll get the data in without tampering with code. The data can be preprocessed so that validation rules aren't triggered. Realistically, the answer is a combination of A & D - disable what you can and lower the batch size to accomodate for what you cannot.

The answer is A. Even though you can mitigate any lack of bulkyfication by importing records in small batches, that won't bypass validation rules, So in the end you'll still have a lot of data not imported because of validation rules. So I'd say A since it'll allow you to import all set of data.

I would tend more to D. Sure in a well designed Salesforce org, it would not have a big impact, if the triggers are disabled during the load the the processing of the triggers can be executed afterwards. But here I would say, import the 100K records in smaller batches. (D)