Salesforce DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Online Questions & Answers

• Question 101:

  Universal Containers (UC) has migrated its back-office data into an on-premise database with REST API access. UC recently implemented Sales Cloud for its sales organization, but users are complaining about a lack of order data inside

  Salesforce.

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

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

  A. Develop a bidirectional integration between the on-premise system and Salesforce
  B. Use Salesforce Connect to virtualize the data in Salesforce and avoid storage limits
  C. Migrate and persist the data in Salesforce to take advantage of native functionality
  D. Build a UI for the on-premise system and iframe it in Salesforce
  B. Use Salesforce Connect to virtualize the data in Salesforce and avoid storage limits

• Question 102:

  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.

• Question 103:

  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?

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

• Question 104:

  Universal Containers (UC) has a variety of systems across its technology landscape, including Salesforce, 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 strategy.

  What are the three key steps that a data architect should take when merging data from multiple systems into Salesforce? (Choose three.)

  A. Analyze each system's data model and perform gap analysis
  B. Create new fields to store additional values from all of the systems
  C. Install a third-party AppExchange tool to handle the merger
  D. Utilize an ETL tool to migrate, transform, and deduplicate data
  E. Work with stakeholders to define record and field survivorship rules
  C. Install a third-party AppExchange tool to handle the merger
  D. Utilize an ETL tool to migrate, transform, and deduplicate data
  E. Work with stakeholders to define record and field survivorship rules

• Question 105:

  Universal Containers has a rollup summary field on account to calculate the count of contacts associated with an account. During the account load, Salesforce is throwing an "Unable to lock a row" error. Which solution should a data architect recommend to resolve the error?

  A. Perform batch job in parallel mode, and reduce batch size
  B. Defer rollup summary fields calculation during data migration
  C. Leverage data loader platform API to load data
  D. Perform batch job in serial mode, and reduce batch size
  D. Perform batch job in serial mode, and reduce batch size

• Question 106:

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

  A. Use searches against single Objects for greater speed and accuracy.
  B. Keep searches specific and avoid wildcards where possible.
  C. Use SOSL option to ignore custom indexes as search fields are pre-indexed.
  D. Use Find in "ALL FIELDS" for faster searches.
  B. Keep searches specific and avoid wildcards where possible.
  D. Use Find in "ALL FIELDS" for faster searches.

• Question 107:

  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?

  A. Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.
  B. Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.
  C. Store all data in shadow custom objects on any updates and deletes, and extract them as needed .
  D. Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.
  D. Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

• Question 108:

  A large retail B2C customer wants to build a 360-degree view of its customers for its call center agents. The customer information is currently maintained in the following systems:

  1.

  Salesforce CRM

  2.

  Custom billing solution

  3.

  Customer master data management (MDM)

  4.

  Contract management system

  5.

  Marketing solution

  What should a data architect recommend that would help uniquely identify the customer across multiple systems?

  A. Store the salesforce id in all the solutions to identify the customer.
  B. Create a custom object that will serve as a cross reference for the customer id.
  C. Create a customer data base and use this id in all systems.
  D. Create a custom field as external id to maintain the customer Id from the MDM solution.
  A. Store the salesforce id in all the solutions to identify the customer.

• Question 109:

  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.

• Question 110:

  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?

  A. validation Rule
  B. required Fields
  C. Apex Class
  D. Process Builder
  A. validation Rule