DATA-ARCHITECT practice question 22 of 35

NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not…

Full set: 257 questions
NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification. Which 3 considerations are needed prior to a SF Connect implementation? Choose 3 answers:
Answer options
A: Create a 2nd system Admin user for authentication to the external source.
B: Develop an object relationship strategy. Correct answer
C: Identify the external tables to sync into external objects Correct answer
D: Assess whether the external data source is reachable via an ODATA endpoint. Correct answer
E: Configure a middleware tool to poll external table data
Correct Answer:
B. Develop an object relationship strategy.; C. Identify the external tables to sync into external objects; D. Assess whether the external data source is reachable via an ODATA endpoint.
Explanation

When implementing Salesforce Connect for data virtualization, a data architect must perform key planning activities. First, it's essential to assess the technical feasibility, which includes verifying that the external data source exposes an OData 2.0 or 4.0 endpoint (D). Next, the scope of the integration must be defined by identifying the specific external tables that will be represented as external objects in Salesforce (C). Finally, a crucial design step is to develop an object relationship strategy, determining how these new external objects will link to existing standard or custom objects (like Account or Contact) to provide a seamless user experience (B).

Why Incorrect

A. While authentication is required, creating a second System Administrator is an overly specific and not universally necessary implementation detail. A dedicated integration user is a best practice, but not necessarily an admin.
E. Salesforce Connect provides real-time access to external data, eliminating the need for middleware or data polling/replication. This option describes a data replication pattern, not a virtualization pattern.

References

1. Salesforce Help. (2023). Salesforce Connect. "Before you start, determine which Salesforce Connect adapter you need... For the OData 2.0 or 4.0 adapter, know the service root URL of the external data producer." This supports option D.

2. Salesforce Help. (2023). Define an External Object for Salesforce Connect. "Each external object maps to a data table in the external data source." This supports option C.

3. Salesforce Help. (2023). Relationships with External Objects. "External objects support standard lookup relationships, which link them to standard or custom objects... This allows you to link related data from different systems." This supports option B.

Scroll to Top