Data Modeling and Management Flashcards

A Salesforce admin wants to prevent users from saving a Contact without a related Account. Which approach achieves this without code?

Answer: Create a validation rule requiring Account ID to be non-null

A validation rule using ISBLANK(AccountId) will block the save and display an error message if no Account is linked.

Which data type is best suited for storing a phone number that should be clickable on mobile devices?

Answer: Phone

The Phone field type formats numbers correctly and enables click-to-call functionality on mobile devices.

An admin creates a junction object to model a many-to-many relationship. How many master-detail relationships does the junction object have?

Answer: Two

A junction object has two master-detail relationships, one to each of the two parent objects it connects.

Which statement about schema builder is TRUE?

Answer: It allows admins to create and edit objects and fields visually

Schema Builder provides a drag-and-drop canvas to create objects, fields, and relationships without navigating multiple setup pages.

What is the purpose of the 'External ID' attribute on a custom field?

Answer: It allows the field to be used as a match key during data import upserts

Marking a field as External ID enables it to be used as a unique key for upsert operations in the Data Loader and APIs.

A company needs a field that displays the number of days since an Opportunity was last modified. Which field type is most appropriate?

Answer: Formula (Number)

A Formula field using TODAY() - LastModifiedDate calculates and displays a dynamic value without storing it separately.

Which Salesforce feature allows an admin to define dependencies between picklist values so that selecting one value filters the options in another picklist?

Answer: Dependent Picklists

Dependent picklists link a controlling field to a dependent field, filtering available values based on the controlling field's selection.