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
When adding a role to the role hierarchy or a territory to the territory hierarchy, in what mode should the bulk job be run?
serial
when changing the structure of the role hierarchy, in what mode should the bulk job be run?
serial
when changing the structure of the territory hierarchy, in what mode should the bulk job be run?
serial
Why should you schedule plenty of time between jobs?
so that they don’t overlap and cause unforeseen locking issues.
When adding or removing members from public or personal groups, in what mode should a bulk job be run?
serial
When adding or removing members from roles, in what mode should a bulk job be run?
serial
When adding or removing members from territories, in what mode should a bulk job be run?
serial
When adding or removing members from queues, in what mode should a bulk job be run?
serial
When processing a bulk job: If the owner of an account that has at least 1 community role and the new owner belongs to a different role, in what mode should the job be executed?
serial
BULK API
