jths 1

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 architecture commended to improve report performance?. Move data out of salesforce and run reporting on it. Create an aggregation custom object that summarized monthly and 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?. Improve existing point-to-point integrations. Data cleanse each system. Perform a one time synchronization to level set the built up inconsistencies. An MDM solution as customers master, with centralized integrations to ensure consistency across all systems.

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

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?. Leverage Salesforce weekly exports, and store data in flat files on a protected system. Utilize an ETL tool to migrate data to an on-premise archival solution. 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.

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

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.

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 on the platform?. Create a custom object to store the data. Implement a custom big object to store the data. Use the standard "Order" 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 customer-s are created in Salesforce. Configure Page Layout marking attributes as required fields. Create validation rules to check if required attributes are entered. Mark Fields for the attributes as required under Setup. Build validation in Integration with M DM 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 equality issues with account data. Which solutions should a data architect recommend to resolve the complaint?. Build a nightly batch job to de-dupe data, and merge account records. Build a nightly sync job from ERP to Salesforce. Do a bulk delete of all account records in Salesforce and a complete reload from ERP. 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. Implement a master data management (MDM) strategy for customer data. Load customer data in all systems. Let each system be an owner of data it generates.

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

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 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 big object in Einstein Analytics to capture the Loyalty Program data. Create a custom object in Salesforce that will be used 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?. 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. Load data in external database and provide access to database to sales users. Create a chatter group and upload all excel files to the group.

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 there requirements?. Bulk API. Data loader. Data export wizard. Thrid-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?. Create a custom field for Opportunity Amount that sales users update separating the field that PPS updates. 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 sales user updates. Change PPS integration to update only Opportunity Amount field when the value is null.

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?. Add description fields to explain why the field is used, and mark the fields as Required. 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.

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

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?. 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. Use Salesforce Connect to Integrate the website and the marketing system Into Service Console using external objects. Build customer view In Service Console with components that show website data and marketing data in mashup.

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

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

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 Project__c to VTOTime__C displaying a list of VTOTime__C in a related list. LookUp field on VTOTIme__c to ProJect__c with formula flled on ProJect__c showlnq 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. Master Detail field on Project__c to VTOTime__c showing a list of VTOTlme__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?. Lightning Platform Starter License. Service Cloud License. Sales Cloud License. Salesforce License.

Northern Trail Outfitters (NTO) plans to maintain contact preferences for customers and employees. NTO has implemented the following : Customers a re Person Accounts far their retail businesses. 1. Customers are represented as Contacts for theii commercial business, 2. Employees are maintained as Users. 3. 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 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. Create a Custom object to maintain preferences and build relationships to Lead, Person Account, and Users. Use individual objects to maintain the preference with relationships to Leads,Person Accounts 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?. Add LIMIT 100 to the query. Change query to SOSL. Remove description from the requested field set. 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?. Leverage real-time integration to pull records into Salesforce. Bring all data in Salesforce, and delete it after a year. Build a swivel chair solution to go into the legacy system and display records. 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 data nightly to the system of truth in a scheduled batch job. 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. 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 our of Salesforce Which solution should a data architect recommend as an archiving solution?. 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. 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.

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 Contract 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?. 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. Create a lookup relationship field on the Contact object. Create a master-detail relationship field on the Conference__c 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?. Enable granular locking. Remove SOQL statements from Apex Loops. Enable sharing recalculations. Ask Salesforce support for additional CPU power.

Northern Trail Outfltters 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. Single-select restricted picklist 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 ?. Bulk API. REST API. Streaming 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 standard account and contact object in Salesforce. Leverage the person account 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: Remove outdated information not required on a day-to-day basis. 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 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?. Archive records to a data warehouse and run analytics on the data warehouse. Leverage big objects to archive record and Einstein Analytics to run reports. Leverage custom objects to store aggregate data and run analytics. Leverage out-of-the-box reports and dashboard on case and interactive voice response (IVR) custom object.

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 Person Accounts, Payment providers as Accounts, and Doctors as Person Accounts. Patients as Contacts, Payment providers as Accounts, and Doctors as 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 update at the same time?. Embed the keywords FOR UPDATE after SOQL statements. Refactor or optimize classes and triggers for maximum CPU performance. Disable classes or triggers that have the potential to obtain the same record. 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?. Customer Community Lightning. External Apps Starter. Customer Community Plus. Partner Community.

Universal Containers (UC) is going through major reorganization of their sales team. This would require changes to a large 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 out all users and make change to sharing rules. Log a case with Salesforce to make sharing rule changes.

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. Contact Salesforce support to enable skinny table for cases. Build reports using custom Lightning components. Create a custom object to store aggregate data and run reports.

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 and "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. Defer rollup summary field calculation during data migration. Perform a batch job in parallel mode and reduce the batch size.

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. Add Custom Indexes on frequently searched Account and Contact fields. 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. Formatted Fields. Apex Trigger. 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?. 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 the staging database and leverage stored procedures to transform data types before loading into Salesforce. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce. Export legacy data into CSV files and leverage data loader to load data into Salesforce.

What should a data architect do to provide additional guidance for users when they enter information in a Standard field?. Create a custom page with help text for user guidance. Add custom help text in default value for the field. 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?. 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 data 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?. Reduce number of users updated concurrently. Enable granular locking. Analyze Splunk query to spot offending records. Increase CPU for the Salesforce org.

Universal Containers is preparing to implement Sales Cloud and would like its users to have Read Only access to an Account 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. Add appropriate users to the Account team. Create a criteria-based sharing rule. Implicit sharing will automatically handle this with standard functionality.

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 extract, transform, load (ETL) tool for extraction of records. Use the Rest API to extract data as it automatically chunks records by 200. Use a custom auto number and formula field to chunk records while extracting data. 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?. 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. 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.

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

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 Custom Object to store leads, and allow unprocessed leads to be reported. Save Apex errors in a custom object, and allow access to this object for reporting. Use Apex services to email failures to business when error occurs. Use AppExchange package to clean lead Information before Apex job processes them.

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

Universal Containers 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?. Implement shield platform encryption to encrypt custom and standard fields. Use Apex Crypto Class to encrypt custom and standard fields. Implement classic encryption to encrypt custom and standard fields. Export data out of Salesforce and encrypt custom and standard fields.

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

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

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

A large multinational B2C Salesforce customer is looking to implement their distributor management application in Salesforce. The application has the following capabilities: 1. Distributor 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. Manually update Opportunities with Prices applicable to distributors. Create lookup to Custom Price object and share with distributors.

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 is 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 seach for customers in Salesforce before they create the customers Which scalable option should a data architect choose to implement to avoid duplicates?. Create duplicate rules in Salesforce to validate duplicates during the account creation process. Build custom search based on fields on Accounts which can be matched with customer when they visit the store. Implement a MDM solution to validate the customer information before creating Accounts in Salesforce. Customize Account create process to search if customer exists before createing a Account.

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 split 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) 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?. Create multiple similar products and distribute the skew across those products. 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.

Universal Containers (UC) is implementing Salesforce for Lead management. UC procures lead data from multiple source 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 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 provides to populate company profile and location data. Run reports to identify records which do not have company profile and location data.

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