Data-Con-101 practice question 25 of 25

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?

Full set: 168 questions
Answer options
A: Ingest the file with the SFTP Connector. Correct answer
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.
Correct Answer:
A. Ingest the file with the SFTP Connector.
Explanation

Data Cloud provides a native SFTP Connector that securely pulls CSV or JSON files placed on an external SFTP server and loads them into a data stream, exactly matching the customer’s export method.

Why Incorrect

B. Cloud Storage Connector is for S3, Azure Blob, and Google Cloud Storage, not SFTP.
C. Data Import Wizard operates on core Salesforce objects, not Data Cloud datasets.
D. Data Loader uploads to CRM objects only and cannot write directly to Data Cloud.

References

• Salesforce Help, “Set Up the SFTP Connector,” Overview – “Use this connector to ingest files exported to an SFTP site.”

• Salesforce Help, “Cloud Storage Connectors,” Introduction – lists supported providers (S3, Azure, GCS) only.

• Salesforce Help, “Import Data with the Data Import Wizard,” Scope section.

• Salesforce Help, “Use Data Loader,” Overview – limited to standard and custom objects.

Scroll to Top