Performance Flashcards Preview

Salesforce Data Architecture and Management Designer > Performance > Flashcards

Flashcards in Performance Deck (34)
Loading flashcards...
1
Q

How much data can be retrieved in a bulk query?

A

15GB

2
Q

T/F: Bulk queries supports the queryAll operation

A

true

3
Q

T/F: Bulk queries support the query operation.

A

True

4
Q

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

A

true

5
Q

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

A

true

6
Q

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

A

True

7
Q

What is the timeout on a bulk query

A

2 minutes

8
Q

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

A

text/csv application/xml application/json

9
Q

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

A

QUERY_TIMEOUT

10
Q

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

A

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

11
Q

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

A

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

12
Q

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

A

1

13
Q

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

A

Serial mode

14
Q

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

A

Serial Mode

15
Q

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

A

concurrencyMode

16
Q

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

A

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

17
Q

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

A

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.

18
Q

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

A

The master record is locked during the update.

19
Q

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

A

Creating a report.

20
Q

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?

A

Salesforce will lock the other records.

21
Q

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

A

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

22
Q

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

A

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

23
Q

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

A

Serial

24
Q

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

A

serial

25
Q

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

A

serial

26
Q

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

A

serial

27
Q

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

A

serial

28
Q

Why should you schedule plenty of time between jobs?

A

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

29
Q

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

A

serial

30
Q

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

A

serial

31
Q

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

A

serial

32
Q

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

A

serial

33
Q

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?

A

serial

34
Q
A

BULK API