Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 231:

  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 data. 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?

  A. The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.

  B. A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.

  C. The Opportunity engagement system should become the system of record for Opportunity records.

  D. Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

  Correct Answer: D

  Explanation: The recommended course of action to appropriately integrate the new Opportunity engagement system with Salesforce is to bring the stakeholders together to discuss the appropriate data strategy moving forward. This is because there may be valuable data in both systems that need to be reconciled and harmonized, and the Master Data Management (MDM) strategy may need to be revised or updated to accommodate the new system. The other options are not recommended, as they may result in data loss, inconsistency, or duplication

• Question 232:

  UC developers have created a new lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.

  What tool should a data architect use to identify why the query is taking too long?

  A. Use Splunk to query the system logs looking for transaction time and CPU usage.

  B. Enable and use the query plan tool in the developer console.

  C. Use salesforce's query optimizer to analyze the query in the developer console.

  D. Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.

  Correct Answer: B

  Explanation: According to the Salesforce documentation1, the query plan tool is a tool that can be enabled and used in the developer console to analyze the performance of a SOQL query. The query plan tool shows the cost, cardinality, sObject type, and relative cost of each query plan that Salesforce considers for a query. The relative cost indicates how expensive a query plan is compared to the Force.com query optimizer threshold. A query plan with a relative cost above

  1.0 is likely to cause a time-out error. To identify why the query is taking too long, a data architect should use the query plan tool in the developer console (option B). This way, the data architect can see which query plan is chosen by Salesforce and how it affects the performance of the query. The data architect can also use the query plan tool to optimize the query by adding indexes, filters, or limits to reduce the cost and improve the efficiency of the query. Using Splunk to query the system logs looking for transaction time and CPU usage (option A) is not a good solution, as it can be complex, costly, and difficult to integrate with Salesforce. It may also not provide enough information or insights to identify and optimize the query performance. Using Salesforce's query optimizer to analyze the query in the developer console (option C) is also not a good solution, as it is not a separate tool that can be used in the developer console. The query optimizer is a feature that runs automatically when a SOQL query is executed and chooses the best query plan based on various factors2. Opening a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time (option D) is also not a good solution, as it can be time- consuming, dependent, and inefficient. It may also not provide enough information or insights to identify and optimize the query performance.

• Question 233:

  Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

  A. Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.

  B. Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master- detail relationship to the container object.

  C. Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC's existing data warehouse.

  D. Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.

  Correct Answer: D

  Explanation: The recommended solution for Universal Containers (UC) to implement its new Internet of Things technology is to create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour. This solution would allow UC to store and access current and historical temperature and humidity data for each container on Salesforce, and use reports and dashboards to analyze it. However, since UC expects a large volume of data over time, they should implement an archiving process that moves data off-platform after a certain period of time to avoid hitting the Org data storage limit and maintain optimal performance. The other options are not recommended, as they would either not store the historical data on Salesforce, or create too many custom fields on the Container object that could impact performance and usability.

• Question 234:

  A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?

  A. Query only indexed ID field values on the imported order to import related order lines.

  B. Leverage an External ID from source system orders to import related order lines.

  C. Leverage Batch Apex to update order ID on related order lines after import.

  D. Leverage a sequence of numbers on the imported orders to import related order lines.

  Correct Answer: B

  Explanation: Leverage an External ID from source system orders to import related order lines. This is the recommended solution because it allows you to use the upsert operation to match records based on the External ID field, which is indexed and unique. This avoids the need to query the parent order IDs in Salesforce before importing the order line items, which can cause time-out errors or long delays1.

• Question 235:

  DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.

  What are two approaches an Architect should recommend? (Choose two.)

  A. Weekly Snapshots

  B. Einstein Analytics

  C. Setup Audit Trails

  D. AppExchange Apps

  Correct Answer: BD

  Explanation: Einstein Analytics can provide more analytical insights than native reports and dashboards by allowing users to explore data from multiple sources, create interactive visualizations, and apply AI-powered features5. AppExchange Apps can also provide more analytical insights by offering pre-built solutions or integrations with external tools that can enhance the reporting and analytics capabilities of Salesforce6.

• Question 236:

  North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.

  Which two native tools should a data architect recommend to achieve this reporting requirement?

  A. Standard reports and dashboards

  B. Async SOQL with a custom object

  C. Standard SOQL queries

  D. Einstein Analytics

  Correct Answer: BD

  Explanation: Async SOQL with a custom object (option B) and Einstein Analytics (option D) are the two native tools that can be used to report on big object data. Async SOQL allows querying big object data and storing the results in a custom object, which can then be used for reporting. Einstein Analytics can connect to big object data sources and provide advanced analytics and visualization features. Standard reports and dashboards (option A) and standard SOQL queries (option C) cannot be used to report on big object data, as they do not support big object fields

• Question 237:

  UC recently migrated 1 Billion customer related records from a legacy data store to Heroku Postgres. A subset of the data need to be synchronized with salesforce so that service agents are able to support customers directly within the service console. The remaining non- synchronized set of data will need to be accessed by salesforce at any point in time, but UC management is concerned about storage limitations.

  What should a data architect recommend to meet these requirements with minimal effort?

  A. Virtualize the remaining set of data with salesforce connect and external objects.

  B. Use Heroku connect to bi-directional, sync all data between systems.

  C. As needed, make call outs into Heroku postgres and persist the data in salesforce.

  D. Migrate the data to big objects and leverage async SOQL with custom objects.

  Correct Answer: A

  Explanation: Virtualizing the remaining set of data with salesforce connect and external objects is the best way to meet the requirements with minimal effort, as it allows salesforce to access data stored in Heroku Postgres without storing it in salesforce. This reduces the storage limitations and avoids data duplication. Heroku connect can bi-directionally sync data between systems, but it requires more configuration and maintenance. Making callouts to Heroku Postgres and persisting the data in salesforce may not be feasible for 1 billion records. Migrating the data to big objects may incur additional costs and require custom code to use async SOQL

• Question 238:

  A large insurance provider is looking to implement Salesforce. The following exist.

  1.

  Multiple channel for lead acquisition

  2.

  Duplication leads across channels

  3.

  Poor customer experience and higher costs

  On analysis, it found that there are duplicate leads that are resulting to mitigate the issues? (Choose three.)

  A. Build process is manually search and merge duplicates.

  B. Standard lead information across all channels.

  C. Build a custom solution to identify and merge duplicate leads.

  D. Implement third-party solution to clean and event lead data.

  E. Implement de-duplication strategy to prevent duplicate leads

  Correct Answer: BDE

  Explanation: According to the Salesforce documentation2, duplicate leads are leads that have the same or similar information as other leads in Salesforce. Duplicate leads can cause poor customer experience, higher costs, and inaccurate reporting. To mitigate the issues caused by duplicate leads, some of the recommended practices are: Standardize lead information across all channels (option B). This means using consistent formats, values, and fields for capturing lead data from different sources, such as web forms, email campaigns, or third-party vendors. This can help reduce data quality issues and make it easier to identify and prevent duplicate leads. Implement a third-party solution to clean and enrich lead data (option D). This means using an external service or tool that can validate, correct, update, and enhance lead data before or after importing it into Salesforce. This can help improve data quality and accuracy, and reduce duplicate leads. Implement a de-duplication strategy to prevent duplicate leads (option E). This means using Salesforce features or custom solutions that can detect and block duplicate leads from being created or imported into Salesforce. For example, using Data.com Duplicate Management3, which allows defining matching rules and duplicate rules for leads and other objects. Building a process to manually search and merge duplicates (option A) is not a good practice, as it can be time-consuming, error-prone, and inefficient. Building a custom solution to identify and merge duplicate leads (option C) is also not a good practice, as it can be complex, costly, and difficult to maintain. It is better to use existing Salesforce features or third-party solutions that can handle duplicate leads more effectively.

• Question 239:

  Northern Trail Outfitters (NTO) has multiple Salesforce orgs based on regions. Users need read-only access to customers across all Salesforce orgs.

  Which feature in Salesforce can be used to provide access to customer records across all NTO orgs?

  A. Salesforce Connect

  B. Salesforce 2 Salesforce

  C. Federated Search

  D. External APIs

  Correct Answer: A

  Explanation: Salesforce Connect is a feature that allows users to access data from external sources and multiple Salesforce orgs, using either clicks or code. Salesforce Connect can provide read-only access to customer records across all NTO orgs, without replicating or storing the data in Salesforce.

• Question 240:

  Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports and dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers

  A. AppExchange Apps

  B. Wave Analytics

  C. Weekly Snapshots

  D. Setup Audit Trails

  Correct Answer: AB

  Explanation: According to the exam guide, one of the objectives is to "describe the use cases and considerations for using AppExchange apps and Wave Analytics"1. This implies that options A and B are both valid approaches to provide more analytical insights. Option C is not correct because weekly snapshots are used to track changes over time, not to provide advanced analytics3. Option D is not correct because setup audit trails are used to monitor changes in the setup menu, not to provide analytical insights.