Given a Customer Scenario, Design a Data Model That Is Scalable, Supports All Business Processes with Appropriate Level of Customizations (click vs. Code), While Considering Performance for Large Data Volumes. DATA-ARCHITECT Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   A data architect is designing a Salesforce data model for a new application. Which design principle is most directly associated with ensuring the model remains scalable as data volume and user load increase?

   • AStoring all related data in a single record to avoid joins
   • BMinimizing the number of custom objects and fields to reduce complexity
   • CUsing a single large object to store all records to simplify access
   • DDesigning with an eye toward future growth in records and users, using appropriate relationships and indexing
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A university needs to track student enrollments in courses. Each student can enroll in multiple courses, and each course can have multiple students. They also need to track the grade a student received in each course. Which data model best supports this business process?

   • AUse a custom object 'Enrollment__c' with a text field that stores the course ID and grade as a string.
   • BCreate a custom object 'Course_Student__c' with a master-detail relationship to Course and a lookup to Student, storing the grade on the Course_Student__c record.
   • CCreate a custom junction object 'Enrollment' with lookup relationships to both Student and Course, and store the grade on the junction object.
   • DAdd a multi-select picklist on the Student object to list all courses and a separate field for grades.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which data modeling practice is most likely to help a Salesforce data model scale effectively as the number of records grows?

   • AUsing master-detail relationships for all related objects to enforce data integrity
   • BCreating a custom index on every field to speed up all queries
   • CAvoiding formula fields that reference large text areas
   • DUsing selective queries and designing objects to support efficient filtering
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A non-profit organization needs to track donations and campaign responses. They have a small IT team with no developers and need to implement a solution quickly. The business process requires that when a donation is received, the related campaign's total donation amount is updated. Which approach is most appropriate?

   • AUse a workflow rule to update the Campaign total when a Donation is created.
   • BCreate a formula field on the Campaign that sums the donation amounts.
   • CWrite an Apex trigger on the Donation object to update the total on the Campaign.
   • DUse a roll-up summary field on the Campaign object to sum the donation amounts from the related Donation records.
   Reveal Solution Discussion Select an answer first
6. 5expert · medium

   A financial services company is designing a data model for client accounts and transactions. They have a requirement to support multiple business processes, including account management, transaction reporting, and compliance auditing. They expect to have millions of accounts and hundreds of millions of transactions. The compliance team needs to be able to query transaction data for a specific account over a specific date range quickly. Which data model approach best balances scalability, business process support, and performance?

   • AUse a BigObject to store all transactions and use a custom Apex API to query them.
   • BDenormalize the data by storing all transactions as a JSON array on the Account record.
   • CUse a standard Account object and a custom 'Transaction__c' object with a lookup to Account, and create custom indexes on the Account lookup and Transaction_Date__c fields.
   • DCreate a separate custom object for each year of transactions and use a lookup to Account.
   Reveal Solution Discussion Select an answer first