Free Access Salesforce.Data-Architect.v2025-09-05.q216 Practice Test (Page 26)

Question 121

Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?

A.Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.

B.Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.

C.After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.

D.Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.

Question 122

To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

A.Errors with duplicate external Id values within the same CSV file.

B.Errors when a duplicate Contact name is found cause upsert to fail.

C.Errors with using the wrong external Id will cause the load to fail.

D.Errors with records being updated and inserted in the same CSV file.

Question 123

Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?

A.Define external IDs for an object, migrate second database to first database, and load into Salesforce.

B.Define duplicate rules in Salesforce, and load data into Salesforce from both databases.

C.Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.

D.Define external IDs for an object, Insert data from one database, and use upsert for a second database

Question 124

Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintain two years of data in Saleforce and archive older data out of Salesforce.
Which solution should a data architect recommend as an archiving solution?

A.Build a batch job to move all restore off platform, and delete old records from Salesforce.

B.Build a batch join move all records off platform, and delete all records from Salesforce.

C.Use a third-party backup solution to backup all data off platform.

D.Build a batch join to move two-year-old records off platform, and delete records from Salesforce.

Question 125

DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out.
What should be considered to address this issue?

A.Tooling API

B.PK Chunking

C.Metadata API

D.Streaming API

Other Version: 586Salesforce.Data-Architect.v2026-09-29.q136; 2670Salesforce.Data-Architect.v2023-11-08.q173; 2047Salesforce.Data-Architect.v2023-02-06.q72

Latest Upload: 114WGU.Health-Fitness-and-Wellness.v2026-10-21.q14; 129ISACA.COBIT-Design-and-Implementation.v2026-10-21.q57; 128NACE.NACE-CIP2-001.v2026-10-21.q36; 164Cisco.400-007.v2026-10-21.q176; 139F5.301a.v2026-10-21.q97; 145Oracle.1z0-1195-26.v2026-10-19.q18; 148Salesforce.Salesforce-Slack-Administrator.v2026-10-19.q126; 187Salesforce.JS-Dev-101.v2026-10-19.q106; 234PaloAltoNetworks.SSE-Engineer.v2026-10-17.q44; 404Cisco.300-420.v2026-10-17.q324

Question 121

Question 122

Question 123

Question 124

Question 125

Download PDF File