Practice Data-Architect Exam Online

Question 1

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 with records being updated and inserted in the same CSV file.

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

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

Answer: A

Question 2

Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be

creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of

these records is controlled by a 50 owner and criteria-based sharing rules.

Get Cloudy Consulting needs to minimize data loading time during this migration to a new

organization.

Which two approaches will accomplish this goal? (Choose two.)

A : Create the users, upload all data, and then deploy the sharing rules.

B : Contact Salesforce to activate indexing before uploading the data.

C : First, load all account records, and then load all user records.

D : Defer sharing calculations until the data has finished uploading.

Answer: A,D

Question 3

Northern Trail Outfitters needs to implement an archive solution for Salesforce dat

a. This archive solution needs to help NTO do the following:

1. Remove outdated Information not required on a day-to-day basis.

2. Improve Salesforce performance.

Which solution should be used to meet these requirements?

A : Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis,

B : Identify a location to store archived data, and move data to the location using a time-based workflow.

C : Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.

D : Create a full copy sandbox, and use it as a source for retaining archived data.

Answer: A

Question 4

Your organization is building a complex data warehouse, and you need to capture and manage business and technical metadata to maintain data lineage. What would be your approach to capture and manage this metadata?

A : Implement a manual documentation approach and maintain metadata in spreadsheets

B : Use Salesforce's Custom Metadata Types

C : Use Salesforce's Data Catalog

D : Store metadata as comments in the Apex code

Answer: C

Question 5

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

A : Review the time zones of the User loading the data

B : Remove custom indexes on the data being loaded.

C : Determine if the legacy system is still in use.

D : Defer sharing calculations of the Salesforce Org.

E : Deactivate approval processes and workflow rules

Answer: A,B,D

Name:	Salesforce Certified Data Architect (WI24)
Exam Code:	Data-Architect
Certification:	Salesforce Architect
Vendor:	Salesforce
Total Questions:	640
Last Updated:	Apr 22, 2024

Salesforce Data-Architect