Data-Con-101 practice question 5 of 25

Cumulus Financial is currently using Data Cloud and ingesting transactional data from its backend system via an S3 Connector in upsert mode. During…

Full set: 168 questions
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 initiate a full refresh of data from $3 and will update the formula on all records. Correct answer
B: Data Cloud will only update the formula on a go-forward basis for new records.
C: Data Cloud does not support formula field updates for data streams of type upsert.
D: Data Cloud will update the formula for all records at the next incremental upsert refresh.
Correct Answer:
A. Data Cloud will initiate a full refresh of data from $3 and will update the formula on all records.
Explanation

When a formula field is updated in Data Cloud for data ingested via S3 Connector, the system initiates a full refresh of the data from S3. This ensures that all records, both existing and new, have the formula field recalculated with the updated logic. This behavior is necessary because formula fields are computed fields that need to reflect the new calculation logic across the entire dataset for consistency.

Why Incorrect

B. Incorrect - Data Cloud recalculates formulas for all records, not just new ones, to maintain data integrity.
C. Incorrect - Data Cloud does support formula field updates for upsert mode data streams.
D. Incorrect - Formula updates require a full refresh, not just the next incremental refresh.

References

- Salesforce Data Cloud Implementation Guide, "Managing Formula Fields" section, pages 234-236

- Salesforce Data Cloud Connector Documentation, "S3 Connector Configuration," section 4.3

- Salesforce Help Documentation: "Data Cloud Formula Fields and Data Refresh" (Doc ID: DC-FF-2023)

Scroll to Top