Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics. What solution addresses this requirement?

A.

Use third-party AppExchange tools to monitor and measure data quality.

B.

Generate reports to view the quality of sample data.

C.

Use custom objects and fields to calculate data quality.

D.

Export the data to an enterprise data warehouse and use BI tools for data quality.

Universal Containers (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place. Once the data is brought together into a global view, management would like to use advanced Al-driven analytics on the dataset. Which tool should a data architect recommend to accomplish this reporting requirement?

A.

Run standard reports and dashboards.

B.

Install a third-party AppExchange tool for multi-org reporting.

C.

Use Einstein Analytics for multi-org.

D.

Write a Python script to aggregate and visualize the data.

To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

A.

Errors with duplicate external Id values within the same CSV file.

B.

Errors with records being updated and inserted in the same CSV file.

C.

Errors when a duplicate Contact name is found cause upsert to fail.

D.

Errors with using the wrong external Id will cause the load to fail.

Universal Containers (UC) manages Vehicle and Service History in Salesforce. Vehicle (Vehicle__ c) and Service History (Service-History__ c) are both custom objects related through a lookup relationship. Every week a batch synchronization process updates the Vehicle and Service History records in Salesforce. UC has two hours of migration window every week and is facing locking issues as part of the data migration process. What should a data architect recommend to avoid locking issues without affecting performance of data migration?

A.

Use Bulk API parallel mode for data migration

B.

Use Bulk API serial mode for data migration

C.

Insert the order in another custom object and use Batch Apex to move the records to Service_ Order__ c object.

D.

Change the lookup configuration to "Clear the value of this field" when lookup record is deleted.

Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future.

A.

Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.

B.

Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

C.

Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

D.

Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.

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.

Universal Containers (UC) is concerned about the accuracy of their Customer information in Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce. What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

A.

Extract the Salesforce data into Excel and manually compare this against the trusted source.

B.

Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.

C.

Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.

D.

Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

Universal Containers (UC) uses the following Salesforce products:
Sales Cloud for customer management.
Marketing Cloud for marketing.
Einstein Analytics for business reporting.
UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process. What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

A.

Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ;

B.

Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.

C.

Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.

D.

Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.

NTO has a loyalty program to reward repeat customers. The following conditions exists:
1.Reward levels are earned based on the amount spent during the previous 12 months.
2.The program will track every item a customer has bought and grant them points for discount.
3.The program generates 100 million records each month.
NTO customer support would like to see a summary of a customer’s recent transaction and reward level(s) they have attained.
Which solution should the data architect use to provide the information within the salesforce for the customer support agents?

A.

Create a custom object in salesforce to capture and store all reward program. Populate nightly from the point-of-scale system, and present on the customer record.

B.

Capture the reward program data in an external data store and present the 12 months trailing summary in salesforce using salesforce connect and then external object.

C.

Provide a button so that the agent can quickly open the point of sales system displaying the customer history.

D.

Create a custom big object to capture the reward program data and display it on the contact record and update nightly from the point-of-scale system.

Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution. What is a correct technique UC should use to solve the data inconsistency?

A.

Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.

B.

Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

C.

Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.

D.

Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.