Free Data-Architect Exam Braindumps (page: 15)

Page 14 of 65

The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce.
What three things should the architect consider to optimize performance of the data migration? Choose 3 answers

  1. Review the time zones of the User loading the data.
  2. Remove custom indexes on the data being loaded.
  3. Determine if the legacy system is still in use.
  4. Defer sharing calculations of the Salesforce Org.
  5. Deactivate approval processes and workflow rules.

Answer(s): B,D,E



Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records.
What should the architect recommend to reduce data load processing time?

  1. Load Contact records together using the Streaming API via the Upsert operation.
  2. Delete all existing records, and then load all records together via the Insert operation.
  3. Load all records via the Upsert operation to determine new records vs. existing records.
  4. Load new records via the Insert operation and existing records via the Update operation.

Answer(s): D



An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode.
What should be considered when loading the Opportunity records?

  1. Create indexes on Opportunity object text fields.
  2. Group batches by the AccountId field.
  3. Sort batches by Name field values.
  4. Order batches by Auto -number field.

Answer(s): D



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?

  1. Tooling API
  2. PK Chunking
  3. Metadata API
  4. Streaming API

Answer(s): B






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

Data-Architect Discussions & Posts