Data Architect - Set 1

Universal Containers is preparing to implement Agentforce Sales 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. Create a criteria-based sharing rule. Add appropriate users to the Account team.

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Salesforce is implemented as follows: 1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes. 2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis. 3. PPS is the trusted source within NTO for Opportunity Amount. 4. NTO uses Opportunity Forecast for its sales planning and management. Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities. How should a data architect address this overwriting issue?. Change Opportunity Amount field access to Read Only for sales users using field-level security. Create a custom field for Opportunity Amount that sales users update separating the field that PPS updates. Create a custom field for Opportunity amount that PPS updates separating the field sales user updates. Change PPS integration to update only Opportunity Amount field when the value is null.

Universal Containers (UC) has implemented Agentforce Sales 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 employer 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?. Agentforce Service. Lightning Platform Plus. Agentforce Sales. Lightning Platform Starter.

Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer complaints, provide white papers on products, and provide subscription based support. Which license type will UC users need to fulfill UC's requirements?. Agentforce Sales License. Agentforce Service License. Lightning Platform Starter License. Salesforce License.

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 the WHERE clause to filter by a deterministic defined value. Change query to SOSL.

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. Move data off of the platform and run reporting outside Salesforce, and give access to reports. Build reports using custom Lightning components. Contact Salesforce support to enable skinny table for cases.

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?. Add custom fields in Opportunity and use triggers to update prices. Configure Price Books for each region and share with distributors. Manually update Opportunities with Prices applicable to distributors. Create lookup to Custom Price object and share with distributors.

Universal Containers is establishing a call center that will use Salesforce. UC receives 10 million calls and creates 100 million cases every month. Cases are linked to a custom call object using lookup relationship. UC would like to run reports and dashboard to better understand different case types being created on calls to better serve customers. What solution should a data architect recommend to meet the business requirement?. Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object. Archive records to a data warehouse and run analytics on the data warehouse. Leverage big objects to archive records and Einstein Analytics to run reports. Leverage custom objects to store aggregate data and run analytics.

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?. 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. Write an Apex callout and populate a related list to display on the account record.

A consumer products company has decided to use Salesforce for its contact center. The contact center agents need access to the following information in Service Console when a customer contacts them: 1. Customer browsing activity on its website stored on its on-premise system 2. Customer interactions with sales associates at its retail stores maintained in Salesforce 3. Contact center interactions maintained in Salesforce 4. Email campaign activity to customer from its marketing systems. What should a data architect do to fulfill these requirements with minimum development effort in Salesforce?. Use Salesforce Connect to integrate the website and the marketing system into Service Console using external objects. Build custom components in Service Console to bring information from the marketing and website information. Build customer view in Service Console with components that show website data and marketing data as mashup. Create web tabs in Service Console to show website and marketing activities.

Universal Containers (UC) has decided that they are going to retire a homegrown CRM application and move to Salesforce. As part of the implementation, they will need to migrate 5 billion records in a series of batches. The records are a collection of Accounts, Contacts, Opportunities, Products, and Orders. Since the legacy CRM application and Salesforce have different data models, the data will need to be transformed and normalized before it is loaded into the system. What should a data architect recommend as a migration and storage strategy?. Import all data into custom objects with data loader. Import all data into custom objects with middleware. Migrate data to a centralized datastore first with ETL tools. Use an ETL tool to extract and transform the data, then load into standard objects.

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?. Maintain required pricing criteria in custom metadata types. Configure the pricing criteria in price books. Assign the pricing criteria within custom pricing engine. Create a custom object to maintain the pricing criteria.

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?. Embed the keywords FOR UPDATE after SOQL statements. 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.

Universal Containers is implementing Agentforce Sales 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?. Implement Shield Platform Encryption to encrypt files. Implement a third party AppExchange app to encrypt files. Store files outside of Salesforce and access them in real time. Use classic encryption to encrypt files.

Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following: 1. Customers are Person Accounts for their retail business. 2. Customers are represented as Contacts for their commercial business. 3. Employees are maintained as Users. 4. Prospects are maintained as Leads. NTO needs to implement a standard communication preference management model for Person Accounts, Contacts, Users, and Leads. Which option should the data architect recommend NTO to satisfy this requirement?. Create a custom object to maintain preferences and build relationships to Lead, Person Account, and Users. Create custom fields for contact preferences in Lead, Person Account, and Users objects. Create case for contact preferences, and use this to validate the preferences for Lead, Person Accounts, and Users. Use Individual objects to maintain the preferences with relationships to Lead, Person Account, and Users.

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?. Data loader. Third-party ETL tool. Bulk API. Data export wizard.

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?. Manually upload Attachments in Lightning Experience. Migrate Notes and Attachments to Enhanced Notes and Files using a migration tool. Manually upload Notes in Lightning Experience. Add Notes and Attachments Related Lists to Page Layouts in Lightning Experience.

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?. Use the Customer 360 data manager to sync product and pricing information from product master database to Salesforce. Build a custom integration for one way sync of product and pricing information from product master to Salesforce. Build a custom integration for two-way sync of product and pricing information between product master to Salesforce. Implement a manual process to update the products from an extract from the products master on a weekly basis.

Northern Trail Outfitters (NTO) is streaming IoT data from connected devices to a cloud database. Every 24 hours, 100,000 records are generated. NTO employees will need to see these IoT records within Salesforce and generate weekly reports on it. Developers may also need to write programmatic logic to aggregate the records and incorporate them into workflows. Which data pattern will allow a data architect to satisfy these requirements, while also keeping limits in mind?. Persistence. Unidirectional integration. Virtualization. Bidirectional integration.

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 implicit sharing. Enable parallel sharing rule calculation. Enable granular locking. Enable defer sharing calculation.

Which API should a data architect use if exporting 1 million records from Salesforce?. SOAP API. Streaming API. REST API. Bulk API.

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. Log a case with salesforce to make sharing rule changes. Log out all users and make change to sharing rules. Delete old sharing rules and build new sharing rules.

What should a data architect do to provide additional guidance for users when they enter information in a Standard field?. Add a label field with help text adjacent to the custom field. Add custom help text in default value for the field. Create a custom page with help text for user guidance. Provide custom help text under field properties.

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 custom big objects to maintain Sales Orders in Salesforce. Use Standard Order object to maintain Sale Orders in Salesforce. Use custom objects to maintain Sales Orders in Salesforce. Use external objects to maintain Sales Orders in Salesforce.

Universal Containers has multiple systems all containing and maintaining customer data. Although point-to-point integrations are in place, customers are complaining about consistency in the data. What solution should the data architect recommend?. Perform a one time synchronization to level set the built up inconsistencies. Data cleanse each system. An MDM solution as the customer master, with centralized integrations to ensure consistency across all systems. Improve existing point-to-point integrations.

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?. Globally Unique Identifier. Email address. Full name. Phone number.

Universal Containers (UC) has a requirement to migrate 100 million order records from a legacy enterprise resource planning (ERP) application into the Salesforce platform. UC does not have any requirements around reporting on the migrated data. What should a data architect recommend to reduce performance degradation of the platform?. Use a standard big object defined by Salesforce. Implement a custom big object to store the data. Use the standard "Order" object to store the data. Create a custom object to store the data.

Northern Trail Outfitters (NTO) wants to start a loyalty program to reward repeat customers. The program will track every item a customer has bought and grants them points for discounts. The following conditions will exist upon implementation: 1. Data will be used to drive marketing and product development initiatives. 2. NTO estimates that the program will generate 100 million rows of data monthly. 3. NTO will use Salesforce's Einstein Analytics and Discovery to leverage their data and make business and marketing decisions. What should the Data Architect do to store, collect, and use the reward program data?. Create a custom big object in Salesforce which will be used to capture the Reward Program data for consumption by Einstein. Have Einstein connect to the point of sales system to capture the Reward Program data. Create a custom object in Salesforce that will be used to capture the Reward Program data. Create a big object in Einstein Analytics to capture the Loyalty Program data.

Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs. Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?. Federated Search. External APIs. Salesforce 2 Salesforce. Salesforce Connect.

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 the Salesforce CLI to query, export, and import. Write a script to use the Bulk API. Use an ETL tool to orchestrate the migration. Use Data Loader for export and Data Import Wizard for import.

Northern Trail Outfitters (NTO) needs to extract 50 million records from a custom object every day from its Salesforce org. NTO facing query time-out issues while extracting these records. What should a data architect recommend in order to get around the time-out issue?. Use the Rest API to extract data as it automatically chunks records by 200. Use a PK Chunking within the Bulk API. Use extract, transform, load (ETL) tool for extraction of records. Ask Salesforce support to increase the query timeout value.

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?. Use Data Classification metadata fields available in Field definition. Create a custom picklist field to capture classification of information on the Contact object. Build reports that contain customer data and classify manually. Use an AppExchange product to classify fields based on policy.

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?. Create a chatter group and upload all Excel files to the group. Load data in external database and provide access to database to sales users. Use the Excel connector to Salesforce to sync data from individual Excel files. Define a standard mapping and train sales users to import opportunity data.

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?. Leverage big object to store data and run reports on it. Create an aggregation custom object that summarized the monthly and yearly values. Move data out of Salesforce and run reporting on it. Delete old data from Salesforce and run reports on it.

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?. Send customer record changes from Salesforce to each system in a nightly batch job. Send customer record changes from Salesforce to the system of truth in real time. Send customer data nightly to the system of truth in a scheduled batch job. Have each system pull the record changes from Salesforce using change data capture.

Northern Trail Outfitters needs to implement an archive solution for Salesforce data. This archive solution needs to help NTO do the following: 1. Remove outdated information not required on a day to day basis. 2. Improve Salesforce performance. Which solution should be used to meet these requirements?. Identify a location to store archived data, and move data to the location using a time-based workflow. Create a full copy sandbox, and use it as a source for retaining archived data. Identify a location to store archived data and use scheduled batch jobs to migrate and purge the aged data on a nightly basis. Use a formula field that shows true when a record reaches a defined age and use that field to run a report and export a report into SharePoint.

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?. Purchase more data storage to support the case object. Use a custom big object to store archived case data. Use a custom object to store archived case data. Archive case dala using a Salesforce Archival solution.

Universal Containers's system administrators have been complaining that they are not able to make changes to its users' records, including moving them to new territories without getting "unable to lock row" errors. This is causing the system admins to spend hours updating user records every day. What should the data architect do to prevent the errors?. Analyze Splunk query to spot offending records. Increase CPU for the Salesforce org. Enable granular locking. Reduce number of users updated concurrently.

Universal Containers (UC) owns multiple Salesforce orgs that are distributed across regional branches. Each branch stores local customer data inside of its org's Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs. UC has an initiative to create a 360 degree view of the customer, as UC would like to see Account and Contact data from all of its orgs in one place. Which solution should a data architect suggest to achieve a 360 degree view of the customer?. Use the Salesforce Connect cross-org adapter. Use an ETL tool to migrate gap Accounts and Contacts into each org. Build a bidirectional integration between all orgs. Consolidate the data from each org into a centralized datastore.

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?. Utilize an ETL tool to migrate data to an on premise archival solution. Leverage Salesforce weekly exports, and store data in flat files on a protected system. Leverage a third-party tool that extracts Salesforce data/metadata, and stores the information in an external protected system. Write a custom batch job to extract data changes nightly, and store on an external protected system.

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?. Migrate the data as is, and use Salesforce's de duplicating feature. Hire an intern manually de duplicate the records after migrating to Salesforce. Have the users manually clean the data in the old system prior to migration. Store the data in a staging database, and de-duplicate identical records.

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?. Remove SOQL statements from Apex Loops. Ask Salesforce support for additional CPU power. Enable granular locking. Enable sharing recalculations.

Universal Containers uses Apex jobs to create leads in Salesforce. The business team has requested that lead creation failures should be reported to them. Which option does Apex provide to report errors from this Apex job?. Use Apex services to email failures to business when error occurs. Save Apex errors in a custom object, and allow access to this object for reporting. Use AppExchange package to clean lead information before Apex job processes them. Use Custom Object to store leads, and allow unprocessed leads to be reported.

Universal Containers has implemented Salesforce for its operations. In order for customers to be created in their MDM solution, the customer record needs to have the following attributes: 1. First Name 2. Last Name 3. Email. Which option should the data architect recommend to mandate this when customers are created in Salesforce?. Create validation rules to check if the required attributes are entered. Configure Page Layout marking attributes as required fields. Mark Fields for the attributes as required under Setup. Build validation in Integration with MDM to check required attributes.

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 all records off platform, and delete all 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 two-year-old records off platform, and delete old records from Salesforce.

Universal Containers has provided a web order form for its customer and has noticed invalid data coming in on orders. What should be used to mitigate this problem?. Validation Rules. Apex Trigger. Formatted Fields. Work Flow Rules.

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?. Bring all data in Salesforce, and delete it after a year. Leverage real-time integration to pull records into Salesforce. Leverage mashup to display historical records in Salesforce. Build a swivel chair solution to go into the legacy system and display records.

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?. Create a master-detail relationship field on the Contact object. Create a master-detail relationship field on the Conference__c object. Create a lookup relationship field on the Contact object. Implement a Contact Conference junction object with master-detail relationships to both Contact and Conference__c.

A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following: 1. A record is created in Project c and used to track the project through completion. 2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime c object related to the project. 3. Ability to view or edit the VTOTime c object needs to be the same as the Project c record. 4. Managers must see total hours volunteered while viewing the Project c record. Which data relationship should the data architect use to support this requirement when creating the custom VTOTime_c object?. Master Detail Field on VTOTime__c to Project__c with rollup summary field on Project__c showing sum of hours from VTOTime_c records. Master Detail field on Project__c to VTOTime__c showing a list of VTOTime__c Records in a related list. LookUp field on VTOTime__c to Project_c with formula filed on Project__c showing Sum of hours from VTOTime__c records. Lookup Field on Project__c to VTOTime__C displaying a list of VTOTime__C in a related list.

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?. 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. Develop an Apex class that searches for duplicates and removes them nightly. Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.

Northern Trail Outfitters is planning to build a consent form to record customer authorization for marketing purposes. What should a data architect recommend to fulfill this requirement?. Use AppExchange solution to address the requirement. Utilize the Authorization Form Consent object to capture the consent. Use custom fields to capture the authorization details. Create a custom object to maintain the authorization.

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?. Lightning External Apps Starter. Partner Community. Customer Community Plus. Customer Community.

Universal Containers has an Agentforce Sales 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?. Build a nightly batch job to de dupe data, and merge account records. Do a bulk delete of all account records in Salesforce and a complete reload from the ERP. Build a nightly sync job from ERP to Salesforce. Implement a de-dupe solution and establish account ownership in Salesforce.

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?. Leverage a custom account and contact object in Salesforce. Leverage the person account object in Salesforce. Leverage a custom person account object in Salesforce. Leverage the standard account and contact object in Salesforce.

A large healthcare provider wishes to use Salesforce to track patient care. The following actors are in Salesforce: 1. Payment providers: Organizations who pay for the care to patients. 2. Doctors: They provide care plans for patients and need to support multiple patients. They are provided access to patient information. 3. Patients: These are individuals who need care. A data architect needs to map the actors to Salesforce objects. What should be the optimal selection by the data architect?. Patients as Contacts, Payment providers as Accounts, and Doctors as Accounts. Patients as Person Accounts, Payment providers as Accounts, and Doctors as Person Accounts. Patients as Person Accounts, Payment providers as Accounts, and Doctors as Person Accounts. Patients as Person Accounts, Payment providers as Accounts, and Doctors as Contacts.

Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types. Which solution should a data architect use to ensure successful data migrations?. Export legacy data into CSV files and leverage data loader to load data into Salesforce. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.

Northern Trail Outfitters (NTO) uses Agentforce Sales and Agentforce Service 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 and manage a data dictionary, and use a governance process for changes made to common objects. Create validation rules with error messages to explain why the field is used. Create reports to identify which fields users are leaving blank, and use external data sources to augment the missing data. Add description fields to explain why the field is used, and mark the fields as Required.

Universal Containers (UC) is building an Agentforce Service call center application and has a multi-system support solution. UC would like to ensure that all systems have access to the same customer information. What solution should a data architect recommend?. Let each system be an owner of data it generates. Implement a master data management (MDM) strategy for customer data. Load customer data in all systems. Make Salesforce the system of record for all data.

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?. Lookup to a custom object with defined choices. Provide help text to guide users with defined choices. Single-select restricted picklist with defined choices. Create a validation rule to limit entry to defined choices.

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?. Leverage Data Loader's platform API to load data. Perform a batch job in serial mode and reduce the batch size. Perform a batch job in parallel mode and reduce the batch size. Defer rollup summary field calculation during data migration.

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?. Maximum page size for server-driven paging. Maximum external objects per org. Maximum number of records returned. OData callout limits per day.

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?. Limit data loading to the 2,000 most recently created records. Add Custom Indexes on frequently searched Account and Contact fields. Create a Skinny Table to represent Account and Contact objects. Load only data that the user is permitted to access.

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?. Select Clear the value of this field option while configuring the lookup relationship. Change the lookup relationship to master-detail relationship. Create a custom object to maintain the relationship between products and customers. Create multiple similar products and distribute the skew across those products.

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?. Leverage external data providers to populate company profile and location data. Ask sales people to search for and populate company profile and location data. Export data out of Salesforce and send to another team to populate company profile and location data. Run reports to identify records which do not have company profile and location data.

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 hub org for change data and push into the spoke orgs. Develop custom APIs to poll the spoke org for change data and push into the hub org. A backup and archive solution that extracts and restores data across orgs. A middleware solution that extracts and distributes data across both the hub and spokes.