Changed Data-Architect Exam Questions

Using an indexed data field with bounded data filters can improve the report performance by making the query more selective and reducing the number of records to scan. Using formula fields to surface information from related entities on the report can also enhance the report performance by avoiding joins and complex calculations

The two features that a data architect should recommend to share records between Salesforce orgs are:

Change Data Capture (CDC): This is a feature that publishes change events for changes in Salesforce records, such as create, update, delete, and undelete operations. Change events can be subscribed by external systems or other Salesforce orgs using various tools, such as Platform Events, Streaming API, or CometD. CDC can help keep data in sync between Salesforce orgs in near real time89.

Salesforce to Salesforce (S2S): This is a feature that allows sharing records and related data with other Salesforce orgs that you partner with. You can choose which records and fields to share, and which orgs to share with. You can also accept updates from the other orgs to keep the data consistent10.

Salesforce Connect is not a good feature to share records between Salesforce orgs because it is intended for integrating external data sources with Salesforce using external objects. Federation Search is not a good feature to share records between Salesforce orgs because it is intended for searching across multiple Salesforce orgs without sharing data.

Before replicating the data from Heroku Postgres to Salesforce, the data architect should consider the following factors:

Whether the data is a driver of key processes implemented within Salesforce. For example, if the data is used for workflows, triggers, or validation rules, it should be replicated to Salesforce.

Whether there is a tight relationship between order data and an enterprise resource planning (ERP) application. For example, if the order data needs to be synchronized with the ERP system, it should be replicated to Salesforce.

The selection of the tool required to replicate the data. For example, Heroku Connect can be used to bi-directionally sync data between Heroku Postgres and Salesforce

The correct answer is A, D, and E. The data architect should consider these three factors when evaluating the need for Salesforce Connect: You want real-time access to the latest data from other systems, you have a large amount of data that you don’t want to copy into your Salesforce org, and you need to small amounts of external data at any one time. These factors indicate that Salesforce Connect is a suitable solution for creating a connected experience in Salesforce without importing inventory data from a cloud database. Salesforce Connect allows Salesforce to access external data via OData or custom adapters without storing it in Salesforce, which reduces storage costs and ensures data freshness. Salesforce Connect also supports pagination and caching to optimize performance when accessing small amounts of external data at any one time. Option B is incorrect because if you have a large amount of data and would like to copy subsets of it into Salesforce, you may not need Salesforce Connect but rather use other tools such as Data Loader or API integration. Option C is incorrect because if you need to expose data via a virtual private connection, you may not need Salesforce Connect but rather use other tools such as VPN or VPC peering.