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

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

• Question 91:

  Universal Containers (UC) is planning a massive Salesforce implementation with large volumes of data. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.

  What should a data architect do to minimize data load times due to system calculations?

  A. Enable defer sharing calculations, and suspend sharing rule calculations
  B. Load the data through data loader, and turn on parallel processing.
  C. Leverage the Bulk API and concurrent processing with multiple batches
  D. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.
  A. Enable defer sharing calculations, and suspend sharing rule calculations

• Question 92:

  Cloud Kicks is launching a Partner Community, which will allow users to register shipment requests that are then processed by Cloud Kicks employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped.

  First, Cloud Kicks will introduce its community to 6,000 customers in North America, and then to 24,000 customers worldwide within the next two years. Cloud Kicks expects 12 shipment requests per week per customer, on average, and wants customers to be able to view up to three years of shipment requests and use Salesforce reports.

  What is the recommended solution for the Cloud Kicks Data Architect to address the requirements?

  A. Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku's Postgres database.
  B. Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.
  C. Create a custom object to track shipment requests with five lookup custom fields for each item being shipped. Implement an archiving process that moves data off-platform after three years.
  D. Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku's Postgres database.
  B. Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.

• Question 93:

  A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?

  A. Use Salesforce Soap API in parallel mode.
  B. Use Salesforce Bulk API in serial mode.
  C. Use Salesforce Bulk API in parallel mode.
  D. Use Salesforce Soap API in serial mode.
  C. Use Salesforce Bulk API in parallel mode.

• Question 94:

  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 stored in 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?

  A. Master-detail relationship filed on Account, related to Inventory_c
  B. Master-detail relationship filed on Inventory_c, related to Account
  C. Indirect lookup relationship field on Account, related to Inventory_c
  D. Lookup relationship fields on Inventory related to Account
  A. Master-detail relationship filed on Account, related to Inventory_c

• Question 95:

  Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?

  A. Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.
  B. Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.
  C. Implement a new Categories custom object and a master-detail relationship from Account to Category.
  D. Implement a new Categories custom object and create a lookup field from Account to Category.
  B. Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.

• Question 96:

  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?

  A. Embed the keywords FOR UPDATE after SOQL statements.
  B. Disable classes or triggers that have the potential to obtain the same record.
  C. Migrate programmatic logic to processes and flows.
  D. Refactor or optimize classes and trigger for maximum CPU performance.
  A. Embed the keywords FOR UPDATE after SOQL statements.

• Question 97:

  Which three characteristics of a Skinny table help improve report and query performance?

  A. Skinny tables can contain frequently used fields and thereby help avoid joins.
  B. Skinny tables can be used to create custom indexes on multi-select picklist fields.
  C. Skinny tables provide a view across multiple objects for easy access to combined data.
  D. Skinny tables are kept in sync with changes to data in the source tables.
  E. Skinny tables do not include records that are available in the recycle bin.
  A. Skinny tables can contain frequently used fields and thereby help avoid joins.
  C. Skinny tables provide a view across multiple objects for easy access to combined data.
  D. Skinny tables are kept in sync with changes to data in the source tables.

• Question 98:

  Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

  A. Reduce data storage by purging old data.
  B. Implement an AppExchange package.
  C. Review projected data storage needs.
  D. Schedule a weekly export file.
  A. Reduce data storage by purging old data.

• Question 99:

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

  A. Implement a Master Data Management system to determine system of record.
  B. Implement a workflow rule that sends Opportunity data through Outbound Messaging.
  C. Have the ERP poll Salesforce nightly and bring in the desired Opportunities.
  D. Implement an hourly integration to send Salesforce Opportunities to the ERP system.
  B. Implement a workflow rule that sends Opportunity data through Outbound Messaging.

• Question 100:

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

  1.

  Accounts

  2.

  Contacts

  3.

  Opportunities

  4.

  Orders

  5.

  Order Line Items

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

  A. Custom report types CANNOT contain Opportunity data.
  B. Salesforce does NOT support Orders or Order Line Items.
  C. Salesforce does NOT allow more than four objects in a single report type.
  D. A report CANNOT contain data from Accounts and Contacts.
  C. Salesforce does NOT allow more than four objects in a single report type.