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

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

• Question 81:

  A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

  A. Import Account records first followed by order records after sorting order by OrderID.
  B. Import Account records first followed by order records after sorting orders by AccountID.
  C. Change the relationship to Lookup and update the relationship to master-detail after import.
  D. Import Order records and Account records separately and populate AccountID in orders using batch Apex.
  B. Import Account records first followed by order records after sorting orders by AccountID.

• Question 82:

  Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

  A. Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
  B. Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.
  C. Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.
  D. Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.
  B. Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.

• Question 83:

  UC has a salesforce org with multiple automated processes defined for group membership process. UC also have multiple admins on staff that perform manual adjustments to the role hierarchy. The automated task and manual task overlap daily and UC is experiencing "Lock errors" consistently. What should a data architect recommend mitigate these errors?

  A. Ask salesforce support for addition CPU power.
  B. Enable granular locking.
  C. Remove SOQL statements from APEX loops.
  D. Enable sharing recalculations
  C. Remove SOQL statements from APEX loops.

• Question 84:

  Universal Containers (UC) recently migrated 1 billion customer related records from a legacy datastore to Heroku Postgres. A subnet of the data needs 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?

  A. Use Heroku Connect to bidirectionally sync all data between systems
  B. As needed, make callouts into Heroku Postgres and persist the data in Salesforce
  C. Virtualize the remaining set of data with Salesforce Connect and external objects.
  D. Migrate the data to big objects and leverage Async SOQL with custom objects
  A. Use Heroku Connect to bidirectionally sync all data between systems

• Question 85:

  Northern Trail Outfitters (NTO) has one million customer records spanning 25 years. As part of its new Salesforce project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.

  Which three activities will be required to identify a successful master data management strategy? (Choose three.)

  A. Identify data to be replicated
  B. Create a data archive strategy
  C. Define the systems of record for critical data
  D. Install a data warehouse
  E. Choose a Business Intelligence tool.
  A. Identify data to be replicated
  B. Create a data archive strategy
  C. Define the systems of record for critical data

• Question 86:

  Northern Trail Outfitters (NTO) has decided to franchise its brand. Upon implementation 1,000 franchisees will be able to access NTO's product information and track large customer sales and opportunities through a portal. The franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.

  Which license does NTO need to provide these features to the franchisees?

  A. Salesforce Sales Cloud license
  B. Lightning Platform license
  C. Customer Community license
  D. Partner Community license
  A. Salesforce Sales Cloud license

• Question 87:

  North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly. Which two native tools should a data architect recommend to achieve this reporting requirement?

  A. Standard reports and dashboards
  B. Async SOQL with a custom object
  C. Standard SOQL queries
  D. Einstein Analytics
  B. Async SOQL with a custom object
  D. Einstein Analytics

• Question 88:

  Developers at Universal Containers need to build a report 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 should be recommended to make this report perform well and satisfy the business need?

  A. Use triggers to populate denormalized related fields on the Account.
  B. Use an indexed data field with bounded data filters.
  C. Use Formula fields to surface information I related entities on the report.
  D. Use unbounded date ranges to filter the report.
  B. Use an indexed data field with bounded data filters.
  D. Use unbounded date ranges to filter the report.

• Question 89:

  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?

  A. Create indexes on Opportunity object text fields.
  B. Group batches by the AccountId field.
  C. Sort batches by Name field values.
  D. Order batches by Auto -number field.
  D. Order batches by Auto -number field.

• Question 90:

  A casino is implementing Salesforce and is planning to build a customer 360-degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity:

  1.

  Point-of-sale system: All purchases for a customer

  2.

  Salesforce: All customer service activity and sales activities for a customer

  3.

  Mobile app: All bookings, preferences, and browser activity for a customer

  4.

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

  Customer service agents using Salesforce 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?

  A. Explore external data sources in Salesforce to build 360-degree view of customer
  B. Periodically upload summary information in Salesforce to build 360-degree view
  C. Migrate customer activities from all four systems into Salesforce
  D. Use a customer data mart to view the 360-degree view of customer
  C. Migrate customer activities from all four systems into Salesforce