Universal Containers keeps its Account data in Salesforce and its Invoice data in a third - party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place.
What two approaches should an architect suggest for achieving this solution? Choose 2 answers

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?

UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.
Which 3 recommendations should a data architect provide to prevent ownership skew?
Choose 3 answers:

Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

UC is implementing sales cloud for patient management and would like to encrypt sensitive patient records being stored in files.
Which solution should a data architect recommend to solve this requirement?