Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a 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 the target org.
Which three things should a data architect do to maintain the relationship hierarchy during migration? (Choose three.)
ARedefine the master-detail relationship fields to lookup relationship fields in the target org.
BUse Data Loader to export the data from the source org and then import/upsert into the target org in sequential order.
CKeep the relationship fields populated with the source record IDs in the import file.
DReplace source record IDs with new record IDs from the target org in the import file.
ECreate an external ID field for each object in the target org and map source record IDs to this field.
Northern Trail Outfitters (NTO) has a variety of customers that include households, businesses, and individuals.
The following conditions exist within its system:
NTO has a total of five million customers.
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.)
AInvest in data duplication tool to de-dupe and merge duplicate records across all systems.
BUse Salesforce CDC to sync customer data across all systems to keep customer record in sync.
CCreate a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
DCreate a unique global customer ID for each customer and store that in all systems for referential identity.
EDuplicate customer records across the systems and provide a two-way sync of data between the systems.
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?
AA middleware solution that extracts and distributes data across both the hub and spokes.
BDevelop custom APIs to poll the spoke org for change data and push into the hub org.
CDevelop custom APIs to poll the hub org for change data and push into the spoke orgs.
DA backup and archive solution that extracts and restores data across 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:
Salesforce CRM
Custom billing solution
Customer master data management (MDM)
Contract management system
Marketing solution
What should a data architect recommend that would help uniquely identify the customer across multiple systems?
AStore the Salesforce ID in all the solutions to identify the customer.
BCreate a custom field as external ID to maintain the customer ID from the MDM solution.
CCreate a custom object that will serve as a cross-reference for the customer ID.
DCreate a customer database, and use this ID in all 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.)
AData loss and recovery
BData accuracy and quality
CData completeness
DData duplication
EData standardization
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:
Point-of-sale system: All purchases for a customer
Salesforce: Ail customer service activity and sales activities for a customer
Mobile app: All bookings, preferences, and browser activity for a customer
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?
AUse a customer data mart to create the 360-degree view of the customer.
BPeriodically upload summary information in Salesforce to build a 360-degree view.
CMigrate customer activities from all four systems into Salesforce.
DExplore external data sources in Salesforce to build a 360-degree view of the customer.
Universal Containers (UC) has the following systems:
Billing system
Customer support system
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?
APhone number
BEmail address
CFull name
DGlobally Unique Identifier
During the implementation of Salesforce, a customer has the following requirements for Sales Order:
Sales Order information needs to be shown to users in Salesforce.
Sales Orders are maintained in the on-premise enterprise resource planning (ERP).
Sales Order information has more than 150 million records.
Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders in Salesforce?
AUse custom objects to maintain Sales Orders in Salesforce.
BUse external objects to maintain Sales Orders in Salesforce.
CUse custom big objects to maintain Sales Orders in Salesforce.
DUse Standard Order object to maintain Sale 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?
AImplicit sharing will automatically handle this with standard functionality.
BCreate an owner-based sharing rule.
CAdd appropriate users to the Account team.
DCreate a criteria-based sharing rule.
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?
ALeverage Canvas to bring the order management UI in to the Salesforce tab.
BBuild real-time integration to pull order line items into Salesforce when viewing orders.
CBuild batch jobs to push order line items to Salesforce.
DLeverage Salesforce Connect to bring the order line item from the legacy system to Salesforce.
A large multinational B2C Salesforce customer is looking to implement their distributor management application in Salesforce. The application has the following capabilities:
Distributors create Sales Orders in Salesforce.
Sales Orders are based on Product prices applicable to their region.
Sales Orders are closed once they are fulfilled.
It is decided to maintain Sales Orders in Opportunities object.
How should the data architect model this requirement?
ACreate lookup to Custom Price object and share with distributors.
BManually update Opportunities with Prices applicable to distributors
CConfigure Price Books for each region and share with distributors.
DAdd custom fields in Opportunity and use triggers to update prices.
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.)
ALeverage third-party AppExchange tools.
BLeverage Apex to validate the format of data being entered via a mobile device.
CLeverage validation rules and workflows.
DLeverage picklist and lookup fields where possible.
A large Insurance provider is looking to implement Salesforce. The following conditions exist:
Multiple channels for lead acquisition
Duplicate leads across channels
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.)
AImplement third-party solution to dean and enrich lead data.
BImplement de-duplication strategy to prevent duplicate leads.
CBuild a custom solution to identify and merge duplicate leads.
DStandardize lead information across all channels.
EBuild process to manually search and merge duplicates.
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?
ADevelop an Apex class that searches for duplicates and removes them nightly.
BBuild a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
CLeverage duplicate rules in Salesforce to validate duplicates during the account creation process.
DImplement an MDM solution to validate the customer information before creating Accounts in Salesforce.
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?
AEnable granular locking.
BEnable parallel sharing rule calculation.
CEnable defer sharing calculation.
DEnable implicit sharing.
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?
ACreate a Skinny Table to represent Account and Contact objects.
BLimit data loading to the 2,000 most recently created records.
CAdd Custom Indexes on frequently searched Account and Contact fields.
DLoad only data that the user is permitted to access.
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?
ALeverage real-time integration to pull records into Salesforce.
BBuild a swivel chair solution to go into the legacy system and display records.
CLeverage mashup to display historical records in Salesforce.
DBring all data in Salesforce, and delete it after a year.
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?
AImplement shield platform encryption to encrypt custom and standard fields.
BExport data out of Salesforce and encrypt custom and standard fields.
CImplement classic encryption to encrypt custom and standard fields.
DUse Apex Crypto Class to encrypt custom and standard 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?
AUse Data Classification metadata fields available in Field definition.
BBuild reports that contain customer data and classify manually.
CCreate a custom picklist field to capture classification of information on the Contact object.
DUse an AppExchange product to classify fields based on policy.
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?
AValidation Rule
BApex Class
CProcess Builder
DRequired Fields
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?
AEmbed the keywords FOR UPDATE after SOQL statements.
BRefactor or optimize classes and triggers for maximum CPU performance.
CMigrate programmatic logic to processes and flows.
DDisable classes or triggers that have the potential to obtain the same record.
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?
APerform a batch job in parallel mode and reduce the batch size.
BDefer rollup summary field calculation during data migration.
CPerform a batch job in serial mode and reduce the batch size.
DLeverage Data Loader’s platform API to load data.
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?
ACreate a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on it.
BExtract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
CCreate custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
DCreate an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.
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:
Information in certain records is incomplete.
Incorrect entry in certain fields causes records to be excluded in report filters.
Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues? (Choose three.)
AExplore third-party data providers to enrich and augment information entered in Salesforce.
BBuild a sales data warehouse with purpose-built data marts for dashboards and senior management reporting.
CDesign and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect.
DPeriodically export data to cleanse data and import them back into Salesforce for executive reports.
ELeverage Salesforce features, such as validation rules, to avoid incomplete and incorrect records.
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?
AEmail all customers and ask them to verify their information and to call NTO if their address is incorrect.
BDelete contacts when the mail is returned to save postal costs for NTO.
CHave the sales team call all existing customers and ask to verify the contact details.
DUse a third-party data source to update the contact information in Salesforce.