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 a Master Data Management system to determine system of record.
• B.Implement an hourly integration to send Salesforce Opportunities to the ERP system.
• 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.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?

• A.Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.
• B.Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
• C.Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.
• D.Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

Comment: *

Name: *

Email: *

Verification: *

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.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not routed by assignment rules are assigned to a dummy user. Sales rep are complaining of high load times and issues with accessing leads assigned to the dummy user.
What should a data architect recommend to solve these performance issues?

• A.Assign dummy user last role in role hierarchy
• B.Create multiple dummy user and assign leads to them
• C.Assign dummy user to highest role in role hierarchy
• D.Periodically delete leads to reduce number of leads

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and
"Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

• A.Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
• B.Implement an integration tool to send OMS Accounts and Contacts to Salesforce.
• C.Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
• D.Use the Streaming API to send Account and Contact data from Salesforce to the OMS.

Comment: *

Name: *

Email: *

Verification: *