Salesforce Certified Data Cloud Consultant — Question 63

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.)

Answer options

• 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".

Correct answer: A, D

Explanation

Option A is correct because using a wildcard in the filename allows for the dynamic inclusion of the timestamp in file names. Option D is also correct as setting the refresh mode to 'Upsert' enables the system to update existing records and insert new ones, which is suitable for incremental data updates. Options B and C are incorrect as they do not address the specific requirements for processing the incoming data stream.