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 3)

Questions 11–14

1. 11foundation · easy

   What is the primary purpose of using an index in a Salesforce data model?

   • ATo enforce data integrity
   • BTo reduce the storage space required for the data
   • CTo automatically clean up duplicate records
   • DTo speed up data retrieval for queries
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A retail company is designing a data model for customer orders. Each order can have multiple order lines, and each order line can have multiple shipments. They expect to have millions of orders and need to ensure that queries for order summaries (e.g., total amount, number of lines) are fast. Which design consideration is most important for scalability?

   • AUse a master-detail relationship between Order and Order Line, and a lookup relationship between Order Line and Shipment.
   • BUse a single object with all order and line data in one record to avoid joins.
   • CUse a custom index on the Order Number field and rely on SOQL queries to aggregate data.
   • DUse a lookup relationship between Order and Order Line, and a master-detail between Order Line and Shipment.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A manufacturing company has a complex approval process for purchase orders. The approval chain can vary based on the amount, department, and region. They need to track the approval history and status for each purchase order. Which data model approach best supports this business process?

   • ACreate a separate custom object for each approval step and link them to the Purchase Order.
   • BBuild a custom Apex-based approval engine with a custom object to store the entire approval chain and status.
   • CUse standard Salesforce Approval Process with the Purchase Order object and a custom object to track approval history details.
   • DStore the approval status in a single text field and use workflow rules to update it.
   Reveal Solution Discussion Select an answer first
5. 14expert · medium

   A non-profit organization needs to track donations and pledges. A pledge is a promise to donate, and a donation is the actual receipt of funds. A pledge can be fulfilled by multiple donations over time. They need to track the remaining balance on a pledge and report on donation history. Which data model best supports this business process?

   • ACreate a junction object between 'Pledge__c' and 'Donation__c' to track the relationship.
   • BCreate a 'Donation__c' object with a lookup to 'Pledge__c' and use a workflow rule to update the pledge balance.
   • CCreate a 'Pledge__c' object and a 'Donation__c' object with a lookup relationship from Donation to Pledge, and use a roll-up summary field on Pledge to sum the donations.
   • DCreate a single 'Pledge__c' object with a field for the pledge amount and a field for the total donations received.
   Reveal Solution Discussion Select an answer first