Data-Architect Practice Test

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.