Correct Answer: BC

Explanation: To capture and report on any changes made to ten text fields on the Contact object for the past 3 months, the data architect should write an Apex trigger on Contact after insert and after update events and store the old values in another custom object, or turn on field Contact object history tracking for these ten fields and create reports on contact history. An Apex trigger can capture the old and new values of the fields, as well as the user and time of the change, and store them in a custom object that can be used for reporting. Field history tracking can also track the changes to the fields and store them in a history table that can be used for reporting. However, field history tracking only retains data for up to 18 months or 24 months with an extension, so it may not be suitable for longer- term reporting needs. The other options are not feasible or effective for capturing and reporting on field data changes.

Correct Answer: A

Explanation: Exploring external data sources in Salesforce to build a 360 degree view of the customer (option A) is the best strategy to satisfy this requirement, as it allows customer service agents to view the activities from all four systems in real time without storing or replicating the data in Salesforce. Using a customer data mart to create the 360 degree view of the customer (option B) is not a good strategy, as it may introduce additional complexity and cost, and it does not leverage the native Salesforce features. Periodically uploading summary information in Salesforce to build a 360 degree view (option C) is also not a good strategy, as it may cause data latency and inconsistency, and it does not provide real-time information. Migrating customer activities from all four systems into Salesforce (option D) is also not a good strategy, as it may cause data redundancy and conflicts, and it does not scale well with large volumes of data.

Correct Answer: B

Explanation: The recommended solution to ensure long-term performance for the customer categorization process is to implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values. A picklist field is a

simple and efficient way to store a predefined set of values for a record. A picklist field has the following benefits:

It allows you to easily filter, sort, and group records by their category values, which can help you analyze and segment your customers. It does not require creating any additional objects or relationships, which can reduce the data model

complexity and maintenance overhead. It supports large data volumes and can handle millions of records without affecting performance or scalability.

Correct Answer: CD

Explanation: The correct answer is C and D. To minimize performance and storage issues, a data architect should recommend leveraging on premise data archival and building integration to view archived data, and leveraging big object to archive case data and lightning components to show archived data. These solutions will allow some user groups to access historical cases for up to 7 years without consuming too much storage space or affecting the performance of queries and reports. Option A is incorrect because exporting data out of salesforce and storing it in flat files on external system will make it difficult to access and query the data. Option B is incorrect because creating a custom object to store case history and run reports on it will still consume a lot of storage space and impact the performance of queries and reports.

Correct Answer: AD

Explanation: Creating the users, uploading all data, and then deploying the sharing rules will reduce the number of sharing recalculations that occur during the data load. Deferring sharing calculations until the data has finished uploading will also improve the performance by postponing the sharing rule evaluation. These are the recommended best practices for loading large data sets into Salesforce

Correct Answer: D

Explanation: Creating an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports (option D) is the fastest and most effective way for a data architect to solve the time-out issue, as it reduces the amount of data that needs to be queried and processed by the reports. Creating custom fields on opportunity and copying data from order into those custom fields (option A) is not a good solution, as it may create data redundancy and inconsistency, and it does not address the large volume of data. Extracting opportunity and order data from Salesforce and using a third-party reporting tool (option B) is also not a good solution, as it may introduce additional complexity and cost, and it does not leverage the native reporting features of Salesforce. Creating a skinny table in Salesforce and copying order and opportunity fields into it (option C) is also not a good solution, as it may not support all the reporting requirements, and it does not reduce the number of records.

Correct Answer: BC

Explanation: Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce. This is a good technique to ensure data consistency and avoid conflicts between the two systems. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields. This is another good technique to define the data governance and stewardship policies and processes for managing data quality and integrity across multiple systems

Correct Answer: AB

Explanation: Analytics/BI Owners and Data Domain Stewards are appropriate roles as members of a team that makes decisions on enterprise-wide data governance. Analytics/BI Owners are responsible for defining the business requirements and metrics for data analysis and reporting, and Data Domain Stewards are responsible for defining and enforcing the data quality standards and rules for specific data domains. Salesforce Administrators and Operational Data Users are not suitable roles for this team, as they are more focused on the operational aspects of data management, such as configuration, maintenance, and usage.

Correct Answer: BC

Explanation: Option B is correct because data model is a key artifact that an architect should use to document the data architecture for a multi-system, enterprise Salesforce implementation1. Data model describes the structure and relationship of data entities within an organization2. Option C is correct because integration specification is another key artifact that an architect should use to document the data architecture for a multi-system, enterprise Salesforce implementation1. Integration specification defines the scope, requirements, design, testing, and deployment of integration solutions between Salesforce and other systems3. Option A is not correct because user stories are not key artifacts for documenting the data architecture, but agile development tools that capture the features and functionalities that users want from a system4. Option D is not correct because non- functional requirements are not key artifacts for documenting the data architecture, but quality attributes that specify how well a system performs its functions.

Correct Answer: A

Explanation: Using an ETL tool to orchestrate the migration is the best strategy for this scenario, as it can handle the data model changes, the large volume of records, and the tight timeline. Writing a script to use the Bulk API (option C) is also possible, but it would require more coding and testing effort. Using Data Loader and Data Import Wizard (option B) is not suitable for migrating three million records, as they have limitations on the batch size and the number of records per operation. Using Salesforce CLI (option D) is also not recommended for large data migration, as it is mainly designed for development and testing purposes