Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 211:

  UC has multiple SF orgs that are distributed across regional branches. Each branch stores local customer data inside its org's Account and Contact objects. This creates a scenario where UC is unable to view customers across all orgs.

  UC has an initiative to create a 360-degree view of the customer, as UC would like to see Account and Contact data from all orgs in one place.

  What should a data architect suggest to achieve this 360-degree view of the customer?

  A. Consolidate the data from each org into a centralized datastore

  B. Use Salesforce Connect's cross-org adapter.

  C. Build a bidirectional integration between all orgs.

  D. Use an ETL tool to migrate gap Accounts and Contacts into each org.

  Correct Answer: A

  Consolidating the data from each org into a centralized datastore is the best suggestion to achieve a 360-degree view of the customer. This way, UC can have a single source of truth for all customer data and avoid data silos and inconsistencies. The other options are not feasible because they either require complex integration, additional cost, or data duplication.

• Question 212:

  UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?

  A. Set a standard profile for Data Migration user, and assign view encrypted data

  B. Create another field to copy data from encrypted field and use this field in export

  C. Leverage Apex class to decrypt data before exporting it.

  D. Set up a custom profile for data migration user and assign view encrypted data.

  Correct Answer: A

  Explanation: The best solution to make sure decrypted values are exported during data export is to create another field to copy data from encrypted field and use this field in export. This is because classic encryption does not support exporting decrypted values of encrypted fields. The view encrypted data permission only allows users to view decrypted values in the user interface, but not in reports or data exports. Therefore, a workaround is to create a formula field or a workflow field update that copies the value of the encrypted field to another field, and use that field for data export. However, this solution has some drawbacks, such as exposing sensitive data in plain text and consuming extra storage space. A better solution would be to use Shield Platform Encryption, which supports exporting decrypted values of encrypted fields with the Export Encrypted Data permission

• Question 213:

  Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.

  Which two solutions should a data architect recommend to mitigate data quality issues?

  A. Leverage picklist and lookup fields where possible

  B. Leverage Apex to validate the format of data being entered via a mobile device.

  C. Leverage validation rules and workflows.

  D. Leverage third-party- AppExchange tools

  Correct Answer: AC

  Explanation: According to the Salesforce documentation1, data quality is the measure of how well the data in Salesforce meets the expectations and requirements of the users and stakeholders. Data quality can be affected by various factors,

  such as data entry errors, data duplication, data inconsistency, data incompleteness, data timeliness, etc. To mitigate data quality issues, some of the recommended solutions are:

  Leverage picklist and lookup fields where possible (option A). This means using fields that restrict the values or references that can be entered by the users or integrations. This can help reduce data entry errors, enforce data consistency, and

  improve data accuracy.

  Leverage validation rules and workflows (option C). This means using features that allow defining rules and criteria to validate the data that is entered or updated by the users or integrations. This can help prevent invalid or incorrect data from

  being saved, and trigger actions or alerts to correct or improve the data. Leveraging Apex to validate the format of data being entered via a mobile device (option B) is not a good solution, as it can be complex, costly, and difficult to maintain. It

  is better to use standard features or declarative tools that can handle data validation more effectively. Leveraging third-party AppExchange tools (option D) is also not a good solution, as it can incur additional costs and dependencies. It is

  better to use native Salesforce features or custom solutions that can handle data quality more efficiently.

• Question 214:

  DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project.

  There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.

  

  What should the Architect consider in this situation?

  A. Load all data after deferring sharing calculations.

  B. Calculate summary values instead of Roll-Up by using workflow.

  C. Calculate summary values instead of Roll-Up by using triggers.

  D. Load all data using external IDs to link to parent records.

  Correct Answer: A

  Explanation: According to the exam guide, one of the objectives is to "describe the use cases and considerations for deferring sharing calculations"1. This implies that option A is the correct way to load large amounts of data into Salesforce without affecting performance and data integrity. Deferring sharing calculations allows the data to be loaded first and then the sharing rules to be applied later2. Option B is not correct because workflows are not recommended for calculating summary values, as they can cause performance issues and data skew3. Option C is not correct because triggers are also not recommended for calculating summary values, as they can cause governor limit errors and data inconsistency. Option D is not correct because external IDs are used to link records from different systems, not to improve data loading performance.

• Question 215:

  A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.

  The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sales associates use Global Search to search for customers in Salesforce before they create the customers.

  Which option should a data architect choose to implement to avoid duplicates?

  A. leverage duplicate rules in Salesforce to validate duplicates during the account creation process.

  B. Develop an Apex class that searches for duplicates and removes them nightly.

  C. Implement an MDM solution to validate the customer information before creating Salesforce.

  D. Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.

  Correct Answer: A

  Explanation: Leveraging duplicate rules in Salesforce to validate duplicates during the account creation process (option A) is the best option to implement to avoid duplicates, as it allows the sales associates to identify and merge duplicate accounts before they are saved. Developing an Apex class that searches for duplicates and removes them nightly (option B) is not a good option, as it may cause data loss or conflicts, and it does not prevent duplicates from being created in the first place. Implementing an MDM solution to validate the customer information before creating Salesforce (option C) is also not a good option, as it may introduce additional complexity and cost, and it does not address the issue of customers interacting with both the website and the store. Building a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores (option D) is also not a good option, as it may not be reliable or user-friendly, and it does not leverage the existing Global Search feature.

• Question 216:

  Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an "UNABLE _TO_LOCK_ROW" error.

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

  A. Defer rollup summary field calculation during data migration.

  B. Perform a batch job in serial mode and reduce the batch size.

  C. Perform a batch job in parallel mode and reduce the batch size.

  D. Leverage Data Loader's platform API to load data.

  Correct Answer: B

  Explanation: According to the Salesforce documentation1, the "UNABLE _TO_LOCK_ROW" error occurs when a record is being updated or created, and another operation tries to access or update the same record at the same time. This can cause lock contention and timeout issues. To resolve the error, some of the recommended solutions are: Perform a batch job in serial mode and reduce the batch size (option B). This means running the batch job one at a time and processing fewer records per batch. This can reduce the chances of concurrent updates and lock contention on the same records. Use the FOR UPDATE keyword to lock records in Apex code or API calls. This means explicitly locking the records that are being accessed or updated by a transaction, and preventing other transactions from modifying them until the lock is released. This can avoid conflicts and errors between concurrent operations on the same records2. Defer rollup summary field calculation during data migration (option A). This means disabling the automatic calculation of rollup summary fields on the parent object when child records are inserted or updated. This can improve performance and avoid locking issues on the parent records. However, this option is only available for custom objects, not standard objects3. Performing a batch job in parallel mode and reducing the batch size (option C) is not a good solution, as it can still cause lock contention and errors if multiple batches try to access or update the same records at the same time. Leveraging Data Loader's platform API to load data (option D) is also not a good solution, as it can still encounter locking issues if other operations are modifying the same records at the same time.

• Question 217:

  A customer wants to maintain geographic location information including latitude and longitude in a custom object. What would a data architect recommend to satisfy this requirement?

  A. Create formula fields with geolocation function for this requirement.

  B. Create custom fields to maintain latitude and longitude information

  C. Create a geolocation custom field to maintain this requirement

  D. Recommend app exchange packages to support this requirement.

  Correct Answer: C

  Explanation: The correct answer is C, create a geolocation custom field to maintain this requirement. A geolocation custom field is a compound field that can store both latitude and longitude information in a single field. It also supports geolocation functions and distance calculations. Creating formula fields or custom fields for latitude and longitude separately would be inefficient and redundant. Recommending app exchange packages would not be a direct solution to the requirement.

• Question 218:

  Universal Containers (UC) is transitioning from Classic to Lightning Experience.

  What does UC need to do to ensure users have access to its notices and attachments in Lightning Experience?

  A. Add Notes and Attachments Related List to page Layout in Lighting Experience.

  B. Manually upload Notes in Lighting Experience.

  C. Migrate Notes and Attachment to Enhanced Notes and Files a migration tool

  D. Manually upload Attachments in Lighting Experience.

  Correct Answer: C

  Explanation: The correct answer is C, migrate Notes and Attachment to Enhanced Notes and Files using a migration tool. Enhanced Notes and Files are the new features in Lightning Experience that replace the classic Notes and Attachments. They offer more functionality and security than the classic version. To access them in Lightning Experience, you need to migrate your existing Notes and Attachments using a migration tool provided by Salesforce. Adding Notes and Attachments Related List, manually uploading Notes or Attachments, or doing nothing are not valid solutions, as they will not enable you to use the enhanced features in Lightning Experience.

• Question 219:

  To address different compliance requirements, such as general data protection regulation (GDPR), personally identifiable information (PII), of health insurance Portability and Accountability Act (HIPPA) and others, a SF customer decided to categorize each data element in SF with the following:

  Data owner Security Level, such as confidential Compliance types such as GDPR, PII, HIPPA A compliance audit would require SF admins to generate reports to manage compliance.

  What should a data architect recommend to address this requirement?

  A. Use metadata API, to extract field attribute information and use the extract to classify and build reports

  B. Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.

  C. Create a custom object and field to capture necessary compliance information and build custom reports.

  D. Build reports for field information, then export the information to classify and report for Audits.

  Correct Answer: B

  Explanation: The data architect should recommend using field metadata attributes for compliance categorization, data owner, and data sensitivity level. This will allow the SF admins to generate reports to manage compliance based on the field metadata attributes that are defined for each data element in SF. Option A is incorrect because using metadata API to extract field attribute information and use the extract to classify and build reports will require additional development effort and may not be up-to-date with the latest changes in SF. Option C is incorrect because creating a custom object and field to capture necessary compliance information and build custom reports will require additional configuration effort and may not be consistent with the actual data elements in SF. Option D is incorrect because building reports for field information, then exporting the information to classify and report for audits will require additional manual effort and may not be accurate or timely.

• Question 220:

  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.

  Correct Answer: C

  Explanation: Using Salesforce Bulk API in parallel mode can reduce the migration time by processing multiple batches of records simultaneously and leveraging the server resources more efficiently. The Bulk API is designed for loading large amounts of data into Salesforce