Data Modeling and Database Design

An architect is modeling a 'Subscription' service where Customers have multiple active subscriptions. Which approach best handles the 'Current' vs 'Historical' subscription data for reporting?

An organization wants to use 'Person Accounts' to manage B2C relationships. Which consideration is most important for a Data Architect when evaluating this change?

A company is migrating legacy data and needs to preserve the CreatedDate and CreatedById. Which feature should they enable?

An org has a custom object 'Invoice__c' with a Lookup to Account. Users frequently complain that deleting an Account leaves orphaned Invoice records, and reports show Invoices with no Account. The business wants the platform to prevent an Invoice from being saved without a valid Account. Which change should the architect make?

An architect is choosing between storing a new data domain in a custom object versus using Big Objects in Salesforce. The dataset is expected to reach billions of records with append-only writes and infrequent, key-based reads. Which two characteristics make Big Objects the appropriate choice for this scenario? (Choose two.)

Universal Containers wants to track complex relationships between Accounts where one Account can be a subsidiary of many others, and an Account can have many parent companies. Which modeling approach should the Architect recommend?

An architect is building a data model for a subscription service. They need to calculate the total revenue across all related 'Invoice' records for an 'Account'. Which approach should they use?

An administrator wants to convert an existing custom lookup relationship on the 'Project' object pointing to the 'Client' object into a master-detail relationship. Which precondition must be satisfied before this conversion can be completed successfully?

Universal Containers requires a data model where a Child object must have exactly one Parent object that is mandatory. If the Parent is deleted, the Child must be deleted. Which relationship should the Architect select?

A nonprofit needs to record donations. Each donation is made by exactly one donor Account, and the organization wants a Donor's lifetime giving total displayed on the Account record itself, updated automatically whenever a Donation is created or edited. What should the architect configure?

A financial services firm stores portfolio holdings in a custom object with 4 million records. Analysts frequently filter holdings by Account and by a calculated risk score derived from multiple fields on the holding record. The architect wants to minimize query time when users filter by risk score in list views and reports. Which approach should the architect take?

When designing a data model for a multi-region deployment, what is the best way to handle global picklist values?

Which TWO factors should be considered when choosing between a Master-Detail and a Lookup relationship for a new custom object? (Choose two)

A Data Architect is analyzing a legacy system migration. Which THREE factors should be evaluated before deciding between a Lookup or a Master-Detail relationship?

An enterprise architect is evaluating data storage strategies for a telecommunications client experiencing rapid data growth of fifty million call detail records annually. Which TWO strategies should the architect implement to maintain database query performance and platform data limits? Choose 2 answers.

Which design approach is best for handling a 'Data Warehouse' requirement within Salesforce when dealing with millions of records?

An architect is designing a schema to store product information. Each product has many versions, and each version has many components. What is the most efficient way to model this relationship?

When designing a custom Data Model, when should an architect choose a 'Lookup' relationship over a 'Master-Detail' relationship?

A healthcare company needs to store patient consent records that must be retained for ten years and are rarely accessed after the first year. The records include sensitive data and must be queryable by compliance officers using standard reports. Which storage strategy should the architect recommend?

Refer to the exhibit. The architect observes this error during bulk Opportunity updates. Which action resolves the issue while adhering to best practices?

Refer to the exhibit. The query is part of a bulk apex process. What is the potential risk with this query in a large-scale data environment?

Universal Containers notices severe locking issues and transaction failures when updating a parent Account object that has over 15,000 child records in a master-detail relationship. What is the fundamental architectural cause of this behavior?

Refer to the exhibit. The Data Architect is tasked with ensuring that order status options are limited based on the geographic region of the order. Which feature should be used to implement this?

Universal Containers maintains a custom object, Shipment__c, that has a Master-Detail relationship to Account and a Lookup to Carrier__c. A Data Architect is asked to design a new object, Shipment_Line__c, that must always belong to exactly one Shipment__c, must inherit Shipment__c's sharing rules, and must not be independently owned by a different user. Which relationship type should be used between Shipment_Line__c and Shipment__c?

A Data Architect is designing a high-volume data model where an Account has millions of Child records. Which TWO strategies should be implemented to ensure optimal performance and avoid data skew?

An organization has 50 million records in a custom object. They need to report on historical snapshots weekly. What is the best strategy to manage storage while keeping data available?

An architect is designing a schema for a logistics org where each 'Shipment__c' record can be linked to many 'Carrier__c' records, and each Carrier can serve many Shipments. The business also needs to store the negotiated 'Rate__c' and 'Effective_Date__c' specific to each Shipment-Carrier pairing, and report on those values. Which data modeling approach should the architect use?

A healthcare provider's Salesforce org uses a custom object 'Care_Plan__c' with a Lookup to 'Patient__c'. Compliance now requires that a Care Plan cannot exist without a Patient, that the Patient record cannot be deleted while Care Plans reference it, and that each Care Plan should inherit the Patient's sharing settings. The team also needs a roll-up summary of active Care Plans on the Patient record. Which relationship change should the architect recommend?

A Salesforce org has a custom object Invoice__c with a Lookup relationship to Account. The business now requires that every Invoice__c record must always have a valid Account, and deleting an Account must also delete its related invoices. The architect decides to change the relationship type to Master-Detail. Which statement describes a valid consequence of this change?

A Salesforce architect is designing a data model for a recruiting application. A Candidate can apply to many Positions, and a Position can receive applications from many Candidates. For each application, the company needs to track the Application Date and the Source (for example, LinkedIn or Referral). Which data modeling approach should the architect use?

Refer to the exhibit. An architect needs to track changes to the 'Status__c' field for auditing purposes. Based on the configuration provided, what is the best way to report on the duration a record spent in each status?

Which field type should be used for a primary key when integrating data from an external ERP system into Salesforce?

A Salesforce architect is designing a data model for a custom object 'Invoice__c' that will have a master-detail relationship to 'Account'. The architect needs to ensure that the data model supports efficient reporting and aggregation. Which two considerations are critical when designing this master-detail relationship? (Choose two.)

A large university is modeling academic records in Salesforce. Each Course can be taught by multiple Instructors, and each Instructor can teach multiple Courses. The university must report on the aggregate number of Courses each Instructor is teaching per semester and enforce that an Instructor cannot be assigned to the same Course twice within the same semester. Which data modeling approach should the architect implement?

A company requires a data model to track 'Training Sessions' (which have many attendees) and 'Employees' (who attend many sessions). Which relationship is required to model this correctly?

Which indexing strategy is best to improve performance for queries on a field used in multiple filters?

Universal Containers requires a many-to-many relationship between Projects and Consultants. They need to track specific attributes like 'Hourly Rate' and 'Assigned Role' on the relationship itself. Which approach should a Data Architect recommend?

A Salesforce architect is designing a data model for a custom object 'Case__c' that needs to track the priority of each case. The priority values must be limited to a predefined list: Low, Medium, High, and Critical. Users should be able to select only one value, and the values should be easily reportable. Which field type should be used?

A financial services org needs to record every change to the 'Credit_Score__c' field on Contact for regulatory audit, including the prior value, the new value, the user, and the timestamp. The data volume is moderate and auditors query the history by Contact. Which approach should the architect recommend?

An architect is modeling a case management system where a single Case may be linked to many Product records, and each Product may appear on many Cases. The business needs to report on the quantity and discount negotiated for each Case-Product pairing. Which design should the architect implement?

A Salesforce architect is designing a data model for a custom object that must support a strict one-to-many relationship where each child record must have a parent, and the parent's sharing settings should automatically control child record access. The architect also needs to ensure that deleting a parent cascades to delete all related children. Which relationship type should be used?