Free Data-Architect Exam Braindumps
Salesforce Certified Data Architect Questions 81–85 (page: 18)

Updated On: 9-Feb-2026

Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand.
What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

  1. Implement data archiving for old Shipment records.
  2. Contact Salesforce to create Skinny tables on Shipment.
  3. Configure shipment OWD to Public Read/Write.
  4. Contact Salesforce to enable Defer Sharing Rules

Answer(s): D



A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object.
What is the recommended way to avoid locking issues during import?

  1. Import Account records first followed by order records after sorting order by OrderID.
  2. Import Account records first followed by order records after sorting orders by AccountID.
  3. Change the relationship to Lookup and update the relationship to master-detail after import.
  4. Import Order records and Account records separately and populate AccountID in orders using batch Apex.

Answer(s): B



Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move.
What is a recommended solution for building data exploration dashboards in Salesforce?

  1. Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.
  2. Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.
  3. Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.
  4. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

Answer(s): D



DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year.

A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.

What are two important considerations for the Data Architect in this scenario? (Choose two.)

  1. Standard list view in-line editing.
  2. Limitations on Org data storage.
  3. Bulk API limitations on picklist fields.
  4. Limitations on master-detail relationships.

Answer(s): B,C



Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped.

First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports.

What is the recommended solution for the Cloud Kicks Data Architect to address the requirements?

  1. Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku's Postgres database.
  2. Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku's Postgres database.
  3. Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.
  4. Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.

Answer(s): C



Viewing page 18 of 53
Viewing questions 86 - 90 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!