Updated Salesforce Data Architect Dumps (V10.03): Save a Lot of Time and Effort in your Salesforce Certified Data Architect Exam Preparation

1. Universal Containers (UC) has a very large and complex Salesforce org with hundreds of validation rules and triggers. The triggers are responsible for system updates and data manipulation as records arecreated or updates by users. A majority of the automation tool within UC’’ org were not designed to run during a data load. UC is importing 100,000 records into Salesforce across several objects over the weekend.

What should a data architect do to mitigate any unwanted results during the import?

2. UC is migrating data from legacy system to SF.

UC would like to preserve the following information on records being migrated:

✑ Date time stamps for created date and last modified date.

✑ Ownership of records belonging to inactive users being migrated to Salesforce.

Which 2 solutions should a data architect recommends to preserve the date timestamps and ownership on records? Choose 2 answers.

3. A company wants to document the data architecture of a Salesforce organization.

What are two valid metadata types that should be included? (Choose two.)

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

5. Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker.

What is a data quality problem that could cause this?

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

7. A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.

Which two approaches should the manager take to achieve this goal? (Choose two.)

8. NTO processes orders from its website via an order management system (OMS). The OMS stores over 2 million historical records and is currently not integrated with SF. The Sales team at NTO using Sales cloud and would like visibility into related customer orders yet they do not want to persist millions of records directly in Salesforce. NTO has asked the data architect to evaluate SF connect and the concept of data verification.

Which 3 considerations are needed prior to a SF Connect implementation? Choose 3 answers

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

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

11. Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC.

Which two common techniques are used building a data dictionary to store information on how business entities are defined?

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

13. Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.

What should a Data architect implement to make changes efficiently?

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

15. Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.

Which two solutionshould a data architect recommend to mitigate data quality issues?

16. Universal Container require all customers to provide either a phone number of an email address when registering for an account.

What should the data architect use to ensure this requirement is met?

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

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

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

20. Universal Container (US) 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?

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

22. 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:

23. UC has millions of case records with case history and SLA data. UC’s compliance team would like historical cases to be accessible for 10 years for Audit purpose.

What solution should a data architect recommend?

24. 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 change of encountering race condition on the same record.

What should a data architect recommend to guarantee that records are not being updated at the same time?

25. For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load.

Which two recommended options assign Account ownership to mitigate potential performance problems?

26. 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.)

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

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

29. Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level.

What is the recommended solution to address these requirements?

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

31. Universal Containers (UC) is transitioning from Classic to Lightning Experience.

What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

32. Marketing: All email, SMS, and social campaigns for a customer

Customer service agents using Salesforee would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.

What strategy should the data architect implement to satisfy this requirement?

33. Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, anditem color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce CustomerCommunity solution.

What is a correct technique UC should use to solve the data inconsistency?

34. Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed.

Which two techniques should be used for smooth interoperability now and in the future?

35. Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in parallel mode.

What should an Architect consider when loading the Opportunity records?

36. Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce.

What approach should be suggested to address this requirement?

37. A company has 12 million records, and a nightly integration queries these records.

Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

38. Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.

What should a data architect recommend for a daily backup and restore solution?

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

40. Patients: They are individuals who need care.

A data architect needs to map the actor to Sf objects.

What should be the optimal selection by the data architect?

41. A customer is operating in a highly reputated industry and is planning to implement SF.

The customer information maintained in SF, includes the following:

✑ Personally, identifiable information (PII)

✑ IP restrictions on profiles organized by Geographic location

✑ Financial records that need to be private and accessible only by the assigned Sales associate.

✑ User should not be allowed to export information from Salesforce.

Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity.

Which 3 Salesforce shield capabilities should a data architect recommend? Choose 3 answers:

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

43. UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.

Which 2 solutions should a data architect recommend to monitor and measure data quality? Choose 2 answers.

44. Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicate customer accounts, contacts, and leads. UC wants to fix this issue immediately by prompting users about a record that possibly exists in Salesforce. UC wants a report regarding duplicate records.

What would be the recommended approach to help UC start immediately?

45. Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used.

An Architect needs to determine which system is the system of record on a field level.

What should the Architect do to achieve this goal?

46. US is implementing salesforce and will be using salesforce to track customer complaints, provide white papers on products and provide subscription (Fee) C based support.

Which license type will US users need to fulfil US’s requirements?

47. Get Cloudy Consulting is migrating their legacy system's users and data to Salesforce. They will be creating 15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.

Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.

Which two approaches will accomplish this goal? (Choose two.)

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

49. DreamHouseRealty has an integration that creates records in a Salesforce Custom Object.

The Custom Object has a field marked as required on the page layout.

Dream House Realty has noticed that many of the records coming from the external system are missing data in this field.

The Architect needs to ensure this field always contains data coming from the source system.

Which two approaches should the Architect take? Choose 2 answers

50. A customer wants to maintain geographic location information including latitude and longitude in a custom object.

What would a data architect recommend to satisfy this requirement?

51. Marketing solution

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

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

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

54. UC has the following system:

✑ Billing system.

✑ Customer support system.

✑ CRM system.

US has been having trouble with business intelligence across the different systems. Recently US 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?

55. A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delaysquerying parents order IDs in Salesforce before importing related order line items.

What is the recommended solution?

56. The migrate will need occur within the next two month, prior to be split.

Which migrate strategy should a data architect use to successfully migrate the date?

57. UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.

Which 3 recommendationsshould the data architect make to avoid the data skew? Choose 3 answers.

58. Cloud Kicks has the following requirements:

- Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).

- A Salesforce administrator must be able tocustomize which fields will be sent to the external system without changing code.

What are two approaches for fulfilling these requirements? (Choose two.)

59. Each contact may attend multiple conferences and each conference may be related to multiple contacts.

How should a data architect modelthe relationship between the contact and conference objects?

60. Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce.

What are two automated approaches to fulfillthis goal? (Choose two.)

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

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

63. UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and order data into Salesforce as part of its master data management (MDM) strategy.

What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

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

65. Poor customer experience and higher costs

On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

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

67. DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out.

What should be considered to address this issue?

68. (NTO) has multiple salesforce orgs based on geographical reports (AMER, EMEA, APAC). NTO products are in the AMER org and need to be created in the EMEA and APAC after the products are approved.

Which two features should a data architect recommend to share records between salesforce orgs? Choose 2.

69. UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported.

What should a data architect recommend to make sure decrypted values areexported during data export?

70. Universal Containers (UC) is concerned about the accuracy of their Customer informationin Salesforce. They have recently created an enterprise-wide trusted source MDM for Customer data which they have certified to be accurate. UC has over 20 million unique customer records in the trusted source and Salesforce.

What should an Architect recommend to ensure the data in Salesforce is identical to the MDM?

71. NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.

Which 3activities will be required to identify a successful master data management strategy? Choose 3 answers:

72. Universal Containers has two systems. Salesforce and an on -premise ERP system. Anarchitect 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?

73. Universal Containers has a requirement to store more than 100 million records in salesforce and needs to create a custom big object to support this business requirement.

Which two tools should a data architect use to build custom object?

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

75. 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.)