Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 41:

  Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?

  A. Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.

  B. Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.

  C. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.

  D. Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.

  Correct Answer: C

  Explanation: Enabling Account de-duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts, is what UC should do to ensure proper data quality for their Account records. Matching rules allow UC to define how Salesforce identifies duplicate Accounts based on various criteria, such as name, address, phone number, etc. Mass merge allows UC to merge up to 200 duplicate Accounts at a time, based on the matching rules. This simplifies and automates the process of de-duplicating Accounts and improves data quality. The other options are either more time-consuming, costly, or error-prone for ensuring proper data quality.

• Question 42:

  Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?

  A. Missing phone number on the Contact record.

  B. Customer phone number has changed on the Contact record.

  C. Duplicate Contact records exist in the system.

  D. Duplicate Activity records on a Contact.

  Correct Answer: C

  Explanation: A data quality problem that could cause customers to be called by multiple Sales Reps is having duplicate Contact records in the system. Duplicate records can result from data entry errors, data imports, or integrations with other systems. Duplicate records can lead to confusion, inefficiency, and customer dissatisfaction

• Question 43:

  Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers

  A. Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.

  B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.

  C. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.

  D. Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

  Correct Answer: BC

  Explanation: To capture and report on any changes made to ten text fields on the Contact object for the past 3 months, the data architect should write an Apex trigger on Contact after insert and after update events and store the old values in another custom object, or turn on field Contact object history tracking for these ten fields and create reports on contact history. An Apex trigger can capture the old and new values of the fields, as well as the user and time of the change, and store them in a custom object that can be used for reporting. Field history tracking can also track the changes to the fields and store them in a history table that can be used for reporting. However, field history tracking only retains data for up to 18 months or 24 months with an extension, so it may not be suitable for longer- term reporting needs. The other options are not feasible or effective for capturing and reporting on field data changes.

• Question 44:

  Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing, UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock errors" consistently.

  What should a data architect recommend to mitigate these errors?

  A. Enable granular locking.

  B. Remove SOQL statements from Apex Loops.

  C. Enable sharing recalculations.

  D. Ask Salesforce support for additional CPU power.

  Correct Answer: A

  Explanation: Enabling granular locking (option A) is the best recommendation to mitigate these errors, as it allows finer control over how records are locked during automated or manual processes, and reduces the chances of lock contention or deadlock. Removing SOQL statements from Apex Loops (option B) is a good practice for improving performance and avoiding governor limits, but it does not directly address the lock errors issue. Enabling sharing recalculations (option C) is also not relevant for this issue, as it is used to update sharing rules and recalculate access for records. Asking Salesforce support for additional CPU power (option D) is also not a viable solution, as it does not solve the root cause of the lock errors.

• Question 45:

  DreamHouse Realty has a legacy system that captures Branch Offices and Transactions. DreamHouse Realty has 15 Branch Offices. Transactions can relate to any Branch Office. DreamHouse Realty has created hundreds of thousands of Transactions per year. A Data Architect needs to denormalize this data model into a single Transaction object with a Branch Office picklist.

  What are two important considerations for the Data Architect in this scenario? (Choose two.)

  A. Standard list view in-line editing.

  B. Limitations on Org data storage.

  C. Bulk API limitations on picklist fields.

  D. Limitations on master-detail relationships.

  Correct Answer: BC

  Explanation: The Data Architect should consider the limitations on Org data storage and the Bulk API limitations on picklist fields when denormalizing the data model into a single Transaction object with a Branch Office picklist. The Org data storage limit is the total amount of data that can be stored in a Salesforce Org, and it depends on the edition and license type of the Org1. The Bulk API limit on picklist fields is the maximum number of values that can be imported or exported using the Bulk API, and it is 1,000 values per picklist field2. These limitations could affect the performance and scalability of the data model, and the Data Architect should plan accordingly.

• Question 46:

  What should a data architect do to provide additional guidance for users when they enter information in a standard field?

  A. Provide custom help text under field properties.

  B. Create a custom page with help text for user guidance.

  C. Add custom help text in default value for the field.

  D. Add a label field with help text adjacent to the custom field.

  Correct Answer: A

  Explanation: The correct answer is A. To provide additional guidance for users when they enter information in a standard field, a data architect should provide custom help text under field properties. This will display a help icon next to the field label that users can hover over to see the help text. Option B is incorrect because creating a custom page with help text for user guidance will require additional development effort and may not be easily accessible by users. Option C is incorrect because adding custom help text in default value for the field will overwrite the actual default value of the field and may confuse users. Option D is incorrect because adding a label field with help text adjacent to the custom field will clutter the page layout and may not be visible to users.

• Question 47:

  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.

  Correct Answer: A

  Explanation: The data architect should recommend using AppExchange package for backup and restore. AppExchange is a marketplace for Salesforce apps and solutions that can be installed and configured in Salesforce orgs. There are several AppExchange packages that provide backup and restore functionality for Salesforce data, such as OwnBackup, Odaseva, or Spanning. These packages can perform daily backups of Salesforce data to a secure cloud storage, and provide restore capability to avoid any data loss in case of outage. Option B is incorrect because using ETL (Extract, Transform, Load) for backup and restore from EDW (Enterprise Data Warehouse) will require additional development effort and may not be reliable or secure. Option C is incorrect because using Bulk API to extract data on daily basis to EDW and REST API for restore will require additional integration effort and may not be scalable or performant. Option D is incorrect because changing weekly backup process to daily backup, and implementing a custom restore solution will require additional configuration effort and may not be robust or compliant.

• Question 48:

  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.

  Correct Answer: B

  Explanation: Creating a custom lookup field on the standard Product to reference the parent record in the hierarchy is the correct way to modify the standard Product object model to support a hierarchical data structure. This allows UC to create a self-relationship on the Product object and define parent-child relationships among products.

• Question 49:

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

  Accounts Contacts Opportunities Orders Order Line Items

  Which issue will an architect have when implemented 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.

  Correct Answer: C

  Explanation: The issue that an architect will have when implementing the quarterly accounts receivable report in Salesforce is that Salesforce does not allow more than four objects in a single report type. A report type defines the set of

  records and fields available to a report based on the relationships between a primary object and up to four related objects. A report type has the following limitations:

  It cannot include more than four objects in a single report type, which means that the report cannot compile data from five objects (Accounts, Contacts, Opportunities, Orders, and Order Line Items) at once. It cannot include objects that are

  more than two relationships away from each other, which means that the report cannot access fields from Order Line Items through Opportunities and Orders.

  It cannot include objects that have a many-to-many relationship with each other, which means that the report cannot access fields from Contacts and Opportunities through the junction object Opportunity Contact Role.

• Question 50:

  Northern Trail Outfitters (NTO) has recently implemented Salesforce to track opportunities across all their regions. NTO sales teams across all regions have historically managed their sales process in Microsoft Excel. NTO sales teams are complaining that their data from the Excel files were not migrated as part of the implementation and NTO is now facing low Salesforce adoption.

  What should a data architect recommend to increase Salesforce adoption?

  A. Use the Excel connector to Salesforce to sync data from individual Excel files.

  B. Define a standard mapping and train sales users to import opportunity data.

  C. Load data in external database and provide access to database to sales users.

  D. Create a chatter group and upload all Excel files to the group.

  Correct Answer: B

  Explanation: According to Trailhead2, one of the best practices to increase Salesforce adoption is to migrate existing data from legacy systems or spreadsheets into Salesforce, so that users can access all their data in one place and leverage the features and functionality of Salesforce. Option B is the correct answer because it suggests defining a standard mapping and training sales users to import opportunity data from Excel files into Salesforce, which can help them transition from their old process and increase their confidence and satisfaction with Salesforce. Option A is incorrect because using the Excel connector to Salesforce does not migrate the data into Salesforce, but only syncs it between Excel and Salesforce, which can cause data inconsistency and duplication issues. Option C is incorrect because loading data in an external database and providing access to it does not increase Salesforce adoption, but rather creates another system for users to manage and switch between. Option D is incorrect because creating a chatter group and uploading all Excel files to it does not migrate the data into Salesforce, but only stores it as attachments, which cannot be used for reporting or analysis purposes.