Data Modeling and Management

Question 1

What type of relationship allows creating Roll-Up Summary Fields and deletes child records when the parent record is deleted?

Accepted Answer

Master-Detail Relationship

Answer

Lookup Relationship

Answer

External Lookup

Answer

Hierarchical Relationship

Question 2

An administrator needs to model a Many-to-Many relationship between 'Student' and 'Course'. How is it implemented?

Accepted Answer

Create a Junction Object with two Master-Detail relationships (one to Student and one to Course)

Answer

Create a Lookup from Student to Course and another from Course to Student

Answer

Use a Multi-Select Picklist field on Student with Course values

Answer

Create a Hierarchical relationship between both objects

Question 3

What is the main difference between Data Import Wizard and Data Loader? (Select 2)

Accepted Answer

Answer

Data Import Wizard supports up to 50,000 records; Data Loader up to 5 million

Answer

Data Loader can schedule automatic imports (Schedule); Data Import Wizard cannot

Answer

Data Import Wizard is a desktop application; Data Loader is web

Answer

Data Loader only supports standard objects; Data Import Wizard supports custom

Question 4

What declarative tool allows you to visualize and modify objects, fields, and relationships graphically?

Accepted Answer

Schema Builder

Answer

Object Manager

Answer

Report Builder

Answer

App Builder

Question 5

How many Master-Detail relationships can a custom object have as a child?

Accepted Answer

2

Answer

1

Answer

3

Answer

5

Question 6

What operations does Data Loader allow that are NOT available in Data Import Wizard? (Select 2)

Accepted Answer

Answer

Insert (create records)

Answer

Delete (mass delete records)

Answer

Export All (include recycle bin data)

Answer

Upsert (insert and update)

Question 7

A custom object 'Invoice__c' has a Lookup to Account. What happens to Invoice records when the parent Account is deleted?

Accepted Answer

Invoice's Lookup field is set to null (orphaned)

Answer

Invoice records are automatically deleted (cascade delete)

Answer

Account deletion is blocked if it has Invoices

Answer

Invoice records are moved to the recycle bin

Question 8

What field type is used to establish a relationship between a Salesforce record and a record stored in an external system?

Accepted Answer

External Lookup Relationship

Answer

Lookup Relationship

Answer

Indirect Lookup Relationship

Answer

URL Field

Question 9

What field is commonly used to prevent duplicate records when importing data with Data Loader using the Upsert operation?

Accepted Answer

External ID

Answer

Record Type ID

Answer

Salesforce ID (18 characters)

Answer

Auto-Number

Question 10

What characteristics does a field marked as 'Required' in Object Manager have? (Select 2)

Accepted Answer

Answer

It's required on all Page Layouts without exception

Answer

Applied at database level; no API or UI can bypass it

Answer

Only applies in the standard user interface

Answer

Can be overridden with a Validation Rule