DA3

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

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.

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?. Bidirectional integration. Persistence. Unidirectional integration. Virtualization.

Universal 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?. 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. Utilize an ETL tool to migrate data to an on-premise archival solution.

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. What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?. Assign the pricing criteria within custom pricing engine. Configure the pricing criteria in price books. Maintain required pricing criteria in custom metadata types. Create a custom object to maintain the pricing criteria.

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?. 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. Use Data Classification metadata fields available in Field definition.

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?. 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. Use a standard big object defined by Salesforce.

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?. Configure Page Layout marking attributes as required fields. Mark Fields for the attributes as required under Setup. Create validation rules to check if the required attributes are entered. Build validation in Integration with MDM to check required attributes.

Universal Containers has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master. Sales teams are complaining about duplicate account records and data quality issues with account data. Which solution should a data architect recommend to resolve the complaints?. Build a nightly sync job from ERP to Salesforce. Do a bulk delete of all account records in Salesforce and a complete reload from the ERP. Build a nightly batch job to de-dupe data, and merge account records. Implement a de-dupe solution and establish account ownership in Salesforce.

Universal Containers (UC) is building a Service Cloud 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?. Make Salesforce the system of record for all data. Let each system be an owner of data it generates. Load customer data in all systems. Implement a master data management (MDM) strategy for customer data.

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 external objects to maintain 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.

Northern Trail Outfitters (NTO) wants to start a loyalty program to reward repeat customers under the following conditions: 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 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. 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.

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?. 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. Create a custom object and upload all Excel files to the group. Change the lookup relationship to master-detail relationship.

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.

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 PPS integration to update only Opportunity Amount field when the value is null. Create a custom field for Opportunity Amount that sales users update. Change Opportunity Amount field access to Read Only for sales users using field-level security. Create a custom field for Opportunity amount that PPS updates, separating the field that sales user updates.

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 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. Create and manage a data dictionary, and use governance process for changes made to common objects.

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 custom fields to capture the authorization details. Create a custom object to maintain the authorization. Utilize the Authorization Form Consent object to capture the consent. Use AppExchange solution to address the requirement.

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?. Lightning Platform Starter. Service Cloud. Sales Cloud. Lightning Platform Plus.

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?. Build customer view in Service Console with components that show website data and marketing data as mashup. Use Salesforce Connect to integrate the website and the marketing system into Service Console using external objects. Create web tabs in Service Console to show website and marketing activities. Build custom components in Service Console to bring information from the marketing and website information.

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 custom object and migrate the last 12 months of invoice data into Salesforce so it can be displayed on the Account layout. Create mashup page that will present the billing system records within Salesforce. Create a visual force tab with the billing system encapsulated within an iframe.

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. Full name. Phone number. Email address.

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?. 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. None of the above.

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?. LookUp field on VTOTime__c to Project__c with formula field on Project__c showing Sum of hours from VTOTime__c records. Master Detail Field on VTOTime__c to Project__c with rollup summary field 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. Master Detail field on Project__c to VTOTime__c showing a list of VTOTime__c Records in a related list.

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?. Sales Cloud License. Salesforce License. Lightning Platform Starter License. Service Cloud License.

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.

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?. Remove description from the requested field set. Change query to SOSL. Add LIMIT 100 to the query. Change the WHERE clause to filter by a deterministic defined value.

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

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.

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. Build a batch job to move all 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 all records from Salesforce.

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 data architect recommend as a migration and storage strategy?. Migrate data to a centralized datastore first with ETL tools. Import all data into custom objects with middleware. Import all data into custom objects with data loader. Use an ETL tool to extract and transform the data, then load into standard objects.

Universal Containers is building a Salesforce application to track Contacts and the respective Conferences that they have attended with the following requirements: 1. Contacts will be stored in the standard Contact object 2. Conferences will be stored in a custom Conference__c object 3. Each Contact may attend multiple Conferences and each Conference may be related to multiple Contacts. How should a data architect model the relationship between the Contact and Conference__c objects?. 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. Create a master-detail relationship field on the Contact object.

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 sharing recalculations. Enable granular locking.

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

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

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

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?. 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. Identify a location to store archived data, and move data to the location using a time-based workflow.

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 big objects to archive records and Einstein Analytics to run reports. Archive records to a data warehouse and run analytics on the data warehouse. Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object. Leverage custom objects to store aggregate data and run analytics.

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 Contacts. Patients as Accounts, Payment providers as Accounts, and Doctors as Person Accounts.

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?. Disable classes or triggers that have the potential to obtain the same record. Refactor or optimize classes and triggers for maximum CPU performance. Embed the keywords FOR UPDATE after SOQL statements. Migrate programmatic logic to processes and flows.

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. Customer Community Plus.

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

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

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

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?. Work Flow Rules. Apex Trigger. Formatted Fields. Validation Rules.

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 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. Export legacy data into CSV files and leverage data loader to load data into Salesforce. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.

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

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

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?. Enable Defer Sharing Calculation. Analyze Splunk query to spot offending records. Increase CPU for the Salesforce org. Reduce number of users updated concurrently.

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

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?. Create an owner-based sharing rule. Implicit sharing will automatically handle this with standard functionality. Create a criteria-based sharing rule. Add appropriate users to the Account team.

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

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. Use a backup and archive solution that extracts and restores data across orgs. 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.

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?. Build a bidirectional integration between all orgs. Use an ETL tool to migrate gap Accounts and Contacts into each org. Use the Salesforce Connect cross-org adapter. Consolidate the data from each org into a centralized datastore.

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?. 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. Use Apex services to email failures to business when error occurs.

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

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?. External APIs. Federated Search. Salesforce Connect. Salesforce to Salesforce.

Universal Containers is implementing Sales Cloud for patient management and would like to encrypt sensitive patient records being stored in files. Which solution should a data architect recommend to solve this requirement?. 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. Implement Shield Platform Encryption to encrypt files.

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

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

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. How should the data architect model this requirement?. Create lookup to Custom Price object and share with distributors. Add custom fields in Opportunity and use triggers to update prices. Configure Price Books for each region and share with distributors. Use custom objects to maintain Sales Orders in Salesforce.

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. Leverage duplicate rules in Salesforce to validate duplicates during the account creation process. Develop an Apex class that searches for duplicates and removes them nightly. Implement an MDM solution to validate the customer information before creating Accounts in Salesforce.

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: 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 split. Which migration strategy should a data architect use to successfully migrate the data?. Use Data Loader for export and Data Import Wizard for import. Write a script to use the Bulk API. Use an ETL tool to orchestrate the migration. Use the Salesforce CLI to query, export, and import.

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