A large retail company has recently chosen SF as its CRM solution. They have the following record counts:
2500000 accounts
25000000 contacts
When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views.
What should a data architect do to solve the performance issue?

• A.Add custom indexes on frequently searched account and contact objects fields
• B.Create a skinny table to represent account and contact objects.
• C.Load only the data that the users is permitted to access
• D.Limit data loading to the 2000 most recently created records.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system.
Which solution should a data architect recommend to remediate the duplication issue?

• A.Utilize a data warehouse as the system of truth
• B.Implement duplicate rules
• C.Extract the data using data loader and use excel to merge the duplicate records
• D.Develop an ETL process that utilizers the merge API to merge the duplicate records

Comment: *

Name: *

Email: *

Verification: *

Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:
1. High Value
2. Medium Value
3. Low Value
Which strategy should a data architect recommend to configure customer type?

• A.Single-select restricted picklist with defined choices.
• B.Create a validation rule to limit entry to defined choices.
• C.Lookup to a custom object with defined choices.
• D.Provide help text to guide users with defined choices.

Comment: *

Name: *

Email: *

Verification: *

Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.
What should a data architect recommend to increase Salesforce adoption?

• A.Define a standard mapping and train sales users to import opportunity data.
• B.Use the Excel connector to Salesforce to sync data from individual Excel files.
• C.Load data in external database and provide access to database to sales users.
• D.Create a chatter group and upload all Excel files to the group.

Comment: *

Name: *

Email: *

Verification: *

Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.
Which three recommendations should a data architect make is order to reduce the number of records from the org?
Choose 3 answers

• A.Use hard delete in Bulk API to permanently delete records from Salesforce.
• B.Use hard delete in batch Apex to permanently delete records from Salesforce.
• C.Identify records in objects that have not been modified or used In last 3 years.
• D.Use Rest API to permanently delete records from the Salesforce org.
• E.Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

Comment: *

Name: *

Email: *

Verification: *