Data Modeling/Database Design: 25% Flashcards
What is one major consideration when using a Person Account?
They use up twice the data storage because they store an Account and Contact record
What Salesforce feature can be used to view and edit records in an external system?
Salesforce Connect
What setting has to be enabled to modify the created date of records when importing?
Set “Audit Fields upon Record Creation”
What type of diagram can be created to help stakeholders, visualize objects, fields and relationships?
Entity Relationship Diagram
What is Salesforce Data Cloud?
Used to integrate data from multiple orgs and clouds to provide a unified view of customer data
How can you calcualte the distance between two locations using a formula field?
The GEOLOCATION and DISTANCE functions
How big is a single Salesforce record?
2 KB
What is the maximum number of picklist values a field can have?
1000 values
When using an External Object what kind of relationship is configured when the child object is external?
An Indirect Lookup Relationship
What is a “Data Dictionary”?
Entity Relationship Diagrams (ERDs) and Metadata API can be used to build a data dictionary
What is “Data Taxonmy”?
Defining a data taxonomy invloves classifying the data into categories and sub-categories
What is “Data Lineage” ?
Defining a data lineage involves specifying the origin of data, how it is affected, and where it moves in its lifecycle
What is “Data Classification”?
Metadata can be identified and categorized based on risk levels and required security controls
What are the four standard classification metadata fields available on all standard and custom objects?
- Data Owner
- Field Usage
- Data Sensitivity Level
- Compliance Categorization
What can be used to stores millions or even billions of records in Salesforce?
Big Obejects
