Salesforce Certified Data Architect Certification Dumps Free

Jonnie Karnath2023-06-08T07:56:13+00:00

The Salesforce Certified Data Architect Certification is designed for professionals who specialize in data architecture and management within the Salesforce ecosystem. This certification validates the candidate’s expertise in designing and implementing effective data solutions that meet business requirements. To aid candidates in their exam preparation, Certspots offers free dumps for the Salesforce Certified Data Architect Certification. These Data Architect dumps consist of practice questions that closely resemble the actual exam, allowing candidates to assess their knowledge, identify weak areas, and familiarize themselves with the exam format. By utilizing these Data Architect free dumps from Certspots, candidates can gain confidence, refine their understanding of data architecture principles, and increase their chances of success in the Salesforce Certified Data Architect Certification exam.

Page 1 of 7

1. 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?

Use Streaming API to get the current status from the ERP and display on the Opportunity page.

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

Create a custom object Invoice _c with a master -detail relationship with Opportunity.

Create a custom object Invoice _c with a Lookup relationship with Opportunity.

2. Universal Containers (UC) has a Salesforce instance with over 10.000Account records.

They have noticed similar, but not identical. Account names and addresses.

What should UC do to ensure proper data quality?

Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.

Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.

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

Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.

3. A large Automobile company has implemented SF for its Sales Associates. Leads flow from its website to SF using a batch integration in SF. The Batch job connects the leads to Accounts in SF. Customer visiting their retail stores are also created in SF as Accounts.

The company has noticed a large number of duplicate accounts in SF. 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 scalable option should a data Architect choose to implement to avoid duplicates?

Create duplicate rules in SF to validate duplicates during theaccount creation process

Implement a MDM solution to validate the customer information before creating Accounts in S

Build Custom search based on fields on Accounts which can be matched with customer when they visit the store

Customize Account creation process to search if customer exists before creating an Account.

4. Which two best practices should be followed when using SOSL for searching?

Use searches against single Objects for greater speed and accuracy.

Keep searches specific and avoid wildcards where possible.

Use SOSL option to ignore custom indexes as search fields arepre-indexed.

Use Find in “ALL FIELDS” for faster searches.

5. Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system it was discovered that same standard and custom fields need to encrypted.

Which solution should a data architect recommend to encrypt existing fields?

Use Apex Crypto Class encrypt customer and standard fields.

Implement classic encryption to encrypt custom and standard fields.

Implement shield platform encryption to encrypt and standard fields

Expert data out of Salesforce and encrypt custom and standard fields.

6. Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.

Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

Change each address field to required on the Page Layout.

Write an Apex Trigger to require all fields to be populated.

Utilize a Validation Rule with a REGEX operator on Postal Code.

Utilize a Validation Rule with a CONTAINS operator on address fields.

7. Marketing solution

What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

Store the salesforce id in all the solutions to identify the customer.

Create a custom object that will serve as a cross reference for the customer id.

Create a customer data base and use this id in all systems.

Create a custom field as external id to maintain the customer Id from the MDM solution.

8. NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.

Which 3 key factors should a data architect consider while defining data quality standards?

Choose 3 answers:

Define data duplication standards and rules

Define key fields in staging database for data cleansing

Measure data timeliness and consistency

Finalize an extract transform load (ETL) tool for data migration

Measure data completeness and accuracy

9. Cloud Kicks has the following requirements:

• Their Shipment custom object must alwaysrelate to a Product, a Sender, and a Receiver (all separate custom objects).

• If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed.

• Each custom object must have separate sharing models.

What should an Architect do to fulfill these requirements?

Associate the Shipment to each parent record by using a VLOOKUP formula field.

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

Create a Master-Detailrelationship to each of the three parent records.

Create two Master-Detail and one Lookup relationship to the parent records.

10. NTO has been using salesforce for sales and service for 10 years. For the past 2 years, the marketing group has noticed a raise from 0 to 35 % in returned mail when sending mail using the contact information stored in salesforce.

Which solution should the data architect use to reduce the amount of returned mails?

Use a 3rd-party data source to update contact information in salesforce.

Email all customer andasked them to verify their information and to call NTO if their address is incorrect.

Delete contacts when the mail is returned to save postal cost to NT

Have the sales team to call all existing customers and ask to verify the contact details.

Page 2 of 7

11. DreamHouse Realty has a legacy system that captures Branch Offices and Transactions.

DreamHouse Realty has 15 Branch Offices. Transactions can relate to anyBranch Office.

DreamHouse Realty has created hundreds of thousands of Transactions per year.

A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.

What are two important considerations for the Data Architect in this scenario? (Choose two.)

Standard list view in-line editing.

Limitations on Org data storage.

Bulk API limitations on picklist fields.

Limitations on master-detail relationships.

12. Which two statements are accurate with respect to performance testing a Force.com application?

All Force.com applications must be performance tested in a sandbox as well as production.

A performance test plan must be created and submitted to Salesforce customer support.

Applications with highly customized code or large volumes should be performance tested.

Application performance benchmarked in a sandbox can also be expected in production.

13. Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move.

What is a recommended solution for building data exploration dashboards in Salesforce?

Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.

Create a Dashboardin an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.

Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.

Create a Dashboard using AnalyticsCloud that will allow the user to create ad-hoc lenses and drill down.

14. UniversalContainers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted.

What statement is true with respect to a data archiving strategy for UC?

UC can store long-term lead records in custom storage objects to avoid countingagainst storage limits.

UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.

UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.

UC can leverage a “tier”-based approach to classify the record storage need.

15. The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and help managers take corrective actions where appropriate.

What is one reporting option Get Cloudy Consulting should consider?

Case SLA performance report

Sales KPI Dashboard

Opportunity analytic snapshot

Lead conversion rate report

16. What is an advantage of using Custom metadata type over Custom setting?

Custom metadata records are not copied from production to sandbox.

Custom metadata types are available for reporting.

Custom metadata records are deployable using packages.

Custom metadata records are editable in Apex.

17. UC has been using SF for 10 years. Lately, users have noticed, that the pages load slowly when viewing Customer and Account list view.

To mitigate, UC will implement a data archive strategy to reduce the amount of data actively loaded.

Which 2 tasks are required to define the strategy? Choose 2 answers:

Identify the recovery point objective.

Identify how the archive data will be accessed and used.

Identify the recovery time objective.

Identify the data retention requirements

18. 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?

Load Contact records together using the Streaming API via the Upsert operation.

Delete all existing records, and then load all records together via the Insert operation.

Load all records via the Upsert operation to determine new records vs. existing records.

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

19. 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

AppExchange Apps

Wave Analytics

Weekly Snapshots

Setup Audit Trails

20. The data architect for UC has written a SOQLquery 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 usages 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 SOS

Add limit 100 to the query.

Change the where clause to filter by a deterministic defined value.

Page 3 of 7

21. UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need to be synchronized with salesforce so that service agents are able to support customers directly within the service console. The remaining non- synchronized set of data will need to be accessed by salesforce at any point in time, but UC management is concerned about storage limitations.

What should a data architect recommend to meet these requirements with minimal effort?

Virtualize the remaining set of data with salesforce connect and external objects.

Use Heroku connect to bi-directional, sync all data between systems.

As needed, make call outs into Heroku postgres and persist the data in salesforce.

Migrate the data to big objects and leverage async SOQL with custom objects.

22. NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and data. NTO’s data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.

What 3 things should a data architect do to maintain the relationship hierarchy during migration?

Choose 3 answers:

Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.

Create a external id fieldfor each object in the target org and map source record ID’s to this field.

Redefine the master detail relationship fields to lookup relationship fields in the target org.

Replace source record ID’s with new record ID’s from the target org in the import file.

Keep the relationship fields populated with the source record ID’s in the import file.

23. 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

Index key fields used in report criteria.

Enable Divisions for large data objects.

Create one skinny table per report.

Share each report with fewer users.

24. Northern Trail Outfitters has these simple requirements for a data export process:

File format should be in CSV.

Process should be scheduled and run once per week.

The expert should be configurable through the Salesforce UI.

Which tool should a data architect leverage to accomplish these requirements?

Bulk API

Data export wizard

Third-party ETL tool

Data loader

25. 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?

Create indexes on Opportunity object text fields.

Group batches by the AccountId field.

Sortbatches by Name field values.

Order batches by Auto -number field.

26. Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year.

What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

Implement an archiving process for shipment records created after five years.

Implement an archiving process for shipment records created after three years.

Set Customer-Reference_c as anExternal ID (non-unique).

Set Customer-Reference_c as an External ID (unique).

27. Universal Containers (UC) is implementing Salesforce and will be using Salesforceto 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

Lightning Platform Starter License

Service Cloud License

Salesforce License

28. 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?

Account and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.

Whatever system updates the attribute orobject should be the system of record for that field or object.

Whatever integration data flow runs last will, by default, determine which system is the system of record.

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

29. Northern Trail Outfitters (NTO) has the following systems:

Customer master-source of truth for customer information

Service cloud-customer support

Marketing cloud-marketing support

Enterprise data warehouse―business reporting

The customer data is duplicated across all these system and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call into update their information.

NTO is planning to implement master data management (MDM) solution across the enterprise.

Which three data will an MDM tool solve? Choose 3 answers

Data completeness

Data loss and recovery

Data duplication

Data accuracy and quality

Data standardization

30. 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 theirsupport organization.

What first step is recommended to implement a reporting solution to measure the support reps case closure rates?

Enable field history tracking on the Case object.

Create a report on Case analytic snapshots.

Install AppExchange packages for available reports.

Create Contact and Opportunity Reports and Dashboards.

Page 4 of 7

31. A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.

The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store.

The sales associates use Global Search to search for customers in Salesforce before they create the customers.

Which option should a data architect choose to implement to avoid duplicates?

leverage duplicate rules in Salesforce to validate duplicates during the account creation process.

Develop an Apex class that searches for duplicates and removes them nightly.

Implement an MDM solution to validate the customer information before creating Salesforce.

Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.

32. UC has migrated its Back-office data into an on-premisedatabase with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.

UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.

Which design patterns should a data architect select to satisfy the requirement?

Migrate and persist the data in SF to take advantage of native functionality.

Use SF Connect to virtualize the data in SF and avoid storage limits.

Develop a bidirectional integration between the on-premise system and Salesforce.

Build a UI for the on-premise system and iframe it in Salesforce

33. The MDM solution provides de-duplication features, so it acts as the single source of truth.

How should a data architect implement the storage of master key within salesforce?

Store the master key in Heroku postgres and use Heroku connect for synchronization.

Create a custom object to store the master key with a lookup field to contact.

Create an external object to store the master key with a lookup field to contact.

Store the master key on the contact object as an external ID (Field for referential imports)

34. Universal containers is implementing Salesforce lead management. UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information.

Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

Ask sales people to search for populating company profile and location data

Run reports to identify records which does not have company profile and location data

Leverage external data providers populate company profile and location data

Export data out of Salesforce and send to another team to populate company profile and location data

35. NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external.

Which API is the best fit for accomplishing thistask?

Metadata API

Tooling API

Bulk API in serial mode

SOAP API

36. To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) and others, a SF customer decided to categorize each data element in SF with the following:

✑ Data owner

✑ Security Level, such as confidential

✑ Compliance types such as GDPR, PII, HIPPA

A compliance audit would require SF admins to generate reports to manage compliance.

What should a data architect recommend to address this requirement?

Use metadata API, to extract field attribute information and use the extract to classify and build reports

Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.

Create a custom object and field to capture necessary compliance information and build custom reports.

Build reports for field information, then export the information to classify and report for Audits.

37. A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company's containers, and they are starting to time out when users are trying to run the reports.

What is a recommended approach to avoid these time-out issues?

Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.

Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.

Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.

Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.

38. How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

Remove "customize application" permissions from everyone else.

Export the metadata and search it for the fields in question.

Create a field history report for the fields in question.

Export the setup audit trail and find the fieldsin question.

39. An Architect needs to document the data architecture for a multi-system, enterprise Salesforce implementation.

Which two key artifacts should the Architect use? (Choose two.)

User stories

Data model

Integration specification

Non-functional requirements

40. Sales Orders will not be updated in Salesforce.

What should a data architect recommend for maintaining Sales Orders in salesforce?

Us custom objects to maintain Sales Orders in Salesforce.

Use custom big objects to maintain Sales Orders in Salesforce.

Use external objects to maintain Sales Order in Salesforce.

Use Standard order object to maintain Sale Orders in Salesforce

Page 5 of 7

41. Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours.

The following requirements are needed:

A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization.

The finance users will not access to any sales objects, but they will need to interact with the custom object.

Which license type a data architect recommend for the finance team that best meets the requirements?

Service Cloud

Sales Cloud

Light Platform Start

Lighting platform plus

42. Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity data. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce.

What is the recommended course of action to appropriately integrate this new system?

The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

The Opportunity engagement system should become the system of record for Opportunity records.

Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

43. Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters.

Which two options can be used to improve report performance?

Ask support to create a skinny table for Application with the necessary reporting fields.

Add custom indexes to all fields on Application without a standard index.

Run multiple reports to get different pieces of the data and combine them.

Add custom indexes to the Date fields used for filtering the report.

44. Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand.

What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

Implement data archiving for old Shipment records.

Contact Salesforce to create Skinny tables on Shipment.

Configure shipment OWD to Public Read/Write.

Contact Salesforce to enable Defer Sharing Rules

45. Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.

What is the fastest and most effective way for a data architect to solve the time-out issue?

Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.

Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

46. An architect has been asked to provide errormessages 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

Implement a third -party validation process with translate functionality.

Create a trigger on Contact and add an error to the record with a custom label.

Create a workflow field update to set the standard ErrorMessage field.

Create a validation ruleand translate the error message with translation workbench.

47. A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:

State in which the customer is located

City in which the customer is located if available

Zip code In which the customer is located if available

Changes to this information should have minimum code changes

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 customer pricing engine.

Maintain require pricing criteria in custom metadata types.

Configure the pricing criteria in price books.

48. Ursa Major Solar has defined a new Data Quality Plan for their Salesforce data.

Which two approaches should an Architect recommend to enforce the plan throughout the organization? (Choose two.)

Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.

Schedule reports that will automatically catch duplicates and merge or delete the records every week.

Enforce critical business processes by using Workflow, Validation Rules, and Apex code.

Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

49. UC 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 shield platform encryption to encrypt files.

Use classic encryption to encrypt files.

Implement 3rd party App Exchange app to encrypt files.

Store files outside of salesforce and access them to real time.

50. Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc.

What is the recommended approach for defining a solution for this requirement?

Use a field audit trail to capture field changes.

Use a custom object and trigger to capture changes.

Use Event Monitoring to capture these changes.

Use a third-party AppExchange app to capture changes.

Page 6 of 7

51. UC has multiple SF orgs that aredistributed across regional branches. Each branch stores local customer data inside 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 orgs in one place.

What should a data architect suggest to achieve this 360-degree view of the customer?

Consolidate the data from each org into a centralized datastore

Use Salesforce Connect’s cross-org adapter.

Build a bidirectional integration between all orgs.

Use an ETL tool to migrate gap Accounts and Contacts into each org.

52. 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

Review the time zones of the User loading the data.

Remove custom indexes on the data being loaded.

Determine if the legacy system is still in use.

Defer sharing calculations of the Salesforce Org.

Deactivate approval processes and workflow rules.

53. UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B). UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.

Which 3 options should a data architect recommend to share data between Org A and Org B? Choose 3answers.

Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.

Install a 3rd party AppExchange tool to handle the data sharing

Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.

Leverage middleware tools to bidirectionally send Opportunity data across orgs.

Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects

54. 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?

Use a Lead standard report and filter on the Is Deleted standard field.

Use a Converted Lead report to display data on Leads that have been deleted.

Query Salesforce with the query All API method or using the ALL ROWS SOQL keywords.

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

55. What should a data architect do to provide additional guidance for users when they enter information in a standard field?

Provide custom help text under field properties.

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.

56. 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?

Create a Custom Object Individual Consumer c to load all individual consumers.

Load all individual consumers as Account records and avoid using the Contact object.

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

Create one Account and load individual consumers as Contacts linked to that one Account.

57. Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.

Which three recommendations should a data architect make is order to reduce the number of records from the org? Choose 3 answers

Use hard delete in Bulk API to permanently delete records from Salesforce.

Use hard delete in batch Apex to permanently delete records from Salesforce.

Identify records in objects that have not been modified or used In last 3 years.

Use Rest API to permanently delete records from the Salesforce org.

Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.

58. UC is trying to switch from legacy CRM to salesforce and wants to keeplegacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP.

What is the recommendation.

Integrate legacy CRM to salesforce and keep data in synch till newfunctionality is in place

Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP

Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce

Suggest MDM solution and link MDM to salesforce and SAP

59. 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?

Create a picklist field, values sorted alphabetically.

Create a Master -Detail to custom object ShippingStatus c.

Create a Lookup to custom object ShippingStatus c.

Create a text field and make it an external I

60. Universal Containers (UC) has a custom discount request object set as a detail object with a custom product object as the master. There is a requirement to allow the creation of generic discount requests without the custom product object as its master record.

What solution should an Architect recommend to UC?

Mandate the selection of a custom product for each discount request.

Create a placeholder product record for the generic discount request.

Remove the master-detail relationship and keep the objects separate.

Change the master-detail relationship to a lookup relationship.

Page 7 of 7

61. UC needs to load a large volume of leads into salesforce on a weekly basis. During this process the validation rules are disabled.

What should a data architect recommendto ensure data quality is maintained in salesforce.

Activate validation rules once the leads are loaded into salesforce to maintain quality.

Allow validation rules to be activated during the load of leads into salesforce.

Develop custom APEX batchprocess to improve quality once the load is completed.

Ensure the lead data is preprocessed for quality before loading into salesforce.

62. Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on aweekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc.

Which two recommended approaches would address the above requirement?

Use Field Audit History to capture operational data and extract it to on-premise systems.

Use Weekly Export to extract transactional data to on-premise systems.

Use a custom built extract job to extract operational data to on-premise systems.

Use Event Monitoring to extractevent data to on-premise systems.

63. 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

Use a workflow to check and prevent duplicates.

Clean data before importing to Salesforce.

Use Salesforce matching and duplicate rules.

Import the data concurrently.

64. Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants tomaintain data synchronization between systems.

Which two techniques should be used to achieve this goal? (Choose two.)

Integrate Salesforce with the ERP environment.

Utilize workbench to update files within systems.

Utilize an MDM strategy to outline a single source of truth.

Build synchronization reports and dashboards.

65. A customer is facing locking issued when importing large data volumes of order records that are children in amaster-detail relationship with the Account object.

What is the recommended way to avoid locking issues during import?

Import Account records first followed by order records after sorting order by OrderI

Import Account records first followed by order records after sorting orders by AccountI

Change the relationship to Lookup and update the relationship to master-detail after import.

Import Order records and Account records separately and populate AccountID in orders using batch Apex.

66. UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.

Which 2 solutions should a data architect recommend in order to minimize performance and storage issues? Choose 2 answers:

Export data out of salesforce and store in Flat files on external system.

Create a custom object to store case history and run reports on it.

Leverage on premise data archival and build integration to view archived data.

Leverage big object to archive case data and lightning components to show archived data.

Facebook Twitter LinkedIn Google + Email