Salesforce Certified Data Cloud Consultant — Question 72

Cumulus Financial is currently using Data Cloud and ingesting transactional data from its backend system via an S3 Connector in upsert mode. During the initial setup six months ago, the company created a formula field in Data Cloud to create a custom classification. It now needs to update this formula to account for more classifications.

What should the consultant keep in mind with regard to formula field updates when using the S3 Connector?

Answer options

• A. Data Cloud will only update the formula on a go-forward basis for new records.
• B. Data Cloud will update the formula for all records at the next incremental upsert refresh.
• C. Data Cloud does not support formula field updates for data streams of type upsert.
• D. Data Cloud will initiate a full refresh of data from S3 and will update the formula on all records.

Correct answer: B

Explanation

The correct answer is B because Data Cloud processes formula field updates at the next incremental upsert refresh, applying changes to all existing records. Option A is incorrect since it suggests updates only apply to new records, which is not the case. Option C is wrong as Data Cloud does allow formula field updates for upsert streams, and option D is misleading because it implies unnecessary full refreshes when incremental updates are sufficient.