Data Model: Quiz

These questions are designed to be similar to ones that will be asked on certification exams.  Aim to get most of these questions correct on the first attempt.
To view the remainder of this content, you must register for a free account.  Please Login or Sign Up.

48 Responses to “Data Model: Quiz”

  1. msjohncox July 21, 2017 at 5:45 pm #

    It kind of seems like there is a “hierarchy” of objects. Near the top are Accounts, which have one-to-many relationships with other objects. One Account can have many Contacts, many Opportunities, etc. Users would seem to be even higher. An Account, Opportunity or Contact can have only one Owner, even though an Owner may own many Accounts, Opportunities or Contacts. Does this make sense?

    • JohnCoppedge July 25, 2017 at 8:45 pm #

      The strongest sense of hierarchy in my mind is the record ownership relationship (most records will have a record owner in salesforce). Also account ownership as you mention- the account is the “glue” that holds together a whole of related records. Beyond that, I would call the relationships more of a “web” 🙂

  2. opaz April 17, 2017 at 1:56 pm #

    Hi Jhon,
    Where can I found more resources for practice? Quiz/Tests/Questions
    The 2 questions quiz is not enough…


    • martin8594 July 29, 2017 at 10:46 pm #

      This is true. Suggestions welcome!

      • JohnCoppedge July 31, 2017 at 12:28 pm #

        I’m working on a massive update folks, including lots of new quesitons

        • asehic89 August 31, 2017 at 12:23 am #

          Yes! Thanks! Definitely need a few more on here, with ERD diagrams would help.

  3. rarenet March 1, 2017 at 3:14 pm #

    Hi. Maybe this was answered, but there are a lot of responses to this. For reporting purposes, would you not have a single opportunity named that when converted, could be tied to multiple accounts for reporting purposes?

    For example, a sale of an engine part would have an opportunity called – Engine part opportunity, which could be tied to many accounts.

    Or is an opportunity an opportunity, with no individual reference to a particular opportunity. That would be referenced in another field.

    For example “opportunity,” would be linked many accounts, with another field, Part Name – referencing the part and in reports it would be configured to look for both fields to get the same result.

    • JohnCoppedge March 1, 2017 at 6:15 pm #

      An opportunity is linked to a single account.

      If you were selling multiple parts within the opportunity, those parts would be represented as line items within that opportunity.

      Now if you wanted to create a relationship where an opportunity was linked to multiple accounts you would like do either a) create multiple opportunities or b) create a junction object to allow secondary relationships (kind of like contact roles for accounts/contacts)

  4. piyushsharma09 August 23, 2016 at 11:49 pm #

    Hi John,

    how should we read the Account-Opportunities relationship. one way like one account can have many opportunities.Many opportunities can have one account.

    Should we read it forward from account to opportunity, in second step backwards from opportunity to account. Then we can reach to conclusion what kind of relationship has to be established.?
    I am not getting that.

    • JohnCoppedge August 24, 2016 at 7:54 am #

      One account can have many opportunities- therefore account to opportunity is a one to many relationship. Reversing that, opportunity to account is a … relationship

      • Shirley Lafuente November 21, 2016 at 4:33 pm #

        So if you refer to Opportunities to accounts would you say opportunities to accounts is a “many to one”….?

        • JohnCoppedge November 21, 2016 at 6:07 pm #

          Correct, account is one to many with opportunities, the reverse is true as well

  5. CarlosSiqueira May 25, 2016 at 10:29 pm #

    As of Summer 16, we can have Multiple Contacts assigned to multiple Accounts:

  6. joshliu22 April 10, 2016 at 4:15 pm #

    I think we should have a chart detailing the various possibilities, for example have an account object and multiple lines drawn to an opportunity. Having graphical examples are really helpful. Great work btw!

    • JohnCoppedge April 10, 2016 at 9:54 pm #

      ERDs should detail exactly what you’re describing- however the relationship between account and opportunity would be expressed through a single line (crows feet describing the “many” side of the relationship)

  7. March 23, 2016 at 7:31 am #

    Hi John,
    I am wondering if its really necessary to study those huge diagrams under Salesforce Data Model from certification point of view? Since I’m literally bogged down studying all these scary diagrams along with the relationship lines. Any advice is really appreciated. Thanks.

    • JohnCoppedge April 10, 2016 at 9:49 pm #

      You don’t need to memorize the diagrams by any stretch but you should have a solid understanding of the basic object relationships (e.g. account, contact, opp, lead, etc.)

  8. joelramos March 1, 2016 at 9:40 pm #

    I think the questions are not clear. You ask in “singular” and the answer/explanation is in plural.

    I know the relationships between these objects. But I didn’t answer correctly in my first quiz.

    Thanks in advance for your great support with site.

    • JohnCoppedge March 2, 2016 at 12:04 am #

      Ah gotcha- the name of the object would be singular. For example “User” is the actual name of the object; the question is using the literal object name.

      • meticulousmeerkat September 3, 2016 at 2:49 am #

        Hi, yep, As Joel same here. Cheers.

  9. dgallegos1975 March 1, 2016 at 8:05 pm #

    Am I incorrect to think that PermissionSet is referring to one instance of a permission set (one permission set label)? I know the creation of a permission set can be applied to many users. Multiple “PermissionSets” can can be applied to mulitple users, creating a many to many relationship.

    • JohnCoppedge March 1, 2016 at 8:32 pm #

      You’re correct- permission set is a m2m relationship to user (that’s the correct answer as well).

  10. rits_bits November 29, 2015 at 7:51 am #

    Hi John

    We need more practice question on data model as the relationship is very extensive. Can you let us know the trusted link or site where we can have practice question or test to firm our understanding.

    Please help

    • JohnCoppedge December 1, 2015 at 1:39 am #

      I will look into adding more questions – FYI this is not a heavy focus of this exam. It is more provided for reference.

  11. DAVID WALL August 29, 2015 at 3:11 am #

    Awesome site…

    Do you think that Question 2 should read-

    PermissionSet(s) to User is a _____ to ____ relationship.

    instead of

    PermissionSet to User is a _____ to ____ relationship. ?

    I guess i was thinking of it as how a single permission set relates to users. Thanks

    • JohnCoppedge August 29, 2015 at 1:44 pm #

      Tbe question refers to the objects themselves (single) rather than the records created in the object (plural). That’s the intent of the question!

  12. Sri May 24, 2015 at 4:28 am #

    Hi John,
    I am a bit confused with the relationships. One Opportunity can have many Accounts meanwhile one account can have many Opportunities right. Then should it be Many to many relationship?

  13. Agyasi Ampah May 12, 2015 at 11:09 pm #

    hi John

    thanks for a great site for exam prep.
    would it be possible to point me to where i can get a detail look at all the relationships between the major tabs. i get a little confused, so if possible will like a list of object relationships between the major ones.

    thanks in advance

  14. Susan Sampson March 5, 2015 at 4:56 pm #

    Hi John,

    I cannot find the quiz for the Data Model section either.


  15. Andrey Stoyanov March 5, 2015 at 2:48 pm #

    When I go to the quiz section in any of the modules I only see the remark “These questions are designed to be similar…” and then the comments section. The quiz itself is not displayed. What could be the reason for that?

  16. Jai Patel November 21, 2014 at 3:44 am #

    Hi John.
    The Question One is about Opportunity – to – Account relationship. As an opportunity can have one and only one account, it is a one- to – one relationship. If it is about Account- to – Opportunity relationship then it will be zero(or one) – to – many relationship as one account can have zero(or one) to many opportunities. But the answer to the question is different.
    Awaiting your clarification. Thanks.

    • JohnCoppedge November 21, 2014 at 10:46 pm #

      Hi Jai,

      Great question – this quiz question is there precisely for this reason.

      The account to opportunity is a one (or zero) to many relationship, as you mentioned. That necessarily means – from a data a perspective – that the reverse is also true: the opportunity object has a many to one relationship with the account object.

      Now if you think about this from the perspective of an individual opportunity record, yes, an opportunity can only be related to one account. However, an account can still have more than one opportunity related. Therefore the object relationship still stands as a many to one. Hope that helps.



      • Jai Patel November 22, 2014 at 4:05 am #

        It’s much clear now. Thanks.

  17. jon rios August 4, 2014 at 9:43 pm #

    hi, i see the Data Model had 2 Quiz questions (i was expecting more), for a paid subscription, what are the total quiz questions.. per topic, etc?


    • JohnCoppedge August 5, 2014 at 12:24 am #

      Hi Jon,

      Some sections are slimmer than others – there are 30 practice questions (half of the real exam) at the end of the guide. The value of this guide is not intended to be in the # raw questions but the overall approach (you can search the web for a greater volume of questions… albeit most are incorrect or poorly written). That said it is something I get asked for frequently so I will consider beefing up!



      • Jean Allen September 9, 2014 at 11:02 pm #

        I read question 2 a little differently. I would have said many to one.
        Permission sets can be many but user would stipulate 1. Should the question not be “users” sorry to be pedantic.

        • JohnCoppedge September 17, 2014 at 7:25 pm #

          The question wording is using fully qualified API names, but yeah I agree with your objection from an English standpoint 🙂

  18. Barbara Hill July 1, 2014 at 8:41 pm #

    It would have helped me a lot to do the data model section BEFORE the security and user setup sections.

    • JohnCoppedge July 8, 2014 at 8:17 pm #

      Thanks for the thought – it is intentionally organized this way (so that the data model has some context), but I do appreciate the feedback. Others feel free to chime in on your thoughts on the organization – always open to making changes.

  19. Marc Williams April 3, 2014 at 5:20 pm #

    Thanks for the SSN example John, that made a light bulb come on

  20. Arpan Lidder December 12, 2013 at 3:23 am #

    I am confused about question one in the Quiz – Relationship of Opportunity to Account — Why is it not one to one? One opportunity is related to only one account.
    An account to opportunity relation would be quite understandably one to many.
    What am I missing?

    • JohnCoppedge December 13, 2013 at 6:19 am #

      Many opportunities can be related to one account.

      A true one-to-one relationship isn’t very common in Salesforce – for instance:
      A US citizen to Social Security Number would be a one to one relationship.

      Citizen can only have 1 SSN, SSN can only be tied to one citizen.

      Whereas an opportunity can only have on account, an account can have many opportunities.

      Make sense?

Leave a Reply