Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 121:

  Universal containers is implementing Salesforce lead management. UC Procure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information?

  A. Ask sales people to search for populating company profile and location data

  B. Run reports to identify records which does not have company profile and location data

  C. Leverage external data providers populate company profile and location data

  D. Export data out of Salesforce and send to another team to populate company profile and location data

  Correct Answer: C

  Explanation: The best solution to make sure lead data has both profile and location information is to leverage external data providers to populate company profile and location data. This is because external data providers can enrich lead data with additional information from third-party sources, such as Dun and Bradstreet, ZoomInfo, or Clearbit. This can help improve lead quality, segmentation, and conversion. Salesforce supports integrating with external data providers using Data.com Clean or other AppExchange solutions2. Asking sales people to search for populating company profile and location data is inefficient and prone to errors. Running reports to identify records which do not have company profile and location data is useful, but does not solve the problem of how to populate the missing data. Exporting data out of Salesforce and sending to another team to populate company profile and location data is cumbersome and time-consuming.

• Question 122:

  To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?

  A. Errors with duplicate external Id values within the same CSV file.

  B. Errors with records being updated and inserted in the same CSV file.

  C. Errors when a duplicate Contact name is found cause upsert to fail.

  D. Errors with using the wrong external Id will cause the load to fail.

  Correct Answer: A

  Explanation: Data Loader uses external Id fields to match records in the CSV file with records in Salesforce during an upsert operation. If the CSV file contains duplicate external Id values within the same file, Data Loader will throw an error saying "Duplicate Id Specified" and will not process those records. Therefore, it is important to ensure that the CSV file does not have any duplicate external Id values before using Data Loader to upsert records.

• Question 123:

  UC has a variety of systems across its technology landscape, including SF, legacy enterprise resource planning (ERP) applications and homegrown CRM tools. UC has decided that they would like to consolidate all customer, opportunity and order data into Salesforce as part of its master data management (MDM) strategy.

  What are the 3 key steps that a data architect should take when merging data from multiple systems into Salesforce? Choose 3 answers:

  A. Create new fields to store additional values from all the systems.

  B. Install a 3rd party AppExchange tool to handle the merger

  C. Analyze each system's data model and perform gap analysis

  D. Utilize an ETL tool to merge, transform and de-duplicate data.

  E. Work with Stakeholders to define record and field survivorship rules

  Correct Answer: CDE

  Explanation: The three key steps that a data architect should take when merging data from multiple systems into Salesforce are: Analyze each system's data model and perform gap analysis. This step involves understanding the structure and meaning of the data in each system, identifying the common and unique data elements, and mapping the data fields between the systems. This step also involves assessing the quality and consistency of the data, and identifying any data cleansing or transformation needs. Utilize an ETL tool to merge, transform, and de-duplicate data. This step involves using an ETL tool to connect to the source systems, extract the data, apply any data transformations or validations, and load the data into Salesforce. This step also involves applying de-duplication rules or algorithms to avoid creating duplicate records in Salesforce. Work with stakeholders to define record and field survivorship rules. This step involves collaborating with the business users and owners of the data to determine which records and fields should be retained or overwritten in case of conflicts or discrepancies. This step also involves defining the criteria and logic for record and field survivorship, and implementing them in the ETL tool or in Salesforce. Creating new fields to store additional values from all the systems is not a key step, but rather a possible outcome of the gap analysis. It may not be necessary or desirable to create new fields for every value from every system, as it may result in redundant or irrelevant data. Installing a 3rd party AppExchange tool to handle the merger is not a key step, but rather a possible option for choosing an ETL tool. It may not be the best option depending on the requirements, budget, and preferences of the organization.

• Question 124:

  A customer needs a sales model that allows the following:

  Opportunities need to be assigned to sales people based on the zip code.

  Each sales person can be assigned to multiple zip codes.

  Each zip code is assigned to a sales area definition.

  Sales is aggregated by sales area for reporting.

  What should a data architect recommend?

  A. Assign opportunities using list views using zip code.

  B. Add custom fields in opportunities for zip code and use assignment rules.

  C. Allow sales users to manually assign opportunity ownership based on zip code.

  D. Configure territory management feature to support opportunity assignment.

  Correct Answer: D

  Explanation: The best solution to assign opportunities based on zip code and sales area is to configure territory management feature to support opportunity assignment. Territory management is a feature that allows you to organize your sales team into territories based on criteria such as geography, industry, product line, or customer segment. You can assign accounts and opportunities to territories using assignment rules or manual sharing. You can also define forecast managers and roll up forecasts by territory45. Assign opportunities using list views using zip code is not a good solution because it is inefficient and does not support reporting by sales area. Add custom fields in opportunities for zip code and use assignment rules is not a good solution because it requires creating additional fields and does not support reporting by sales area. Allow sales users to manually assign opportunity ownership based on zip code is not a good solution because it is prone to errors and does not support reporting by sales area.

• Question 125:

  Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.

  What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency? (Choose two.)

  A. Run a report which shows the last time the key fields were updated.

  B. Run one report per key field, grouped by that field, to understand its data variability.

  C. Run a report that shows the percentage of blanks for the important fields.

  D. Run a process that can fill in default values for blank fields.

  Correct Answer: AC

  Explanation: Running a report that shows the last time the key fields were updated can help Get Cloudy Consulting identify stale or outdated data and prioritize data cleansing activities. Running a report that shows the percentage of blanks for the important fields can help Get Cloudy Consulting measure the completeness of their data and identify gaps or missing value

• Question 126:

  Northern Trail Outfitters has these simple requirements for a data export process:

  File format should be in CSV.

  Process should be scheduled and run once per week.

  The expert should be configurable through the Salesforce UI.

  Which tool should a data architect leverage to accomplish these requirements?

  A. Bulk API

  B. Data export wizard

  C. Third-party ETL tool

  D. Data loader

  Correct Answer: B

  Explanation: The correct answer is B, data export wizard. The data export wizard is a tool that allows you to export your data in CSV format, schedule the export process to run once per week, and configure the export settings through the Salesforce UI. The data export wizard can handle up to 51 million records per export. The bulk API, third-party ETL tools, and data loader are also tools that can export data, but they are not as simple or user- friendly as the data export wizard.

• Question 127:

  UC has millions of Cases and are running out of storage. Some user groups need to have access to historical cases for up to 7 years.

  Which 2 solutions should a data architect recommend in order to minimize performance and storage issues?

  Choose 2 answers:

  A. Export data out of salesforce and store in Flat files on external system.

  B. Create a custom object to store case history and run reports on it.

  C. Leverage on premise data archival and build integration to view archived data.

  D. Leverage big object to archive case data and lightning components to show archived data.

  Correct Answer: CD

  Explanation: The correct answer is C and D. To minimize performance and storage issues, a data architect should recommend leveraging on premise data archival and building integration to view archived data, and leveraging big object to archive case data and lightning components to show archived data. These solutions will allow some user groups to access historical cases for up to 7 years without consuming too much storage space or affecting the performance of queries and reports. Option A is incorrect because exporting data out of salesforce and storing it in flat files on external system will make it difficult to access and query the data. Option B is incorrect because creating a custom object to store case history and run reports on it will still consume a lot of storage space and impact the performance of queries and reports.

• Question 128:

  A large retail B2C customer wants to build a 360 view of its customer for its call center agents. The customer interaction is currently maintained in the following system:

  1. Salesforce CRM

  3.

  Customer Master Data management (MDM)

  4.

  Contract Management system

  5.

  Marketing solution

  What should a data architect recommend that would help upgrade uniquely identify customer across multiple systems:

  A. Store the salesforce id in all the solutions to identify the customer.

  B. Create a custom object that will serve as a cross reference for the customer id.

  C. Create a customer data base and use this id in all systems.

  D. Create a custom field as external id to maintain the customer Id from the MDM solution.

  Correct Answer: D

  Explanation: To help uniquely identify customer across multiple systems, a data architect should recommend creating a custom field as external ID to maintain the customer ID from the MDM solution. An external ID is a custom field that has the "External ID" attribute enabled, which means that it contains unique record identifiers from a system outside of Salesforce. By using the customer ID from the MDM solution as an external ID in Salesforce CRM, Contract Management system, and Marketing solution, the data architect can ensure that each customer can be easily identified and integrated across these systems. Option A is incorrect because storing the Salesforce ID in all the solutions to identify the customer will not work if the customer records are created or updated in other systems besides Salesforce CRM. Option B is incorrect because creating a custom object that will serve as a cross reference for the customer ID will require additional configuration effort and may not be consistent with the actual customer records in each system. Option C is incorrect because creating a customer database and using this ID in all systems will require additional infrastructure cost and maintenance effort.

• Question 129:

  North Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org, NTO also owns several secondary orgs that the service, finance, and marketing teams work out of, At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.

  Moving forward, NTO has identified that a hub-and-spoke model is the proper architect to manage its data, where the central org is the hub and the secondary orgs are the spokes.

  Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

  A. A middleware solution that extracts and distributes data across both the hub and spokes.

  B. Develop custom APIs to poll the hub org for change data and push into the spoke orgs.

  C. Develop custom APIs to poll the spoke for change data and push into the org.

  D. A backup and archive solution that extracts and restores data across orgs.

  Correct Answer: A

  Explanation: According to the Salesforce documentation, a hub-and-spoke model is an integration architecture pattern that allows connecting multiple Salesforce orgs using a central org (hub) and one or more secondary orgs (spokes). The hub org acts as the master data source and orchestrates the data flow between the spoke orgs. The spoke orgs act as the consumers or producers of the data and communicate with the hub org. To orchestrate data between the hub org and spoke orgs, a data architect should use: A middleware solution that extracts and distributes data across both the hub and spokes (option A). This means using an external service or tool that can connect to multiple Salesforce orgs using APIs or connectors, and perform data extraction, transformation, and distribution operations between the hub and spoke orgs. This can provide a scalable, flexible, and reliable way to orchestrate data across multiple orgs. Developing custom APIs to poll the hub org for change data and push into the spoke orgs (option B) is not a good solution, as it can be complex, costly, and difficult to maintain. It may also not be able to handle large volumes of data or complex transformations efficiently. Developing custom APIs to poll the spoke orgs for change data and push into the hub org (option C) is also not a good solution, as it can have the same drawbacks as option B. It may also not be able to handle conflicts or errors effectively. Using a backup and archive solution that extracts and restores data across orgs (option D) is also not a good solution, as it can incur additional costs and dependencies. It may also not be able to handle real-time or near-real-time data orchestration requirements.

• Question 130:

  Universal container (UC) would like to build a Human resources application on Salesforce to manage employee details, payroll, and hiring efforts. To adequately and store the relevant data, the application will need to leverage 45 custom objects. In addition to this, UC expects roughly 20,00 API calls into Salesfoce from an n-premises application daily.

  Which license type should a data architect recommend that best fits these requirements?

  A. Service Cloud

  B. Lightning platform Start

  C. Lightning Platform plus

  D. Lightning External Apps Starts

  Correct Answer: C

  Explanation: Lightning Platform Plus is the license type that best fits UC's requirements, as it allows up to 50 custom objects and 40,000 API calls per user per 24-hour period4. Service Cloud does not provide enough custom objects or API calls. Lightning Platform Start only allows up to 10 custom objects and 5,000 API calls per user per 24-hour period. Lightning External Apps Start is for external users and does not provide enough API calls.