Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.
Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

• A.Utilize a Validation Rule with a CONTAINS operator on address fields.
• B.Utilize a Validation Rule with a REGEX operator on Postal Code.
• C.Change each address field to required on the Page Layout.
• D.Write an Apex Trigger to require all fields to be populated.

Comment: *

Name: *

Email: *

Verification: *

A company has 12 million records, and a nightly integration queries these records.
Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

• A.Make sure the query doesn't contain NULL in any filter criteria.
• B.Create a formula field instead of having multiple filter criteria.
• C.Create custom indexes on the fields used in the filter criteria.
• D.Modify the integration users' profile to have View All Data.

Comment: *

Name: *

Email: *

Verification: *

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.
Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

• A.Use picklist fields rather than lookup to custom object.
• B.Limit assigning one user 10000 records ownership.
• C.Assign 10000 opportunities to one account.
• D.Limit associating 10000 opportunities to one account.
• E.Limit associating 10000 records looking up to same records.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) wants to ensure their data on 100,000 Accounts pertaining mostly to US-based companies is enriched and cleansed on an ongoing basis. UC is looking for a solution that allows easy monitoring of key data quality metrics. What should be the recommended solution to meet this requirement?

• A.Use a declarative approach by installing and configuring Data.com Clean to monitor Account data quality.
• B.Implement Batch Apex that calls out a third-party data quality API in order to monitor Account data quality.
• C.Use declarative approach by installing and configuring Data.com Prospector to monitor Account data quality.
• D.Implement an Apex Trigger on Account that queries a third-party data quality API to monitor Account data quality.

Comment: *

Name: *

Email: *

Verification: *

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: *