Data Modeling and Management I

Question 1

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 object and vice-versa?

Answer 1

Many-to-many relationship

Question 2

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

Answer 2

Custom object

Question 3

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

Answer 3

Schema Builder

Question 4

Can a text field be converted to a picklist?

Answer 4

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.

Question 5

Can relationship types be changed?

Answer 5

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.

Question 6

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

Answer 6

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

Question 7

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

Answer 7

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.

Question 8

How is a many-to-many relationship created?

Answer 8

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.

Question 9

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

Answer 9

Hierarchical relationship

Question 10

What is an auto number field?

Answer 10

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

Question 11

What are the different types of Text fields?

Answer 11

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)

Question 12

What are the different types of picklists?

Answer 12

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

Question 13

How does a Text (Encrypted) field work?

Answer 13

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.

Question 13

How does a Text (Encrypted) field work?

Answer 13

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.

Question 14

What is an external ID

Answer 14

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

Question 15

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

Answer 15

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.

Question 16

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

Answer 16

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

Question 17

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

Answer 17

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.

Question 18

What does record type access control?

Answer 18

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.

Question 19

Where is record type access assigned

Answer 19

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.

Question 20

What are record types used for?

Answer 20

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

Question 21

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

Answer 21

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

Question 22

What is a Person Account?

Answer 22

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.