Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 161:

  UC has a roll-up summary field on Account to calculate the count of contacts associated with an account. During the account load, SF is throwing an "Unable to lock a row" error.

  Which solution should a data architect recommend, to resolve the error?

  A. Leverage data loader platform API to load data.

  B. Perform Batch job in parallel mode and reduce Batch size

  C. Perform Batch job in serial mode and reduce batch size

  D. Defer roll-up summary fields calculation during data migration.

  Correct Answer: C

  Explanation: The best solution to resolve the error of "Unable to lock a row" during the account load is to perform batch job in serial mode and reduce batch size. This is because roll-up summary fields are calculated synchronously when the parent record is updated, and asynchronously when the child record is updated. Therefore, updating many child records at once can cause locking issues on the parent record. To avoid this, it is recommended to use serial mode and smaller batch sizes when loading data using tools like Data Loader or Bulk API12. Leverage data loader platform API to load data is not a good option because it does not specify the mode or batch size. Perform batch job in parallel mode and reduce batch size is not a good option because parallel mode can still cause locking issues even with smaller batches. Defer roll-up summary fields calculation during data migration is not a good option because it is not possible to defer or disable roll- up summary fields calculation

• Question 162:

  Universals Containers' system administrators have been complaining that they are not able to make changes to its users' record, including moving them to new territories without getting "unable to lock row" errors. This is causing the system admins to spend hours updating user records every day.

  What should the data architect do to prevent the error?

  A. Reduce number of users updated concurrently.

  B. Enable granular locking.

  C. Analyze Splunk query to spot offending records.

  D. Increase CPU for the Salesforce org.

  Correct Answer: B

  Explanation: Enabling granular locking (option B) is the best option to prevent the error, as it allows finer control over how records are locked during automated or manual processes, and reduces the chances of lock contention or deadlock. Reducing number of users updated concurrently (option A) is not a good option, as it may limit the productivity and efficiency of the system admins, and it does not address the root cause of the error. Analyzing Splunk query to spot offending records (option C) is also not a good option, as it may require more time and effort, and it does not provide a permanent solution for the error. Increasing CPU for the Salesforce org (option D) is also not a good option, as it may introduce additional cost and complexity, and it does not solve the root cause of the error.

• Question 163:

  Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

  A. Limitations on master -detail relationships.

  B. Org data storage limitations.

  C. Bulk API limitations on picklist fields.

  D. Standard list view in -line editing.

  Correct Answer: CD

  Explanation: When denormalizing a data model into a single object with a picklist field, the data architect should consider the Bulk API limitations on picklist fields and the standard list view in-line editing. The Bulk API has a limit of 1,000 distinct picklist values per file1, which could be an issue if there are more than 1,000 venues in the future. The standard list view in-line editing allows users to edit multiple records at once, which could introduce data quality issues if the venue picklist is not validated or restricted2. The other options are not relevant to denormalizing a data model.

• Question 164:

  Universal Containers (UC) owns several Salesforce orgs across a variety of business units. UC management has declared that it needs the ability to report on Accounts and Opportunities from each org in one place. Once the data is brought

  together into a global view, management would like to use advanced Al-driven analytics on the dataset.

  Which tool should a data architect recommend to accomplish this reporting requirement?

  A. Run standard reports and dashboards.

  B. Install a third-party AppExchange tool for multi-org reporting.

  C. Use Einstein Analytics for multi-org.

  D. Write a Python script to aggregate and visualize the data.

  Correct Answer: C

  Explanation: According to this article, Einstein Analytics for multi-org can help UC to report on accounts and opportunities from each org in one place. It can also provide advanced AI- driven analytics on the dataset using Einstein Discovery.

• Question 165:

  Northern trail Outfitters (NTO) runs its entire out of an enterprise data warehouse (EDW), NTD's sales team starting to use Salesforce after a recent implementation, but currently lacks data required to advanced and opportunity to the next stage.

  NTO's management has research Salesforce Connect and would like to use It to virtualize and report on data from the EDW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.

  What should a data architect consider before implementing Salesforce Connect for reporting?

  A. Maximum number for records returned

  B. OData callout limits per day

  C. Maximum page size for server-driven paging

  D. Maximum external objects per org

  Correct Answer: B

  Explanation: According to the Salesforce Connect Reporting blog post, one of the considerations for using Salesforce Connect for reporting is the OData callout limits per day. The blog post states that "Salesforce Connect has a limit of 100,000 callouts per day. This limit is shared across all external data sources in your org. If you exceed this limit, you will receive an error message and no more callouts will be allowed until the next day." Therefore, a data architect should consider this limit before implementing Salesforce Connect for reporting.

• Question 166:

  Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year. What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

  A. Implement an archiving process for shipment records created after five years.

  B. Implement an archiving process for shipment records created after three years.

  C. Set Customer-Reference_c as an External ID (non-unique).

  D. Set Customer-Reference_c as an External ID (unique).

  Correct Answer: D

  Explanation: Setting Customer-Reference_c as an External ID (unique) is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records. This is because external ID fields are indexed and can be used as filters in reports and list views4. Making the field unique also ensures that there are no duplicate values that could confuse the search results.

• Question 167:

  Universal Containers (UC) has implemented Sales Cloud for its entire sales organization, UC has built a custom object called projects_c that stores customers project detail and employee bitable hours.

  The following requirements are needed:

  A subnet of individuals from the finance team will need to access to the projects object for reporting and adjusting employee utilization.

  The finance users will not access to any sales objects, but they will need to interact with the custom object.

  Which license type a data architect recommend for the finance team that best meets the requirements?

  A. Service Cloud

  B. Sales Cloud

  C. Light Platform Start

  D. Lighting platform plus

  Correct Answer: D

  Explanation: The data architect should recommend Lighting platform plus license type for the finance team that best meets the requirements. This license type allows users to access custom objects and run reports and dashboards on them, without accessing any sales objects. Option A is incorrect because Service Cloud license type is more suitable for customer service users who need to access cases, knowledge, and other service objects. Option B is incorrect because Sales Cloud license type is more suitable for sales users who need to access accounts, contacts, opportunities, and other sales objects. Option C is incorrect because Light Platform Start license type does not allow users to run reports and dashboards on custom objects.

• Question 168:

  Company S was recently acquired by Company T. As part of the acquisition, all of the data for the Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance (target). Company S has 6 million Case records.

  An Architect has been tasked with optimizing the data load time.

  What should the Architect consider to achieve this goal?

  A. Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.

  B. Directly leverage Salesforce-to-Salesforce functionality to load Case data.

  C. Load the data in multiple sets using Bulk API parallel processes.

  D. Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.

  Correct Answer: A

  Explanation: Pre-processing the data means transforming and cleansing the data before loading it into Salesforce. This can reduce the errors and conflicts that might occur during the data load. Using Data Loader with SOAP API to upsert with zip compression enabled can also improve the performance and efficiency of the data load by reducing the network bandwidth and avoiding duplication

• Question 169:

  Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.

  Which governance measure should a data architect recommend to solve this issue?

  A. Add description fields to explain why the field is used, and mark the field as required.

  B. Create and manage a data dictionary and ups a governance process for changes made to common objects.

  C. Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.

  D. Create validation rules with error messages to explain why the fields is used

  Correct Answer: B

  Explanation: To solve the issue of lack of governance in making changes to Salesforce, a data architect should recommend creating and managing a data dictionary and setting up a governance process for changes made to common objects. A data dictionary is a document that defines the metadata, structure, and relationship of each object and field in Salesforce. A governance process is a set of rules and procedures that govern how changes are proposed, reviewed, approved, and deployed in Salesforce. These measures will help NTO to maintain consistency, quality, and clarity of their data model and avoid confusion and errors among users. Option A is incorrect because adding description fields to explain why the field is used, and marking the field as required will not prevent unauthorized or unnecessary changes to Salesforce. Option C is incorrect because creating reports to identify which users are leaving blank, and using external data sources to augment the missing data will not address the root cause of the issue, which is the lack of governance in making changes to Salesforce. Option D is incorrect because creating validation rules with error messages to explain why the fields are used will not stop users from seeing new fields on their page that they are unsure of.

• Question 170:

  Universal Containers has provided a web order form for its customer and has noticed invalid data coming in on orders.

  What should be used to mitigate this problem?

  A. Work Flow Rules

  B. Formatted Fields

  C. Apex Trigger

  D. Validation Rules

  Correct Answer: D

  Explanation: Using validation rules to mitigate this problem is the best option. Validation rules can help you prevent invalid data from being entered in your web order form. You can use validation rules to check for data quality, format, range, or consistency. For example, you can use validation rules to ensure that the order quantity is positive, the product code is valid, or the shipping address is complete.