Certified Platform Data ArchitectPreview

Northern Trail Outfitters (NTO) has an external product master system that syncs product and pricing information with Salesforce. Users have been complaining that they are seeing discrepancies in product and pricing information displayed on the NTO website and Salesforce.
As a data architect, which action is recommended to avoid data sync issues?

Universal Containers 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?

Universal Containers (UC) has implemented a master data management strategy, which uses a central system of truth, to ensure the entire company has the same customer information in all systems. UC customer data changes need to be accurate at all times in all of the systems. Salesforce is the identified system of record for this information.
What is the correct solution for ensuring all systems using customer data are kept up to date?

Universal Containers is preparing to implement Sales Cloud and would like its users to have Read Only access to an Account record if they have access to its child Opportunity record.
How would a data architect implement this sharing requirement between objects?

Universal Containers is building a Salesforce application to track Contacts and the respective Conferences that they have attended with the following requirements:

1. Contacts will be stored in the standard Contact object.
2. Conferences will be stored in a custom Conference__c object.
3. Each Contact may attend multiple Conferences and each Conference may be related to multiple Contacts.
   How should a data architect model the relationship between the Contact and Conference__c objects?

Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:

1. High Value
2. Medium Value
3. Low Value
   Which strategy should a data architect recommend to configure customer type?

A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.
The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sates associates use Global Search to search for customers in Salesforce before they create the customers.
Which option should a data architect choose to implement to avoid duplicates?

Universal Containers (UC) has adopted Salesforce as its primary sales automation tool. UC has 100,000 customers with a growth rate of 10% a year. UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.
The UC sales team needs to be able to pull up a customer record and view their account status, invoice history, and open opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?

Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an "UNABLE_TO_LOCK_ROW" error.
Which solution should a data architect recommend to resolve the error?

Universal Containers (UC) has implemented Sales Cloud for its entire sales organization. UC has built a custom object called Projects__c that stores customer project details and employee billable hours.
The following requirements are needed:

1. A subset of individuals from the finance team will need access to the Projects object for reporting and adjusting employee utilization.
2. The finance users will not need access to any sales objects, but they will need to interact with the custom object.
   Which license type should a data architect recommend for the finance team that best meets the requirements?

Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system. During analysis, UC users highlight a pain point that there are multiple versions of many customers.
What should the data architect do for a successful migration to mitigate the pain point?

Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.
What should a data architect recommend to mitigate these errors?

A large retail company has recently chosen Salesforce as its CRM solution. They have the following record counts:
2,500,000 Accounts
25,000,000 Contacts
When doing an initial performance test, the data architect noticed an extremely slow response-time for reports and list views.
What should a data architect do to solve the performance issues?

Universal Containers (UC) needs to aggregate monthly and yearly metrics using standard reports. UC's monthly and yearly details are stored in custom objects with four million monthly records and nine million yearly records. The reports are aggregating millions of records across the two objects and taking long time to return results.
What solution should a data architect recommend to improve report performance?

Northern Trail Outfitters (NTO) needs to extract 50 million records from a custom object every day from its Salesforce org. NTO is facing query time-out issues while extracting these records.
What should a data architect recommend in order to get around the time-out issue?

Universal Containers has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master. Sales teams are complaining about duplicate account records and data quality issues with account data.
Which solution should a data architect recommend to resolve the complaints?

United Containers (UC) has released a new disaster recovery (DR) policy that states that cloud solutions need a business continuity plan in place separate from the cloud provider's built-in data recovery solution.
Which solution should a data architect use to comply with the DR policy?

Northern Trail Outfitters has decided that it is going to build a channel sales portal with the following requirements:

1. External resellers are able to authenticate to the portal with a login.
2. Lead data, Opportunity data, and Order data are available to authenticated users.
3. Authenticated users may need to run reports and dashboards.
4. There is no need for more than 10 custom objects or additional file storage.
   Which Community Cloud license type should a data architect recommend to meet the portal requirements?

Northern Trail Outfitters has these simple requirements for a data export process:

1. File format should be in CSV.
2. Process should be scheduled and run once per week.
3. The export should be configurable through the Salesforce UI.
   Which tool should a data architect leverage to accomplish these requirements?

Universal Containers (UC) is implementing Salesforce for lead management. UC procures lead data from multiple sources and would like to make sure lead data has company profile and location information.
Which solution should a data architect recommend to make sure lead data has both profile and location information?

Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.
What should a data architect recommend to increase Salesforce adoption?

Universal Containers is migrating individual customers (B2C) data from legacy systems to Salesforce. There are millions of customers stored as accounts and contacts in the legacy database.
Which object model should a data architect configure within Salesforce?

What should a data architect do to provide additional guidance for users when they enter information in a Standard field?

Universal Containers (UC) has millions of case records with case history and service level agreement data. UC's compliance team would like historical cases to be accessible for 10 years for audit purposes.
What solution should a data architect recommend?

Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product. The solution architect has recommended to create a custom object for product, and to create a lookup relationship between its customers and its products. Products will be modeled as a custom object (NTO_Product__c) and customers are modeled as person accounts. Every NTO product may have millions of customers looking up a single product, resulting in a lookup skew.
What should a data architect suggest to mitigate issues related to lookup skew?