Performance

Question 1

How much data can be retrieved in a bulk query?

Answer 1

15GB

Question 2

T/F: Bulk queries supports the queryAll operation

Answer 2

true

Question 3

T/F: Bulk queries support the query operation.

Answer 3

True

Question 4

T/F: in a bulk query, queryAll returns records that have been deleted because of a merge

Answer 4

true

Question 5

T/F: in a bulk query, the query operation returns records that ahve been deleted because of a delete

Answer 5

true

Question 6

T/F: An archived Task or Event can be retrieved in a bulk query using queryAll

Answer 6

True

Question 7

What is the timeout on a bulk query

Answer 7

2 minutes

Question 8

If a batch is added to a bulk job, what are the three possible Content-Type headers?

Answer 8

text/csv application/xml application/json

Question 9

What error is returned when a job fails due to timeout?

Answer 9

QUERY_TIMEOUT

Question 10

How is the degree of parallelism (of a bulk job) calculated?

Answer 10

amount of work completed (as a duration) divided by the actual amount of time it took to complete that work

Question 11

As an architect, what is the desire for a data load?

Answer 11

For the load/integration to run as quickly and efficiently as possible

Question 12

In serial mode, what is the maximum degree of parallelism?

Answer 12

1

Question 13

When inserting group members to a table, what mode should a bulk job be processed in?

Answer 13

Serial mode

Question 14

When inserting users who are assigned to a specific role, in what mode should the bulk job be processed?

Answer 14

Serial Mode

Question 15

What field on the JobInfo object needs to be set in order for Salesforce to process a job serially?

Answer 15

concurrencyMode

Question 16

What must be ensured prior to processing jobs with records who have master-detail relationships?

Answer 16

That no master records’ IDs span multiple batches or order loads by the master records’ IDs

Question 17

What effect does “Clear the value of this field” option on a Lookup field have?

Answer 17

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.

Question 18

What happens if a detail record is updated that causes an update to a rollup summary field?

Answer 18

The master record is locked during the update.

Question 19

What is an alternative to having a roll-up summary field?

Answer 19

Creating a report.

Question 20

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?

Answer 20

Salesforce will lock the other records.

Question 21

How can workflow rules impact the performance of a data load?

Answer 21

When a workflow rule is fired, Salesforce locks the records that they update.

Question 22

What five situations can impact record locking on a data load?

Answer 22

M-D relationships Lookup relationships roll-up Summary fields Triggers Workflow rules

Question 23

In what mode should a job be processed when adding users who are assigned to roles?

Answer 23

Serial

Question 24

In what mode should a job be processed when changing users’ roles??

Answer 24

serial

Question 25

When adding a role to the role hierarchy or a territory to the territory hierarchy, in what mode should the bulk job be run?

Answer 25

serial

Question 26

when changing the structure of the role hierarchy, in what mode should the bulk job be run?

Answer 26

serial

Question 27

when changing the structure of the territory hierarchy, in what mode should the bulk job be run?

Answer 27

serial

Question 28

Why should you schedule plenty of time between jobs?

Answer 28

so that they don’t overlap and cause unforeseen locking issues.

Question 29

When adding or removing members from public or personal groups, in what mode should a bulk job be run?

Answer 29

serial

Question 30

When adding or removing members from roles, in what mode should a bulk job be run?

Answer 30

serial

Question 31

When adding or removing members from territories, in what mode should a bulk job be run?

Answer 31

serial

Question 32

When adding or removing members from queues, in what mode should a bulk job be run?

Answer 32

serial

Question 33

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?

Answer 33

serial

Question 34

Answer 34

BULK API