Salesforce Certified Data Architect: DATA-ARCHITECT

Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.

Which two techniques should be used to achieve this goal? (Choose two.)

A. Integrate Salesforce with the ERP environment.

B. Utilize workbench to update files within systems.

C. Utilize an MDM strategy to outline a single source of truth.

D. Build synchronization reports and dashboards.

Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce. What are two automated approaches to fulfill this goal? (Choose two.)

A. Third-party Integration Tool (ETL)

B. Schedulable Batch Apex

C. Third-party Business Intelligence system

D. Apex Triggers

Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.

Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

A. Number of queries running at a time.

B. Number of joins used in report query.

C. Number of records returned by report query.

D. Number of characters in report query.