How should the file be brought into Data Cloud?

A customer wants to use the transactional data from their data warehouse in Data Cloud.

They are only able to export the data via an SFTP site.

How should the file be brought into Data Cloud?
A . Ingest the file with the SFTP Connector.
B . Ingest the file through the Cloud Storage Connector.
C . Manually import the file using the Data Import Wizard.
D . Use Salesforce’s Dataloader application to perform a bulk upload from a desktop.

View Answer

Answer: A

Explanation:

The SFTP Connector is a data source connector that allows Data Cloud to ingest data from an SFTP server. The customer can use the SFTP Connector to create a data stream from their exported file and bring it into Data Cloud as a data lake object. The other options are not the best ways to bring the file into Data Cloud because:

B: The Cloud Storage Connector is a data source connector that allows Data Cloud to ingest data from cloud storage services such as Amazon S3, Azure Storage, or Google Cloud Storage. The customer does not have their data in any of these services, but only on an SFTP site.

C: The Data Import Wizard is a tool that allows users to import data for many standard Salesforce objects, such as accounts, contacts, leads, solutions, and campaign members. It is not designed to import data from an SFTP site or for custom objects in Data Cloud.

D: The Dataloader is an application that allows users to insert, update, delete, or export Salesforce records. It is not designed to ingest data from an SFTP site or into Data Cloud.

Reference: SFTP Connector – Salesforce, Create Data Streams with the SFTP Connector in Data Cloud – Salesforce, Data Import Wizard – Salesforce, Salesforce Data Loader