Salesforce Certified Platform Data Architect (Plat-Arch-201): DATA-ARCHITECT

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)

In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?

A. Salesforce allows up to four objects in a single report type.

B. Salesforce does not support Orders or Order Line Items.

C. A report cannot contain data from Accounts and Contacts.

D. Custom report types cannot contain Opportunity data.

Universal Containers has a custom object with millions of rows of data.

When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

A. Using leading % wildcards.

B. Using trailing % wildcards.

C. Performing large loads and deletions.

D. Using NOT and != operators.

E. Using a custom index on a deterministic formula field.