Data Modeling and Management Flashcards

Which field type should be used to store a unique identifier that is automatically generated by Salesforce for each record?

Answer: Auto Number

Auto Number fields automatically generate a unique, sequential number for each record, formatted as defined by the admin.

A company wants to track the total value of all related Opportunity line items on the Opportunity record. Which field type accomplishes this?

Answer: Roll-Up Summary

Roll-Up Summary fields aggregate child record values (SUM, COUNT, MIN, MAX) and display the result on the parent record.

What happens to child records in a lookup relationship when the parent record is deleted?

Answer: Child records remain with the lookup field set to null

In a lookup relationship, deleting the parent record does not delete children; the lookup field on child records is cleared.

Which of the following is a key difference between a picklist and a multi-select picklist field?

Answer: Multi-select picklist allows users to select more than one value

Multi-select picklists allow users to choose multiple values simultaneously, whereas standard picklists allow only a single value.

An administrator needs to ensure that no two Account records share the same Tax ID number. Which field setting enforces this?

Answer: Unique checkbox on the field definition

Enabling the Unique attribute on a custom field prevents duplicate values from being saved in that field across records.

Which object relationship type allows the child record to be included in the parent record's page layout and detail view by default?

Answer: Master-Detail

Master-Detail relationships enable related lists and roll-up summaries, and the child record's ownership and sharing follow the parent.

What is the maximum number of custom fields allowed on a standard Salesforce object in most editions?

Answer: 500

Salesforce allows up to 500 custom fields per standard object in most editions, though some limits vary by object and edition.