Data Architect V1

UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need to be synchronized with salesforce so that service agents are able to support customers directly within the service console. The remaining non- synchronized set of data will need...

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...

Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answersA . Create a custom object to store a copy of the record when changed. B. Create...

A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?A . Create formula fields with geolocation function for this requirement. B. Create custom fields to maintain latitude and longitude information C. Create a geolocation...

Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record. What should a data architect recommend to guarantee...

Cloud Kicks has the following requirements: - Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS). - A Salesforce administrator must be able tocustomize which fields will be sent to the external system without changing code. What are two...

Universal Containers (UC) is transitioning from Classic to Lightning Experience. What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?A . Add Notes and Attachments Related List to page Layout in Lighting Experience. B. Manually upload Notes in Lighting Experience. C....

A customer is facing locking issued when importing large data volumes of order records that are children in amaster-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?A . Import Account records first followed by order records after sorting order by OrderID. B....

Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?A . Missing phone number on the Contact record. B. Customer...

UC has millions of case records with case history and SLA data. UC’s compliance team would like historical cases to be accessible for 10 years for Audit purpose. What solution should a data architect recommend?A . Archive Case data using Salesforce Archiving process B. Purchase more data storage to support...