Free Data-Architect Exam Braindumps
Salesforce Certified Data Architect Questions 96–100 (page: 21)

Updated On: 9-Feb-2026

Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities.
When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year.
What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

  1. Implement an archiving process for shipment records created after five years.
  2. Implement an archiving process for shipment records created after three years.
  3. Set Customer-Reference_c as an External ID (non-unique).
  4. Set Customer-Reference_c as an External ID (unique).

Answer(s): D



Universal Containers has a custom object with millions of rows of data.

When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

  1. Using leading % wildcards.
  2. Using trailing % wildcards.
  3. Performing large loads and deletions.
  4. Using NOT and != operators.
  5. Using a custom index on a deterministic formula field.

Answer(s): A,D,E



Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

  1. Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
  2. Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.
  3. Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.
  4. Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.

Answer(s): B



UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items.
What two steps can you take to help correct this? Choose two answers.

  1. Export in multiple batches
  2. Export Bulk API in parallel mode
  3. Use PK Chunking
  4. Limit Batch to 10K records

Answer(s): A,C



Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce.
What approach should be suggested to address this requirement?

  1. Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.
  2. Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.
  3. Store all data in shadow custom objects on any updates and deletes, and extract them as needed .
  4. Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

Answer(s): D



Viewing page 21 of 53
Viewing questions 101 - 105 out of 257 questions


Post your Comments and Discuss Salesforce Data-Architect exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!