Data-Architect Practice Test

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.

NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error. Which 3 options should help improve the dashboard performance? Choose 3 answers:

A.

Use selective queries to reduce the amount of data being returned.

B.

De-normalize the data by reducing the number of joins.

C.

Remove widgets from the dashboard to reduce the number of graphics loaded.

D.

Run the dashboard for CEO and send it via email.

E.

Reduce the amount of data queried by archiving unused opportunity records.