Font size
WorksheetsData architect
Total questions: 60
Worksheet time: 10hrs 0mins
Universal Containers has a requirement to store more than 100 million records in Salesforce and needs to create a custom big object to support this business requirement. Which two tools should a data architect use to build custom big object? Choose 2 answers
Use Metadata API to create big object.
Go to Big Object in Setup and select new to create big object
Use DX to create big object
Go to Object Manager in Setup and select new to create big object.
Northern Trail Outfitters is migrating to Salesforce from a legacy CRM system that identifies the agent relationships in a look-up table. What should the data architect do in order to migrate the data to Salesforce?
Migrate the data and assign to a non-person system user.
Create custom object to store agent relationships.
Assign record owners based on relationship.
Migrate to Salesforce without a record owner.
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?
Configure Price Books for each region and share with distributors
Add custom fields in Opportunity and use triggers to update prices
Create lookup to Custom Price object and share with distributors
Manually update Opportunities with Prices applicable to distributors.
Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records are created or updated by users. A majority of the automation tools within UC's org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend. What should a data architect do to mitigate any unwanted results during the import?
Import the data in smaller batches over a 24-hour period.
Bulkify the triggers to handle import loads.
Ensure validation rules, triggers, and other automation tools are disabled.
Ensure duplication and matching rules are defined.
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 2 answers
Leverage Apex to validate the format of data being entered via a mobile device
Leverage validation rules and workflows
Leverage third-party AppExchange tools.
Leverage picklist and lookup fields where possible.
Universal Containers (UC) is transitioning from Classic to Lightning Experience. What does UC need to do to ensure users have access to its notes and attachments in Lightning Experience?
Add Notes and Attachments Related Lists to Page Layouts in Lightning Experience
Manually upload Notes in Lightning Experience
Migrate Notes and Attachments to Enhanced Notes and Files using a migration tool.
Manually upload Attachments in Lightning Experience.
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 3 answers
Data accuracy and quality
Data loss and recovery
Data completeness
Data duplication
Data standardization
The data architect for Universal Containers has written a SOQL query that will return all records from the Task object that do not have a value in the whatID field:
SELECT ID, Description, Subject FROM Task WHERE WhatId != NULL
When the data architect uses the query to select values for a process, a time-out error occurs. What does the data architect need to change to make this query more performant?
Add LIMIT 100 to the query.
Remove description from the requested field set
Change query to SOSL.
Change the WHERE clause to filter by a deterministic defined value
A customer is operating in a highly regulated industry and is planning to implement Salesforce. The customer information maintained in Salesforce, includes the following:
1. Personally identifiable information (PII)
2. IP restrictions on profiles organized by geographic location
3. Financial records that need to be private and accessible only by the assigned sales associate
Enterprise Security has mandated access to be restricted to users within a specific geography with detailed monitoring of user activity. Additionally, users should not be allowed to export information from Salesforce.
Which three Salesforce Shield capabilities should a data architect recommend?
Choose 3 answers
Encrypt sensitive customer information maintained in Salesforce.
Prevent sales users access to customer PII information.
Restrict access to Salesforce from users outside specific geography.
Transaction Security policies to prevent export of Salesforce data.
Event monitoring to monitor all user activity.
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?
Build reports that contain customer data and classify manually.
Use an AppExchange product to classify fields based on policy.
Create a custom picklist field to capture classification of information on the contact object
Use Data Classification metadata fields available in Field definition.
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 3 answers
Periodically export data to cleanse data and import them back into Salesforce for executive reports.
Explore third-party data providers to enrich and augment information entered in Salesforce.
Build a sales data warehouse with purpose-built data marts for dashboards and senior management reporting.
Leverage Salesforce features, such as validation rules, to avoid incomplete and incorrect records. E
Design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect.
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?
Write an Apex callout and populate a related list to display on the account record.
Create a visual force tab with the billing system encapsulated within an iframe.
Create a mashup page that will present the billing system records within Salesforce.
Create a custom object and migrate the last 12 months of invoice data into Salesforce so it can be displayed on the Account layout.
Northern Trail Outfitters (NTO) has a loyalty program to reward repeat customers. The following conditions exist:
1. Reward levels are earned based on the amount spent during the previous 12 months.
2. The program will track every item a customer has bought and grant them points for discounts.
3. The program generates 100 million records each month. NTO Customer Support would like to see a summary of a customer's recent transactions and the reward level(s) they have attained.
Which solution should the data architect use to provide the information within Salesforce for the customer support agents?
Provide a button so that the agent can quickly open the point-of-sale system that displays the customer's history.
Capture the reward program data in an external data store, and present the 12-month trailing summary in Salesforce using Salesforce Connect and an external object.
Create a custom big object to capture the reward program data, display it on the contact record, and update nightly from the point-of-sale system.
Create a custom object in Salesforce to capture and store all reward programs, populate nightly from the point-of-sale system, and present on the customer record.
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?
Use Standard Order object to maintain Sale Orders in Salesforce.
Use custom big objects to maintain Sales Orders in Salesforce.
Use custom objects to maintain Sales Orders in Salesforce.
Use external objects to maintain Sales Orders in Salesforce.
Universal Containers (UC) has implemented Salesforce. UC is running out of storage and needs to have an archiving solution. UC would like to maintain two years of data in Salesforce and archive older data out of Salesforce. Which solution should a data architect recommend as an archiving solution?
Build a batch job to move two-year-old records off platform, and delete old records from Salesforce.
Use a third-party backup solution to back up all data off platform.
Build a batch job to move all records off platform, and delete old records from Salesforce.
Build a batch job to move all records off platform, and delete all records from Salesforce.
Universal Containers is migrating 100,000 accounts from an enterprise resource planning (ERP) to Salesforce and is concerned about ownership skew and performances. A Which three recommendations should a data architect provide to prevent ownership skew? Choose 3 answers
Assign a default user as owner of accounts and do not assign any role to the default user.
Assign a default user as owner of accounts and assign the user to the top most role in the hierarchy.
Assign a default user as owner of accounts and assign them a role in the hierarchy.
Keep users out of public groups that can be used as the source for sharing rules.
Assign View All permissions to a group of users for the Account object.
Universal Containers is implementing Salesforce and needs to migrate data from two legacy systems. UC would like to clean and deduplicate data before migrating to Salesforce. Which solution should a data architect recommend a clean migration?
Set up staging data base, and define external IDs to merge, clean, deduplicate data, and load into Salesforce.
Define deduplicate rules in Salesforce, and load data into Salesforce from both databases.
Define external IDs for an object, migrate second database to first database, and load into Salesforce.
Define external IDs for an object, insert data from one database, and use upsert for a second database.
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?
Service Cloud
Sales Cloud
Lightning Platform Plus
Lightning Platform Starter
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?
Export data out of Salesforce and encrypt custom and standard fields.
Implement classic encryption to encrypt custom and standard fields.
Use Apex Crypto Class to encrypt custom and standard fields
Implement shield platform encryption to encrypt custom and standard fields.
Universal Containers developers have created a new Lightning component that leverages an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a timeout error. What tool should a data architect use to identify why the query is taking too long?
Use Splunk to query the system logs looking for transaction time and CPU usage
Open a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time.
Use Salesforce's query optimizer to analyze the query in the developer console
Enable and use the Query Plan tool in the developer console.
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?
Enable parallel sharing rule calculation
Enable granular locking.
Enable implicit sharing.
Enable defer sharing calculation.
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?
Migrate programmatic logic to processes and flows.
Refactor or optimize classes and triggers for maximum CPU performance.
Disable classes or triggers that have the potential to obtain the same record
Embed the keywords FOR UPDATE after SOQL statements.
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?
Load only data that the user is permitted to access.
Limit data loading to the 2,000 most recently created records,
Create a Skinny Table to represent Account and Contact objects
Add Custom Indexes on frequently searched Account and Contact fields.
Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data. Currently, it has data backup processes that runs weekly, which backs up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage What should a data architect recommend for a daily backup and restore solution?
Change weekly backup process to daily backup, and implement a custom restore solution.
Use AppExchange package for backup and restore
Use ETL tool for backup and restore from EDW.
Use Bulk API to extract data on daily basis to EDW and REST API for restore.
Universal Containers (UC) would like to build a Human Resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately maintain and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,000 API calls into Salesforce from an onpremise application daily. Which license type should a data architect recommend that best fits these requirements?
Lightning External Apps Starter
Lightning Platform Plus
Lightning Platform Starter
Service Cloud
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?
Build batch jobs to push order line items to Salesforce.
Leverage Canvas to bring the order management UI in to the Salesforce tab.
Leverage Salesforce Connect to bring the order line item from the legacy system to Salesforce
Build real-time integration to pull order line items into Salesforce when viewing orders.
Universal Containers (UC) is going through major reorganization of their sales team. This would require changes to a large a number of group membership and sharing rules. UCs administrator is concerned about long processing time and failures during the process. What should a Data Architect implement to make changes efficiently?
Enable Defer Sharing Calculation prior to making sharing rule changes.
Delete old sharing rules and build new sharing rules.
Log a case with salesforce to make sharing rule changes.
Log out all users and make change to sharing rules.
Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance issues and time-outs while running case reports in the Salesforce org. Which solution should a data architect recommend to improve reporting performance?
Create a custom object to store aggregate data and run reports.
Build reports using custom Lightning components.
Contact Salesforce support to enable skinny table for cases.
Move data off of the platform and run reporting outside Salesforce, and give access to reports.
To address different compliance requirements such as General Data Protection Regulation (GDPR), personally identifiable information (PIT), Health Insurance Portability and Accountability Act (HIPPA) and others, a Salesforce customer decided to categorize each data element in Salesforce with the following: 1. Data owner 2. Security level (i.e. confidential) 3. Compliance type (.e. GDPR, PII, HIPAA) A compliance audit would require Salesforce admins to generate reports to manage compliance What should a data architect recommend to address this requirement?
Use the Metadata API to extract field attribute information and use the extract to classify and build reports
Create a custom object and field to capture necessary compliance information and build custom reports.
Use field metadata attributes for compliance categorization, data owner, and data sensitivity level
Build reports for field information, then export the information to classify and report for audits.
Universal Containers (UC) is planning a massive Salesforce implementation with large volumes of data. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner. What should a data architect do to minimize data load times due to system calculations?
Enable granular locking to avoid the "UNABLE_TO_LOCK_ROW" error.
Leverage the Bulk API and concurrent processes with multiple batches
Load the data through Data Loader and turn on parallel processing
Enable defer sharing calculations and suspend sharing rule calculations.
Universal Containers needs to load a large volume of leads into Salesforce on a weekly basis. During this process the validation rules are disabled. What should a data architect recommend to ensure data quality is maintained in Salesforce?
Activate validation rules once the leads are loaded into Salesforce to maintain quality
Ensure the lead data is preprocessed for quality before loading into Salesforce
Allow validation rules to be activated during the load of leads into Salesforce.
Develop a custom Batch Apex process to Improve quality once the load is completed.
Northern Trail Outfitters uses Salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining that a dashboard is taking 10 minutes to run and sometimes fails to load, throwing a time-out error. Which three options should help improve the dashboard performance? Choose 3 answers
Remove widgets from the dashboard to reduce the number of graphics loaded.
Denormalize the data by reducing the number of joins.
Use selective queries to reduce the amount of data being returned.
Run the dashboard for the CEO and send it via email
Reduce the amount of data queried by archiving unused opportunity records.
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?
Develop custom APIs to poll the spoke org for change data and push into the hub org
Develop custom APIs to poll the hub org for change data and push into the spoke orgs
A middleware solution that extracts and distributes data across both the hub and spokes
A backup and archive solution that extracts and restores data across orgs.
A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy: 1. State in which the customer is located 2. City in which the customer is located if available 3. Zip code in which the customer is located if available 4. Changes to this information should have minimum code change What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?
Create a custom object to maintain the pricing criteria
Maintain required pricing criteria in custom metadata types
Assign the pricing criteria within custom pricing engine
Configure the pricing criteria in price books.
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?
Implicit sharing will automatically handle this with standard functionality.
Create an owner-based sharing rule.
Add appropriate users to the Account team.
Create a criteria-based sharing rule.
Northern Trail Outfitters (NTO) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly. Which two native tools should a data architect recommend to achieve this reporting requirement? Choose 2 answers
Einstein Analytics
Async SOQL with a custom object
Standard SOQL queries
Standard reports and dashboards
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?
Create a customer database, and use this ID in all systems
Create a custom object that will serve as a cross-reference for the customer ID
Store the Salesforce ID in all the solutions to identify the customer.
Create a custom field as external ID to maintain the customer ID from the MDM solution.
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?
Bulk API
Data loader
Data export wizard
Third-party ETL tool
Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two orgs: Org A and Org B. UC has delivered these requirements to its data architect: 1. The data model for Org B will drastically change with different objects, fields, and picklist values. 2. Three million records will need to be migrated from Org A to Org B for compliance reasons. 3. The migration will need occur within the next two months, prior to the spilt. Which migration strategy should a data architect use to successfully migrate the data?
Use Data Loader for export and Data Import Wizard for import.
Use the Salesforce CLI to query, export, and import.
Write a script to use the Bulk API
Use an ETL tool to orchestrate the migration.
Universal Containers (UC) is in the process of migrating legacy inventory data from an enterprise resource planning (ERP) system into Sales Cloud with the following requirements: 1. Legacy inventory data will be stored in a custom child object called Inventory_c. 2. Inventory data should be related to the standard Account object. 3. The Inventory c object should inherit the same sharing rules as the Account object. 4. Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well. What type of relationship field should a data architect recommend in this scenario?
Master-detail relationship field on Inventory_c, related to Account
Lookup relationship field on Inventory_c, related to Account
Indirect lookup relationship field on Account, related to Inventory_c
Master-detail relationship field on Account, related to Inventory_c
Northern Trail Outfitters (NTO) uses Sales Cloud and Service Cloud to manage their sales and support processes. Some of NTOs teams are complaining they see new fields on their page and are unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce. Which governance measure should a data architect recommend to solve this issue?
Create validation rules with error messages to explain why the field is used.
Create and manage a data dictionary, and use a governance process for changes made to common objects
Add description fields to explain why the field is used, and mark the fields as required
Create reports to identify which fields users are leaving blank, and use external data sources to augment the missing data.
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?
Perform a batch job in parallel mode and reduce the batch size.
Perform a batch job in serial mode and reduce the batch size
Leverage Data Loader's platform API to load data
Defer rollup summary field calculation during data migration.
Universal Containers (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for options to delete unused records from the org. Which three recommendations should a data architect make in order to reduce the number of records from the org? Choose 3 answers
Use Rest API to permanently delete records from the Salesforce org
Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce
Use hard delete in Bulk API to permanently delete records from Salesforce
Identify records in objects that have not been modified or used in last 3 years.
Use hard delete in Batch Apex to permanently delete records from Salesforce.
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?
Have the sales team call all existing customers and ask to verify the contact details
Delete contacts when the mail is returned to save postal costs for NTO.
Email all customers and ask them to verify their information and to call NTO if their address is incorrect.
Use a third-party data source to update the contact information in Salesforce.
Universal Containers (UC) uses the following Salesforce products: • Sales Cloud for customer management. • Marketing Cloud for marketing. • Einstein Analytics for business reporting. UC occasionally gets a list of prospects from third-party sources as comma-separated values (CSV) files for marketing purposes. Historically, UC would load these contacts into Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud. UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process. What should a data architect recommend to UC in order to immediately avoid storage issues in the future?
Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications
Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications
Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales Cloud after the sync is complete
Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.
Universal Containers has a legacy client server app that has a relational database that needs to be migrated to Salesforce. What are the three key actions that should be done when data modeling in Salesforce? Choose 3 answers
Implement the legacy data model within Salesforce using custom fields.
Identify data elements to be persisted in Salesforce.
Map legacy data to custom metadata types.
Work with legacy application owner to analyze the legacy data model.
Map legacy data to Salesforce objects.
Universal Containers (UC) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW. What data extraction strategy should a data architect use for maximum performance?
Utilize PK Chunking with the Bulk API.
Call the REST API in successive queries.
Install a third-party AppExchange tool
Use the Bulk API in parallel mode.
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?
Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
Develop an Apex class that searches for duplicates and removes them nightly
Leverage duplicate rules in Salesforce to validate duplicates during the account creation process.
Implement an MDM solution to validate the customer information before creating Accounts in Salesforce.
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?
Validation Rule
Required Fields
Apex Class
Process Builder
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: All 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?
Migrate customer activities from all four systems into Salesforce
Use a customer data mart to create the 360 degree view of the customer
Explore external data sources in Salesforce to build a 360 degree view of the customer.
Periodically upload summary information in Salesforce to build a 360 degree view.
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?
Ask Salesforce support for additional CPU power.
Enable sharing recalculations.
Enable granular locking.
Remove SOQL statements from Apex Loops.
Universal Containers (UC) has one Salesforce org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately, but would like to bidirectionally share Opportunities between orgs in near-real time. Which three options should a data architect recommend to share data between Org A and Org B? Choose 3 answers
Leverage middleware tools to bidirectionally send Opportunity data across orgs.
Develop an Apex class that pushes Opportunity data between orgs daily via the Apex scheduler
Install a third-party AppExchange tool to handle the data sharing.
Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
Use Salesforce Connect and the cross-org adapter to virtualize Opportunities into external objects.
Northern Trail Outfitters (NTO) runs its entire business out of an enterprise data warehouse (EDW). NTO's sales team is starting to use Salesforce after a recent implementation, but currently lacks the data required to advance leads and opportunities to the next stage. NTO's management has researched Salesforce Connect and would like to use it to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects. What should a data architect consider before implementing Salesforce Connect for reporting?
OData callout limits per day
Maximum external objects per org
Maximum number of records returned
Maximum page size for server-driven paging
A customer wants to maintain geographic location information including latitude and longitude in a custom object. What should a data architect recommend to satisfy this requirement?
Create a geolocation custom field to maintain this requirement
Create formula fields with geolocation functions for this requirement
Recommend AppExchange packages to support this requirement.
Create custom fields to maintain latitude and longitude Information.
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 two solutions should a data architect recommend to resolve the complaints? Choose 2 answers
Implement a de-dupe solution and establish account ownership in Salesforce
Integrate Salesforce with ERP, and make ERP as system of truth
Build a nightly batch job to de-dupe data, and merge account records
Build a nightly sync job from ERP to Salesforce.
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 3 answers
Standardize lead information across all channels.
Build a custom solution to identify and merge duplicate leads
Implement de-duplication strategy to prevent duplicate leads
Implement third-party solution to clean and enrich lead data
Build process to manually search and merge duplicates.
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?
Full name
Phone number
Globally Unique identifier
Email address
Universal Containers (UC) stores 10 million rows of inventory data in a cloud database. As part of creating a connected experience in Salesforce, UC would like to expose this inventory data to Sales Cloud without a direct import. UC has asked its data architect to determine if Salesforce Connect is needed. Which three considerations should the data architect make when evaluating the need for Salesforce Connect? Choose 3 answers
You want real-time access to the latest data from other systems
You have a large amount of data and would like to copy subsets of it into Salesforce
You have a large amount of data that you don't want to copy into your Salesforce org.
You need to expose data via a virtual private connection
You need small amounts of external data at any one time,
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 3 answers
Use Salesforce CDC to sync customer data across all systems to keep customer record in sync
Duplicate customer records across the systems and provide a two-way sync of data between the systems.
Create a unique global customer ID for each customer and store that in all systems for referential identity.
Invest in data duplication tool to de-dupe and merge duplicate records across all systems
Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
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?
Leverage mashup to display historical records in Salesforce.
Build a swivel chair solution to go into the legacy system and display records.
Bring all data in Salesforce, and delete it after a year.
Leverage real-time integration to pull records into Salesforce.
