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

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?
A . Data Cloud will initiate a full refresh of data from $3 and will update the formula on all records.
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.

View Answer

Answer: D

Explanation:

A formula field is a field that calculates a value based on other fields or constants. When using the S3 Connector to ingest data from an Amazon S3 bucket, Data Cloud supports creating and updating formula fields on the data lake objects (DLOs) that store the data from the S3 source. However, the formula field updates are not applied immediately, but rather at the next incremental upsert refresh of the data stream. An incremental upsert refresh is a process that adds new records and updates existing records from the S3 source to the DLO based on the primary key field. Therefore, the consultant should keep in mind that the formula field updates will affect both new and existing records, but only after the next incremental upsert refresh of the data stream. The other options are incorrect because Data Cloud does not initiate a full refresh of data from S3, does not update the formula only for new records, and does support formula field updates for data streams of type upsert.

Reference: Create a Formula Field, Amazon S3 Connection, Data Lake Object