LDV and Integration

Question 1

In a ‘Reply and Request’ integration solution, callouts should typically be made using which protocols?

Answer 1

SOAP or REST

Question 2

In a ‘Reply and Request’ integration solution, callouts should be peformed (synchronously|asynchronously) and contain (smaller|larger) amounts of data.

Answer 2

Callouts should be synchronous and contain small amounts of data to avoid timeouts and size limits for payloads or responses.

Question 3

For External Objects, what are the different types of lookup relationship fields?

Answer 3

Lookup Relationship Field: Links a child standard, custom, or external object to a parent standard or custom object. Use when the external data includes a column that identifies related Salesforce records by their 18-character IDs.

External Lookup Field: Links a child standard, custom, or external object to a parent external object. Use when the parent is an external object

Indirect Lookup Field: Links a child external object to a parent standard or custom object. Use when the external data doesn’t include Salesforce record IDs.

Question 4

What are 3 main approaches to improving data load times by reducing sharing calculation time?

Answer 4

1. Set object OWDs to publid read/write where feasible so Salesforce doesn’t maintain share tables.
2. Temporarily disable automation like workflow rules, validation rules, and record-triggered operations.
3. Defer sharing calculations prior to loading.

Question 5

For how long is data retained in field history objects in the org? Via the API?

Answer 5

Up to 18 months in the org. Up to 24 months via the API.

Question 6

Syncing an external data source via Salesforce Connect fails if it causes the org to exceed what number of external objects?

Answer 6

200

Question 7

Field History Tracking can be used to track history on up to how many fields on an object?

Answer 7

20

Question 8

What are the two primary disadvantages to using mashups?

Answer 8

1. Data retrieval takes more time due to external callouts.
2. Salesforce features and functionality do not support the external data.

Question 9

What is the maximum number of fields that can be added to a skinny table?

Answer 9

100

Question 10

What are the key advantages of granular locking?

Answer 10

• Groups in separate hierarchies can be manipulated concurrently
• Roles and groups that do not include territories aren’t blocked by territory operations
• Users can be added concurrently to territories and public groups
• User provisioning can occur in parallel
• Single, long-running operations block a smaller subset of records

Question 11

What is a main drawback of deferring sharing recalculation?

Answer 11

It requires a full recalculation of sharing rules for all objects.

Question 12

What are the 4 major approaches to optimizing data loads?

Answer 12

1. Set OWD sharing to public read/write
2. Temporarily disable record-triggered automation (flow, triggers, validation rules)
3. Create sharing rules after the data is loaded
4. Define complex object relationships after the data is loaded

Question 13

Data Loader is optimized to load up to how many records?

Answer 13

5 million

Question 14

Scheduled Flows can currently do a batch operation on how many records per day?

Answer 14

250K records per day

Question 15

What are the flow governor limits for:

• SOQL queries issued
• DML statements issued
• Records processed in DML
• Max CPU time

Answer 15

SOQL queries issued: 100

DML statements issued: 150

Records processed in DML: 10,000

Max CPU time: 10,000 ms