Get Certified Easily with Online Data Architect Dumps

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

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

3. Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance issues and time-outs while running case reports in the Salesforce org.

Which solution should a data architect recommend to improve reporting performance?

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

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

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

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

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

9. What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

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

11. (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.

12. What makes Skinny tables fast? Choose three answers.

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

15. Universal Containers (UC) is in the process of migrating lagacy inventory data from an enterprise resources planning (ERP) system into Sales Cloud with the following requirements:

Legacy inventory data will be storedin a custom child objects called Inventory_c.

Inventory data should be related to the standard Account object.

The Inventory_c object should Inhent the same sharing rules as the Account object.

Anytime an Account record is deleted in Salesforce, the related Inventory_c record(s) should be deleted as well.

What type of relationship field should a data architect recommend in this scenario?

16. Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several optionsare being considered, including analytics snapshots, offsite storage, scheduled purges, etc.

Which three questions should be considered when designing an appropriate archiving strategy?

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

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

19. Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production.

What is the recommended approach to re-run the test?

20. A customer needs a sales model that allows the following:

✑ Opportunities need to be assigned to sales people based on the zip code. ✑ Each sales person can be assigned to multiple zip codes.

✑ Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.

What should a data architect recommend?

21. Universal Container is Implementing salesforce andneeds to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.

Which solution should a data architect recommend a clean migration?

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

23. Universal container (UC) would liketo build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00API calls into Salesfoce from an n-premises application daily.

Which license type should a data architect recommend that best fits these requirements?

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

25. Universal Containers (UC) has a data model as shown in the image. The Project object has a private sharing model, and it has Roll -Upsummary 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?

26. Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system.

Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

27. Developers at Universal Containers need to build areport for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system.

Which two options shouldbe recommended to make this report perform well and satisfy the business need?

28. Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Sales reps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics.

What solution addresses this requirement?

29. Poor customer experience and higher costs

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

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

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

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

33. Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields requiredthat have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields.

What is the simplest approach to handle this new requirement?

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

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

36. UC has a requirement to migrate 100 million order records from a legacy ERP application into the salesforce platform. UC does not have any requirements around reporting on the migrated data.

What should a data architect recommend to reduce the performance degradation of the platform?

37. Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing, UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.

What should a data architect recommend to mitigate these errors?

38. Universal Containers (UC) has implemented Salesforce, UC is running out of storage and needs to have an archiving solution, UC would like to maintaintwo years of data in Saleforce and archive older data out of Salesforce.

Which solution should a data architect recommend as an archiving solution?

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

40. Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.

What data extraction strategy should a data architect use for maximum performance?

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

42. Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this listis one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist.

Which two scalable strategies should UC consider to improve the quality of their Account addresses?

43. Marketing solution

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

44. As part of addressing general data protection regulation (GDPR) requirements, UC plans to implement a data classification policy for all its internal systems that stores customer information including salesforce.

What should a data architect recommend so that UC can easily classify consumer information maintained in salesforce under both standard and custom objects?

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

46. NTO uses opportunity forecast for its sales planning and management.

Sales users have noticed that their updates to the opportunity amount field are overwritten when PPS updates their opportunities.

How should a data architect address this overriding issue?

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

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

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

49. NTO uses salesforce to manage relationships andtrack sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.

Which 3 options should help improve the dashboard performance? Choose 3 answers:

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

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

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

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

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

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

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

57. NTO uses Opportunity Forecast for its sales planning and management.

Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updatestheir opportunities.

How should a data architect address this overwriting issue?

58. 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 berecommended to meet this requirement? Choose 2 answers

59. Ensure the customer has order information in another system.

60. Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:

- Accounts

- Contacts

- Opportunities

- Orders

- Order Line Items

Which issue will an architect have when implementing this in Salesforce?

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

62. Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource planning (ERP) as a customer master Sales team are complaining about duplicate account and data quality issues with account data.

Which two solution should a data architect recommend to resolve the complaints?

63. Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.

Which governance measure should a data architect recommend to solve this issue?