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

Comment: *

Name: *

Email: *

Verification: *

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Salesforce is implemented as follows:
1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update Opportunity Amount field on opportunities on a daily basis.
3. PPS is the trusted source within NTO for Opportunity Amount.
4. NTO uses Opportunity Forecast for its sales planning and management.
Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overwriting issue?

• A.Change Opportunity Amount field access to Read Only for sales users using field-level security.
• B.Change PPS integration to update only Opportunity Amount field when the value is null.
• C.Create a custom field for Opportunity amount that PPS updates separating the field sales user updates.
• D.Create a custom field for Opportunity Amount that sales users update separating the field that PPS updates.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi
-system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers

• A.AppExchange Apps
• B.Setup Audit Trails
• C.Wave Analytics
• D.Weekly Snapshots

Comment: *

Name: *

Email: *

Verification: *

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.
What should a data architect recommend in order to get around the time out issue?

• A.Ask SF support to increase the query timeout value.
• B.Use ETL tool for extraction of records.
• C.Use a custom auto number and formula field and use that to chunk records while extracting data.
• D.The REST API to extract data as it automatically chunks records by 200.

Comment: *

Name: *

Email: *

Verification: *

Which three options can prevent your SOQL queries from being selective?

• A.Using trailing % wildcards.
• B.Using NOT and != operators.
• C.Using a custom index on a deterministic formula field.
• D.Using leading % wildcards.
• E.Performing large loads and deletions.

Comment: *

Name: *

Email: *

Verification: *