ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 33 - Certified Data Cloud Consultant discussion

Report
Export

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.
Answers
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.
Answers
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.
Answers
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.
Answers
D.
Data Cloud will update the formula for all records at the next incremental upsert refresh.
Suggested 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.

asked 23/09/2024
Aung Aung Myo Myint
39 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first