Salesforce Relationship Types Quiz
21 Questions
3 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which relationship type supports roll-up summary fields?

  • Many to Many
  • External Lookup
  • Lookup
  • Master-Detail (correct)

Which of the following relationship types is dependent and has a deletion cascade effect?

  • Many to Many
  • External Lookup
  • Lookup
  • Master-Detail (correct)

What is the maximum number of Master-Detail relationships allowed per object?

  • 40
  • 2 (correct)
  • Unlimited
  • 1

Which relationship type allows for unlimited relationships via a junction object?

<p>Many to Many (A)</p> Signup and view all the answers

Which relationship type requires a parent record to exist before a child record can be created?

<p>Master-Detail (B)</p> Signup and view all the answers

What is a key characteristic of a Lookup Relationship?

<p>Child records can exist independently of the parent. (B)</p> Signup and view all the answers

Which relationship type allows for roll-up summary fields?

<p>Master-Detail Relationship (D)</p> Signup and view all the answers

What happens to child records if a Master record is deleted?

<p>Child records are deleted. (B)</p> Signup and view all the answers

Which of the following is true about Hierarchical Relationships?

<p>They are available only for the 'User' object. (A)</p> Signup and view all the answers

How many Master-Detail Relationships can be created on a single object?

<p>2 (D)</p> Signup and view all the answers

Which statement best describes the difference between Lookup and Master-Detail Relationships?

<p>Master-Detail Relationships can be tighter and allow for data dependencies. (D)</p> Signup and view all the answers

In a Lookup Relationship, what is the implication of deleting the parent record?

<p>Child records remain unaffected. (B)</p> Signup and view all the answers

What type of relationship allows one user to reference another user in a hierarchical manner?

<p>Hierarchical Relationship (C)</p> Signup and view all the answers

What is a Many-to-Many Relationship characterized by?

<p>Involvement of a junction object to connect multiple records. (D)</p> Signup and view all the answers

Which statement is true regarding the Indirect Lookup Relationship?

<p>The parent must have a unique, custom field for linking. (A)</p> Signup and view all the answers

What is one property of an External Lookup Relationship?

<p>It requires a unique identifier for proper linking. (D)</p> Signup and view all the answers

How does a Many-to-Many Relationship compare to a Master-Detail Relationship?

<p>It allows for multiple associations between records. (A)</p> Signup and view all the answers

Which feature is unique to the Many-to-Many Relationship?

<p>It facilitates flexible associations between records. (B)</p> Signup and view all the answers

What is a defining characteristic of a Lookup Relationship?

<p>It defines hierarchical relationships like manager-subordinate. (A)</p> Signup and view all the answers

Which statement is accurate regarding the properties of a Many-to-Many Relationship?

<p>It requires a junction object to establish connections. (A)</p> Signup and view all the answers

What limitation is associated with a Lookup Relationship as compared to a Many-to-Many Relationship?

<p>It does not support roll-up summary fields. (A)</p> Signup and view all the answers

Flashcards

Lookup Relationship

Relates two independent objects. No data impact when a parent record is deleted.

Master-Detail Relationship

Creates a parent-child relationship between objects. Child record deletion cascades with the parent.

Many-to-Many Relationship

Relates multiple records from two different objects using a junction object.

Roll-Up Summary (Master-Detail)

Calculates totals or aggregates across child records in a Master-Detail relationship.

Signup and view all the flashcards

External Lookup Relationship

A lookup to objects outside the Salesforce ecosystem.

Signup and view all the flashcards

Lookup Relationship

A loose relationship where one object references another; deletion of one doesn't affect the other.

Signup and view all the flashcards

Master-Detail Relationship

A tight relationship between parent and child objects; deletion of the parent deletes children.

Signup and view all the flashcards

Hierarchical Relationship

A parent-child relationship, specifically for User objects (e.g., manager-employee).

Signup and view all the flashcards

Relationship Types

Different ways objects are connected in Salesforce, each with its own properties.

Signup and view all the flashcards

Lookup Relationship Limitations

A Lookup Relationship cannot have roll-up summary fields and is not mandatory for a relationship.

Signup and view all the flashcards

Master-Detail Properties

Parent record is mandatory, deleting a parent deletes child records and enables roll-up summaries.

Signup and view all the flashcards

Relationship Use Cases

Linking Account and Contact, or Opportunity and Account are good examples of relationship implementations.

Signup and view all the flashcards

Hierarchical Relationship Usage

Only for the 'User' object in Salesforce. Primarily for creating reporting relationships in the organization.

Signup and view all the flashcards

Master-Detail Relationship

A relationship where one record (parent) can have multiple related records (children).

Signup and view all the flashcards

Lookup Relationship

Links records from one object to another single record of a different object.

Signup and view all the flashcards

Many-to-Many Relationship

Allows multiple records of one object to relate to multiple records of another object, using a junction object.

Signup and view all the flashcards

External Lookup Relationship

Links Salesforce objects to external objects (e.g., databases).

Signup and view all the flashcards

Indirect Lookup Relationship

Links a child external object to a parent Salesforce object.

Signup and view all the flashcards

Junction Object

Facilitates many-to-many relationships.

Signup and view all the flashcards

Roll-up Summary Fields

Calculates summary values based on related records.

Signup and view all the flashcards

External Object

Object residing outside of Salesforce, often a database.

Signup and view all the flashcards

Study Notes

Different Relationship Types in Salesforce

  • Salesforce relationships connect objects, linking data.

  • Lookup relationships are loose connections.

    • One object references another.
    • Deleting one doesn't affect the other.
    • Example: Contact referencing an Account.
    • Not mandatory for a related parent.
    • Child records are separate.
    • Up to 40 lookups per object.
    • No roll-up summary fields.

  • Master-Detail relationships are tight connections.

    • Deleting a parent deletes child records.
    • Example: Account and Opportunity, if the account is deleted, all opportunities linked to that account are also deleted.
    • Parent is required for child records.
    • Deleting the parent also deletes the child.
    • Allows roll-up summary fields (like sum, counts).
    • Up to 2 master-detail relationships per object.

  • Hierarchical Relationships are a lookup type.

    • Only for User objects.
    • Manager-employee structure.
    • No roll-up summary fields.

  • Many-to-Many Relationships connect multiple records through a junction object.

    • Multiple records from one object can be related to multiple from another.
    • Uses a junction object (custom).
    • Example: Students and courses (through a course enrollment).
    • Supports roll-up summary fields.

  • External Lookup Relationships link Salesforce objects with external systems.

    • Used to integrate data from other databases.
    • Example: Salesforce Order Object linked to an ERPOrder.
    • Up to 25 external lookups per object.
    • Requires unique identifiers for linking.

  • Indirect Lookup Relationship links a child external object to a parent standard/custom Salesforce object.

    • External object linked to a Salesforce orgs parent object.
    • Example: OrderHistory linked to an Account
    • Parent must have unique custom field for linking.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

Related Documents

Relationships in Salesforce PDF

Description

Test your knowledge on the different relationship types in Salesforce. Explore lookup, master-detail, and hierarchical relationships, including their characteristics and implications for data linking. This quiz is ideal for those looking to deepen their understanding of Salesforce data structures.

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser