Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:

1. A record is created in Project__ c and used to track the project through completion.

2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project.

3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c

record.

4. Managers must see total hours volunteered while viewing the Project__ c record.

Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?

A.

Lookup Field on Project_c to VTOTime_c displaying a list of VTOTime__c in

a related list.

B.

Lookup field on VTOTime_c to Project_c with formula filed on Project__ c

showing Sum of hours from VTOTime__c records.

C.

Master Detail Field on VTOTime_ c to Project_c with rollup summary field on Project __c showing sum of hours from VTOTime_c records.

D.

Master Detail field on Project _c to VTOTime _c showing a list of VTOTime_c Records in a related list.

Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

A.

Reduce data storage by purging old data.

B.

Implement an AppExchange package.

C.

Review projected data storage needs.

D.

Schedule a weekly export file.

UC is preparing to implement sales cloud and would like to its users to have read only access to an account record if they have access to its child opportunity record. How would a data architect implement this sharing requirement between objects?

A.

Create a criteria-based sharing rule.

B.

Implicit sharing will automatically handle with standard functionality.

C.

Add appropriate users to the account team.

D.

Create an owner-based sharing rule.

What makes Skinny tables fast? Choose three answers.

A.

They do not include soft-deleted records

B.

They avoid resource intensive joins

C.

Their tables are kept in sync with their source tables when the source tables are modified

D.

They can contain fields from other objects

E.

They support up to a max of 100 of columns

A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:

1.Point of sales system: All purchases for a customer.

2.Salesforce: All customer service activity and sales activity for a customer.

3.Mobile app: All bookings, preferences and browser activity for a customer.

4.Marketing: All email, SMS and social campaigns for a customer.

Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.

What strategy should the data architect implement to satisfy this requirement?

A.

Explore external data sources in salesforce to build 360 view of customer.

B.

Use a customer data mart to view the 360 view of customer.

C.

Migrate customer activities from all 4 systems into salesforce.

D.

Periodically upload summary information in salesforce to build 360 view.

A large insurance provider is looking to implement Salesforce. The following exist.

1. Multiple channel for lead acquisition

2. Duplication leads across channels

3. Poor customer experience and higher costs

On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

A.

Build process is manually search and merge duplicates.

B.

Standard lead information across all channels.

C.

Build a custom solution to identify and merge duplicate leads.

D.

Implement third-party solution to clean and event lead data.

E.

Implement de-duplication strategy to prevent duplicate leads

Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

A.

Create a "before delete" trigger to check if the current user is not the owner.

B.

Set the Sharing settings as Public Read Only for the Contact object.

C.

Set the profile of the users to remove delete permission from the Contact object.

D.

Create a validation rule on the Contact object to check if the current user is not the owner.

A company has 12 million records, and a nightly integration queries these records.

Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

A.

Make sure the query doesn't contain NULL in any filter criteria.

B.

Create a formula field instead of having multiple filter criteria.

C.

Create custom indexes on the fields used in the filter criteria.

D.

Modify the integration users' profile to have View All Data.

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.

Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

A.

Use a workflow to check and prevent duplicates.

B.

Clean data before importing to Salesforce.

C.

Use Salesforce matching and duplicate rules.

D.

Import the data concurrently.