Data Modeling

Question 1

Can a record type that is referenced by Apex be deleted?

Answer 1

NO

Question 2

How is record type access defined?

Answer 2

Profile or Permission Set or both

Question 3

Profiles can both master an custom record types assigned. True or False

Answer 3

FALSE

Question 4

Can users view records of any record type if they have access to the object?

Answer 4

YES. Record type assignment defines record types users can use at record creation/edit.

Question 5

Maximum record types per object - Salesforce recommends

Answer 5

200

Question 6

Default record type for users can be set in settings

Answer 6

TRUE

Question 7

Default Record Types are defined on the profile and CAN be defaulted in user settings.

Answer 7

TRUE

Question 8

Can page layouts be assigned via permission set?

Answer 8

NO

Question 9

A business process is a special picklist field that captures lifecycle on which standard objects?

Answer 9

1. Lead Status
2. Opportunity Stage
3. Case Status
4. Opportunity Status

Question 10

Can standard fields that are natively required be set to read only?

Answer 10

NO

Question 11

What is a data model comprised of?

Answer 11

Standard/Custom/External objects
Standard/Custom fields
Relationships

Question 12

Strengths of schema builder

Answer 12

Speed and efficiency

Question 13

Lookup relationships are tight or loose?

Answer 13

Loose

Question 14

What object are hierarchical relationships defined on?

Answer 14

User Object

Question 15

When you create a lookup relationship, what kind of report is automatically created?

Answer 15

A standard report type (ie policies with account)

Question 16

External lookup relationships are delivered via what?

Answer 16

Salesforce Connect

Question 17

The standard External ID field on parent external object is matched to what?

Answer 17

The child’s external lookup relationship field.

Question 18

What are the 2 types of external object relationships?

Answer 18

External Lookup

Indirect Lookup

Question 19

Indirect Lookup Relationship

Answer 19

Parent Salesforce object; child external object

Question 20

How many master-detail relationships can each object have?

Answer 20

two

Question 21

Can standard objects be on the detail side of a master-detail when a custom object is the master?

Answer 21

No

Question 22

How do you allow reparenting?

Answer 22

Set “allow reparenting” when you create the relationship

Question 23

What gets deleted when you delete the master record?

Answer 23

Master and any details.

Question 24

Name two security implications of master-detail relationships:

Answer 24

1. Permissions and security are inherited from master.

2. Owner field is not available on detail/subdetail; owner is inherited from master

Question 25

Can custom objects on the detail side of master/detail use sharing rules?

Answer 25

No - because owner field is required.

Question 26

What is used to create a many to many relationship?

Answer 26

Junction object - two master/detail relationships are created

Question 27

Can you use an encrypted text field as a filter for reports, list views or roll up summary fields?

Answer 27

NO

Question 28

Are global value sets restricted or unrestricted?

Answer 28

Restricted

Question 29

Two types of fields that can be a controlling field for a dependent picklist

Answer 29

Picklist | Checkbox

Question 30

How many External ID fields can there be on an object?

Answer 30

25

Question 31

What types of field can be defined as an external ID?

Answer 31

Text Number Email

Question 32

Can the data type on fields referenced by setup items be changed?

Answer 32

NO

Question 33

When can you convert master/detail to lookup?

Answer 33

If there are no roll up summary fields on the master object.

Question 34

When can you convert lookup to master/detail?

Answer 34

If there are values for all records

Question 35

Can you convert the data type of custom fields mapped in lead conversion?

Answer 35

Never

Question 36

Can you convert a picklist to a checkbox?

Answer 36

Yes

Question 37

Can you convert formula fields to another kind of field or vice versa?

Answer 37

NO

Question 38

What is faster - objects or schema builder?

Answer 38

Schema builder

Question 39

What types of fields cannot be created in schema builder?

Answer 39

Encrypted fields with data mask | Geolocation feilds

Question 40

What is the security setting of a field created in schema builder?

Answer 40

Visible and editable for internal profiles only.

Question 41

Fields created in schema builder are added to page layouts - true or false

Answer 41

False - schema builder does not add the fields to the page layout.

Question 42

Does Data Import Wizard support Opportunities?

Answer 42

NO Data Loader only.