Page | 1
SALESFORCE CERTIFIED DATA
ARCHITECTURE AND MANAGEMENT
DESIGNER QUESTIONS WITH DETAILED
VERIFIED ANSWERS
What does LDV stand for Ans: Large data volumes.
A simplistic rule of thumb is any table over 2 million records
In the context of LDV design what can Heroku be used for Ans: To bring
external data from outside salesforce
What are the 4 phases when figuring out an LDV approach Ans: 1.
Design - Get to know the application. Get data volumes. Understand data
growth.
2. Load - Use Bulk API to reduce load times.
3. Sharing - The record sharing in SF will have a huge impact on LDV
performance.
4. Maintenance - strategy concerning custom indexing; partitioning; app
partitioning (so things like use of external data)
What standard fields are automatically indexed Ans: Id
Name
OwnerId
CreatedDate
SystemModstamp
RecordType (if present on the object)
, Page | 2
Email (for contacts and leads)
Master-Detail Fields (treated as custom index)
Lookup Fields (treated as custom index)
What custom fields are automatically indexed Ans: Unique fields
External ID Fields
What are the selectivity conditions for a standard index when it's the only
filter term Ans: 1. 30% of the first million
2. 15% after the first million
3. 1 million total records
What are the selectivity conditions for a custom index when it's the only
filter term Ans: 1. 10% of first million
2. 5% after the first million
3. 333333 total records
What are the selectivity conditions when we use AND in the query Ans:
1. Twice the index selectivity thresholds for each filter
2. The index selectivity thresholds of the intersection of the fields
3. This is termed as using a composite index
With regards to a date or number range; will the optimiser consider this
as one or two filter terms Ans: One
What are the selectivity conditions when we use OR in the query Ans:
1.The index selectivity thresholds for each filter
2. The index selectivity thresholds for the sum of those fields
3. This is termed as an index union
, Page | 3
What are the selectivity conditions we use LIKE in the query Ans: If we
don't start with a leading wildcard force.com will test the first 100K rows
for selectivity
For a standard index what is the maximum number of rows that can be
returned by a filter in order for it to be considered selective Ans: 1
million
For a custom index what is the maximum number of rows that can be
returned by a filter in order for it to be considered selective Ans: 333333
Will a filter be considered selective when it contains any of the following
operators : != ; NOT LIKE ; EXCLUDES Ans: No
Will an filter be considered selective when it pairs a text field with any of
the following operators : < ; > ; <= ; >= Ans: No
Will a filter be considered selective when it starts with a leading wildcard
Ans: No
Will an filter be considered selective when it references a non
deterministic formula field Ans: No
Are chatter feed SOSL searches affected by the scope of the search Ans:
No - the results will match across all objects
Name 4 ways to limit scope with SOSl searches Ans: 1. Target Specific
Objects
2. Target rows owned by the searcher
3. Target rows within a division
4. Target fields with search indexes
Name 4 fields with SOSL search indexes Ans: 1. Name fields
2. Phone fields
3. Text fields
, Page | 4
4. Picklist fields
What happens when the force.com optimiser cant use a selective filer?
Ans: Full table scan
When designing a system how large should your datasets returned to the
application be Ans: Try to find the minimum set of data to satisfy the
use case for the customer
What is the row limit for a record set returned by SOQL in APEX Ans:
50k rows
How can we increase the number of records displayed by a visualforce
page to 1 million records Ans: Set the Readonly attribute to true
Name 2 ways that we can create indexes in salesforce Ans: 1. Contact
customer support and get them to do it
2. Make the field an ExternalId field
When should we use a formula field over a trigger for computed values
Ans: 1. If the formula is deterministic we can index this. This makes it
preferable to using a trigger
2. If we need a 100% Realtime display of computed values
When should we use a trigger over a formula field for computed values
Ans: 1. When we have a mass update over a large number of records -
we have the ability to activate and deactivate triggers so we can have it
active during a maintenance window
2. If we need to index and the formula is non deterministic
Do custom indexes get copied over to sandboxes? Ans: Yes
When in the LDV deployment process should we think about archival and
purge strategy Ans: 1. Take action in the design phase
2. Figure out how much data should be maintained in live
SALESFORCE CERTIFIED DATA
ARCHITECTURE AND MANAGEMENT
DESIGNER QUESTIONS WITH DETAILED
VERIFIED ANSWERS
What does LDV stand for Ans: Large data volumes.
A simplistic rule of thumb is any table over 2 million records
In the context of LDV design what can Heroku be used for Ans: To bring
external data from outside salesforce
What are the 4 phases when figuring out an LDV approach Ans: 1.
Design - Get to know the application. Get data volumes. Understand data
growth.
2. Load - Use Bulk API to reduce load times.
3. Sharing - The record sharing in SF will have a huge impact on LDV
performance.
4. Maintenance - strategy concerning custom indexing; partitioning; app
partitioning (so things like use of external data)
What standard fields are automatically indexed Ans: Id
Name
OwnerId
CreatedDate
SystemModstamp
RecordType (if present on the object)
, Page | 2
Email (for contacts and leads)
Master-Detail Fields (treated as custom index)
Lookup Fields (treated as custom index)
What custom fields are automatically indexed Ans: Unique fields
External ID Fields
What are the selectivity conditions for a standard index when it's the only
filter term Ans: 1. 30% of the first million
2. 15% after the first million
3. 1 million total records
What are the selectivity conditions for a custom index when it's the only
filter term Ans: 1. 10% of first million
2. 5% after the first million
3. 333333 total records
What are the selectivity conditions when we use AND in the query Ans:
1. Twice the index selectivity thresholds for each filter
2. The index selectivity thresholds of the intersection of the fields
3. This is termed as using a composite index
With regards to a date or number range; will the optimiser consider this
as one or two filter terms Ans: One
What are the selectivity conditions when we use OR in the query Ans:
1.The index selectivity thresholds for each filter
2. The index selectivity thresholds for the sum of those fields
3. This is termed as an index union
, Page | 3
What are the selectivity conditions we use LIKE in the query Ans: If we
don't start with a leading wildcard force.com will test the first 100K rows
for selectivity
For a standard index what is the maximum number of rows that can be
returned by a filter in order for it to be considered selective Ans: 1
million
For a custom index what is the maximum number of rows that can be
returned by a filter in order for it to be considered selective Ans: 333333
Will a filter be considered selective when it contains any of the following
operators : != ; NOT LIKE ; EXCLUDES Ans: No
Will an filter be considered selective when it pairs a text field with any of
the following operators : < ; > ; <= ; >= Ans: No
Will a filter be considered selective when it starts with a leading wildcard
Ans: No
Will an filter be considered selective when it references a non
deterministic formula field Ans: No
Are chatter feed SOSL searches affected by the scope of the search Ans:
No - the results will match across all objects
Name 4 ways to limit scope with SOSl searches Ans: 1. Target Specific
Objects
2. Target rows owned by the searcher
3. Target rows within a division
4. Target fields with search indexes
Name 4 fields with SOSL search indexes Ans: 1. Name fields
2. Phone fields
3. Text fields
, Page | 4
4. Picklist fields
What happens when the force.com optimiser cant use a selective filer?
Ans: Full table scan
When designing a system how large should your datasets returned to the
application be Ans: Try to find the minimum set of data to satisfy the
use case for the customer
What is the row limit for a record set returned by SOQL in APEX Ans:
50k rows
How can we increase the number of records displayed by a visualforce
page to 1 million records Ans: Set the Readonly attribute to true
Name 2 ways that we can create indexes in salesforce Ans: 1. Contact
customer support and get them to do it
2. Make the field an ExternalId field
When should we use a formula field over a trigger for computed values
Ans: 1. If the formula is deterministic we can index this. This makes it
preferable to using a trigger
2. If we need a 100% Realtime display of computed values
When should we use a trigger over a formula field for computed values
Ans: 1. When we have a mass update over a large number of records -
we have the ability to activate and deactivate triggers so we can have it
active during a maintenance window
2. If we need to index and the formula is non deterministic
Do custom indexes get copied over to sandboxes? Ans: Yes
When in the LDV deployment process should we think about archival and
purge strategy Ans: 1. Take action in the design phase
2. Figure out how much data should be maintained in live
