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.

Load only the data that the users is permitted to access

B.

Add custom indexes on frequently searched account and contact objects fields

C.

Limit data loading to the 2000 most recently created records.

D.

Create a skinny table to represent account and contact objects.

Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps. What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

A.

Run a report which shows the last time the key fields were updated.

B.

Run one report per key field, grouped by that field, to understand its data variability.

C.

Run a report that shows the percentage of blanks for the important fields.

D.

Run a process that can fill in default values for blank fields.

Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?

A.

Allow users to import their data using the Salesforce Import tools.

B.

Utilize a 3rd -party solution from the AppExchange for data uploads.

C.

Utilize an app from the AppExchange to create data -quality dashboards.

D.

Use Apex to validate the format of phone numbers and postal codes.

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

A.

Use SOQL queries without WHERE conditions.

B.

Work with Salesforce Support to enable Skinny Tables.

C.

Reduce the number of triggers on Order _c object.

D.

Make the queries more selective using indexed fields.

Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updates by users. A majority of the automation tool within UC’’ org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend. What should a data architect do to mitigate any unwanted results during the import?

A.

Ensure validation rules, triggers and other automation tools are disabled.

B.

Ensure duplication and matching rules and defined.

C.

Import the data in smaller batches over a 24-hour period.

D.

Bulkily the trigger to handle import leads.

Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

A.

Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.

B.

Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.

C.

Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.

D.

Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.

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.

Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:
- Accounts
- Contacts
- Opportunities
- Orders
- Order Line Items
Which issue will an architect have when implementing this in Salesforce?

A.

Custom report types CANNOT contain Opportunity data.

B.

Salesforce does NOT support Orders or Order Line Items.

C.

Salesforce does NOT allow more than four objects in a single report type.

D.

A report CANNOT contain data from Accounts and Contacts.

Universal Containers (UC) plans to implement consent management for its customers to be compliant with General Data Protection Regulation (GDPR). UC has the following requirements:
UC uses Person Accounts and Contacts in Salesforce for its customers.
Data Protection and Privacy is enabled in Salesforce.
Consent should be maintained in both these objects.
UC plans to verify the consent provided by customers before contacting them through email or phone.
Which option should the data architect recommend to implement these requirements?

A.

Configure custom fields in Person Account and Contact to store consent provided by customers, and validate consent against the fields.

B.

Build Custom object to store consent information in Person Account and Contact, validate against this object before contacting customers.

C.

Use the Consent Management Feature to validate consent provide under the person Account and Contact that is provided by the customer.

D.

Delete contact information from customers who have declined consent to be contacted.

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.

Use the Excel connector to Salesforce to sync data from individual Excel files.

B.

Define a standard mapping and train sales users to import opportunity data.

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.

NTO has decided that it is going to build a channel sales portal with the following requirements:
1.External resellers are able to authenticate to the portal with a login.
2.Lead data, opportunity data and order data are available to authenticated users.
3.Authenticated users many need to run reports and dashboards.
4.There is no need for more than 10 custom objects or additional file storage.
Which community cloud license type should a data architect recommend to meet the portal requirements?

A.

Customer community.

B.

Lightning external apps starter.

C.

Customer community plus.

D.

Partner community.

A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system:
1. Salesforce CRM
3. Customer Master Data management (MDM)
4. Contract Management system
5. Marketing solution
What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

A.

Store the salesforce id in all the solutions to identify the customer.

B.

Create a custom object that will serve as a cross reference for the customer id.

C.

Create a customer data base and use this id in all systems.

D.

Create a custom field as external id to maintain the customer Id from the MDM solution.