Data Modeling Flashcards
Can a record type that is referenced by Apex be deleted?
NO
How is record type access defined?
Profile or Permission Set or both
Profiles can both master an custom record types assigned. True or False
FALSE
Can users view records of any record type if they have access to the object?
YES. Record type assignment defines record types users can use at record creation/edit.
Maximum record types per object - Salesforce recommends
200
Default record type for users can be set in settings
TRUE
Default Record Types are defined on the profile and CAN be defaulted in user settings.
TRUE
Can page layouts be assigned via permission set?
NO
A business process is a special picklist field that captures lifecycle on which standard objects?
- Lead Status
- Opportunity Stage
- Case Status
- Opportunity Status
Can standard fields that are natively required be set to read only?
NO
What is a data model comprised of?
Standard/Custom/External objects
Standard/Custom fields
Relationships
Strengths of schema builder
Speed and efficiency
Lookup relationships are tight or loose?
Loose
What object are hierarchical relationships defined on?
User Object
When you create a lookup relationship, what kind of report is automatically created?
A standard report type (ie policies with account)
External lookup relationships are delivered via what?
Salesforce Connect
The standard External ID field on parent external object is matched to what?
The child’s external lookup relationship field.
What are the 2 types of external object relationships?
External Lookup
Indirect Lookup
Indirect Lookup Relationship
Parent Salesforce object; child external object
How many master-detail relationships can each object have?
two
Can standard objects be on the detail side of a master-detail when a custom object is the master?
No
How do you allow reparenting?
Set “allow reparenting” when you create the relationship
What gets deleted when you delete the master record?
Master and any details.
Name two security implications of master-detail relationships:
- Permissions and security are inherited from master.
2. Owner field is not available on detail/subdetail; owner is inherited from master
Can custom objects on the detail side of master/detail use sharing rules?
No - because owner field is required.
What is used to create a many to many relationship?
Junction object - two master/detail relationships are created
Can you use an encrypted text field as a filter for reports, list views or roll up summary fields?
NO
Are global value sets restricted or unrestricted?
Restricted
Two types of fields that can be a controlling field for a dependent picklist
Picklist
Checkbox
How many External ID fields can there be on an object?
25
What types of field can be defined as an external ID?
Text
Number
Email
Can the data type on fields referenced by setup items be changed?
NO
When can you convert master/detail to lookup?
If there are no roll up summary fields on the master object.
When can you convert lookup to master/detail?
If there are values for all records
Can you convert the data type of custom fields mapped in lead conversion?
Never
Can you convert a picklist to a checkbox?
Yes
Can you convert formula fields to another kind of field or vice versa?
NO
What is faster - objects or schema builder?
Schema builder
What types of fields cannot be created in schema builder?
Encrypted fields with data mask
Geolocation feilds
What is the security setting of a field created in schema builder?
Visible and editable for internal profiles only.
Fields created in schema builder are added to page layouts - true or false
False - schema builder does not add the fields to the page layout.
Does Data Import Wizard support Opportunities?
NO Data Loader only.
