DATA MODELING & MANAGEMENT I Flashcards

1
Q

Which kind of relationship would be appropriate for a data model in which a record of an object can be related to multiple records of another obeject and vice-versa?

A

Many-to-many relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What kind of object should be used by a company to store data related to real estate properties?

A

Custom object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which feature can be used for an overview of the data model of a custom application in Salesforce?

A

Schema Builder

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Can a text field be converted to a picklist?

A

Yes, if a text field is converted to a standard picklist, values from the text field will be populated into picklist values and data is retained.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Can relationship types be changed?

A

Yes, a master-detail relationship field can be converted to a lookup relationship field and vice versa, but the lookup field must have values in all the records.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What custom field types cannot be converted? (to or from)

A

Encrypted fields and formula fields cannot be converted to or from.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the difference between a lookup and master-detail relationship?

A

Both allow one object to be related to another in a one-to-many relationship, but in a master-detail relationship, the detail record wouldn’t exist without the master. Usually when the master is deleted, the detail records are deleted.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How is a many-to many relationship created?

A

Using a junction object. This object sits between the two objects in the many-to-many relationship and has two master-detail fields, one for each of the objects to be related.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which relationship can be used on the User object to associate one user with another?

A

Hierarchical relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is an auto number field?

A

It is a read-only field that includes a specified prefix or suffix and a unique incremented number.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the different types of Text fields?

A

Text (up to 255), Text Area (up to 255 chars on separate lines), Text Area (Long) (up to 131,072 chars, Text Area (Rich) (up to 131,072 can contain rich formatting), Text (Encrypted)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are the different types of picklists?

A

Standard, multi-select, and dependent. Note that picklists can be defined globally (global picklist) or at the object level (local picklist).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How does a Text(Encrypted) field work?

A

Up to 175 chars can be encrypted, but they are displayed as masked if a user doesn’t have the required system permission to view.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is an external ID?

A

An external ID is a field that contains a unique identifier from a system outside of Salesforce.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the difference between assigning the default record type at the profile level or as a user setting?

A

If a default record type is assigned in a user’s profile, the user is prompted to select it while creating a new record. If it is assigned in the user’s personal settings, it is selected automatically.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A field does not display any picklist values, even though picklist values exist. What could cause this?

A

The object has record types defined, and no picklist values were added to the field for the record type.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What happens to picklist values of a record type if a value is removed from the master picklist?

A

If a value is removed from the master picklist, it is no longer an option for new records of any record types that included it. For existing records, a prompt is displayed to either replace the value or leave blank.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What does record type access control?

A

Record type access controls which record type is used when a user creates or edits a record. Users can view records of any record type if they have read access to the object.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Where is record type access assigned?

A

Record type access can be assigned using a profile or permission set, or a combination of both. A permission set can only be used to grant additional access.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What are record types used for?

A

Display different picklist values for the same field based on the record type, Display different fields in page layouts based on the record type / profile combination, Support different business processes for an object

21
Q

What kind of accounts are there and how are they used?

A

Business Accounts and Person Accounts. Business Accounts are used for B2B selling and Person Accounts are for B2C.

22
Q

What is a Person Account?

A

A Person Account is used for B2C situations and is an account made up of one Account and one Contact record. It is not enabled by default. It must be requested and enabled by Salesforce Support.

23
Q

What are Campaign Statistics?

A

Campaign Statistics include the number of responses, leads and opportunities generated, and the value of the won opportunities.

24
Q

What are some of the major capabilities of the Lead object?

A

Lead Business Process, Web-to-Lead, Auto Response Rule, Lead Import, Lead Queues, Assignment Rule, Lead Conversion

25
Q

What are some of the major capabilities of the Case object?

A

Email-to-Case, Web-to-Case, Case Queues, Assignment Rules, Escalation Rules

26
Q

What is a record type ?

A

Define the business process, picklist values and page layout for the object

27
Q

Where can users change their default record type for an object?

A

User settings (no admin required)

28
Q

What is the master picklist?

A

An independent complete list of all values used in any record type

29
Q

What is an external lookup relationship?

A

Defined to link an object with a PARENT external object

30
Q

What is an indirect lookup relationship?

A

Link a CHILD external object to a parent standard or custom object through a custom, unique external ID field

31
Q

What are the standard fields in SF?

A

Name, Owner and Created By

32
Q

How many characters do each Text field type allow?

A
Text = 255
Text Area = 255
Text Area (Long) = 131,072
Text Area (Rich) = 131,072
33
Q

What permission must the SF org allow before implementing encrypted fields?

A

Require secure connections (HTTPS)

34
Q

What are the two types of controlling fields?

A

Picklist or checkbox

35
Q

What is the limit of External ID fields on an object?

A

25

36
Q

What types of fields are “Read-Only”?

A

Auto-number field, roll-up summary field, and formula field

37
Q

How many characters can be in an Auto-Number field?

A

30 characters

38
Q

What custom field types cannot be created in Schema Builder?

A

Geolocation, External lookup Relationship, Indirect Lookup Realtionship and Encrypted Fields

39
Q

What tools are avaliable for importing data into SF?

A
Data Loader
Data Loader CLI
Third Party Tools
Data Import Wizard
Import Knowledge Articles
40
Q

What tools can be used for exporting data from SF?

A
Data Loader
Data Loader CLI 
Third Party Tools
Data export service
Report Export
41
Q

What is the record transfer limit of the Data Loader?

A

5 million records

42
Q

What objects are supported by the Data Import Wizard?

A

Standard Objects:

Accounts
Contacts
Leads 
Solutions
Campaign Members
Person Accounts
Custom Objects
43
Q

What does the “_x” suffix represent with an object name?

A

It is an External Object

44
Q

What are the requirements for defining an external object?

A

Label
Name
External Data Source
Table Name

45
Q

What types of lookup relationships are available for external objects?

A
  • Lookup relationship
  • Indirect lookup
  • External lookup
46
Q

What can an App Builder create with Schema Builder?

A
  • Master detail relationships
  • Lookup relationships
  • Custom objects
  • Custom fields (except geolocation)
47
Q

What are two capabilities of Schema Builder?

A
  • Modify custom field help text on standard objects

* Create lookup or master detail object relationships

48
Q

What happens to a junction object record when either associated master record is deleted?

A

The record is deleted and placed in the recycle bin