MCB Data Cloud Certification Practice Exam

When ingesting data, which setting is critical to accommodate varying timestamps in the filenames?

1. Ensure that deletion of old files is enabled.

2. Ensure the refresh mode is set to 'Upsert'.

3. Ensure the filename contains a wildcard.

4. Ensure the refresh mode is set to 'Full Refresh'.

The correct answer is: Ensure the filename contains a wildcard.

The critical setting when ingesting data to accommodate varying timestamps in the filenames is to ensure that the filename contains a wildcard. This approach allows the data ingestion process to recognize and include files with different timestamps in their names, facilitating the automated handling of various data files that may be generated over time. Using a wildcard in the filename enables the system to match multiple files that fit a certain pattern, thus simplifying the ingestion of datasets that could have different timestamps embedded in their filenames. This is particularly useful in scenarios where data files are continuously generated or where data arrives in a batch process that creates timestamped filenames to avoid overwriting previous files. In contrast, settings such as enabling deletion of old files, setting the refresh mode to 'Upsert', or opting for a 'Full Refresh' do not directly address the issue of differing timestamps in filenames. While these settings pertain to data management and refresh strategies, they do not assist in recognizing multiple versions of files based on their naming conventions, which is the core issue addressed by the correct choice.