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

Questions 6–10

1. 6expert · medium

   A healthcare company needs to capture patient vitals at each visit. The vitals include standard measurements (e.g., blood pressure, heart rate) and a variable set of custom measurements that can change over time. The business team wants to be able to add new custom measurements without code changes. They also need to report on all vitals for a patient over time. Which data model approach best meets these requirements?

   • AUse a JSON field on the 'Vitals__c' object to store all measurements.
   • BCreate a single 'Vitals__c' object with a field for each possible measurement, including all custom measurements.
   • CUse a BigObject to store vitals and a custom Apex API to query them.
   • DCreate a 'Vitals__c' object with standard fields for common measurements and a related 'Custom_Vital__c' object with a name-value pair structure.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   In Salesforce, what is the primary difference between declarative (click) and programmatic (code) customization?

   • ADeclarative customization is only available for standard objects, while programmatic is for custom objects
   • BDeclarative customization requires coding, while programmatic does not
   • CDeclarative customization uses point-and-click tools, while programmatic uses code
   • DDeclarative customization is less scalable than programmatic customization
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which data modeling technique is specifically used to improve query performance for large data volumes in Salesforce?

   • AUsing a formula field to pre-calculate values
   • BUsing a custom setting to store frequently accessed data
   • CIncreasing the number of fields on the object
   • DCreating a skinny table
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A logistics company tracks shipments, each with multiple stops. They currently store stops as a comma-separated list in a text field on the Shipment object. The company is now expanding to handle 10x more shipments and needs to report on stop-level metrics (e.g., average dwell time per stop, on-time performance per stop). Which data model change best supports the new reporting requirements while maintaining scalability?

   • ACreate a separate custom object for each stop (Stop 1, Stop 2, etc.) with lookup relationships to the Shipment.
   • BStore stops in a BigObject and use a custom Apex method to query and aggregate stop data on the fly.
   • CCreate a custom child object 'Shipment Stop' with a master-detail relationship to Shipment, and store stop-level fields on the child record.
   • DKeep the comma-separated list but add a formula field that extracts each stop into a separate field for reporting.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   A data architect is designing a data model for a sales process that includes leads, opportunities, and orders. What is the most important consideration when mapping these entities?

   • AEnsuring each entity is represented by a standard Salesforce object
   • BEnsuring the relationships between entities support the flow of the sales process
   • CEnsuring the data model uses only lookup relationships
   • DEnsuring each entity has a unique external ID
   Reveal Solution Discussion Select an answer first