MCB Data Cloud Certification Practice Exam

A customer wants to use the transactional data from their data warehouse in Data Cloud. How should the file be brought into Data Cloud?

1. Ingest the file with the SFTP Connector.

2. Use Salesforce's Dataloader application to perform a bulk upload from a desktop.

3. Ingest the file through the Cloud Storage Connector.

4. Manually import the file using the Data Import Wizard.

The correct answer is: Ingest the file with the SFTP Connector.

The recommended approach for bringing transactional data from a data warehouse into Data Cloud is to ingest the file with the SFTP Connector. This method is particularly effective for handling the transfer of large datasets securely and efficiently. The SFTP Connector allows for the automated transfer of files over a secure channel, minimizing the risk of data interception during transmission. It is designed to work seamlessly with batch processes typical in data warehousing environments, ensuring that the data is transferred without compromising performance. Using the SFTP Connector is also beneficial because it can facilitate scheduled data transfers, making it possible for the customer to maintain up-to-date data in Data Cloud regularly without manual intervention. This automation is crucial for organizations looking to enhance their data integrity and operational efficiency. While the other methods each have their use cases, they may not be as suitable for this specific scenario. For example, using the Dataloader or manually importing via the Data Import Wizard can be more labor-intensive and may not handle large datasets as effectively as the SFTP Connector. Additionally, bulk uploads through a desktop can introduce risks related to connectivity and data integrity if not managed properly. Cloud Storage Connector can be appropriate in different contexts but does not inherently provide the same level of security and efficiency required for a direct link to a data warehouse