Salesforce Plat-Arch-201 : Salesforce Certified Platform Data Architect

Universal Containers has two systems. Salesforce and an on-premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?

• A. Implement an hourly integration to send Salesforce Opportunities to the ERP system.
• B. Implement a Master Data Management system to determine system of record.
• C. Implement a workflow rule that sends Opportunity data through Outbound Messaging.
• D. Have the ERP poll Salesforce nightly and bring in the desired Opportunities.

All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:
- An ERP system feeds order data into Salesforce and updates both
Account and Opportunity records.
- An accounting system feeds invoice data into Salesforce and updates
both Account and Opportunity records.
- A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.
How should the architect determine which of these systems is the system of record?

• A. Whatever system updates the attribute or object should be the system of record for that field or object.
• B. Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.
• C. Whatever integration data flow runs last will, by default, determine which system is the system of record.
• D. Data flows should be reviewed with the business users to determine the system of record per object or field.

NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and data. NTO's data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org. What 3 things should a data architect do to maintain the relationship hierarchy during migration? Choose 3 answer

• A. Keep the relationship fields populated with the source record ID's in the import file.
• B. Replace source record ID's with new record ID's from the target org in the import file.
• C. Redefine the master detail relationship fields to lookup relationship fields in the target org.
• D. Create a external id field for each object in the target org and map source record ID's to this field.
• E. Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process. What should a Data architect implement to make changes efficiently?

• A. Enable Defer Sharing Calculation prior to making sharing rule changes.
• B. Log a case with salesforce to make sharing rule changes.
• C. Log out all users and make changes to sharing rules.
• D. Delete old sharing rules and build new sharing rules

What is the best tool for analyzing SOQL query performance?

• A. Data Loader
• B. Workbench
• C. Debug Logs
• D. Query Plan Tool