Salesforce Certified Data Architecture and Management Designer study review solution guide new questions and answers update

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