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

Questions 16–19

1. 16foundation · medium

   A Salesforce data architect is designing a data model for a recruiting application. A candidate can apply to many job postings, and a job posting can receive applications from many candidates. The architect needs to track the application date and the candidate's current stage in the hiring process for each application. Which relationship type should the architect use?

   • AA lookup relationship from Candidate to Job Posting, storing the application date and stage on the Candidate record
   • BA master-detail relationship between Candidate and Job Posting with the Application as the detail record
   • CA self-relationship on the Candidate object with a custom field to indicate the Job Posting, and a separate custom object for application details
   • DA many-to-many relationship implemented with a junction object that has master-detail relationships to both Candidate and Job Posting, with the application date and stage on the junction object
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A company wants to track the relationship between Opportunities and Products. An Opportunity can have multiple Products, and a Product can be associated with multiple Opportunities. They also need to capture the quantity and discount for each product on an opportunity. What is the best data model?

   • ACreate a custom object 'Opportunity Product' with lookups to Opportunity and Product.
   • BUse a custom object 'Product Line Item' with a master-detail to Opportunity and a lookup to Product.
   • CAdd a Product lookup field to Opportunity and a Quantity field.
   • DUse the standard Opportunity Product object, which is a junction between Opportunity and Product.
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   How does the object hierarchy in a Salesforce data model affect reporting?

   • AIt only affects the visual layout of reports, not the data
   • BIt determines the storage size of each record
   • CIt determines which objects can be included in a report and how data is aggregated
   • DIt has no impact on reporting; reports only use fields from a single object
   Reveal Solution Discussion Select an answer first
5. 19foundation · medium

   A Salesforce architect is evaluating whether to denormalize a data model by storing a calculated roll-up value on a parent object instead of computing it from child records at runtime. Which statement accurately describes a primary trade-off of this design choice in Salesforce?

   • ADenormalization increases storage consumption and slows down all queries because the duplicated data must be read from disk on every access, making it a poor choice for any read-heavy scenario.
   • BDenormalization reduces the need for queries that aggregate child records, improving read performance, but requires careful maintenance to keep the stored value consistent with the underlying child data.
   • CDenormalization is primarily used to enforce referential integrity between parent and child records, ensuring that a child record cannot exist without a corresponding parent record.
   • DDenormalization eliminates the need for any database indexes, because the data is stored in a single flat table that can be scanned quickly without additional lookup structures.
   Reveal Solution Discussion Select an answer first