Salesforce Data Architecture and management

16) Managers at Universal Containers (UC) have noticed that shipment records (a custom object) are being sent to the shipping department with bad address data Specifically, addresses have missing data like City and poorly formatted Postal codes. Which two approaches will solve this issue? Choose 2 answers A. Edit each of the page layouts to require that each address field contains data. B. Use a Validation Rule using CONTAINS to ensure address fields contain data. C. Use a Validation Rule using REGEX to ensure proper Postal Code formatting. D. Write an Apex Trigger to require all of the fields on the page layouts.

A. C. Use a Validation Rule using REGEX to ensure proper Postal Code formatting. (regex is a function used in validation rules used to specify a format that entries should be entered in so that if they are not an error can be thrown.)

38) Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers A. Analytics/BI Owners B. Data Domain Stewards C. Salesforce Administrators D. Operational Data Users

A. Analytics/BI Owners B. Data Domain Stewards

47) Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers A. AppExchange Apps B. Wave Analytics C. Weekly Snapshots D. Setup Audit Trails

A. AppExchange Apps B. Wave Analytics

26) In a disparate multi -system ERP environment, where Salesforce is being deployed, what are two techniques that should be used to maintain data synchronization between systems? Choose 2 answers A. Build synchronization reports and dashboards. B. Integrate Salesforce with the ERP environment. C. Establish an MDM strategy to outline a single source of truth. D. Use workbench to update files within systems.

A. Build synchronization reports and dashboards. C. Establish an MDM strategy to outline a single source of truth.

10) Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met? A. Create a "before delete" trigger to check if the current user is not the owner. B. Set the Sharing settings as Public Read Only for the Contact object. C. Set the profile of the users to remove delete permission from the Contact object. D. Create a validation rule on the Contact object to check if the current user is not the owner.

A. Create a "before delete" trigger to check if the current user is not the owner. (You can't use a Validation Rule to prevent a Deletion. That has to be a trigger.)

12) Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answers A. Create a custom object to store a copy of the record when changed. B. Create a custom object to store the previous and new field values. C. Use Analytic Snapshots to store a copy of the record when changed. D. Select the 100 fields in the Opportunity Set History Tracking page.

A. Create a custom object to store a copy of the record when changed. B. Create a custom object to store the previous and new field values.

8) Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew? A. Create a picklist field, values sorted alphabetically. B. Create a Master -Detail to custom object ShippingStatus c. C. Create a Lookup to custom object ShippingStatus c. D. Create a text field and make it an external ID.

A. Create a picklist field, values sorted alphabetically.

1) Universal Containers wants their Shipment custom object to always relate to a Container, a Sender, and a Receiver (all separate custom objects). If a Shipment is currently associated with a Container, Sender, or Receiver, deletion of those records should not be allowed. They also want separate sharing models on each custom object. What approach should an architect take to fulfill these requirements? A. Create a required Lookup relationship to each of the three parent records. B. Create two Master -Detail and one Lookup relationship to the parent records. C. Create a Master -Detail relationship to each of the three parent records. D. Use a VLOOKUP formula field to associate the Shipment to each parent record.

A. Create a required Lookup relationship to each of the three parent records.

51) Universal Containers is migrating their legacy system's users and data to Salesforce. They will be creating 10,000 users,2 million Account records, and 10 million Invoice records. The visibility of these records is controlled by a few dozen owner and criteria -based sharing rules. What are two approaches that will minimize data loading time during this migration to a new organization? Choose 2 answers A. Create the users, upload all data, and then deploy the sharing rules. B. Contact Salesforce to activate indexing before uploading the data. C. First, load all account records, and then load all user records. D. Defer sharing calculations until the data has finished uploading.

A. Create the users, upload all data, and then deploy the sharing rules. D. Defer sharing calculations until the data has finished uploading. In this case, the order would be to Load users Load accounts Load opportunities

36) A customer monitors over 10,000 servers and these servers automatically record their status every 15 minutes The customer is required to maintain all of these status reports for a period of 10 years. Service Reps need access to up to one week's worth of these status reports with all of their details. What are two limits an architect should consider when recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce? Choose 2 answers A. Data storage limits B. API Request limits C. Webservice callout limits D. Workflow rule limits

A. Data storage limits B. API Request limits (There is nothing like webservice)

42) Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates? A. Enable field history tracking on the Case object. B. Create a report on Case analytic snapshots. C. Install AppExchange packages for available reports. D. Create Contact and Opportunity Reports and Dashboards.

A. Enable field history tracking on the Case object.

41) To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert? A. Errors with duplicate external Id values within the same CSV file. B. Errors with records being updated and inserted in the same CSV file. C. Errors when a duplicate Contact name is found cause upsert to fail. D. Errors with using the wrong external Id will cause the load to fail.

A. Errors with duplicate external Id values within the same CSV file. What if there are more than one records in Salesforce with Same external Id ? In this case Dataloader or Apex will throw an error saying "Duplicate external id specified".

58) universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers A. Index key fields used in report criteria. B. Enable Divisions for large data objects. C. Create one skinny table per report. D. Share each report with fewer users.

A. Index key fields used in report criteria. C. Create one skinny table per report.

60) Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project? Choose 2 answers A. Pre -go -live automated page -load testing against the Salesforce Full sandbox. B. Post go -live automated page -load testing against the Salesforce Production org. C. Pre -go -live unit testing in the Salesforce Full sandbox. D. Stress testing against the web services hosted by the integration middleware.

A. Pre -go -live automated page -load testing against the Salesforce Full sandbox. D. Stress testing against the web services hosted by the integration middleware.

28) What are two valid metadata types that should be included to document the data architecture of a Salesforce org? Choose 2 answers A. RecordType B. Document C. CustomField D. SecuritySettings

A. RecordType C. CustomField

34) Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan? A. Reduce data storage by purging old data. B. Implement an AppExchange package. C. Review projected data storage needs. D. Schedule a weekly export file.

A. Reduce data storage by purging old data.

40) A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers A. Review the metadata xml files for redundant fields to consolidate. B. Determine if any integration points create records in Salesforce. C. Run key reports to determine what fields should be required. D. Export the setup audit trail to review what fields are being used. E. Review the sharing model to determine impact on duplicate records.

A. Review the metadata xml files for redundant fields to consolidate. C. Run key reports to determine what fields should be required. E. Review the sharing model to determine impact on duplicate records.

44) In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce? A. Salesforce allows up to four objects in a single report type. B. Salesforce does not support Orders or Order Line Items. C. A report cannot contain data from Accounts and Contacts. D. Custom report types cannot contain Opportunity data.

A. Salesforce allows up to four objects in a single report type. Object Limit Reached You can associate up to four objects to a custom report type.

33) Which two automated approaches should an architect recommend to purge old data out of Salesforce and aggregate that data in Salesforce? Choose 2 answers A. Schedulable Batch Apex B. Third -party Business Intelligence system C. Third -party Integration Tool (ETL) D. Apex Triggers

A. Schedulable Batch Apex C. Third -party Integration Tool (ETL)

18) Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan? Choose 2 answers A. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review. B. Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes. C. Schedule reports that will automatically catch duplicates and merge or delete the records every week. D. Store all data in an external system and set up an integration to Salesforce for view -only access.

A. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review. B. Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.

21) A customer has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout. The customer has noticed that many of the records coming from the external system are missing data in this field. What two things should the architect do to ensure this field always contains data coming from the source system? Choose 2 answers A. Set up a Validation Rule to prevent blank values. B. Create a Workflow to default a value into this field. C. Mark the field required in setup at the field level. D. Blame the customer's external system for bad data.

A. Set up a Validation Rule to prevent blank values. C. Mark the field required in setup at the field level.

48) Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process? A. Use the SOAP API to export data. B. Utilize the Bulk API to export the data. C. Use GZIP compression to export the data. D. Schedule a Batch Apex job to export the data.

B

55) An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records? A. Create indexes on Opportunity object text fields. B. Group batches by the AccountId field. C. Sort batches by Name field values. D. Order batches by Auto -number field.

B

45) Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers A. Create a report in an external system combining Salesforce Account data and Invoice data from the ERP. B. Create a report combining data from the Account standard object and the Invoices external object. C. Create a Visualforce page combining Salesforce Account data and Invoice external object data. D. Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.

B C. Create a Visualforce page combining Salesforce Account data and Invoice external object data. SOQL, Visualforce, APEX, Reports can be used on External Objects

52) Universal Containers wishes to send data from Salesforce to an external system to generate invoices from their Order Management System (OMS). They want a Salesforce administrator to be able to customize which fields be sent to the external system without modifying code. What two approaches should an architect recommend to deliver the desired solution? Choose 2 answers A. A set<sobjectFieldset> to determine which fields to send in an HTTP callout. B. An Outbound Message to determine which fields to send to the OMS. C. A Field Set that determines which fields to send in an HTTP callout. D. Enable the field -level security permissions for the fields to send.

B. An Outbound Message to determine which fields to send to the OMS. C. A Field Set that determines which fields to send in an HTTP callout.

35) A Salesforce customer has millions of orders every year. Each order contains, on average, ten line items. The customer wants its Sales Reps to know how much money each customer generates year -over -year, but they are running out of data storage in Salesforce. What data archiving plan should the architect recommend? A. Annually delete orders and order line items and ensure the customer has order information in another system. B. Annually aggregate order amount data to store in a custom object, then delete those orders and order line items. c Annually export and delete orders and order line items and store them in a zip file in case the data is needed later. D. Annually export and delete order line items and store them in a zip file in case they data is needed later.

B. Annually aggregate order amount data to store in a custom object, then delete those orders and order line items.

14) Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers A. Use a workflow to check and prevent duplicates. B. Clean data before importing to Salesforce. C. Use Salesforce matching and duplicate rules. D. Import the data concurrently.

B. Clean data before importing to Salesforce. C. Use Salesforce matching and duplicate rules.

3) An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers A. Implement a third -party validation process with translate functionality. B. Create a trigger on Contact and add an error to the record with a custom label. C. Create a workflow field update to set the standard ErrorMessage field. D. Create a validation rule and translate the error message with translation workbench.

B. Create a trigger on Contact and add an error to the record with a custom label. D. Create a validation rule and translate the error message with translation workbench.

11) Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space? A. Use Streaming API to get the current status from the ERP and display on the Opportunity page. B. Create an external object Invoice _x with a Lookup relationship with Opportunity. C. Create a custom object Invoice _c with a master -detail relationship with Opportunity. D. Create a custom object Invoice _c with a Lookup relationship with Opportunity.

B. Create an external object Invoice _x with a Lookup relationship with Opportunity.

29) What are two key artifacts used to document the data architecture for a multi -system enterprise Salesforce implementation? Choose 2 answers A. User stories B. Data model C. Non-functional requirements D. Integration specification

B. Data model D. Integration specification

22) Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution? A. Implement a Master Data Management system to determine system of record. B. Implement a workflow rule that sends Opportunity data through Outbound Messaging. C. Have the ERP poll Salesforce nightly and bring in the desired Opportunities. D. Implement an hourly integration to send Salesforce Opportunities to the ERP system.

B. Implement a workflow rule that sends Opportunity data through Outbound Messaging.

56) Universal Containers has more than 10 million records in the Order _c object. The query has timed out when running a bulk query. What should be considered to resolve query timeout? A. Tooling API B. PK Chunking C. Metadata API D. Streaming API

B. PK Chunking

20) which two methods should be used when importing Leads into Salesforce to ensure there are no duplicate records? Choose 2 answers A. Create a Workflow Rule to check for duplicate records. B. Purchase an AppExchange Lead de -duplication application. C. Implement Salesforce Matching and Duplicate Rules. D. Run the Salesforce Lead Mass de -duplication tool.

B. Purchase an AppExchange Lead de -duplication application. C. Implement Salesforce Matching and Duplicate Rules.

30) As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers A. Review the setup audit trail for configuration changes. B. Put the business purpose in the Description of each field. C. Maintain a data dictionary with the justification for each field. D. Use the Force.com IDE to save the metadata files in source control.

B. Put the business purpose in the Description of each field. C. Maintain a data dictionary with the justification for each field.

53) The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers A. Review the time zones of the User loading the data. B. Remove custom indexes on the data being loaded. C. Determine if the legacy system is still in use. D. Defer sharing calculations of the Salesforce Org. E. Deactivate approval processes and workflow rules.

B. Remove custom indexes on the data being loaded. D. Defer sharing calculations of the Salesforce Org. E. Deactivate approval processes and workflow rules.

17) Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers A. Make use of a third -party tool to help merge duplicate Contacts across Accounts. B. Use Data.com to standardize Contact address information to help identify duplicates. C. Use Workflow rules to standardize Contact information to identify and prevent duplicates. D. Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

B. Use Data.com to standardize Contact address information to help identify duplicates. D.

13) In a Salesforce org used to manage Contacts, what two options should be considered to maintain data quality? Choose 2 answers A. Use the private sharing model. B. Use Salesforce duplicate management. C. Use validation rules on new record create and edit. D. Use workflow to delete duplicate records.

B. Use Salesforce duplicate management. C. Use validation rules on new record create and edit.

7) Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers A. Use SOQL queries without WHERE conditions. B. Work with Salesforce Support to enable Skinny Tables. C. Reduce the number of triggers on Order _c object. D. Make the queries more selective using indexed fields.

B. Work with Salesforce Support to enable Skinny Tables. D. Make the queries more selective using indexed fields.

9)Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers A. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields. B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object. C. LII Turn on field Contact object history tracking for these ten fields, then create reports on contact history. D. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object. C. LII Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

50) Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com? A. Load all data using external IDs to link to parent records. B. Use workflow to calculate summary values instead of Roll -Up. C. Use triggers to calculate summary values instead of Roll -Up. D. Load all data after deferring sharing calculations.

C

59) Universal Containers (UC) has over 10 million records. They have a nightly integration that queries these records The queries are timing out What should the data architect do or look for when troubleshooting the queries? Choose 2 answers A. Change the integration users' profile to have View All Data. B. Ensure the query doesn't contain NULL in any filter criteria. C. Create custom indexes on the fields used in the filter criteria. D. Create a formula field instead of having multiple filter criteria.

C B. Ensure the query doesn't contain NULL in any filter criteria.

37) A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren't relevant any longer. Sales Managers need the data for their historical reporting.What strategy should a data architect use to ensure a better user experience for the Sales Reps? A. Create a Permission Set to hide old data from Sales Reps. B. Use Batch Apex to archive old data on a rolling nightly basis. C. Archive and purge old data from Salesforce on a monthly basis. D. Set data access to Private to hide old data from Sales Reps.

C. Archive and purge old data from Salesforce on a monthly basis.

6) Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers A. Limitations on master -detail relationships. B. Org data storage limitations. C. Bulk API limitations on picklist fields. D. Standard list view in -line editing.

C. Bulk API limitations on picklist fields. D. Standard list view in -line editing.

4) What is an advantage of using Custom metadata type over Custom setting? A. Custom metadata records are not copied from production to sandbox. B. Custom metadata types are available for reporting. C. Custom metadata records are deployable using packages. D. Custom metadata records are editable in Apex.

C. Custom metadata records are deployable using packages. (Reporting no support, Not editable via APEX)

2) Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement? A. After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field. B. Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security. C. Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration. D. Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.

C. Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.

39) Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers A. Engage with IT program managers to assess current velocity of projects in the pipeline. B. Engage with database administrators to assess current database performance metrics. C. Engage with executive sponsorship to assess enterprise data strategy and goals. D. Engage with business units and IT to assess current operational systems and data models.

C. Engage with executive sponsorship to assess enterprise data strategy and goals. D. Engage with business units and IT to assess current operational systems and data models.

23) Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met? A. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts. B. Implement an integration tool to send OMS Accounts and Contacts to Salesforce. C. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts. D. Use the Streaming API to send Account and Contact data from Salesforce to the OMS.

C. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.

49) Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues? A. Create a Custom Object Individual Consumer c to load all individual consumers. B. Load all individual consumers as Account records and avoid using the Contact object. C. Load one Account record and one Contact record for each individual consumer. D. Create one Account and load individual consumers as Contacts linked to that one Account.

C. Load one Account record and one Contact record for each individual consumer.

32) Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers A. Use the Force.com Workbench to export the data. B. Schedule a weekly export file from the Salesforce UI. C. Schedule jobs to export and delete using an ETL tool. D. Schedule jobs to export and delete using the Data Loader.

C. Schedule jobs to export and delete using an ETL tool. D. Schedule jobs to export and delete using the Data Loader.

19) Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend? A. Allow users to import their data using the Salesforce Import tools. B. Utilize a 3rd -party solution from the AppExchange for data uploads. C. Utilize an app from the AppExchange to create data -quality dashboards. D. Use Apex to validate the format of phone numbers and postal codes.

C. Utilize an app from the AppExchange to create data -quality dashboards.

24) An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution? Choose 2 answers A. Whether the systems are cloud -based or on -premise. B. Whether or not Salesforce replaced a legacy CRM. C. Whether the system of record changes for different tables. D. The number of systems that are integrating with each other.

C. Whether the system of record changes for different tables. D. The number of systems that are integrating with each other.

31) How can an architect find information about who is creating, changing, or deleting certain fields within the past two months? A. Remove "customize application" permissions from everyone else. B. Export the metadata and search it for the fields in question. C. Create a field history report for the fields in question. D. Export the setup audit trail and find the fields in question.

D. Export the setup audit trail and find the fields in question.

57) Global Containers (GC) just acquired Universal Containers (UC). Both companies use Salesforce. and as part of the acquisition, all of the data for the UC Salesforce instance (source) must be migrated into the GC Salesforce instance (target). Universal Containers has over 5 million Case records. What should the architect consider when trying to optimize the data load time? A. Use the Salesforce Org Migration Tool from the Setup Data Management menu. B. Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled. C. Load Case data directly leveraging Salesforce-to-Salesforce functionality. D. Break the load into multiple sets of data to be loaded using Bulk API parallel processes.

D

5) The invoicing system at Universal Containers requires that attachments associated with the Invoice _c custom object be classified by Types (i.e., "Receipt," "Invoice PDF," etc.) so that reporting can be done on invoices showing the number of attachments grouped by Type. What approach should be taken to categorize the attachments to meet these requirements? A. Add additional options to the standard ContentType picklist field for the Attachment object. B. Add a ContentType picklist field to the Attachment layout and create additional picklist options. C. Create a custom picklist field for the Type on the standard Attachment object with the values. D. Create a custom object related to the Invoice object with a picklist field for the Type.

D. Create a custom object related to the Invoice object with a picklist field for the Type.

27) All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems: • An ERP system feeds order data into Salesforce and updates both Account and Opportunity records. • An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records. • A commission system feeds commission data into Salesforce and updates both Account and Opportunity records. How should the architect determine which of these systems is the system of record? A. Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record. B. Whatever system updates the attribute or object should be the system of record for that field or object. C. Whatever integration data flow runs last will, by default, determine which system is the system of record. D. Data flows should be reviewed with the business users to determine the system of record per object or field.

D. Data flows should be reviewed with the business users to determine the system of record per object or field.

54) Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time? A. Load Contact records together using the Streaming API via the Upsert operation. B. Delete all existing records, and then load all records together via the Insert operation. C. Load all records via the Upsert operation to determine new records vs. existing records. D. Load new records via the Insert operation and existing records via the Update operation.

D. Load new records via the Insert operation and existing records via the Update operation.

43) Universal Containers uses Salesforce to track its sales opportunities The Sales VP would like to better understand key relevant performance figures and help the Sales Managers take corrective actions where appropriate. What reporting option should be considered? A. Opportunity analytic snapshot B. Case SLA performance report C. Lead conversion rate report D. Sales KPI Dashboard

D. Sales KPI Dashboard

46) Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin. What approach should be implemented to achieve this solution? A. Use a Lead standard report and filter on the IsDeleted standard field. B. Use a Converted Lead report to display data on Leads that have been deleted. C. Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords. D. Send data to a Data Warehouse and mark Leads as deleted in that system.

D. Send data to a Data Warehouse and mark Leads as deleted in that system.

15) Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality? A. Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules. B. Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts. c. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts. D. Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.

c. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

25) A customer is integrating two different systems with customer records into the Salesforce Account object Master Data Management will be used to ensure that no duplicate records are created in Salesforce. How can the architect determine which system is the system of record on a field level? A. Any field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record. B. Review the database schema for each external system and any fields with different names should always be separate fields in Salesforce. c. Master Data Management systems determine system of record and the architect doesn't have to think about what data is controlled by what system. D. Any Fields with the same purpose between the two systems should be reviewed by the key stakeholders to see how they will be used in Salesforce.

c. Master Data Management systems determine system of record and the architect doesn't have to think about what data is controlled by what system.