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

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

• Question 201:

  Universal Containers has millions of cases and are running out storage. Some user groups need to have access to historical cases for up to seven years. Which two solutions should a data architect recommend in order to minimize performance and storage issues? (Choose two.)

  A. Export data out of salesforce and store in Flat files on external system.
  B. Create a custom object to store case history and run reports on it.
  C. Leverage on premise data archival and build integration to view archived data.
  D. Leverage big object to archive case data and lightning components to show archived data.
  B. Create a custom object to store case history and run reports on it.
  D. Leverage big object to archive case data and lightning components to show archived data.

• Question 202:

  NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records. What should a data architect recommend in order to get around the time out issue?

  A. Use a custom auto number and formula field and use that to chunk records while extracting data.
  B. The REST API to extract data as it automatically chunks records by 200.
  C. Use ETL tool for extraction of records.
  D. Ask SF support to increase the query timeout value.
  C. Use ETL tool for extraction of records.

• Question 203:

  Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity dat

  A. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce. What is the recommended course of action to appropriately integrate this new system?
  B. The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.
  C. A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.
  D. The Opportunity engagement system should become the system of record for Opportunity records.
  E. Stakeholders should be brought together to discuss the appropriate data strategy moving forward.
  D. The Opportunity engagement system should become the system of record for Opportunity records.

• Question 204:

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

  A. Ensure all data is stored in an external system and set up an integration to Salesforce for view-only access.
  B. Schedule reports that will automatically catch duplicates and merge or delete the records every week.
  C. Enforce critical business processes by using Workflow, Validation Rules, and Apex code.
  D. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
  C. Enforce critical business processes by using Workflow, Validation Rules, and Apex code.
  D. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.

• Question 205:

  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?

  A. Create a "before delete" trigger to check if the current user is not the owner.
  B. Set the Sharing settings as Public Read Only for the Contact object.
  C. Set the profile of the users to remove delete permission from the Contact object.
  D. Create a validation rule on the Contact object to check if the current user is not the owner.
  A. Create a "before delete" trigger to check if the current user is not the owner.

• Question 206:

  Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to

  move to daily backups and provide restore capability to avoid any data loss in case of outage.

  What should a data architect recommend for a daily backup and restore solution?

  A. Use AppExchange package for backup and restore.
  B. Use ETL for backup and restore from EDW.
  C. Use Bulk API to extract data on daily basis to EDW and REST API for restore.
  D. Change weekly backup process to daily backup, and implement a custom restore solution.
  A. Use AppExchange package for backup and restore.

• Question 207:

  Universal Containers is migrating individual customers (B2C) data from legacy systems to Salesforce. There are millions of customers stored as account and contacts in the legacy database. Which object model should a data architect configure within Salesforce?

  A. Leverage person account object in Salesforce
  B. Leverage standard account and contact object in Salesforce
  C. Leverage custom account and contact object in Salesforce
  D. Leverage custom person account object in Salesforce
  A. Leverage person account object in Salesforce

• Question 208:

  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

  A. Create a custom object to store a copy of the record when changed.
  B. Create a custom object to store the previous and new field values.
  C. Use Analytic Snapshots to store a copy of the record when changed.
  D. Select the 100 fields in the Opportunity Set History Tracking page.
  A. Create a custom object to store a copy of the record when changed.
  B. Create a custom object to store the previous and new field values.

• Question 209:

  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 required that 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?

  A. Update the Opportunity page layout to mark these fields as required.
  B. Use a validation rule for each field that takes the Stage into consideration.
  C. Update these Opportunity field definitions in Setup to be required.
  D. Write an Apex trigger that checks each field when records are saved.
  B. Use a validation rule for each field that takes the Stage into consideration.

• Question 210:

  Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system it was discovered that same standard and custom fields need to encrypted. Which solution should a data architect recommend to encrypt existing fields?

  A. Use Apex Crypto Class encrypt customer and standard fields.
  B. Implement classic encryption to encrypt custom and standard fields.
  C. Implement shield platform encryption to encrypt and standard fields
  D. Expert data out of Salesforce and encrypt custom and standard fields.
  C. Implement shield platform encryption to encrypt and standard fields