In a Salesforce org used to manage Contacts, what two options should be considered to maintain data quality?
Choose 2 answers

• A.Use Salesforce duplicate management.
• B.Use the private sharing model.
• C.Use validation rules on new record create and edit.
• D.Use workflow to delete duplicate records.

Comment: *

Name: *

Email: *

Verification: *

A business that works directly with individual consumers (B2C) currently has a home-grown CRM system, but they are moving to Salesforce. The business has 1.2 million consumer records and wants assistance with achieving optimal use of Salesforce functionality while also avoiding data loading issues.
What should an Architect recommend?

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

Comment: *

Name: *

Email: *

Verification: *

Which three options can prevent your SOQL queries from being selective?

• A.Using NOT and != operators.
• B.Performing large loads and deletions.
• C.Using trailing % wildcards.
• D.Using a custom index on a deterministic formula field.
• E.Using leading % wildcards.

Comment: *

Name: *

Email: *

Verification: *

DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

• A.Calculate summary values instead of Roll-Up by using workflow.
• B.Load all data after deferring sharing calculations.
• C.Load all data using external IDs to link to parent records.
• D.Calculate summary values instead of Roll-Up by using triggers.

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *