Members of DreamHouse Realty sales team are reporting that searches are yielding too many irrelevant, outdated records. Management requires that data for historical reporting. DreamHouse Realty has enough data storage.
In this situation, which strategy should a data architect use to ensure a better user experience for the Sales Reps?

• A.Hide old data from Sales Reps by setting data access to Private.
• B.Archive and purge old data from Salesforce on a monthly basis.
• C.Use Batch Apex to archive old data on a rolling nightly basis.
• D.Hide old data from Sales Reps by creating a Permission Set.

Comment: *

Name: *

Email: *

Verification: *

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.
Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

• A.Limit assigning one user 10000 records ownership.
• B.Limit associating 10000 records looking up to same records.
• C.Assign 10000 opportunities to one account.
• D.Limit associating 10000 opportunities to one account.
• E.Use picklist fields rather than lookup to custom object.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

• A.Set Customer-Reference_c as an External ID (non-unique).
• B.Implement an archiving process for shipment records created after three years.
• C.Implement an archiving process for shipment records created after five years.
• D.Set Customer-Reference_c as an External ID (unique).

Comment: *

Name: *

Email: *

Verification: *

UC is migrating data from legacy system to SF. UC would like to preserve the following information on records being migrated:
Date time stamps for created date and last modified date.
Ownership of records belonging to inactive users being migrated to Salesforce.
Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

• A.Enable modify all and view all permission.
• B.Log a case with SF to update these fields
• C.Enable update records with Inactive Owners Permission
• D.Enable Set Audit fields upon Record Creation Permission

Comment: *

Name: *

Email: *

Verification: *

Which three characteristics of a Skinny table help improve report and query performance?

• A.Skinny tables do not include records that are available in the recycle bin.
• B.Skinny tables provide a view across multiple objects for easy access to combined data.
• C.Skinny tables can be used to create custom indexes on multi-select picklist fields.
• D.Skinny tables can contain frequently used fields and thereby help avoid joins.
• E.Skinny tables are kept in sync with changes to data in the source tables.

Comment: *

Name: *

Email: *

Verification: *