Salesforce Data-Architect Salesforce Certified Data Architect (WI23) Exam Exam Practice Test Questions

• Question 1

  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?

  • Let a ''system user'' own all the Account records without assigning any role to this user in Role Hierarchy.
  • Let a ''system user'' own the Account records and assign this user to the lowest-level role in the Role Hierarchy.
  • Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.
  • Let a ''system user'' own all the Account records and make this user part of the highest-level role in the Role Hierarchy.

  Show Answer Answer: A, B Next

• Question 2

  Northern Trail Outfitters (NTO) has a variety of customers that include householder, businesses, and individuals.The following conditions exist within its system:NTO has a total of five million customers.Duplicate records exist, which is replicated across many systems, including Salesforce.Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.Which three option should a data architect perform to resolve the issues with the customer data?

  • Create a unique global customer ID for each customer and store that in all system for referential identity.
  • Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.
  • Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.
  • Duplicate customer records across the system and provide a two-way sync of data between the systems.
  • Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.

  Show Answer Answer: A, C, E Next

• Question 3

  UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an ''Unable to lock a row'' error.Which solution should a data architect recommend, to resolve the error?

  • Leverage data loader platform API to load data.
  • Perform Batch job in parallel mode and reduce Batch size
  • Perform Batch job in serial mode and reduce batch size
  • Defer roll-up summary fields calculation during data migration.

  Show Answer Answer: B Next

• Question 4

  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 to customize which fields will be sent to the external system without changing code.What are two approaches for fulfilling these requirements? (Choose two.)

  • A set to determine which fields to send in an HTTP callout.
  • An Outbound Message to determine which fields to send to the OMS.
  • A Field Set that determines which fields to send in an HTTP callout.
  • Enable the field -level security permissions for the fields to send.

  Show Answer Answer: B, C Next

• Question 5

  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 3 activities will be required to identify a successful master data management strategy? Choose 3 answers:

  • Identify data to be replicated
  • Create a data archive strategy
  • Define the systems of record for critical data
  • Install a data warehouse
  • Choose a Business Intelligence tool.

  Show Answer Answer: A, B, C Next