Salesforce Salesforce Certifications DATA-ARCHITECT Questions & Answers

• Question 181:

  Northern Trail Outfitters is concerned because some of its data is sensitive and needs to be identified for access.

  What should be used to provide ways to filter and identify the sensitive data?

  A. Define data grouping metadata.

  B. Implement field-level security.

  C. Custom checkbox denoting sensitive data.

  D. Define data classification metadata.

  Correct Answer: D

  Explanation: According to the official Salesforce guide1, data classification metadata is a feature that allows administrators to classify data fields based on their sensitivity level, such as confidential, restricted, or general. Data classification metadata can be used to filter and identify sensitive data fields and apply appropriate security measures, such as encryption, masking, or auditing. Option D is the correct answer because it suggests using data classification metadata to provide ways to filter and identify sensitive data. Option A is incorrect because data grouping metadata is not a feature in Salesforce. Option B is incorrect because field-level security is a feature that controls the visibility and editability of fields based on user profiles or permission sets, but it does not provide ways to filter and identify sensitive data. Option C is incorrect because creating a custom checkbox denoting sensitive data is not a scalable or reliable solution, as it requires manual maintenance and does not enforce any security measures.

• Question 182:

  Northern Trail Outfitters (NTO) has a variety of customers that include householder, businesses, and individuals.

  The following conditions exist within its system:

  NTO has a total of five million customers.

  Duplicate records exist, which is replicated across many systems, including Salesforce.

  Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.

  Which three option should a data architect perform to resolve the issues with the customer data?

  A. Create a unique global customer ID for each customer and store that in all system for referential identity.

  B. Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.

  C. Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.

  D. Duplicate customer records across the system and provide a two-way sync of data between the systems.

  E. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.

  Correct Answer: ACE

  Explanation: Creating a unique global customer ID for each customer and storing that in all systems for referential identity (option A), investing in a data duplicate tool to de-dupe and merge duplicate records across all systems (option C), and creating a customer master database external to Salesforce as a system of truth and syncing the customer data with all systems (option E) are the three options that a data architect should perform to resolve the issues with the customer data. Option A ensures that each customer can be uniquely identified across different systems, option C eliminates duplicate records and improves data quality, and option E provides a consistent and reliable source of customer data for all systems. Using Salesforce CDC to sync customer data across all systems (option B) is not a good option, as it does not address the duplication or inconsistency issues. Duplicating customer records across the system and providing a two-way sync of data between the systems (option D) is also not a good option, as it may create more confusion and conflicts with customer data.

• Question 183:

  A consumer products company has decided to use Salesforce for its contact center. The contact center agents need access to the following information in Service Console when a customer contacts them:

  1.

  Customer browsing activity on its website stored on its on premise system

  2.

  Customer interactions with sales associates at its retail stores maintained in Salesforce

  3.

  Contact center interactions maintained in Salesforce

  4.

  Email campaign activity to customer from its marketing systems.

  What should a data architect do to fulfill these requirements with minimum development effort in Salesforce?

  A. Create web tabs in Service Console to show website and marketing activities.

  B. Build custom components in Service Console to bring information from the marketing and website information.

  C. Use Salesforce Connect to integrate the website and the marketing system into Service Console using external objects.

  D. Build customer view in Service Console with components that show website data and marketing data as mashup.

  Correct Answer: D

  Explanation: Building a customer view in Service Console with components that show website data and marketing data as mashup is the best option to fulfill the requirement with minimum development effort in Salesforce. A mashup is a technique that combines data from different sources into a single user interface. You can use Visualforce pages or Lightning components to create mashups that display data from external systems such as your website and marketing system. This way, you can provide your contact center agents with a comprehensive view of the customer information they need.

• Question 184:

  Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?

  A. Implement a Master Data Management system to determine system of record.

  B. Implement a workflow rule that sends Opportunity data through Outbound Messaging.

  C. Have the ERP poll Salesforce nightly and bring in the desired Opportunities.

  D. Implement an hourly integration to send Salesforce Opportunities to the ERP system.

  Correct Answer: B

  Explanation: Implementing a workflow rule that sends Opportunity data through Outbound Messaging is the optimal real-time approach that achieves the solution of copying Opportunity records to the ERP once they reach a Closed/Won Stage. A workflow rule can trigger an Outbound Message when an Opportunity record meets certain criteria, such as having a Closed/Won Stage. An Outbound Message can send data from Salesforce to an external system via SOAP API, without requiring any code. The external system can then process the data and create a read-only record in the ERP system. The other options are not optimal or real-time, as they would either require additional systems or tools, not provide real-time data synchronization, or not meet the frequency requirement

• Question 185:

  A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:

  1.Point of sales system: All purchases for a customer.

  2.Salesforce: All customer service activity and sales activity for a customer.

  3.Mobile app: All bookings, preferences and browser activity for a customer.

  4.Marketing: All email, SMS and social campaigns for a customer.

  Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.

  What strategy should the data architect implement to satisfy this requirement?

  A. Explore external data sources in salesforce to build 360 view of customer.

  B. Use a customer data mart to view the 360 view of customer.

  C. Migrate customer activities from all 4 systems into salesforce.

  D. Periodically upload summary information in salesforce to build 360 view.

  Correct Answer: A

  Explanation: Exploring external data sources in Salesforce to build 360 view of customer is the best strategy to satisfy the requirement, as it allows real-time access to data from other systems without storing it in Salesforce3. Using a customer data mart may not provide real-time information or may require additional integration efforts. Migrating customer activities from all 4 systems into Salesforce may exceed the storage limits or cause data quality issues. Periodically uploading summary information in Salesforce may not provide current or detailed information.

• Question 186:

  Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.

  What data extraction strategy should a data architect use for maximum performance?

  A. Install a third-party AppExchange tool.

  B. Call the REST API in successive queries.

  C. Utilize PK Chunking with the Bulk API.

  D. Use the Bulk API in parallel mode.

  Correct Answer: C

  Explanation: According to the Salesforce documentation2, extracting large amounts of data from Salesforce can be challenging and time-consuming, as it can encounter performance issues, API limits, timeouts, etc. To extract 100 million records from Salesforce for migration to an enterprise data warehouse (EDW), a data extraction strategy that can provide maximum performance is: Utilize PK Chunking with the Bulk API (option C). This means using a feature that allows splitting a large query into smaller batches based on the record IDs (primary keys) of the queried object. This can improve performance and avoid timeouts by processing each batch asynchronously and in parallel using the Bulk API3. Installing a third-party AppExchange tool (option A) is not a good solution, as it can incur additional costs and dependencies. It may also not be able to handle such a large volume of data efficiently. Calling the REST API in successive queries (option B) is also not a good solution, as it can encounter API limits and performance issues when querying such a large volume of data. Using the Bulk API in parallel mode (option D) is also not a good solution, as it can still cause timeouts and errors when querying such a large volume of data without chunking.

• Question 187:

  NTO has decided that it is going to build a channel sales portal with the following requirements:

  1.External resellers are able to authenticate to the portal with a login.

  2.Lead data, opportunity data and order data are available to authenticated users.

  3.Authenticated users many need to run reports and dashboards.

  4.There is no need for more than 10 custom objects or additional file storage.

  Which community cloud license type should a data architect recommend to meet the portal requirements?

  A. Customer community.

  B. Lightning external apps starter.

  C. Customer community plus.

  D. Partner community.

  Correct Answer: D

  Explanation: Partner community license type is the best option for building a channel sales portal, as it allows external resellers to access lead, opportunity, and order data, as well as run reports and dashboards. Customer community and customer community plus license types are more suitable for customer service portals, while lightning external apps starter license type does not support reports and dashboards

• Question 188:

  Cloud Kicks has the following requirements:

  Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS). A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.

  What are two approaches for fulfilling these requirements? (Choose two.)

  A. A set to determine which fields to send in an HTTP callout.

  B. An Outbound Message to determine which fields to send to the OMS.

  C. A Field Set that determines which fields to send in an HTTP callout.

  D. Enable the field -level security permissions for the fields to send.

  Correct Answer: BC

  Explanation: An Outbound Message is a native Salesforce feature that allows sending data to an external system without code. It can be configured to include any fields from the source object3. A Field Set is a collection of fields that can be used in Visualforce pages or Apex classes to dynamically determine the fields to send in an HTTP callout. Both of these approaches meet the requirements of Cloud Kicks.

• Question 189:

  Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?

  A. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.

  B. Implement an integration tool to send OMS Accounts and Contacts to Salesforce.

  C. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.

  D. Use the Streaming API to send Account and Contact data from Salesforce to the OMS.

  Correct Answer: C

  Explanation: Implementing a Master Data Management strategy to reconcile Leads, Accounts, and Contacts is the approach that the architect should suggest so that the requirements are met for UC. A Master Data Management strategy can provide a consistent and unified view of data across multiple systems, by defining and enforcing rules for data quality, governance, and integration. A Master Data Management strategy can also handle complex scenarios where different systems have different systems of record for different entities or fields, and where data can be modified in different systems with different values. A Master Data Management strategy can also provide a consolidated data store that links referenced records across systems and enables cross-system reporting and analysis. The other options are not suitable or sufficient for meeting the requirements, as they would either not provide a consolidated data store, not handle different systems of record, or not allow data modification in different system

• Question 190:

  Universal Containers would like to remove data silos and connect their legacy CRM together with their ERP and with Salesforce. Most of their sales team has already migrated to Salesforce for daily use, although a few users are still on the old CRM until some functionality they require is completed. Which two techniques should be used for smooth interoperability now and in the future?

  A. Replicate ongoing changes in the legacy CRM to Salesforce to facilitate a smooth transition when the legacy CRM is eventually retired.

  B. Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce.

  C. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields.

  D. Do not connect Salesforce and the legacy CRM to each other during this transition period, but do allow both to interact with the ERP.

  Correct Answer: BC

  Explanation: Specify the legacy CRM as the system of record during transition until it is removed from operation and fully replaced by Salesforce. This is a good technique to ensure data consistency and avoid conflicts between the two systems. Work with stakeholders to establish a Master Data Management plan for the system of record for specific objects, records, and fields. This is another good technique to define the data governance and stewardship policies and processes for managing data quality and integrity across multiple systems