Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 11:

  NTO has decided to franchise its brand. Upon implementation, 1000 franchisees will be able to access BTO's product information and track large customer sales and opportunities through a portal. The Franchisees will also be able to run monthly and quarterly sales reports and projections as well as view the reports in dashboards.

  Which licenses does NTO need to provide these features to the Franchisees?

  A. Salesforce Sales Cloud license

  B. Lightning Platform license

  C. Customer Community license

  D. Partner Community license

  Correct Answer: D

  Explanation: The best license to provide these features to the franchisees is the Partner Community license. Partner Community licenses are designed for external users who collaborate with your sales team on deals, such as resellers, distributors, or brokers. Partner Community users can access standard CRM objects, such as accounts, contacts, leads, opportunities, campaigns, and reports. They can also access custom objects and run dashboards12. Salesforce Sales Cloud license is not a good option because it is intended for internal users who need full access to standard CRM and custom apps. Lightning Platform license is not a good option because it is intended for users who need access to custom apps but not to standard CRM functionality. Customer Community license is not a good option because it is intended for external users who need access to customer support features, such as cases and knowledge articles, but not to sales features

• Question 12:

  Universal Containers uses Apex jobs to create leads in Salesforce. The business team has requested that lead creation failures should be reported to them.

  Which option does Apex provide to report errors from this Apex job?

  A. Use Custom Object to store leads, and allow unprocessed leads to be reported.

  B. Save Apex errors in a custom object, and allow access to this object for reporting.

  C. Use Apex services to email failures to business when error occurs.

  D. Use AppExchange package to clean lead information before Apex job processes them.

  Correct Answer: C

  Explanation: saving Apex errors in a custom object can be a way to report errors from an Apex job. The article provides an example of how to create a custom object called AsyncApexError__c and use a trigger to insert error records into it. The custom object can then be used for reporting or notification purposes.

• Question 13:

  Universal Containers (UC) is migrating from an on-premise homegrown customer relationship management (CRM) system- During analysis, UC users highlight a pain point that there are multiple versions of many customers.

  What should the data architect do for a successful migration to mitigate the pain point?

  A. Hire an intern manually de-duplicate the records after migrating to Salesforce.

  B. Migrate the data as is, and use Salesforce's de-duplicating feature.

  C. Have the users manually clean the data in the old system prior to migration.

  D. Store the data in a staging database, and de-duplicate identical records.

  Correct Answer: D

  Explanation: Storing the data in a staging database and de-duplicating identical records (option D) is the best solution for a successful migration to mitigate the pain point, as it allows the data architect to identify and merge duplicate customers before they are imported into Salesforce. Hiring an intern manually de-duplicate the records after migrating to Salesforce (option A) is not a good solution, as it may be time-consuming and error- prone, and it does not prevent duplicate records from being created in Salesforce. Migrating the data as is and using Salesforce's de-duplicating feature (option B) is also not a good solution, as it may cause data quality issues and conflicts, and it does not address the root cause of the duplication. Having the users manually clean the data in the old system prior to migration (option C) is also not a good solution, as it may be unrealistic and impractical, and it does not leverage any automated tools or processes.

• Question 14:

  (NTO) has multiple salesforce orgs based on geographical reports (AMER, EMEA, APAC). NTO products are in the AMER org and need to be created in the EMEA and APAC after the products are approved.

  Which two features should a data architect recommend to share records between salesforce orgs? Choose 2.

  A. Change data capture (CDC)

  B. Salesforce connect.

  C. Federation search

  D. Salesforce 2 Salesforce

  Correct Answer: AD

  Explanation: The two features that a data architect should recommend to share records between Salesforce orgs are:

  Change Data Capture (CDC): This is a feature that publishes change events for changes in Salesforce records, such as create, update, delete, and undelete operations. Change events can be subscribed by external systems or other

  Salesforce orgs using various tools, such as Platform Events, Streaming API, or CometD. CDC can help keep data in sync between Salesforce orgs in near real time89.

  Salesforce to Salesforce (S2S): This is a feature that allows sharing records and related data with other Salesforce orgs that you partner with. You can choose which records and fields to share, and which orgs to share with. You can also

  accept updates from the other orgs to keep the data consistent10. Salesforce Connect is not a good feature to share records between Salesforce orgs because it is intended for integrating external data sources with Salesforce using external

  objects. Federation Search is not a good feature to share records between Salesforce orgs because it is intended for searching across multiple Salesforce orgs without sharing data.

• Question 15:

  What is an advantage of using Custom metadata type over Custom setting?

  A. Custom metadata records are not copied from production to sandbox.

  B. Custom metadata types are available for reporting.

  C. Custom metadata records are deployable using packages.

  D. Custom metadata records are editable in Apex.

  Correct Answer: C

  Explanation: Custom metadata records are deployable using packages, which makes them easier to migrate from one environment to another. Custom settings records are not deployable using packages, and they are copied from production to sandbox. Custom metadata types are not available for reporting, and custom metadata records are not editable in Apex.

• Question 16:

  Universal Containers (UC) is using Salesforce Sales and Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?

  A. Use Duplicate Management.

  B. Use an Enterprise Service Bus.

  C. Use Data.com Clean

  D. Use a data warehouse.

  Correct Answer: AC

  Explanation: Using Duplicate Management and Data.com Clean are two recommended approaches for UC to avoid duplicate data and increase the level of data quality. Duplicate Management can prevent or alert users when they try to create or edit records that are duplicates of existing records. Data.com Clean can compare Salesforce records with Data.com records and provide suggestions for updates or removals of duplicate records.

• Question 17:

  Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?

  A. Modify the export job header to specify Export-in-Parallel.

  B. Modify the export job header to specify Sforce-Enable-PKChunking.

  C. Modify the export query that includes standard index fields(s).

  D. Modify the export query with LIMIT clause with Batch size 10,000.

  Correct Answer: B

  Explanation: The Sforce-Enable-PKChunking header enables you to extract large data sets from Salesforce by using a technique called primary key (PK) chunking. PK chunking splits your query into multiple queries based on the record IDs of the queried object. This reduces the query time and avoids the query timeout issues that can occur with large data volumes

• Question 18:

  Universal Containers keeps its Account data in Salesforce and its Invoice data in a third - party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

  A. Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.

  B. Create a report combining data from the Account standard object and the Invoices external object.

  C. Create a Visualforce page combining Salesforce Account data and Invoice external object data.

  D. Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.

  Correct Answer: AC

  Explanation: Creating a report in an external system combining Salesforce Account data and Invoice data from the ERP, and creating a Visualforce page combining Salesforce Account data and Invoice external object data are two approaches that an architect can suggest for achieving this solution. Both of these approaches can display data from both Accounts and Invoices in one place, using either an external reporting tool or a custom web page. Creating a report combining data from the Account standard object and the Invoices external object is not possible because Salesforce does not support reporting on external objects. Creating a separate Salesforce report for Accounts and Invoices and combining them in a dashboard is not ideal because it will not show the data in one report, but rather in two separate components.

• Question 19:

  Based on government regulations, a Salesforce customer plans to implement the following in Salesforce for compliance:

  Access to customer information based on record ownership Ability for customers to request removal of their information from Salesforce Prevent users from accessing Salesforce from outside company network (virtual private network, or VPN)

  What should a data architect recommend to address these requirements?

  A. Contact Salesforce support to restrict access only with VPN and other requirements

  B. Allow users access to Salesforce through a custom web application hosted within VPN.

  C. Implement IP restrictions, sharing settings, and custom Apex to support customer requests.

  D. Implement Salesforce shield with Event Monitoring to address the requirement.

  Correct Answer: C

  Explanation: IP restrictions can be used to prevent users from accessing Salesforce from outside the company network or VPN. According to this article, sharing settings can be used to control access to customer information based on record ownership. According to this article, custom Apex can be used to support customer requests for removal of their information from Salesforce.

• Question 20:

  Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level. What is the recommended solution to address these requirements?

  A. Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.

  B. Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.

  C. Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.

  D. Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.

  Correct Answer: D

  Explanation: The recommended solution to address the requirements of Universal Containers (UC) is to roll-up discount request amount at the line-item-level and line-item- level summary discount at the opportunity level. This solution would allow UC to show all sums of discounts across line items at an opportunity level using standard roll-up summary fields. Since UC has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request object, they can use two levels of roll-up summary fields to aggregate the discount amounts from the child objects to the parent objects. For example, they can create a roll-up summary field on the custom line item object to sum up the discount request amounts from the custom discount request object. Then, they can create another roll-up summary field on the opportunity object to sum up the line-item-level summary discounts from the custom line item object.