Given a Scenario, Describe Data Modeling Concepts and Implications of Database Design and Modeling. TECHNICAL-ARCHITECT Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A company wants to model the relationship between Sales Reps (Users) and the Accounts they manage. Each Account must have exactly one Sales Rep, and a Sales Rep can manage many Accounts. Which relationship type should be used between Account and User?

   • AA master-detail relationship from Account to User.
   • BA formula field on Account that references the User.
   • CA many-to-many relationship using a junction object.
   • DA lookup relationship from Account to User.
   Reveal Solution Discussion Select an answer first
2. 12foundation · medium

   A Salesforce architect is designing a data model for a large-volume use case. The requirement is to track many child records per parent, and the most frequent query filters child records by a foreign key and a status field. The architect wants to avoid the common scalability pitfall of excessive joins. Which approach best aligns with scalable data modeling principles in Salesforce?

   • ACreate a custom index on the foreign key and status fields of the child object, and design queries to filter directly on the child object using those indexed fields.
   • BStore the status field on the parent object and update it whenever any child record changes, so that queries can filter on the parent object alone without ever querying the child object.
   • CCreate a custom formula field on the child object that concatenates the foreign key and status, and then use a text search on that field to find matching records.
   • DUse a junction object to relate the child records to the parent, and then query the junction object to find matching records, since junction objects are always indexed and provide the fastest lookup path.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   In Salesforce data modeling, what does the term 'cardinality' refer to?

   • AThe uniqueness of a record's primary key in the database
   • BThe level of detail stored in a field, such as a picklist or text
   • CThe number of fields that can be created on a custom object
   • DThe number of records that can be associated on each side of a relationship
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A company is integrating Salesforce with an external ERP system. The ERP sends a unique customer code for each customer. They want to upsert Account records from the ERP without creating duplicates. What should they configure in Salesforce?

   • ACreate a custom field on Account to store the ERP customer code and mark it as an External ID.
   • BUse the standard Account Number field as the External ID.
   • CUse the Account Name field as the matching key in the upsert.
   • DCreate a lookup relationship from Account to a custom object that stores the ERP code.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company wants to report on the number of open Opportunities per Account. They have a standard Account object and a standard Opportunity object. They want to display this count on the Account page and use it in reports. What should they do?

   • ACreate a custom object to store the count and update it via a trigger.
   • BUse a report that counts Opportunities and display it on the Account page via a dashboard.
   • CCreate a formula field on Account that counts Opportunities.
   • DCreate a roll-up summary field on Account that counts Opportunities where Stage is not Closed Won or Closed Lost.
   Reveal Solution Discussion Select an answer first