Performance Flashcards
How much data can be retrieved in a bulk query?
15GB
T/F: Bulk queries supports the queryAll operation
true
T/F: Bulk queries support the query operation.
True
T/F: in a bulk query, queryAll returns records that have been deleted because of a merge
true
T/F: in a bulk query, the query operation returns records that ahve been deleted because of a delete
true
T/F: An archived Task or Event can be retrieved in a bulk query using queryAll
True
What is the timeout on a bulk query
2 minutes
If a batch is added to a bulk job, what are the three possible Content-Type headers?
text/csv application/xml application/json
What error is returned when a job fails due to timeout?
QUERY_TIMEOUT
How is the degree of parallelism (of a bulk job) calculated?
amount of work completed (as a duration) divided by the actual amount of time it took to complete that work
As an architect, what is the desire for a data load?
For the load/integration to run as quickly and efficiently as possible
In serial mode, what is the maximum degree of parallelism?
1
When inserting group members to a table, what mode should a bulk job be processed in?
Serial mode
When inserting users who are assigned to a specific role, in what mode should the bulk job be processed?
Serial Mode
What field on the JobInfo object needs to be set in order for Salesforce to process a job serially?
concurrencyMode
What must be ensured prior to processing jobs with records who have master-detail relationships?
That no master records’ IDs span multiple batches or order loads by the master records’ IDs
What effect does “Clear the value of this field” option on a Lookup field have?
for optional lookups, Salesforce will not lock the record whenever a record that references the field on insert or update; it will only validate that it exists.
What happens if a detail record is updated that causes an update to a rollup summary field?
The master record is locked during the update.
What is an alternative to having a roll-up summary field?
Creating a report.
What happens if a trigger performs a select for update, or a DML operation on records other than the record that’s being acted upon?
Salesforce will lock the other records.
How can workflow rules impact the performance of a data load?
When a workflow rule is fired, Salesforce locks the records that they update.
What five situations can impact record locking on a data load?
M-D relationships Lookup relationships roll-up Summary fields Triggers Workflow rules
In what mode should a job be processed when adding users who are assigned to roles?
Serial
In what mode should a job be processed when changing users’ roles??
serial
