Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 101:

  Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting reports in the Salesforce org.

  Which solution should a data architect recommend to improve reporting performance?

  A. Create a custom object to store aggregate data and run reports.

  B. Contact Salesforce support to enable skinny table for cases.

  C. Move data off of the platform and run reporting outside Salesforce, and give access to reports.

  D. Build reports using custom Lightning components.

  Correct Answer: B

  Explanation: According to the Salesforce documentation1, reporting performance can be affected by various factors, such as the volume and complexity of data, the design and configuration of reports and dashboards, the number and type of users accessing the reports, etc. To improve reporting performance, some of the recommended solutions are: Move data off of the platform and run reporting outside Salesforce, and give access to reports (option C). This means using an external service or tool that can extract, transform, and load (ETL) data from Salesforce to another system or database, such as a data warehouse or a business intelligence platform. This can improve reporting performance by reducing the load and latency on Salesforce, and enabling faster and more flexible reporting and analysis on the external system. Users can access the reports from the external system using a link or an embedded component in Salesforce. Contact Salesforce support to enable skinny table for cases (option B). This means requesting Salesforce to create a custom table that contains a subset of fields from the Case object that are frequently used or queried. A skinny table can improve reporting performance by avoiding joins between standard and custom fields, omitting soft-deleted records, and leveraging indexes on the fields2. Create a custom object to store aggregate data and run reports (option A). This means creating a custom object that contains summary or calculated data from the Case object, such as counts, sums, averages, etc. A custom object can improve reporting performance by reducing the number of records and fields that need to be queried and displayed. Build reports using custom Lightning components (option D). This means creating custom components that use Lightning Web Components or Aura Components frameworks to display report data in Salesforce. A custom component can improve reporting performance by using client-side caching, pagination, lazy loading, or other techniques to optimize data rendering and interaction.

• Question 102:

  Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers

  A. Make use of a third -party tool to help merge duplicate Contacts across Accounts.

  B. Use Data.com to standardize Contact address information to help identify duplicates.

  C. Use Workflow rules to standardize Contact information to identify and prevent duplicates.

  D. Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

  Correct Answer: AB

  Explanation: Making use of a third-party tool to help merge duplicate Contacts across Accounts and using Data.com to standardize Contact address information to help identify duplicates are two solutions that UC should implement to cleanse their data and have a single Contact across departments. A third-party tool, such as an app from the AppExchange, can provide advanced features and capabilities for finding and merging duplicate Contacts across different Accounts, based on various criteria and rules. Data.com can provide address verification and standardization services that can enhance the quality and consistency of Contact address information and make it easier to identify duplicates. The other options are not feasible or effective for cleansing the data, as they would either not work across different Accounts, not address the root cause of duplication, or not provide sufficient functionality for merging duplicates

• Question 103:

  An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers

  A. Implement a third -party validation process with translate functionality.

  B. Create a trigger on Contact and add an error to the record with a custom label.

  C. Create a workflow field update to set the standard ErrorMessage field.

  D. Create a validation rule and translate the error message with translation workbench.

  Correct Answer: BD

  Explanation: Creating a trigger on Contact and adding an error to the record with a custom label allows the architect to use the translation workbench to translate the error message based on the user's language. Creating a validation rule and translating the error message with translation workbench also achieves the same result. The other options would either not provide translation functionality or not display an error message

• Question 104:

  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.

  Correct Answer: BC

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

  NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.

  What should a data architect recommend in order to get around the time out issue?

  A. Use a custom auto number and formula field and use that to chunk records while extracting data.

  B. The REST API to extract data as it automatically chunks records by 200.

  C. Use ETL tool for extraction of records.

  D. Ask SF support to increase the query timeout value.

  Correct Answer: C

  The best solution to extract 50 million records from a custom object everyday from Salesforce org without facing query timeout issues is to use an ETL tool for extraction of records. ETL stands for extract, transform, and load, and it refers to a process of moving data from one system to another. An ETL tool is a software application that can connect to various data sources, perform data transformations, and load data into a target destination. ETL tools can handle large volumes of data efficiently and reliably, and they often provide features such as scheduling, monitoring, error handling, and logging5. Using a custom auto number and formula field and use that to chunk records while extracting data is a possible workaround, but it requires creating additional fields and writing complex queries. The REST API can extract data as it automatically chunks records by 200, but it has some limitations, such as a maximum of 50 million records per query job6. Asking SF support to increase the query timeout value is not feasible because query timeout values are not configurable

• Question 106:

  Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.

  Which solution should a data architect use to ensure successful data migrations?

  A. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.

  B. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.

  C. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.

  D. Export legacy data into CSV files and leverage data loader to load data into Salesforce.

  Correct Answer: C

  Explanation: According to this article, migrating the legacy data leveraging an ETL tool to transform data types and load data into Salesforce can be a way to ensure successful data migrations. The article states that ETL tools can help with data cleansing, mapping, transformation, and loading, and that they can handle different data types and formats. The article also provides some best practices for data migration, such as identifying the data to migrate, creating templates for the data, preparing the destination org, and validating the data.

• Question 107:

  Which two best practices should be followed when using SOSL for searching?

  A. Use searches against single Objects for greater speed and accuracy.

  B. Keep searches specific and avoid wildcards where possible.

  C. Use SOSL option to ignore custom indexes as search fields are pre-indexed.

  D. Use Find in "ALL FIELDS" for faster searches.

  Correct Answer: BD

  Explanation: The two best practices that should be followed when using SOSL for searching are: Keep searches specific and avoid wildcards where possible. Use Find in "ALL FIELDS" for faster searches. These best practices are helpful because they optimize the search performance and relevance. For example, keeping searches specific and avoiding wildcards where possible can reduce the number of results returned and improve the search accuracy. Using Find in "ALL FIELDS" for faster searches can leverage Salesforce's pre-defined indexes on common fields and return results more quickly than specifying individual fields.

• Question 108:

  UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.

  What are the 3 key actions that should be done when data modeling in salesforce?

  Choose 3 answers:

  A. Identify data elements to be persisted in salesforce.

  B. Map legacy data to salesforce objects.

  C. Map legacy data to salesforce custom objects.

  D. Work with legacy application owner to analysis legacy data model.

  E. Implement legacy data model within salesforce using custom fields.

  Correct Answer: ABE

  Explanation: According to the Data Modeling unit on Trailhead, some of the key actions that should be done when data modeling in Salesforce are identifying data elements, mapping legacy data, and implementing legacy data model. The unit states that "Before you start creating objects and fields in Salesforce, you need to identify the data elements that you want to store and work with. ... Next, you need to map your legacy data to Salesforce objects and fields. ... Finally, you need to implement your data model in Salesforce by creating custom objects and fields using declarative tools or Metadata API." Therefore, these are the correct actions for migrating a legacy client server app to Salesforce.

• Question 109:

  Universal Container is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.

  What solution a data architect recommends to give the sales team visibility into order status?

  A. Leverage Canvas to bring the order management UI in to the Salesforce tab.

  B. Build batch jobs to push order line items to salesforce.

  C. leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.

  D. Build real-time integration to pull order line items into Salesforce when viewing orders.

  Correct Answer: C

  Explanation: The correct answer is C, leverage Salesforce Connect to bring the order line item from the legacy system to Salesforce. Salesforce Connect is a feature that allows you to integrate external data sources with Salesforce and access them in real time without copying or synchronizing the data. This way, the sales team can view the order status from the ERP system without having access to it. Leveraging Canvas, building batch jobs, or building real-time integration are also possible solutions, but they are more complex and costly than using Salesforce Connect.

• Question 110:

  Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API. When designing these forms, which two techniques will help maintain a high level of data quality?

  A. Do client-side validation of phone number and email field formats.

  B. Prefer picklist form fields over free text fields, where possible.

  C. Ensure the website visitor is browsing using an HTTPS connection.

  D. Use cookies to track when visitors submit multiple forms.

  Correct Answer: AB

  Explanation: Doing client-side validation of phone number and email field formats and preferring picklist form fields over free text fields, where possible, are two techniques that will help maintain a high level of data quality when designing forms that create Lead records in Salesforce using the REST API. Client-side validation can ensure that the input data is in the correct format and prevent errors or invalid values from being submitted. Picklist form fields can provide a predefined set of values for the users to choose from and avoid typos or inconsistencies in the data.