Salesforce
Salesforce Certified Data
Architecture and Management
Designer study review solution
guide new questions and answers
update
What does LDV stand for - CORRECT ANSWER 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 - CORRECT
ANSWER To bring external data from outside salesforce
What are the 4 phases when figuring out an LDV approach - CORRECT
ANSWER 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 - CORRECT ANSWER Id
Name
OwnerId
CreatedDate
Salesforce Certified Data Architecture and Management Designer study review solution guide new
questions and answers update
,Salesforce
SystemModstamp
RecordType (if present on the object)
Email (for contacts and leads)
Master-Detail Fields (treated as custom index)
Lookup Fields (treated as custom index)
What custom fields are automatically indexed - CORRECT ANSWER Unique
fields
External ID Fields
What are the selectivity conditions for a standard index when it's the only
filter term - CORRECT ANSWER 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 - CORRECT ANSWER 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 -
CORRECT ANSWER 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 -
CORRECT ANSWER One
Salesforce Certified Data Architecture and Management Designer study review solution guide new
questions and answers update
,Salesforce
What are the selectivity conditions when we use OR in the query -
CORRECT ANSWER 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
What are the selectivity conditions we use LIKE in the query - CORRECT
ANSWER 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 - CORRECT
ANSWER 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 - CORRECT
ANSWER 333333
Will a filter be considered selective when it contains any of the following
operators : != ; NOT LIKE ;
EXCLUDES - CORRECT ANSWER No
Will an filter be considered selective when it pairs a text field with any of
the following operators : < ; > ; <= ; >= - CORRECT ANSWER No
Will a filter be considered selective when it starts with a leading wildcard -
CORRECT ANSWER No
Will an filter be considered selective when it references a non
deterministic formula field - CORRECT
ANSWER No
Salesforce Certified Data Architecture and Management Designer study review solution guide new
questions and answers update
, Salesforce
Are chatter feed SOSL searches affected by the scope of the search -
CORRECT ANSWER No - the results will match across all objects
Name 4 ways to limit scope with SOSl searches - CORRECT ANSWER 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 - CORRECT ANSWER 1. Name
fields
2. Phone fields
3. Text fields
4. Picklist fields
What happens when the force.com optimiser cant use a selective filer? -
CORRECT ANSWER Full table scan
When designing a system how large should your datasets returned to the
application be - CORRECT
ANSWER 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 - CORRECT
ANSWER 50k rows
How can we increase the number of records displayed by a visualforce
page to 1 million records -
CORRECT ANSWER Set the Readonly attribute to true
Salesforce Certified Data Architecture and Management Designer study review solution guide new
questions and answers update
Salesforce Certified Data
Architecture and Management
Designer study review solution
guide new questions and answers
update
What does LDV stand for - CORRECT ANSWER 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 - CORRECT
ANSWER To bring external data from outside salesforce
What are the 4 phases when figuring out an LDV approach - CORRECT
ANSWER 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 - CORRECT ANSWER Id
Name
OwnerId
CreatedDate
Salesforce Certified Data Architecture and Management Designer study review solution guide new
questions and answers update
,Salesforce
SystemModstamp
RecordType (if present on the object)
Email (for contacts and leads)
Master-Detail Fields (treated as custom index)
Lookup Fields (treated as custom index)
What custom fields are automatically indexed - CORRECT ANSWER Unique
fields
External ID Fields
What are the selectivity conditions for a standard index when it's the only
filter term - CORRECT ANSWER 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 - CORRECT ANSWER 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 -
CORRECT ANSWER 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 -
CORRECT ANSWER One
Salesforce Certified Data Architecture and Management Designer study review solution guide new
questions and answers update
,Salesforce
What are the selectivity conditions when we use OR in the query -
CORRECT ANSWER 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
What are the selectivity conditions we use LIKE in the query - CORRECT
ANSWER 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 - CORRECT
ANSWER 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 - CORRECT
ANSWER 333333
Will a filter be considered selective when it contains any of the following
operators : != ; NOT LIKE ;
EXCLUDES - CORRECT ANSWER No
Will an filter be considered selective when it pairs a text field with any of
the following operators : < ; > ; <= ; >= - CORRECT ANSWER No
Will a filter be considered selective when it starts with a leading wildcard -
CORRECT ANSWER No
Will an filter be considered selective when it references a non
deterministic formula field - CORRECT
ANSWER No
Salesforce Certified Data Architecture and Management Designer study review solution guide new
questions and answers update
, Salesforce
Are chatter feed SOSL searches affected by the scope of the search -
CORRECT ANSWER No - the results will match across all objects
Name 4 ways to limit scope with SOSl searches - CORRECT ANSWER 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 - CORRECT ANSWER 1. Name
fields
2. Phone fields
3. Text fields
4. Picklist fields
What happens when the force.com optimiser cant use a selective filer? -
CORRECT ANSWER Full table scan
When designing a system how large should your datasets returned to the
application be - CORRECT
ANSWER 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 - CORRECT
ANSWER 50k rows
How can we increase the number of records displayed by a visualforce
page to 1 million records -
CORRECT ANSWER Set the Readonly attribute to true
Salesforce Certified Data Architecture and Management Designer study review solution guide new
questions and answers update
