NTO has multiple systems across its enterprise landscape including salesforce, with disparate version the customer records.
In salesforce, the customer is represented by the contact object.
NTO utilizes an MDM solution with these attributes:
1. The MDM solution keeps track of customer master with a master key.
2. The master key is a map to the record ID's from each external system that customer data is stored within.
3. The MDM solution provides de-duplication features, so it acts as the single source of truth.
How should a data architect implement the storage of master key within salesforce?

• A.Create a custom object to store the master key with a lookup field to contact.
• B.Store the master key on the contact object as an external ID (Field for referential imports)
• C.Create an external object to store the master key with a lookup field to contact.
• D.Store the master key in Heroku postgres and use Heroku connect for synchronization.

Comment: *

Name: *

Email: *

Verification: *

Cloud Kicks has the following requirements:
- They want to automatically archive all inactive Account data that is older than 3 years.
- The information does not need to remain accessible within the application.
Which two approaches should the Architect recommend to meet this requirement? (Choose two.)

• A.Export the data by using the Force.com Workbench.
• B.Schedule jobs to export and delete using the Data Loader.
• C.Schedule jobs to export and delete using an ETL tool.
• D.Schedule a weekly export file from the Salesforce UI.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement?
Choose 2 answers

• A.Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
• B.Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
• C.Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
• D.Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

Comment: *

Name: *

Email: *

Verification: *

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 an app from the AppExchange to create data -quality dashboards.
• C.Utilize a 3rd -party solution from the AppExchange for data uploads.
• D.Use Apex to validate the format of phone numbers and postal codes.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers developers have created a new Lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.
What tool should a data architect use to identify why the query is taking too long?

• A.Enable and use the Query Plan tool in the developer console
• B.Use Splunk to query the system logs looking for transaction time and CPU usage
• C.Use Salesforce's query optimizer to analyze the query in the developer console
• D.Open a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time

Comment: *

Name: *

Email: *

Verification: *