Exam Certified Data Cloud Consultant topic 1 question 26 discussion

Actual exam question from Salesforce's Certified Data Cloud Consultant

Question #: 26
Topic #: 1

[All Certified Data Cloud Consultant Questions]

Every day, Northern Trail Outfitters uploads a summary of the last 24 hours of store transactions to a new file in an Amazon S3 bucket, and files older than seven days are automatically deleted. Each file contains a timestamp in a standardized naming convention.
Which two options should a consultant configure when ingesting this data stream? (Choose two.)

A. Ensure the filename contains a wildcard to accommodate the timestamp.
B. Ensure that deletion of old files is enabled.
C. Ensure the refresh mode is set to "Full Refresh".
D. Ensure the refresh mode is set to "Upsert".

Show Suggested Answer

Suggested Answer: AD 🗳️

by OllyWirban at June 19, 2025, 12:29 p.m.

Comments

Submit Cancel

OllyWirban

1 week, 4 days ago

Selected Answer: AD

✔️ A. Use a wildcard in the filename Since the files include a timestamp, you can't hardcode the file name. You must use a wildcard (e.g., transactions_*.csv) in the S3 file path during setup to ensure all timestamped files are ingested. ✔️ D. Use "Upsert" refresh mode Upsert allows the system to ingest new or updated records incrementally from each file, without wiping previous data. This is necessary for daily uploads where each file contains only the last 24 hours of data. ❌ Why the others are incorrect: B. Deletion of old files This is managed on the S3 side, not by Data Cloud. There's no need to configure this in the data stream. C. Full Refresh Incorrect because Full Refresh replaces all data with each new file. This would delete prior days’ records — not what you want in a cumulative ingestion model.

upvoted 1 times

...