CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Salesforce
  5. Certified Data Architect

Free Certified Data Architect Exam Braindumps (page: 5)

Page 5 of 56
PDF with 221 Questions

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

  1. Errors with duplicate external Id values within the same CSV file.
  2. Errors with records being updated and inserted in the same CSV file.
  3. Errors when a duplicate Contact name is found cause upsert to fail.
  4. Errors with using the wrong external Id will cause the load to fail.

Answer(s): A



UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need to be synchronized with salesforce so that service agents are able to support customers directly within the service console. The remaining non- synchronized set of data will need to be accessed by salesforce at any point in time, but UC management is concerned about storage limitations.

What should a data architect recommend to meet these requirements with minimal effort?

  1. Virtualize the remaining set of data with salesforce connect and external objects.
  2. Use Heroku connect to bi-directional, sync all data between systems.
  3. As needed, make call outs into Heroku postgres and persist the data in salesforce.
  4. Migrate the data to big objects and leverage async SOQL with custom objects.

Answer(s): A



UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.

What should a data architect recommend to ensure dataquality is maintained in salesforce.

  1. Activate validation rules once the leads are loaded into salesforce to maintain quality.
  2. Allow validation rules to be activated during the load of leads into salesforce.
  3. Develop custom APEX batch process to improve quality once the load is completed.
  4. Ensure the lead data is preprocessed for quality before loading into salesforce.

Answer(s): C



A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items.
What is the recommended solution?

  1. Query only indexed ID field values on the imported order to import related order lines.
  2. Leverage an External ID from source system orders to import related order lines.
  3. Leverage Batch Apex to update order ID on related order lines after import.
  4. Leverage a sequence of numbers on the imported orders to import related order lines.

Answer(s): B



Page 5 of 56



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

Kaps commented on August 17, 2024
Excellent for practice !!
JAPAN
upvote

Deepak commented on May 17, 2024
Best Practice Platform !!!
INDIA
upvote