Certified Data ArchitectPreview

Northern Trail Outfitters (NTO) has a variety of customers that include households, businesses, and individuals.
The following conditions exist within its system:

1. NTO has a total of five million customers.
2. Duplicate records exist, which is replicated across many systems, including Salesforce.
   Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.
   Which three options should a data architect perform to resolve the Issues with the customer data? (Choose three.)

Northern Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org. NTO also owns several secondary orgs that the service, finance, and marketing teams work out of. At the moment, there is no integration between central and secondary orgs, leading to data visibility issues.
Moving forward, NTO has identified that a hub-and-spoke model is the proper architecture to manage its data, where the central org is the hub and the secondary orgs are the spokes.
Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

A large retail B2C customer wants to build a 360-degree view of its customers for its call center agents. The customer information is currently maintained in the following systems:

1. Salesforce CRM
2. Custom billing solution
3. Customer master data management (MDM)
4. Contract management system
5. Marketing solution
   What should a data architect recommend that would help uniquely identify the customer across multiple systems?

Northern Trail Outfitters (NTO) has the following systems:
Customer master—source of truth for customer information

Service cloud—customer support -
Marketing cloud—marketing communications
Enterprise data warehouse-business reporting
The customer data is duplicated across all these systems and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call in to update their information.
NTO is planning to implement a master data management (MDM) solution across the enterprise.
Which three data issues will an MDM tool solve? (Choose three.)

A casino is implementing Salesforce and is planning to build a customer 360-degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity:

1. Point-of-sale system: All purchases for a customer
2. Salesforce: Ail customer service activity and sales activities for a customer
3. Mobile app: All bookings, preferences, and browser activity for a customer
4. Marketing: All email, SMS, and social campaigns for a customer
   Customer service agents using Salesforce would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.
   What strategy should the data architect implement to satisfy this requirement?

Universal Containers (UC) has the following systems:

1. Billing system
2. Customer support system
3. CRM system
   UC has been having trouble with business intelligence across the different systems. Recently UC implemented a master data management (MDM) solution that will be the system of truth for the customer records.
   Which MDM data element is needed to allow reporting across these systems?

During the implementation of Salesforce, a customer has the following requirements for Sales Order:

1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premise enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
   What should a data architect recommend for maintaining Sales Orders in Salesforce?

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 using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.
What solution should a data architect recommend to give the sales team visibility into order status?

A large multinational B2C Salesforce customer is looking to implement their distributor management application in Salesforce. The application has the following capabilities:

1. Distributors create Sales Orders in Salesforce.
2. Sales Orders are based on Product prices applicable to their region.
3. Sales Orders are closed once they are fulfilled.
4. It is decided to maintain Sales Orders in Opportunities object.
   How should the data architect model this requirement?

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM. UC is concerned about the quality of data being entered by users and through external integrations.
Which two solutions should a data architect recommend to mitigate data quality issues? (Choose two.)

A large Insurance provider is looking to implement Salesforce. The following conditions exist:

1. Multiple channels for lead acquisition
2. Duplicate leads across channels
3. Poor customer experience and higher costs
   On analysis, it was found that there are duplicate leads that are resulting in multiple quotes and opportunities.
   Which three actions should a data architect recommend to mitigate the issues? (Choose three.)

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 sales 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 is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and automated updates at the same time.
What should a data architect do in order to resolve the issue?

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) is replacing a home grown CRM solution with Salesforce. UC has decided to migrate operational (open and active) records to Salesforce, while keeping historical records in legacy system. UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?

Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system, it was discovered that some standard and custom fields need to encrypted.
Which solution should a data architect recommend to encrypt existing fields?

As part of addressing General Data Protection Regulation (GDPR) requirements, Universal Containers (UC) plans to implement a data classification policy for all of its internal systems that store customer information including Salesforce.
What should a data architect recommend so that UC can easily classify customer information maintained in Salesforce under both standard and custom objects?

Universal Containers requires all customers to provide either a phone number or an email address when registering for an account.
What should the data architect use to ensure this requirement is met?

Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs chance of encountering race conditions on the same record.
What should a data architect recommend to guarantee that records are not being updated at the same time?

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) 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?

Northern Trail Outfitters has implemented Salesforce for its sales associates nationwide. Senior management is concerned that the executive dashboards are not reliable for their real-time decision-making. On analysis, the team found the following issues with data entered in
Salesforce:

1. Information in certain records is incomplete.
2. Incorrect entry in certain fields causes records to be excluded in report filters.
3. Duplicate entries cause incorrect counts.
   Which three steps should a data architect recommend to address the issues? (Choose three.)

Northern Trail Outfitters (NTO) has been using Salesforce for Sales and Service for 10 years. For the past two years, the marketing group has noticed a rise from 0% to 35% in returned mail when sending mail using the contact information stored in Salesforce.
Which solution should the data architect use to reduce the amount of returned mail?