Data Modeling and Management Flashcards

An administrator needs to import 50,000 Account records and update existing records based on a unique field. Which tool is most appropriate?

Answer: Data Loader

Data Loader supports upsert operations on large volumes of records (up to 5 million) and can match on External ID fields.

What is the maximum number of master-detail relationships a single custom object can have?

Answer: Two

A custom object can have up to two master-detail relationship fields, allowing it to serve as a junction object.

Which field type would you use to capture long blocks of text, such as a detailed description, that may exceed 255 characters?

Answer: Long Text Area

Long Text Area fields support up to 131,072 characters and are appropriate for lengthy plain-text content.

An admin wants child records to be deleted when the parent is deleted. Which relationship type enforces this behavior?

Answer: Master-Detail

In a master-detail relationship, deleting the parent record triggers a cascade delete of all related child records.

What does enabling the 'Allow Reports' checkbox on a custom object do?

Answer: Enables the object to be used in custom report types

Checking 'Allow Reports' makes the object available as a primary or related object when creating custom report types.

A company tracks Contacts at multiple Accounts (e.g., a consultant working for several clients). Which Salesforce feature supports this scenario?

Answer: Contacts to Multiple Accounts

The 'Contacts to Multiple Accounts' feature allows a Contact to be directly related to multiple Account records via a relationship record.

Which statement about formula fields is correct?

Answer: Formula field values are calculated at runtime and not stored in the database

Formula fields are computed dynamically each time a record is displayed and do not occupy storage in the database.