SP Database Management 2

Question 1

Which Salesforce feature allows you to store large amounts of unstructured data such as documents and images directly linked to records?

Accepted Answer

Files and Attachments

Answer

Salesforce Files and Attachments allow users to store unstructured data like documents and images linked directly to records.

Question 2

What is the maximum number of custom fields allowed on a standard Salesforce object by default?

Accepted Answer

800

Answer

Salesforce allows up to 800 custom fields on most standard objects by default.

Question 3

Which data type should be used for a Salesforce field that must store a unique identifier from an external system?

Accepted Answer

Text (External ID)

Answer

A Text field marked as External ID stores unique identifiers from external systems and can be used as an upsert key.

Question 4

When using Salesforce SOQL, what clause is used to filter query results based on a related object's field?

Accepted Answer

WHERE with dot notation

Answer

SOQL uses dot notation in the WHERE clause (e.g., Account.Name = 'Acme') to filter on related object fields.

Question 5

What Salesforce tool is best suited for deleting large volumes of records without hitting governor limits?

Accepted Answer

Data Loader with bulk API

Answer

Data Loader using the Bulk API can process up to 5 million records per batch, making it ideal for large-volume deletions.

SP (Certified Service Provider) Practice Test