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

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records.
What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?

• A.Load all individual consumers as Account records and avoid using the Contact object.
• B.Create one Account and load individual consumers as Contacts linked to that one Account.
• C.Create a Custom Object Individual Consumer c to load all individual consumers.
• D.Load one Account record and one Contact record for each individual consumer.

Comment: *

Name: *

Email: *

Verification: *

Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target).
Company S has 6 million Case records.
An Architect has been tasked with optimizing the data load time.
What should the Architect consider to achieve this goal?

• A.Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.
• B.Load the data in multiple sets using Bulk API parallel processes.
• C.Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.
• D.Directly leverage Salesforce-to-Salesforce functionality to load Case data.

Comment: *

Name: *

Email: *

Verification: *

United Containers (UC) has released a new disaster recovery (DR) policy that states that cloud solutions need a business continuity plan in place separate from the cloud provider's built-in data recovery solution.
Which solution should a data architect use to comply with the DR policy?

• A.Utilize an ETL tool to migrate data to an on-premise archive solution
• B.Leverage Salesforce weekly exports, and store data in flat files on a protected system
• C.Leverage a third-party tool that extracts Salesforce data/metadata, and stores the information in an external protected system
• D.Write a custom batch job to extract data changes nightly, and store on an external protected system

Comment: *

Name: *

Email: *

Verification: *

UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:
1. Contacts will be stored in the standard contact object.
2. Conferences will be stored in a custom conference__c object.
3. Each contact may attend multiple conferences and each conference may be related to multiple contacts.
How should a data architect model the relationship between the contact and conference objects?

• A.Implement a Contact Conference junction object with master detail relationship to both contact and conference__c.
• B.Create a lookup relationship field on contact object.
• C.Create a master detail relationship field on the Conference object.
• D.Create a master detail relationship field on the Contact object.

Comment: *

Name: *

Email: *

Verification: *