Data Modeling and Mgmt Flashcards
What is the maximum combined length of a BigObjects index?
100 characters
What is the maximum number of fields that a BigObjects index may contain?
5 (min 1)
What are the main considerations for building a BigObjects index?
- Must include 1-5 fields
- Total character count for combined index must be 100 or fewer characters
- Once an index has been created, it cannot be edited or deleted
- Custom fields in index must be marked as required
- Long Text Area fields are not supported
How much storage space does a typical Salesforce record require?
2 KB
Which standard object records require more storage space than the typical 2 KB?
Person Accounts, Campaigns, and Articles
Which formula calculates the distance between two locations/geolocations?
DISTANCE
What SOQL operators cannot be used in Big Objects queries
LIKE
INCLUDES
EXCLUDES
NOT IN
How many records can be stored in a Big Object by default?
1,000,000
What fields are indexed by default?
Id
Name
OwnerId
CreatedDate
SystemModStamp
RecordType
Master-Detail
Lookup
What is the difference between invalid and inaccurate information?
Invalid information typically means data does not conform to defined formats, while inaccurate information is simply the wrong data values.
What is the maximum number of object relationships in a custom report type?
Four
What field types can be set as External ID fields?
Text, Number, and Email
What is the maximum number of External ID fields per object?
25
What matching algorithms do the standard Account duplicate and matching rules use?
Acronym, Edit Distance, and Exact
