Data-Architect Practice Test

US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) – based support. Which license type will US users need to fulfil US’s requirements?

A.

Lightning platform starter license.

B.

Service cloud license.

C.

Salesforce license.

D.

Sales cloud license

Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following:
1. Customers are Person Accounts for their retail business.
2. Customers are represented as Contacts for their commercial business.
3. Employees are maintained as Users.
4. Prospects are maintained as Leads.
NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads. Which option should the data architect recommend NTO to satisfy this requirement?

A.

Create custom fields for contact preferences in Lead, Person Account, and Users objects.

B.

Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users.

C.

Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users.

D.

Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

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.