Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 161:

  A company has 12 million records, and a nightly integration queries these records.

  Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

  A. Make sure the query doesn't contain NULL in any filter criteria.
  B. Create a formula field instead of having multiple filter criteria.
  C. Create custom indexes on the fields used in the filter criteria.
  D. Modify the integration users' profile to have View All Data.
  A. Make sure the query doesn't contain NULL in any filter criteria.
  C. Create custom indexes on the fields used in the filter criteria.

  ---

  Explanation

  Making sure the query does not contain NULL in any filter criteria can avoid full table scans and leverage indexes more efficiently. Queries with NULL filters are not selective and can cause performance issues. Creating custom indexes on the fields used in the filter criteria can also enhance the query performance by reducing the number of records to scan.

• Question 162:

  Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers

  A. Use a workflow to check and prevent duplicates.
  B. Clean data before importing to Salesforce.
  C. Use Salesforce matching and duplicate rules.
  D. Import the data concurrently.
  B. Clean data before importing to Salesforce.
  C. Use Salesforce matching and duplicate rules.

  ---

  Explanation

  Cleaning data before importing to Salesforce and using Salesforce matching and duplicate rules are two design considerations that an architect should take to minimize data duplication when migrating legacy account data from two aging systems into Salesforce. Cleaning data before importing involves removing or correcting any inaccurate, incomplete, or inconsistent data from the source systems, as well as identifying and resolving any potential duplicates. This ensures that only high-quality and unique data is imported to Salesforce. Using Salesforce matching and duplicate rules allows the architect to define how Salesforce identifies duplicate records during import and how users can handle them. This prevents or reduces the creation of duplicate records in Salesforce and improves data quality. The other options are not effective or recommended for minimizing data duplication.

• Question 163:

  Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers

  A. Use the Force.com Workbench to export the data.
  B. Schedule a weekly export file from the Salesforce UI.
  C. Schedule jobs to export and delete using an ETL tool.
  D. Schedule jobs to export and delete using the Data Loader.
  C. Schedule jobs to export and delete using an ETL tool.
  D. Schedule jobs to export and delete using the Data Loader.

  ---

  Explanation

  Both C and D are valid methods to automatically archive and delete inactive Account data that is older than 3 years1. You can use an ETL tool or the Data Loader to schedule jobs to export and delete data based on certain criteria3. Option A is not recommended because the Force.com Workbench is a web-based tool that does not support scheduling or automation. Option B is not suitable because the weekly export file from the Salesforce UI does not delete data from Salesforce.

• Question 164:

  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.
  C. Duplicate Contact records exist in the system.

  ---

  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 165:

  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.
  B. Enable granular locking.

  ---

  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 166:

  Universal Containers has multiple systems all containing and maintaining customer data. Although point-to-point integrations are in place, customers are complaining about consistency in the data.

  What solution should the data architect recommend?

  A. Improve existing point-to-point integrations
  B. Data cleanse each system
  C. Perform a onetime synchronization to level set the built up inconsistencies
  D. An MDM solution as the customer master, with centralized integrations to ensure consistency across all systems.
  D. An MDM solution as the customer master, with centralized integrations to ensure consistency across all systems.

  ---

  Explanation

  Master data management (MDM) is a solution that helps organizations manage their master data across multiple systems and ensure consistency and quality. An MDM solution can act as the customer master, with centralized integrations to other systems, to avoid data duplication and inconsistency.

• Question 167:

  Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records.

  What should the architect recommend to reduce data load processing time?

  A. Load Contact records together using the Streaming API via the Upsert operation.
  B. Delete all existing records, and then load all records together via the Insert operation.
  C. Load all records via the Upsert operation to determine new records vs. existing records.
  D. Load new records via the Insert operation and existing records via the Update operation.
  D. Load new records via the Insert operation and existing records via the Update operation.

  ---

  Explanation

  Loading new records via the Insert operation and existing records via the Update operation will allow using the external ID field as a unique identifier and avoid any duplication or overwriting of records. This is faster and safer than deleting all existing records or using the Upsert operation, which might cause conflicts or errors .

• Question 168:

  Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system.

  Which solution should a data architect recommend to remediate the duplication issue?

  A. Develop an ETL process that utilizers the merge API to merge the duplicate records
  B. Utilize a data warehouse as the system of truth
  C. Extract the data using data loader and use excel to merge the duplicate records
  D. Implement duplicate rules
  D. Implement duplicate rules

  ---

  Explanation

  Implementing duplicate rules (option D) is the best solution to remediate the duplication issue, as it allows the data architect to identify and merge duplicate accounts in Salesforce using native features and tools. Developing an ETL process that utilizes the merge API to merge the duplicate records (option A) is not a good solution, as it may require more coding and testing effort, and it does not prevent duplicates from being created in Salesforce. Utilizing a data warehouse as the system of truth (option B) is also not a good solution, as it may introduce additional complexity and cost, and it does not address the duplication issue in Salesforce. Extracting the data using data loader and using excel to merge the duplicate records (option C) is also not a good solution, as it may be time-consuming and error-prone, and it does not prevent duplicates from being created in Salesforce.

• Question 169:

  Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system.

  Which two options should be recommended to make this report perform well and satisfy the business need?

  A. Use triggers to populate denormalized related fields on the Account.
  B. Use an indexed data field with bounded data filters.
  C. Use Formula fields to surface information I related entities on the report.
  D. Use unbounded date ranges to filter the report.
  B. Use an indexed data field with bounded data filters.
  C. Use Formula fields to surface information I related entities on the report.

  ---

  Explanation

  Using an indexed data field with bounded data filters can improve the report performance by making the query more selective and reducing the number of records to scan. Using formula fields to surface information from related entities on the report can also enhance the report performance by avoiding joins and complex calculations

• Question 170:

  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.
  A. Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.

  ---

  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